PrepAway - Latest Free Exam Questions & Answers

You need to conserve the disk space used to store the Customers table

You administer a SQL Server 2008 instance. The instance contains an On-Line Analytical
Processing (OLAP) database along with a dimension table named Customers. The data of
the Customers table is updated every thirty minutes.

The Customers table contains redundant data.
You need to conserve the disk space used to store the Customers table.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Implement row compression.

B.
Implement page compression.

C.
Compress the hard disk that contains the instance.

D.
Defragment the hard disk that contains the instance.


Leave a Reply