Microsoft Exam Questions

What should you recommend?

You are designing a database that will be used for reporting purposes. The database stores
data using spatial data type. You need to minimize the data storage requirements and
improve the application response time. What should you recommend?

A.
Use sparse columns.

B.
Use XML datatype.

C.
Use table partitioning.

D.
Use row compression.