PrepAway - Latest Free Exam Questions & Answers

What will you do to implement solutions on security, troubleshooting, deployment and optimization?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle.

In the company, your job is to implement solutions on security,  troubleshooting, deployment and optimization.

A SQL Server 2008 infrastructure is managed by you. The largest table in a database is partitioned into four equal-sized parts.

The first two partitions are seldom queried, while the third partition is regularly queried by several reports.

Meanwhile, the fourth partition is heavily queried and regularly modified.
The disk space of the table should be cut to the least and the query  performance should be with the least impact.

What will you do? (Choose more than one.)

PrepAway - Latest Free Exam Questions & Answers

A.
PAGE compression should be enabled for the first two partitions.

B.
ROW compression should be enabled for the last partition.

C.
ROW compression should be enabled for the third partition.

D.
ROW compression should be enabled for the first two partitions.

E.
PAGE compression should be enabled for the last partition.

F.
PAGE compression should be enabled for the third partition.


Leave a Reply