YOU HAVE A DATABASE TABLE WITH A FILESTREAM FIELD IN IT. MOST OF T...

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.