You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. CK_DB1 contains a table named
CK_Prod that has a clustered primary key called CK_ProdID. Also, the CK_DB1 contains a single
XML column called CK_ProdXml which stores XML data. However, CK_ProdXml has an XML
index. You then create a new column called CK_ProdName to the Production table. You need to
make CK_ProdID the primary key.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
A.
You should consider making the XML index on CK_ProdName disabled.
B.
You should consider changing the XML index.
C.
You should consider reproducing the XML index.
D.
You should consider transferring the XML data to a temporary before clearing the XML
information from the original table by configuring CK_ProdName to NULL.
E.
You should consider setting the ALLOW_ROW_LOCKS = ON option.
F.
You should consider using the statement “Drop the XML index on the table” and change the primary key.