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