YOU’RE RESPONSIBLE FOR MAINTENANCE FOR A MISSION-CRITICAL DATABASE...

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.