Microsoft
70-432 · Question #7
You are the administrator of a SQL Server 2008 instance. There is a n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever…
The correct answer is B. You should use page compression. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There is a n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. Which compression technology should you use?
Options
- AYou should use row compression
- BYou should use page compression
- CYou should use backup compression
- DYou should use windows NTFS file system compression
How the community answered
(57 responses)- A11% (6)
- B82% (47)
- C2% (1)
- D5% (3)
Community Discussion
No community discussion yet for this question.