70-450 · Question #73
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 correct answer is B. An additional table named OrderDetailsHistory should be created for data older than four. The easiest way to deal with history tables is to use partitioned tables and the switch command should be use to attach the old data to the history table.
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
How the community answered
(17 responses)- A6% (1)
- B76% (13)
- C6% (1)
- D12% (2)
Explanation
The easiest way to deal with history tables is to use partitioned tables and the switch command should be use to attach the old data to the history table.
Topics
Community Discussion
No community discussion yet for this question.