PrepAway - Latest Free Exam Questions & Answers

Which Transact-SQL statements should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE CLUSTERED INDEX CL_IDX_Customer ON Customers(CustomerID);
CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR PATH;

B.
CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR VALUE;

C.
CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR PATH;

D.
CREATE CLUSTERED INDEX CL_IDX_Customer ON Customers(CustomerID);
CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer_Property ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR VALUE;


Leave a Reply