Exam 70-761 topic 1 question 161 discussion

Actual exam question from Microsoft's 70-761

Question #: 161
Topic #: 1

You develop and deploy a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application.
The add-on must meet the following requirements:
"¢ Allow case sensitive searches for product.
"¢ Filter search results based on exact text in the description.
"¢ Support multibyte Unicode characters.
You run the following Transact-SQL statement:

You need to ensure that users can perform searches of descriptions.
Which Transact-SQL statement should you run?

A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: D
References:
https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-2017

by M4x at Sept. 13, 2019, 10:29 a.m.

Comments

Submit Cancel

M4x

Highly Voted 5 years, 9 months ago

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Test.dbo.Table_1' because it is not full-text indexed. Correct answer A https://docs.microsoft.com/it-it/sql/t-sql/functions/charindex-transact-sql?view=sql-server-2017

upvoted 10 times

mattia_88

5 years, 7 months ago

is incomplete the answer A

upvoted 1 times

...

mattia_88

Highly Voted 5 years, 7 months ago

"Allow case sensitive searches for product" CHARINDEX (@term,[DESCRIPTION] COLLATE Latin1_General_CS_AS)

upvoted 8 times

...

Deimy

Most Recent 4 years, 10 months ago

CREATE TABLE Bug ( Id UNIQUEIDENTIFIER NOT NULL, Product NVARCHAR(255) NOT NULL, Description NVARCHAR(max) NOT NULL, DateCreated DATETIME NULL, ReportingUser VARCHAR(5) NULL ) INSERT INTO Bug (Id, Product, Description, DateCreated, ReportingUser) VALUES (NEWID(), N'P1', N'P1¢',GETUTCDATE(), 'User1'), (NEWID(), N'P2', N'P2¢',GETUTCDATE(), 'User2'), (NEWID(), N'P3', N'P3',GETUTCDATE(), 'User3'); DECLARE @term NVARCHAR(255) SET @term = N'¢' /*SELECT Id, Description FROM Bug WHERE CONTAINS(Description, @term) ;*/ SELECT Id, Description FROM Bug WHERE CHARINDEX(@term, Description) > 0; answer is A

upvoted 6 times

...

Bartek

5 years, 8 months ago

https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-2017 "The columns in the CONTAINS clause must come from a single table that has a full-text index. Unless language_term is specified, the language of all columns of the table must be the same."

upvoted 1 times

...