Microsoft
70-451 · Question #127
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…
The correct answer is D. Store reports in XML format, and use SQL Server 2008 tables to store the data. 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 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.
How the community answered
(21 responses)- A10% (2)
- B5% (1)
- C5% (1)
- D81% (17)
Community Discussion
No community discussion yet for this question.