PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Row compression

B.
Page compression

C.
Backup compression

D.
Windows NITS file system compression


Leave a Reply