Microsoft Azure Data FundamentalsDescribe how to work with relational data on AzureMedium
A startup is developing a new mobile application that requires a flexible relational database with very low latency and high throughput for small-scale, burstable workloads. They also want to minimize costs by paying only for the resources they consume. Which Azure relational database service is best suited for this scenario?
- AAzure SQL Database (Provisioned)
- BAzure Synapse Analytics
- CAzure SQL Database (Serverless)
- DSQL Server on Azure Virtual Machines
Show answer & explanationAnswer & explanation
Correct answer: C. Azure SQL Database (Serverless)
Azure SQL Database (Serverless) automatically scales compute resources based on workload demand, pauses during inactive periods, and bills only for the compute consumed. This makes it ideal for burstable, unpredictable workloads with low latency requirements, perfectly fitting the startup's needs for cost minimization and flexibility.
Why the other options are wrong
- A. Provisioned tiers require pre-allocating compute and storage, which might lead to higher costs during low usage periods for burstable workloads.
- B. Azure Synapse Analytics is a data warehousing service, not designed for low-latency transactional workloads of a mobile application.
- D. SQL Server on Azure Virtual Machines (IaaS) requires significant management overhead and does not offer the automatic scaling and consumption-based billing of a serverless PaaS solution.
Azure SQL DB Serverless
A compute tier for Azure SQL Database that automatically scales compute, pauses when inactive, and bills based on consumed compute, suitable for intermittent workloads.
- Automatic compute scaling
- Consumption-based billing
- Automatic pausing for inactivity
- Ideal for unpredictable, burstable workloads
Memory trick: SQL's serverless tier adapts to your workload and budget.