Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureEasy
A data engineering team is building a modern data warehouse on Azure. They need a storage solution that can handle petabytes of raw, unstructured, and semi-structured data, support high-performance analytics, and integrate seamlessly with other Azure analytics services like Azure Synapse Analytics. Which Azure storage solution should they choose?
- AAzure Files
- BAzure SQL Database
- CAzure Data Lake Storage Gen2
- DAzure Table Storage
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Data Lake Storage Gen2
Azure Data Lake Storage Gen2 is optimized for big data analytics workloads, offering petabyte-scale storage for various data types and deep integration with Azure analytics services.
Why the other options are wrong
- A. Azure Files is a managed file share service, not designed for large-scale analytics data lakes.
- B. Azure SQL Database is a relational database for structured data, not suitable for petabytes of raw, unstructured data.
- D. Azure Table Storage is a NoSQL key-value store, not ideal for complex analytics on diverse data types.
Azure Data Lake Storage Gen2
A highly scalable and cost-effective data lake solution built on Azure Blob Storage, optimized for big data analytics.
- Combines the best of Azure Blob Storage and Azure Data Lake Storage Gen1.
- Supports hierarchical namespace for file system semantics.
- Optimized for high-throughput, low-latency analytics workloads.
Memory trick: Lakes are vast and deep for data.