Microsoft
70-432 · Question #97
You are the administrator of 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…
The correct answer is B. Page compression. See the full explanation below for the reasoning.
Question
You are the administrator of 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 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?
Options
- ARow compression
- BPage compression
- CBackup compression
- DWindows NTFS file system compression
How the community answered
(33 responses)- A9% (3)
- B82% (27)
- C6% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.