PrepAway - Latest Free Exam Questions & Answers

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.)

PrepAway - Latest Free Exam Questions & Answers

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