Microsoft
70-432 · Question #190
70-432 Question #190: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #190. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName. The current database collation is SQL_Latin1_General_Cp1_CI_AS. You need to ensure that the indexes which include the CompanyName column are case- sensitive. You also need to ensure that other case-insensitive queries are unaffected. What should you do?
Options
- AUse the UPPER function in the filter criteria on all queries that filter on the CompanyName
- BDrop all indexes on the Sales database.Modify the database to specify
- CUse the CAST function in the filter criteria on all queries that filter on the CompanyName
- DDrop all indexes on the Customer table that include the CompanyName column in the index
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.