AZ-305 Question #226: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• A. 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.
• B. 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.
• D. 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.

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

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

No community discussion yet for this question.