How can you achieve this goal?

You work as a Database Administrator (DBA) at ABC.com.

All databases are hosted on Windows Server 2012 servers running SQL Server 2012.

The Sales department uses a database named SalesDB.

SalesDB contains a large table named Orders that lists every order ever received by the company. You want to improve the performance of SalesDB.

You want to configure the database to provide the fastest possible access to the most recent orders.

Historical orders can be stored using a slower storage solution.

How can you achieve this goal?
A . By configuring database mirroring.
B . By configuring a failover cluster.
C . By partitioning the Orders table.
D . By partitioning a partitioned view of the Orders table.

View Answer

Answer: C