You u se S QL S erver 2 008 t o d esign a d atabase t hat w ill h old i ncoming XML r
esponses f or a n 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?
A.
Use SQL Server 2008 tables to store the data using XML datatype.
B.
Use SQL Server 2008 tables to store the data in a varbinar y(max) column.
C.
U se S QL S erver 2 008 t ables t o s tore the d ata i n a v arbinary ( max) c olumn w ith F
ILESTREAM option.
D.
Use SQL Server 2008 tables to store the data in a varchar (max) column.