Which compression technology should you use?

You administer a SQL Server 200S 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 hour.
The Customers table contains redundant data.
You need to conserve the disk space used to store the Customers table.
Which compression technology should you use?

You administer a SQL Server 200S 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 hour.
The Customers table contains redundant data.
You need to conserve the disk space used to store the Customers table.
Which compression technology should you use?

A.
Row compression

B.
Page compression

C.
Backup compression

D.
Windows NITS file system compression



Leave a Reply 0

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