You are a professional level SQL Sever 2008 Database Administrator. 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, NTFS file system compression should be utilized on the volume.
B.
To achieve the goal, varbinary(MAX) data type should be utilized with FILESTREAM
storage.
C.
To achieve the goal, row-level compression should be enabled on all columns that the
vardecimal() data type is utilized.
D.
To achieve the goal, row-level compression should be utilized on the document table.