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.