Microsoft
70-450 · Question #73
70-450 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. A database is included by an instance. And a large table named OrderDetails is included by the database. Only DML statements on the last three months data are executed by the application queries. Administrative audits are managed monthly on data which is longer than four months. The performance problems listed below are found by you in the database . The performance of the application queries against the OrderDetail table is poor. It takes a long time to perform the maintenance tasks against the database, index defragmentation is contained. The performance problems should be solved with on impact on the server performance. Which action will you perform?
Options
- AA database snapshot should be created for the OrderDetails table every four months.
- BAn additional table named OrderDetailsHistory should be created for data older than four
- CAn additional table named OrderDetailsHistory should be created for data longer than four
- DAn additional table named OrderDetailsHistory should be created for data older than four
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.