PrepAway - Latest Free Exam Questions & Answers

What should you do?

Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Implement horizontal partitioning.

B.
Implement vertical partitioning.

C.
Implement a raw partition.

D.
Implement distributed partitioning.


Leave a Reply