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 configuring a partitioned view of the Orders table.
Explanation: