10. You have a database table with a FileStream field in it. Most of the records in
the table have a null value for this field. What’s the best way to save space?
A. Move the data into a second table
B. Use sparse columns
C. Use the SQL Server 2008 Declarative Management Framework
D. None of the above
The correct answer is D. Answer A is incorrect; this will not save space. Answer B
is incorrect, as sparse columns will take up less space for most columns, but
cannot be used for text, ntext, image, timestamp, user-defined data type,
geometry, or geography or varbinary (max) with the FileStream attribute
can be sparse.
Bạn đang xem 10. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC