Azure SQL Database Quiz

You have an Azure subscription with 10 VMs running Windows Server 2019 and SQL Server 2019. You want to manage all SQL Server instances using a single user account. What should you do first?

• Enable a user-assigned managed identity on each VM

• Deploy an Azure AD Domain Services (Azure AD DS) domain and join the VMs

• Enable a system-assigned managed identity on each VM

• Join the VMs to the Azure AD tenant

Which disk type should you use to minimize latency for SQL Server transaction logs on Azure Virtual Machines?

• Standard HDD

• Standard SSD

• Premium SSD

• Ultra SSD

Your Azure SQL Database elastic pool with 10 databases has reached its storage limit. What are three actions you can take to resolve the alert? (Select 3)

• Increase the maximum storage of the elastic pool

• Delete data from a database

• Remove a database from the pool

• Enable data compression

• Shrink individual databases

Which three parameters are required to deploy a new Azure SQL database using Azure CLI?

• --name, --edition, --capacity

• --name, --tier, --min-capacity

• --name, --resource-group, --server

• --name, --licence-type, --capacity

For multi-server administration and MSX/TSX jobs after migrating SQL Server instances to Azure, which SQL deployment option should you select as the master server (MSX) and the target server (TSX)?

• SQL Server on Azure Virtual Machines for both MSX and TSX

• Azure SQL Database for both

• Azure SQL Managed Instance for both

• SQL Server on Azure Virtual Machines as MSX, Azure SQL Database as TSX

You need to migrate databases from an on-premises SQL Server to Azure and ensure they can communicate with on-premises SQL Server via linked server. Which hosting option should you use?

• A single Azure SQL database

• SQL Server on Azure Virtual Machines

• Azure SQL Managed Instance

• Azure SQL Database elastic pool

For an online migration from on-premises SQL Server 2016 to Azure SQL Managed Instance, which type of backup should you create, and where should you store the backup?

• Full backup to Azure Blob Storage

• Differential backup to Azure Blob Storage

• Full backup to local disk

• Transaction log backup to local disk

You need to change the SQL Server edition on an Azure VM from Enterprise to Standard, ensuring licensing compliance. What should you do first?

• From SQL Server Installation Center, run the Edition Upgrade wizard

• Uninstall the SQL Server instance

• From SQL Server Installation Center, run the Repair wizard

• From the Azure portal, reconfigure the VM

You need to minimize disk latency when creating a new Azure SQL Managed Instance. Which service tier should you choose?

• Business Critical

• Hyperscale

• General Purpose

• Premium

You need to deploy an Azure SQL database that can dynamically scale CPU and can be paused to save costs. Which option should you use?

• Business Critical service tier

• Serverless compute tier

• Elastic pool

• General Purpose service tier