What should you do to make CK_ProdID the primary key?

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.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *