Home » Microsoft » 70-462 v.2 » Which two statements should you execute?
You have the following table.
You need to create a full-text index for the table.
Which two statements should you execute? Each correct answer presents part of the solution.
A. CREATE RULE KnowledgeBaseRule
AS @Problem LIKE ‘%’
B. CREATE FULLTEXT STOPLIST KnowledgeBaseStopList
FROM KnowledgeBase
C. CREATE INDEX OurIndex ON KnowledgeBase
(Problem, Solution) ON [Catalog]
D. CREATE FULLTEXT CATALOG [Catalog] WITH ACCENT_SENSITIVITY = ON
AUTHORIZATION [dbo]
E. CREATE FULLTEXT INDEX ON KnowledgeBase
(Problem, Solution) KEY INDEX PK_KnowledgeBase ON OurKB
Correct Answer: DE
Explanation/Reference:
The CREATE FULLTEXT INDEX ON table_name command creates a full-text index on a table or indexed view in a database in SQL Server.
Example: The following example creates a full-text catalog, production_catalog, in the AdventureWorks sample database. The example then creates a full-text index that uses this new catalog.
CREATE FULLTEXT CATALOG production_catalog;
GO
CREATE FULLTEXT INDEX ON Production.ProductReview
..
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-transact-sql
