Your company is rewriting an application (App1) as an Azure Web App. App1 uses data from on-premises Microsoft SQL Server databases that are accessed only on the first day of each month. Data growth is expected to remain under 3% per year. You must migrate the data to Azure SQL Database and ensure the database is available only on the first day of each month. Which Azure SQL Database service tier should you choose?
Choose an answer
Tap an option to check your answer.
Correct answer: vCore-based General Purpose.
Why this is the answer
The vCore-based General Purpose tier is suitable because it offers a balance of cost and performance, and importantly, allows for compute resources to be scaled down to a minimal configuration (or even paused in some cases with serverless) when not in use. Since the database is only accessed once a month, this flexibility in scaling compute resources will significantly reduce costs compared to other tiers that maintain dedicated resources. DTU-based Standard and Basic tiers are less flexible for cost optimization in this scenario as they don't offer the same granular control over compute scaling. vCore-based Business Critical provides high availability and I/O performance, which is overkill and more expensive for a database only accessed monthly.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed