Microsoft
70-433 · Question #93
70-433 Question #93: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
Question
You have a table named Person that contains a nvarchar column named Surname. The Person table currently has a clustered index on PersonID. The Surname column contains Russian and Japanese characters. The following code segment will be used to search by Surname. IF @lang ='Russian' SELECT PersonID, Surname FROM Person WHERE Surname = @SearchName COLLATE Cyrillic_General_CI_AS if @lang = 'Japanese' SELECT PersonID, Surname FROM Person WHERE Surname = @SearchName COLLATE Japanese_CI_AS_KS You need to enable SQL Server to perform an index seek for these queries. What should you do?
Options
- ACreate an index on the Surname column.
- BCreate a computed column for each collation that needs to be searched.
- CCreate a computed column for each collation that needs to be searched.
- DCreate a new column for each collation that needs to be searched and copy
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 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.