wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Azure SQL Database Quiz

Total questions: 23

Worksheet time: 12mins

Name
Class
Date
1.

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?

a)

Enable a user-assigned managed identity on each VM

b)

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

c)

Enable a system-assigned managed identity on each VM

d)

Join the VMs to the Azure AD tenant

2.

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

a)

Standard HDD

b)

Standard SSD

c)

Premium SSD

d)

Ultra SSD

3.

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)

a)

Increase the maximum storage of the elastic pool

b)

Delete data from a database

c)

Remove a database from the pool

d)

Enable data compression

e)

Shrink individual databases

4.

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

a)

--name, --edition, --capacity

b)

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

c)

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

d)

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

5.

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)?

a)

SQL Server on Azure Virtual Machines for both MSX and TSX

b)

Azure SQL Database for both

c)

Azure SQL Managed Instance for both

d)

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

6.

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)

A single Azure SQL database

b)

SQL Server on Azure Virtual Machines

c)

Azure SQL Managed Instance

d)

Azure SQL Database elastic pool

7.

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?

a)

Full backup to Azure Blob Storage

b)

Differential backup to Azure Blob Storage

c)

Full backup to local disk

d)

Transaction log backup to local disk

8.

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

a)

From SQL Server Installation Center, run the Edition Upgrade wizard

b)

Uninstall the SQL Server instance

c)

From SQL Server Installation Center, run the Repair wizard

d)

From the Azure portal, reconfigure the VM

9.

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

a)

Business Critical

b)

Hyperscale

c)

General Purpose

d)

Premium

10.

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?

a)

Business Critical service tier

b)

Serverless compute tier

c)

Elastic pool

d)

General Purpose service tier

11.

For Azure SQL Managed Instance, which service tier and hardware generation maximize the memory-to-vCore ratio and optimize latency?

a)

General Purpose on standard-series

b)

Business Critical on premium-series

c)

General Purpose on memory-optimized-series

d)

Business Critical on memory-optimized-series

12.

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?

a)

Azure SQL Database elastic pool

b)

Azure SQL Database

c)

SQL Server on Azure Virtual Machines

d)

Azure SQL Managed Instance

13.

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?

a)

Azure SQL Managed Instance

b)

Azure SQL Database serverless

c)

SQL Server on Azure Virtual Machines

d)

Azure SQL Database elastic pool

14.

You have an on-premises SQL Server 2019 database using merge replication. Which Azure service should you use for migration?

a)

Azure SQL Edge

b)

Azure SQL Database

c)

SQL Server on Azure Virtual Machines

d)

Azure SQL Managed Instance

15.

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?

a)

Log Replay Service (LRS)

b)

Log shipping

c)

Transactional replication

d)

SQL Data Sync

16.

You need an Azure VM series for SQL Server that supports Write Accelerator. Which should you use?

a)

E-series

b)

G-series

c)

H-series

d)

M-series

17.

You want to replicate an on-premises SQL Server 2019 database to Azure SQL Database. Which replication type should you use?

a)

Transactional

b)

Peer-to-peer

c)

Snapshot

d)

Merge

18.

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?

a)

Remove DB1 from AG, backup and restore to Azure

b)

Use log shipping

c)

Add the Azure VM as a replica, failover, then remove from AG

d)

Replicate using Azure Database Migration Service

19.

You need to create a partitioned table in an Azure SQL Database. What is the correct sequence of objects to create?

a)

Partition function, partition scheme, table

b)

Table, partition scheme, partition function

c)

Partition scheme, table, partition function

d)

Table, partition function, partition scheme

20.

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)?

a)

Create a credential for the domain account

b)

Grant the account permissions on the file share

c)

Map the credential to a SQL Server Agent proxy

d)

Grant the proxy permission for the job step

e)

Add the domain account to the Administrators group

21.

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?

a)

Premium SSD v2

b)

Premium SSD

c)

Standard SSD

d)

Ultra SSD

22.

Which three service tiers support SQL Managed Instance for a 14-TB database?

a)

General Purpose Standard

b)

Business Critical Memory Optimized Premium

c)

General Purpose Premium

d)

Business Critical Premium

e)

Business Critical Standard

23.

Which solution provides randomized encryption, supports comparison operators, and encrypts data in motion for Azure SQL Database?

a)

Always Encrypted with secure enclaves

b)

Always Encrypted

c)

Column-level encryption

d)

Transparent Data Encryption (TDE)