Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureMedium
A media company wants to consolidate all its customer interaction data, including website clicks, video views, and social media engagement, into a single repository for comprehensive analysis. This data comes in various formats (structured, semi-structured, unstructured) and volumes. The goal is to perform ad-hoc analysis and machine learning. Which Azure service provides a scalable and cost-effective solution for storing this diverse raw data?
- AAzure Cosmos DB
- BAzure Synapse Analytics Dedicated SQL Pool
- CAzure Data Lake Storage Gen2
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Data Lake Storage Gen2
Azure Data Lake Storage Gen2 is designed to store massive amounts of data in its native format (structured, semi-structured, or unstructured), making it ideal as a central repository for diverse raw data for big data analytics and machine learning.
Why the other options are wrong
- A. Azure Cosmos DB is a NoSQL database for flexible schema transactional data, not a cost-effective or primary solution for a raw data lake with all data types.
- B. Azure Synapse Analytics Dedicated SQL Pool is a data warehousing solution for structured, processed data, not a raw data repository for diverse formats.
- D. Azure SQL Database is a relational database, unsuitable for storing diverse raw data with varying formats economically or efficiently for big data analytics.
Azure Data Lake Storage Gen2
A massively scalable, secure, and cost-effective data lake solution for high-performance big data analytics.
- Stores data in its native format (structured, semi-structured, unstructured).
- Built on Azure Blob Storage, offering tiered storage.
- Optimized for Apache Hadoop, Spark, and other big data engines.
Memory trick: Data Lake is a lake of raw data, ready for any fish.