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?
A.
Use SQL Server 2008 tables to store data and include proper indexes.
B.
Use ANSI text files to store text reports, and useSQL Server 2008 tables to store numerical reports.
C.
Save reports in binary format in a file within a Windows folder. Save the path of the file in SQL Server 2008 tables.
D.
Store reports in XML format, and use SQL Server 2008 tables to store thedata. Index the XML data to improve performance.