SQL Server on Azure VMs Quiz

Quiz covering Deploy Azure SQL Solutions

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   Which Azure portal feature allows you to automatically register a SQL Server on Azure VM with the SQL IaaS Agent extension to enable advanced management features?

2. 2

   You are deploying a SQL Server on Azure VM and need to ensure that the data and log files are stored on high-performance disks with low latency. Which storage configuration is recommended for production SQL Server workloads?

3. 3

   When configuring automated backups for a SQL Server on Azure VM, where are the backup files physically stored by default?

4. 4

   You need to enable TDE (Transparent Data Encryption) for a SQL Server on Azure VM using Azure Key Vault. What is the primary requirement to ensure the SQL Server service can access the key?

5. 5

   You are optimizing storage for a SQL Server on Azure VM. You have multiple data files and want to achieve maximum IOPS and throughput by striping them across multiple disks. Which feature should you use within the VM guest operating system?