Microsoft
70-451 · Question #114
70-451 Question #114: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #114. The question stem and answer options stay visible for context.
Question
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?
Options
- AUse SQL Server 2008 tables to store the data in a varchar (max) column.
- BUse SQL Server 2008 tables to store the data in a varbinary (max) column with FILESTREAM
- CUse SQL Server 2008 tables to store the data in a varbinar y(max) column.
- DUse SQL Server 2008 tables to store the data using XML datatype.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.