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…
Question
Exhibit
Answer Area
Drag items
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
Community Discussion
No community discussion yet for this question.
