Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureEasy
A company is planning to implement a modern data warehouse solution on Azure. They have a requirement to store historical data for several years, which will be infrequently accessed but needs to be available for compliance audits and occasional analytical queries. Which Azure storage solution is most cost-effective for this scenario?
- AAzure Data Lake Storage Gen2 with Archive tier
- BAzure Premium SSD
- CAzure SQL Database
- DAzure Ultra Disk Storage
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Data Lake Storage Gen2 with Archive tier
Azure Data Lake Storage Gen2 with its Archive tier is designed for highly cost-effective storage of infrequently accessed data, making it ideal for long-term historical data retention for compliance and occasional analytics.
Why the other options are wrong
- B. Azure Premium SSD is optimized for high-performance, frequently accessed data, which is not cost-effective for infrequently accessed historical data.
- C. Azure SQL Database is a relational database service, not a cost-effective solution for storing large volumes of historical, unstructured/semi-structured data that is infrequently accessed.
- D. Azure Ultra Disk Storage provides extremely high performance for I/O-intensive workloads, making it prohibitively expensive for infrequently accessed historical data.
Azure Data Lake Storage Gen2 Archive Tier
A highly cost-effective storage tier within Azure Data Lake Storage Gen2, designed for rarely accessed, long-term data retention.
- Lowest cost storage option for ADLS Gen2.
- Optimized for data that can tolerate longer retrieval times.
- Ideal for compliance, audit, and long-term backup data.
Memory trick: Archive your old data to save big bucks over time.