You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by
using the following definition:
You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What
should you do?
A.
Convert all indexes to Column Store indexes.
B.
Implement Unicode Compression.
C.
Implement row-level compression.
D.
Implement page-level compression.
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/cc280449.aspx
Reference: http://msdn.microsoft.com/en-us/library/cc280464.aspx
Reference: http://msdn.microsoft.com/en-us/library/cc280576.aspx
Reference: http://msdn.microsoft.com/en-us/library/ee240835.aspx
Answer is A
https://www.simple-talk.com/sql/database-administration/columnstore-indexes-in-sql-server-2012/
your reference says “However, because data in a columnstore index is grouped by columns, rather than by rows, data can be compressed more efficiently than with ROWSTORE indexes” but it doesn’t state “page-level compression”
is this correct?
Correct answer is D.
A is wrong since there can be only 1 columnstore index per table.