PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

You administer a SQL Server 2008 instance. You deploy a new database named
Engineering. The Engineering database manages large documents that will be revised
occasionally. You need to design a table structure that allows fast read access. You also
need to minimize storage space requirements. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Use row-level compression on the document table.

B.
Use varbinary(MAX) data type with FILESTREAM storage.

C.
Use NTFS file system compression on the volume.

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


Leave a Reply