nerdexam
Microsoft

70-451 · Question #127

70-451 Question #127: Real Exam Question with Answer & Explanation

Sign in or unlock 70-451 to reveal the answer and full explanation for question #127. 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 EDI system. You have the following requirements: - The data is accessible to heterogeneous platforms: - The database stores various types of reports from multiple sources. - The solution allows search by keywords. - The database stores large amounts of data. - The database is scalable. You need to design the database to meet the given requirements. What should you do?

Options

  • AUse SQL Server 2008 tables to store data and include proper indexes.
  • BUse ANSI text files to store text reports, and use SQL Server 2008 tables to store numerical
  • CSave reports in binary format in a file within a Windows folder.
  • DStore reports in XML format, and use SQL Server 2008 tables to store the data.

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.

Full 70-451 Practice