What should you do?
Correct Answer for the following Question is given below
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?XML datatype is the best option to store XML data.• XML indexes can be created on xml data type columns. They index all tags, values and paths over the XML instances in the column and benefit query performance.• You can use the xml data type methods to query an XML instance stored in a variable or column of xml type.• You can associate an XML schema collection with a column, a parameter, or a variable of the xml data type to validate the XML.The only limitation is that the size of the xml document in the xml data type column cannot exceed 2GB.
Question:
What should you do?
Options:
Use SQL Server 2008 tables to store the data in a varbinary(max) column with FILESTREAM option
Use SQL Server 2008 tables to store the data in a varbinary(max) column.
Use SQL Server 2008 tables to store the data in a varchar(max) column.
Use SQL Server 2008 tables to store the data using XML datatype.
Correct Answer
The Correct Answer for this Question is
Use SQL Server 2008 tables to store the data using XML datatype.
Explanation
The Question – What should you do? has been answered correctly and answers for the question is Use SQL Server 2008 tables to store the data using XML datatype.
More about these Exams
These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.
We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.
you can find more here at mnccertified
Feel free to contact via comment or email.
Happy Learning
Cheers, Team MNCcertified
