Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureHard
A small startup is building its first analytics solution on Azure. They have limited budget and initially expect moderate data volumes (hundreds of GBs) and analytical query needs. They want a data warehousing solution that allows them to scale compute and storage independently and pause compute resources during off-hours to save costs. Which Azure Synapse Analytics component best meets these requirements?
- AAzure Synapse Analytics serverless SQL pool
- BAzure Cosmos DB
- CAzure Synapse Analytics dedicated SQL pool
- DAzure Databricks
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Synapse Analytics dedicated SQL pool
Azure Synapse Analytics dedicated SQL pool (formerly Azure SQL Data Warehouse) allows you to provision specific compute resources (Data Warehouse Units - DWUs) for structured data warehousing. It supports independent scaling of compute and storage, and critically, allows you to pause compute when not in use to save costs, which is important for a startup with a limited budget.
Why the other options are wrong
- A. Serverless SQL pool is pay-per-query and doesn't involve pausing compute, as it's always on-demand, which might be less predictable for cost management in some scenarios.
- B. Azure Cosmos DB is a NoSQL operational database, not a data warehousing solution for structured analytical queries.
- D. Azure Databricks is a Spark-based platform, excellent for big data processing and ML, but not a traditional relational data warehouse and typically has higher running costs than a paused dedicated SQL pool.
Azure Synapse Dedicated SQL Pool Pause/Resume
A feature of Azure Synapse Dedicated SQL pools that allows users to pause compute resources when not in use, significantly reducing operational costs.
- Pausing stops compute billing while retaining data.
- Resuming restarts compute, typically within minutes.
- Ideal for cost optimization during non-business hours or inactive periods.
Memory trick: Dedicated pool, dedicated savings: pause the power!