70-432 · Question #109
You are the administrator of a SQL Server 2008 instance with a database named named Dworks. The Dworks database contains a table named BillDetails which has a clustered primary key named BillId on…
The correct answer is A. You should drop the XML index on the table. Modify the primary key. Recreate the XML index. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named named Dworks. The Dworks database contains a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. Which action should you perform to achieve this goal?
Options
- AYou should drop the XML index on the table. Modify the primary key. Recreate the XML index
- BYou should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option.
- CYou should move the XML data to a temporary table.
- DYou should disable the XML index on the GoodsDetails column. Modify the primary key.
How the community answered
(54 responses)- A72% (39)
- B4% (2)
- C9% (5)
- D15% (8)
Community Discussion
No community discussion yet for this question.