Font size
WorksheetsAzure SQL Database Quiz
Total questions: 23
Worksheet time: 12mins
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
For Azure SQL Managed Instance, which service tier and hardware generation maximize the memory-to-vCore ratio and optimize latency?
General Purpose on standard-series
Business Critical on premium-series
General Purpose on memory-optimized-series
Business Critical on memory-optimized-series
You want to migrate a SQL Server 2017 instance to Azure using the latest SQL version, supporting SQL Server Agent, and with minimal administrative effort. Which service should you use?
Azure SQL Database elastic pool
Azure SQL Database
SQL Server on Azure Virtual Machines
Azure SQL Managed Instance
You need to recommend a solution for migrating five SQL Server 2017 databases to Azure that automatically scales compute and provides per-second billing. What should you use?
Azure SQL Managed Instance
Azure SQL Database serverless
SQL Server on Azure Virtual Machines
Azure SQL Database elastic pool
You have an on-premises SQL Server 2019 database using merge replication. Which Azure service should you use for migration?
Azure SQL Edge
Azure SQL Database
SQL Server on Azure Virtual Machines
Azure SQL Managed Instance
You have a 2-TB on-premises SQL Server 2019 database to migrate to Azure SQL Managed Instance. The solution must minimize downtime and admin effort. What should you include?
Log Replay Service (LRS)
Log shipping
Transactional replication
SQL Data Sync
You need an Azure VM series for SQL Server that supports Write Accelerator. Which should you use?
E-series
G-series
H-series
M-series
You want to replicate an on-premises SQL Server 2019 database to Azure SQL Database. Which replication type should you use?
Transactional
Peer-to-peer
Snapshot
Merge
You have two on-premises servers running SQL Server 2017 Always On availability group with DB1. You want to migrate DB1 to a SQL Server 2019 instance on an Azure Linux VM, minimizing downtime. What should you do?
Remove DB1 from AG, backup and restore to Azure
Use log shipping
Add the Azure VM as a replica, failover, then remove from AG
Replicate using Azure Database Migration Service
You need to create a partitioned table in an Azure SQL Database. What is the correct sequence of objects to create?
Partition function, partition scheme, table
Table, partition scheme, partition function
Partition scheme, table, partition function
Table, partition function, partition scheme
On a SQL Server VM, you want a SQL Server Agent job step to access files in an AD DS file share using least privilege. What three steps should you perform (in order)?
Create a credential for the domain account
Grant the account permissions on the file share
Map the credential to a SQL Server Agent proxy
Grant the proxy permission for the job step
Add the domain account to the Administrators group
You need to deploy an Azure VM running SQL Server with custom IOPS, capacity, and throughput, and minimize costs. Which disk type should you use?
Premium SSD v2
Premium SSD
Standard SSD
Ultra SSD
Which three service tiers support SQL Managed Instance for a 14-TB database?
General Purpose Standard
Business Critical Memory Optimized Premium
General Purpose Premium
Business Critical Premium
Business Critical Standard
Which solution provides randomized encryption, supports comparison operators, and encrypts data in motion for Azure SQL Database?
Always Encrypted with secure enclaves
Always Encrypted
Column-level encryption
Transparent Data Encryption (TDE)
