You administer a SQL Server 2008 infrastructure. An instance contains a database that
includes a table named EmployeeData. The EmployeeData table has a column named
Profile. The column is used to store Microsoft Office Word 2003 documents. You need to
minimize the space occupied by the Profile column. You also need to maintain a reasonable
performance to retrieve the content of the column. What should you do?
A.
Use ROW compression for the EmployeeData table.
B.
Use PAGE LEVEL compression for the EmployeeData table.
C.
Implement the Profile column as a CLR user-defined type.
D.
Store the Profile column by using filestream storage, and use the NTFS file system
compression.