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.

Answer: C

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments