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
May’be this question relate to exam 70-462?
0
0
Maybe. Anyway, it’s a good topic to read https://msdn.microsoft.com/en-us/library/cc280449.aspx
0
0
By the way, part of that new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0