6. You’re responsible for maintenance for a mission-critical database that is 650 GB
in size, with a particularly large sales order table. The nightly index maintenance
scripts are fully optimized but regularly run longer than the maintenance
window. How could you resolve this with minimal impact to the business?
A. Delete old data from the sales order table.
B. Separate sales data into separate databases, one for each calendar year.
C. Don’t carry out index maintenance.
D. Implement table partitioning.
The correct answer is D. Table partitioning is well suited to address this
requirement. Options A, B, and C will all impact the business.
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX