CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A database administrator is deploying a new database instance for a Big Data analytics platform. The platform will store petabytes of semi-structured data and needs to perform complex analytical queries across this vast dataset. The team wants to minimize storage costs while ensuring reasonable query performance. Which storage tier is MOST appropriate for this scenario?
- AStandard HDD
- BArchive Storage
- CPremium SSD
- DCold HDD
Show answer & explanationAnswer & explanation
Correct answer: D. Cold HDD
Cold HDD storage is designed for large volumes of infrequently accessed data where cost is a primary concern. For petabytes of semi-structured data in an analytics platform, 'reasonable query performance' often implies that the data isn't accessed with the same urgency as transactional data, making Cold HDD a good balance between cost and performance for analytical workloads on vast datasets.
Why the other options are wrong
- A. Standard HDD is a general-purpose tier, cheaper than SSDs, but might not provide the 'reasonable' performance required for complex analytical queries on petabytes of data compared to Cold HDD, which is often optimized for sequential reads of large blocks.
- B. Archive storage is for very long-term retention of rarely accessed data, with high retrieval latency and costs, making it unsuitable for a platform requiring 'reasonable query performance'.
- C. Premium SSD offers high IOPS and low latency, suitable for high-performance transactional databases, but is significantly more expensive than needed for petabyte-scale analytics with 'reasonable' performance.
Cloud Storage Tiers
Different categories of cloud storage services offered by providers, varying in cost, performance (IOPS, latency), and availability characteristics.
- Optimized for different access patterns (hot, warm, cold, archive).
- Cost scales inversely with access frequency and performance.
- Choosing the right tier is crucial for cost optimization and meeting performance SLAs.
Memory trick: Match data heat to storage cost: hot for speed, cold for cheap.