Microsoft
70-433 · Question #23
70-433 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
You have a table named Customers that has an XML column named CustomerData. There are currently no indexes on the table. You use the following WHERE clause in a query: WHERE CustomerData.exist ('/CustomerDemographic/@Age[.>="21"]') = 1 You need to create indexes for the query. Which Transact-SQL statements should you use?
Options
- ACREATE CLUSTERED INDEX CL_IDX_Customer
- BCREATE PRIMARY XML INDEX PXML_IDX_Customer
- CCREATE PRIMARY XML INDEX PXML_IDX_Customer
- DCREATE CLUSTERED INDEX CL_IDX_Customer
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.