You are designing a database that will be used for reporting purposes. You need to minimize the data storage requirements and improve the application response time. What should you recommend?
A.
row compression
B.
sparse columns
C.
table partitioning
D.
XML