You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
R2instance that contains a database named ABC_DB1.
ABC_DB1 contains a table named ABC_Prod that has a clustered primary key called
ABC_ProdID. ABC_DB1 also contains a solitary XML column, called ABC_ProdXml, which stores
XML data. ABC_ProdXmlis configured with an XML index.
After creating a new column called ABC_ProdNamein the Production table, you are instructed to
make sure that ABC_ProdNameis added to the primary key.
To achieve this, you have to alter the primary key.
Which of the following actions should you take prior to altering the primary key?
A.
You should consider configuring a non-clustered index.
B.
You should consider dropping the XML index.
C.
You should consider restoring the XML index.
D.
You should consider configuring the ABC_Prod table to make use of an XML index.
Explanation: