70-450 · Question #12
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…
The correct answer is B. Create an additional table named OrderDetailsHistory for data older than three months. See the full explanation below for the reasoning.
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.
How the community answered
(32 responses)- A3% (1)
- B84% (27)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.