nerdexam
Microsoft

AZ-305 · Question #211

Drag and Drop Question You are planning an Azure solution that will host production databases for a high-performance application. The solution will include the following components: Two virtual…

The correct answer is A premium managed disk; A premium managed disk; A locally-redundant storage (LRS) account. For high-performance SQL Server production databases, Premium Managed Disks are required for both SQL Server data files and SQL Server log files because they provide SSD-based low-latency, high-throughput storage essential for database performance and are supported by Always On…

Submitted by certguy· Mar 6, 2026Design Data Storage Solutions / Recommend storage and compute solutions for relational data workloads on Azure Virtual Machines

Question

Drag and Drop Question You are planning an Azure solution that will host production databases for a high-performance application. The solution will include the following components: Two virtual machines that will run Microsoft SQL Server 2016, will be deployed to different data centers in the same Azure region, and will be part of an Always On availability group SQL Server data that will be backed up by using the Automated Backup feature of the SQL Server IaaS Agent Extension (SQLIaaSExtension) You identify the storage priorities for various data types as shown in the following table. Which storage type should you recommend for each data type? To answer, drag the appropriate storage types to the correct data types. Each storage type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

AZ-305 question #211 exhibit

Answer Area

Drag items

A geo-redundant storage (GRS) accountA locally-redundant storage (LRS) accountA premium managed diskA standard managed disk

Correct arrangement

  • A premium managed disk
  • A premium managed disk
  • A locally-redundant storage (LRS) account

Explanation

For high-performance SQL Server production databases, Premium Managed Disks are required for both SQL Server data files and SQL Server log files because they provide SSD-based low-latency, high-throughput storage essential for database performance and are supported by Always On availability groups. SQL Server automated backups (via SQLIaaSExtension) must be stored in an Azure Storage account, and since the backups themselves are already replicated by the Always On availability group and data redundancy is handled at the application layer, a Locally-Redundant Storage (LRS) account is sufficient and cost-effective - GRS would be unnecessary overhead for backup data that doesn't require geo-replication.

Topics

#Azure Storage#SQL Server IaaS#Managed Disks#High Availability

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice