Exam 70-464 topic 1 question 45 discussion

Actual exam question from Microsoft's 70-464

Question #: 45
Topic #: 1

You have a database named Database1.
You execute the following code:

You have the following query. (Line numbers are included for reference only.)

Users report that the query takes a long time to complete.
You create a full-text index for the Notes column.
You need to recommend changes to the query to reduce the amount of time it takes for the query to complete.
Which code segment should you use to replace line 03?

A. WHERE FREETEXT(notes, '%call%') AND
B. INNER JOIN FREETEXTTABLE(dbo.table1, notes, 'call') AS t2 ON dbo.table1.ID = t2.key WHERE
C. WHERE CONTAINS(notes, 'call*') AND
D. WHERE CONTAINS(notes,*%call%'> AND

Show Suggested Answer

Suggested Answer: A 🗳️

by Kepty at Nov. 22, 2020, 8:03 p.m.

Comments

Submit Cancel

Zikato

4 years, 6 months ago

Again, none of these is correct. https://docs.microsoft.com/en-us/sql/relational-databases/search/query-with-full-text-search?view=sql-server-ver15 To match words and phrases, use CONTAINS and CONTAINSTABLE. To match the meaning, but not the exact wording, use FREETEXT and FREETEXTTABLE. So it should be CONTAINS, but to use wildcards in CONTAINS predicate, you need to wrap it in double quotation marks otherwise it takes the * literally.

upvoted 1 times

...

Kepty

4 years, 7 months ago

I don't agree with the answer. In my opinion it should be B. The A use % that are not usable inside FREETEXT functions.

upvoted 1 times

...