You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 instance is utilized by you. A new
database named Engineering is deployed. Large documents are managed by the Engineering database,
and the documents will be revised occasionally. A table structure should be designed to permit fast read
access. The storage space requirements should be cut to the least.What will you do to achieve the goal?
(Choose more than one.)
A.
To achieve the goal, row-level compression should be utilized on the document table.
B.
To achieve the goal, NTFS file system compression should be utilized on the volume.
C.
To achieve the goal, varbinary(MAX) data type should be utilized with FILESTREAM storage.
D.
To achieve the goal, row-level compression should be enabled on all columns that the vardecimal() data type is utilized.