PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are creating a SQL Server 2005 application that will store and manage legal documents.

The original documents are stored as XML documents on a file server. The application will be used to insert the

documents into the database. Later, the documents must be retrieved from the database. These documents must be

identical to the originals.

You need to design a table to store the document data.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Store the XML in a column that has a data type of nvarchar(max).

B.
Shred the XML and store it in a relational structure.

C.
Store the XML in a column that has a data type of XML.

D.
Store the XML in a column that has a data type of varchar(8000).


Leave a Reply