Microsoft
70-450 · Question #110
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…
The correct answer is D. Store the Profile column by using filestream storage, and use the NTFS file system. See the full explanation below for the reasoning.
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
How the community answered
(24 responses)- A4% (1)
- B17% (4)
- C8% (2)
- D71% (17)
Community Discussion
No community discussion yet for this question.