How would you accomplish this?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com has an instance
with an On-Line Analytical Processing (OLAP) database and a dimension table named ABC_TST.
ABC_TST is updated continuously. You want to reduce storage space used by the ABC_TST
table by compressing any redundant data in the table.
How would you accomplish this?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com has an instance
with an On-Line Analytical Processing (OLAP) database and a dimension table named ABC_TST.
ABC_TST is updated continuously. You want to reduce storage space used by the ABC_TST
table by compressing any redundant data in the table.
How would you accomplish this?

A.
You should consider using Page compression.

B.
You should consider using NTFS file system compression.

C.
You should consider using Transaction compression.

D.
You should consider using Dimension compression.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *