nerdexam
Microsoft

AZ-305 · Question #55

Your company has an app named App1 that uses data from the on-premises Microsoft SQL Server databases shown in the following table. App1 and the data are used on the first day of the month only. The d

The correct answer is A. vCore-based General Purpose. Note: App1 and the data are used on the first day of the month only. See Serverless compute tier The vCore based purchasing model. The term vCore refers to the Virtual Core. In this purchasing model of Azure SQL Database, you can choose from the provisioned compute tier and serve

Submitted by salim_om· Mar 6, 2026Design data storage solutions

Question

Your company has an app named App1 that uses data from the on-premises Microsoft SQL Server databases shown in the following table. App1 and the data are used on the first day of the month only. The data is not expected to grow more than 3% each year. The company is rewriting App1 as an Azure web app and plans to migrate all the data to Azure. You need to migrate the data to Azure SQL Database. The solution must minimize costs. Which service tier should you use?

Exhibits

AZ-305 question #55 exhibit 1
AZ-305 question #55 exhibit 2

Options

  • AvCore-based General Purpose
  • BDTU-based Standard
  • CvCore-based Business Critical
  • DDTU-based Basic

How the community answered

(48 responses)
  • A
    83% (40)
  • B
    2% (1)
  • C
    4% (2)
  • D
    10% (5)

Explanation

Note: App1 and the data are used on the first day of the month only. See Serverless compute tier The vCore based purchasing model. The term vCore refers to the Virtual Core. In this purchasing model of Azure SQL Database, you can choose from the provisioned compute tier and serverless compute tier. * Provisioned compute tier: You choose the exact compute resources for the workload. * Serverless compute tier: Azure automatically pauses and resumes the database based on workload activity in the serverless tier. During the pause period, Azure does not charge you for the compute resources.

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice