70-465 · Question #107
70-465 Question #107: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #107. The question stem and answer options stay visible for context.
Question
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?
Options
- ABy configuring database mirroring.
- BBy configuring a failover cluster.
- CBy partitioning the Orders table.
- DBy partitioning a partitioned view of the Orders table.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.