Microsoft
70-450 · Question #110
70-450 Question #110: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #110. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 infrastructure. An instance contains a database that includes a table named EmployeeData. The EmployeeData table has a column named Profile. The column is used to store Microsoft Office Word 2003 documents. You need to minimize the space occupied by the Profile column. You also need to maintain a reasonable performance to retrieve the content of the column. What should you do?
Options
- AUse ROW compression for the EmployeeData table.
- BUse PAGE LEVEL compression for the EmployeeData table.
- CImplement the Profile column as a CLR user-defined type.
- DStore the Profile column by using filestream storage, and use the NTFS file system
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.