Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureMedium
A data engineering team is designing a new analytics solution for a retail company. The company needs to analyze sales data from various sources, including online transactions, in-store POS systems, and inventory management. The solution must support historical analysis, real-time dashboards, and machine learning model training. Which Azure service is primarily designed to act as the central repository for all these diverse data types before further processing?
- AAzure Data Lake Storage Gen2
- BAzure SQL Database
- CAzure Synapse Analytics
- DAzure Cosmos DB
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Data Lake Storage Gen2
Azure Data Lake Storage Gen2 is optimized for handling large volumes of diverse data types, both structured and unstructured, making it ideal as a central raw data repository for analytics workloads.
Why the other options are wrong
- B. Azure SQL Database is a relational database and not suitable for storing raw, diverse, and potentially unstructured data at scale for analytics.
- C. Azure Synapse Analytics is an analytics service that integrates data warehousing and big data processing, but it relies on an underlying storage layer like Data Lake Storage Gen2 for its data.
- D. Azure Cosmos DB is a NoSQL database suitable for specific application workloads requiring low-latency access, not typically for a raw, central analytics data lake.
Data Lake Storage Gen2
A highly scalable and cost-effective data lake solution built on Azure Blob Storage, optimized for big data analytics workloads.
- Supports petabytes of data and trillions of files.
- Offers hierarchical namespace for folder and file organization.
- Combines benefits of Blob Storage (cost-effectiveness, tiered storage) with Data Lake Store Gen1 (file system semantics).
Memory trick: Think of a lake for all your data, big and small.