PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

You administer a SQL Server 2008 infrastructure.
You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third partition is frequently queried by several reports. The last partition is heavily queried and frequently modified.
You need to minimize the disk space of the table and ensure that this has minimum effect on the query performance.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Enable ROW compression for the last partition.

B.
Enable ROW compression for the third partition.

C.
Enable ROW compression for the first two partitions.

D.
Enable PAGE compression for the last partition.

E.
Enable PAGE compression for the third partition.

F.
Enable PAGE compression for the first two partitions.


Leave a Reply