Exit 70-447 UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
Question 5 of 5
0% complete
Q5 Single choice

You are a database administrator for your company. Your company uses a SQL Server 2005 application.
The application executes a query that returns three columns of the nvarchar data type and one column of the XML data type. The query uses a WHERE clause that includes all three of the nvarchar columns. The table contains 5 million rows, and the query returns 50,000 rows. You need to improve the performance of the query.

What should you do?

  • A

    Create a composite index on the three nvarchar columns, and specify INCLUDE for the XML column.

  • B

    Create a primary XML index on the XML column.

  • C

    Create statistics on the nvarchar columns.

  • D

    Create a view that includes only the four columns that the query uses.

Previous Save & finish