nerdexam
Microsoft

AZ-305 · Question #226

What two parameters would you recommend set up to ensure that the new IPSCustomers database will scale to meet the workload demands?

The correct answer is C. Define the maximum of Database Transaction Units E. Define the maximum size for a database. To ensure an Azure SQL Database scales to meet workload demands, you should define its maximum Database Transaction Units (DTUs) for performance and its maximum size for data capacity.

Submitted by klara.se· Mar 6, 2026Design data storage solutions

Question

What two parameters would you recommend set up to ensure that the new IPSCustomers database will scale to meet the workload demands?

Options

  • ADefine the maximum of CPU cores
  • BDefine the maximum resource limit per group of databases
  • CDefine the maximum of Database Transaction Units
  • DDefine the maximum of the allocated storage
  • EDefine the maximum size for a database

How the community answered

(56 responses)
  • A
    13% (7)
  • B
    4% (2)
  • C
    79% (44)
  • D
    5% (3)

Why each option

To ensure an Azure SQL Database scales to meet workload demands, you should define its maximum Database Transaction Units (DTUs) for performance and its maximum size for data capacity.

ADefine the maximum of CPU cores

While CPU cores are a resource, DTUs (option C) provide a more holistic and common blended measure of performance scaling for Azure SQL Database, encompassing CPU, memory, and I/O.

BDefine the maximum resource limit per group of databases

Defining resource limits per group of databases (elastic pools) is for managing multiple databases, but the question specifically asks about scaling a single 'IPSCustomers database' directly.

CDefine the maximum of Database Transaction UnitsCorrect

Defining the maximum Database Transaction Units (DTUs) directly controls the compute, memory, and I/O resources available to the database, allowing it to scale performance to handle increased transaction loads.

DDefine the maximum of the allocated storage

Defining the maximum of the allocated storage is conceptually similar to defining the maximum size for a database (option E), but 'maximum size' is the more standard parameter for setting the upper storage limit for an Azure SQL Database.

EDefine the maximum size for a databaseCorrect

Defining the maximum size for a database ensures that it has sufficient storage capacity to accommodate data growth over time, preventing service interruptions due to running out of space under increasing workload demands.

Concept tested: Azure SQL Database scaling parameters (DTU, max size)

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/purchasing-models?view=azuresql

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice