What should you do?

You use SQL Server 2008 to design a database that will hold incoming XML responses for an Electronic Data Interchange system.
You have the following requirements:
• The database is scalable.
• The data is accessible to heterogeneous platforms.
• The database stores various types of reports from multiple sources.
• The database stores large amounts of data.
• The solution allows search by keywords.
• Full-text search is not enabled in the database.
You need to design the database to meet these requirements.
What should you do?
A. Use SQL Server 2008 tables to store the data in a varbinary(max) column with FILESTREAM option
B. Use SQL Server 2008 tables to store the data in a varbinary(max) column.
C. Use SQL Server 2008 tables to store the data in a varchar(max) column.
D. Use SQL Server 2008 tables to store the data using XML datatype.

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.