what should you do to reduce storage space requirements?

You are the administrator of your company network. And you’re in charge of SQL Server 2008 instance. Now you deploy a new database named TCK which manages large documents. The documents will be revised sometimes. Fast read access must be permitted by developing a table structure. Meanwhile, you have to reduce storage space requirements. So what should you do? (Each correct answer presents part of the solution. Choose two.)

You are the administrator of your company network. And you’re in charge of SQL Server 2008 instance. Now you deploy a new database named TCK which manages large documents. The documents will be revised sometimes. Fast read access must be permitted by developing a table structure. Meanwhile, you have to reduce storage space requirements. So what should you do? (Each correct answer presents part of the solution. Choose two.)

A.
You should use NTFS file system compression on the volume.

B.
You should use row-level compression on the document table.

C.
You should use varbinary(MAX) data type with FILESTREAM storage.

D.
You should enable row-level compression on all columns that use the vardecimal() data type.



Leave a Reply 0

Your email address will not be published. Required fields are marked *