PrepAway - Latest Free Exam Questions & Answers

You need to minimize the space occupied by the Profile column

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply