Question 6 of 10Pro Only

Design a data archival strategy for a database growing by hundreds of gigabytes per month. How do you balance storage costs, query performance, regulatory retention requirements, and the ability to access historical data when needed?

Sample answer preview

A data archival strategy must address the tension between keeping the operational database lean for performance and retaining data for compliance, analytics, and occasional retrieval.

data archivaltime-based partitioningstorage tieringS3 Glacierpartition detachdata retention

Unlock the full answer

Get the complete model answer, key points, common pitfalls, and access to 9+ more Database Administrator interview questions.

Upgrade to Pro

Starting at $19/month • Cancel anytime