Microsoft
70-450 · Question #12
70-450 Question #12: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 infrastructure. An instance contains a database that includes a large table named OrderDetails. The application queries only execute DML statements on the last three months data. Administrative audits are conducted monthly on data older than three months. You discover the following performance problems in the database. The performance of the application queries against the OrderDetail table is poor. The maintenance tasks against the database, including index defragmentation, take a long time. You need to resolve the performance problems without affecting the server performance. What should you do?
Options
- ACreate a database snapshot for the OrderDetails table every three months.
- BCreate an additional table named OrderDetailsHistory for data older than three months.
- CCreate an additional table named OrderDetailsHistory for data older than three months.
- DCreate an additional table named OrderDetailsHistory for data older than three months.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.