Exam 70-761 topic 1 question 157 discussion

HOTSPOT -
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:

Users report that searches for the product Salt also return results for the product salt.
You need to ensure that the query returns the correct results.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Suggested Answer:
References:
https://stackoverflow.com/questions/1831105/how-to-do-a-case-sensitive-search-in-where-clause-im-using-sql-server