Microsoft
70-450 · Question #96
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…
The correct answer is A. Use NTFS file system compression on the volume. C. Use varbinary(MAX) data type with FILESTREAM storage. See the full explanation below for the reasoning.
Question
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.)
Options
- AUse NTFS file system compression on the volume.
- BUse row-level compression on the document table.
- CUse varbinary(MAX) data type with FILESTREAM storage.
- DEnable row-level compression on all columns that use the vardecimal() data type.
How the community answered
(28 responses)- A82% (23)
- B7% (2)
- D11% (3)
Community Discussion
No community discussion yet for this question.