Microsoft
70-432 · Question #190
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…
The correct answer is A. Use the UPPER function in the filter criteria on all queries that filter on the CompanyName. See the full explanation below for the reasoning.
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
How the community answered
(37 responses)- A81% (30)
- B5% (2)
- C3% (1)
- D11% (4)
Community Discussion
No community discussion yet for this question.