Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1. You need to migrate DB1 to a vCore-based purchasing model by using the Azure Command-Line Interface…

Question

Exhibit

Answer Area

• az sql db update -g RG1 -s Server1 -n DB1 --editionHyperscale
  GeneralPurposeHyperscalePremiumStandard
• --service-objective HS_Gen5_2 --read-replicas 2
  --manual-cutover--perform-cutover--read-scale--zone-redundant

Explanation

This question tests knowledge of Azure CLI commands to migrate an Azure SQL Database to the vCore-based purchasing model with high availability replicas while minimizing downtime.

Approach. The correct Azure CLI command is 'az sql db update' to modify the existing DB1 without recreating it, which minimizes downtime. The '--edition' flag should be set to 'GeneralPurpose' or 'BusinessCritical' (vCore-based tiers), '--family' should specify the hardware generation (e.g., 'Gen5'), '--capacity' sets the number of vCores, and '--ha-replicas' (or '--read-replicas') should be set to '2' to include two high availability replicas. Using 'az sql db update' instead of delete/recreate minimizes downtime since it performs an in-place migration. The '--ha-replicas 2' parameter specifically provisions two additional high availability replicas for zone redundancy or read scale-out, which is available in the vCore model under BusinessCritical or Hyperscale tiers.

Concept tested. Migrating an Azure SQL Database to the vCore purchasing model using Azure CLI, specifically using 'az sql db update' with parameters such as --edition (e.g., BusinessCritical or Hyperscale), --family (Gen5), --capacity (number of vCores), and --ha-replicas 2 to meet high availability and minimal downtime requirements.

Reference. https://learn.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-update

No community discussion yet for this question.