Microsoft
70-450 · Question #96
70-450 Question #96: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #96. The question stem and answer options stay visible for context.
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.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.