You are a professional level SQL Sever 2008 Database Administrator. A database is
included by the instance, and a table named EmployeeData is contained by the database.
There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003
documents are stored in the column. The space utilized by the Profile column should be cut
to the least. In addition, a reasonable performance should be maintained to retrieve the
content of the column. Which action will you perform?
A.
The Profile column should be stored by utilizing filestream storage, and the NTFS file
system compression should be utilized.
B.
PAGE LEVEL compression should be utilized for the EmployeeData table.
C.
ROW compression should be utilized for the EmployeeData table.
D.
The Profile column should be implemented as a CLR user-defined type.