CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A database administrator is planning the storage requirements for a new data warehouse. The data warehouse will store 500 TB of raw data, and a 20% overhead is expected for indexes and temporary files. The company requires a 3x replication factor for disaster recovery and high availability. What is the minimum raw storage capacity (in TB) that should be provisioned?
- A1800 TB
- B1500 TB
- C900 TB
- D600 TB
Show answer & explanationAnswer & explanation
Correct answer: A. 1800 TB
First, calculate the total data size including overhead: 500 TB * 1.20 = 600 TB. Then, apply the replication factor: 600 TB * 3 = 1800 TB. This is the minimum raw storage capacity needed.
Why the other options are wrong
- B. This incorrectly applies the replication factor to only the raw data without overhead (500 * 3 = 1500).
- C. This might be a calculation error, possibly 500 * 1.2 * 1.5, or 500 * 1.8, neither of which matches the requirements.
- D. This only accounts for the raw data with overhead, not the replication factor (500 * 1.2 = 600).
Database Storage Sizing
The process of estimating the total disk space required for a database, considering raw data, indexes, overhead, and replication/backup needs.
- Always account for overhead (indexes, logs, temp files).
- Factor in replication for HA/DR.
- Consider future growth and retention policies.
Memory trick: Size it up: Raw, Overhead, then Replicate!