Azure SQL Database Scaling Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Configure Resources for Scale

What you'll be asked

  1. Which scaling model for Azure SQL Database allows you to independently scale compute and storage resources?
  2. You have a workload that is highly unpredictable with long idle periods. Which configuration is most cost-effective for this scenario?
  3. When using an Elastic Pool, what is the primary benefit of setting a 'min vCores' and 'max vCores' per database?
  4. Your application requires a database that can scale up to 100 TB of storage. Which Azure SQL Database service tier supports this requirement?
  5. You are scaling a Business Critical database and notice that the application experiences a brief connection drop during the scale operation. What is the technical cause of this behavior?

Answers and explanations come after you submit.