nerdexam
Microsoft

70-451 · Question #114

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…

The correct answer is D. Use SQL Server 2008 tables to store the data using XML datatype. See the full explanation below for the reasoning.

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.

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    12% (3)
  • C
    8% (2)
  • D
    77% (20)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-451 Practice