Fundamental
Prepare and test your skills
Fundamental
Prepare and test your skills
Ultra Disk for Extreme OLTP Database Performance
Free sample question, answered and explained below. The AZ-900 Microsoft Azure Fundamentals Exam practice bank has 688 more like it. Try 10 free: instant score, no account.
A company is planning to migrate a mission-critical, transaction-heavy online transaction processing (OLTP) database to an Azure Virtual Machine.
The database workload requires extreme performance with up to several hundred thousand IOPS, high throughput in gigabytes per second, and consistently sub-millisecond disk latency.
Which Azure managed disk type should the company choose for this workload?
Explanations
Standard SSD
Standard SSD
What Standard SSD Is
Azure Standard SSD managed disks are solid-state drive storage options optimized for workloads that need consistent performance at lower IOPS levels.
Why It Doesn't Meet The Requirement
Standard SSD does not meet the database requirements because:
- Moderate performance caps: It offers capped IOPS and throughput well below the hundreds of thousands of IOPS required by high-end OLTP systems.
- Millisecond-level latency: Provides single-digit millisecond latency rather than the consistent sub-millisecond latency provided by Ultra Disks.
- Not tuned for high I/O: Designed for consistent light workloads rather than heavy transactional I/O spikes.
Key Characteristics and Limitations
- Solid-state media: Provides more consistent latency and reliability compared to Standard HDD.
- Cost-effective SSD tier: Serves as an affordable middle ground between Standard HDD and Premium SSD.
- Entry-level enterprise usage: Commonly used for web servers, low-traffic application servers, and non-critical development environments.
This Answer Would Be Correct If
This option would be correct for web servers, light application workloads, or non-production environments that require the reliability and consistent latency of solid-state media without needing premium performance.
Additional Context
Standard SSD is best suited for workloads with light-to-moderate throughput needs, while production OLTP databases require Premium SSD or Ultra Disk.
Ultra Disk
Ultra Disk
What Ultra Disk Is
Azure Ultra Disk is Azure's highest-performing managed disk storage option, engineered specifically for top-tier, I/O-intensive workloads running on Azure Virtual Machines.
How It Meets The Requirements
Ultra Disk is designed for the most demanding enterprise workloads, providing:
- Extreme IOPS: Scales up to 400,000 IOPS per disk depending on capacity and configuration.
- High throughput: Delivers throughput caps of up to 10,000 MB/s, perfectly accommodating heavy data stream requirements.
- Sub-millisecond latency: Provides consistent sub-millisecond disk latency suitable for top-tier OLTP databases.
Key Advantages and Capabilities
- Dynamic performance configuration: Allows granular tuning of IOPS and throughput independently from disk capacity without restarting the virtual machine.
- Massive scalability: Supports disk capacities up to 65,536 GiB (64 TiB).
- Tailored for heavy enterprise systems: Ideal for enterprise databases such as SAP HANA, Oracle Database, and Microsoft SQL Server.
- Flexible performance scaling: Avoids over-provisioning storage capacity simply to obtain higher I/O capabilities.
Why This Is Optimal
While Premium SSD provides high performance for standard production systems, it cannot reach the hundreds of thousands of IOPS or 10,000 MB/s throughput limits offered by Ultra Disk. This makes Ultra Disk the ideal and necessary choice for extreme database workloads.
Standard HDD
Standard HDD
What Standard HDD Is
Azure Standard HDD managed disks are backed by traditional magnetic, spinning-disk hard disk drives (HDD) and represent the most cost-effective disk storage tier in Azure.
Why It Doesn't Meet The Requirement
Standard HDD is unsuitable for transaction-heavy databases because:
- Low throughput and IOPS: It delivers low IOPS (typically up to 500 IOPS) and limited throughput.
- Higher latency: Latency is in the double-digit milliseconds due to mechanical disk arm movements.
- Workload mismatch: It cannot handle transaction-heavy enterprise workloads or provide sub-millisecond response times.
Key Characteristics and Limitations
- Mechanical storage: Backed by traditional spinning magnetic media rather than solid-state hardware.
- Variable latency: Performance can vary depending on traffic and data access patterns.
- Cost-optimized: Provides the lowest cost per gigabyte among all Azure managed disk types.
This Answer Would Be Correct If
This option would be correct if the scenario asked for the most cost-effective storage for non-critical workloads, dev/test environments, or backup archives that are infrequently accessed and do not require high performance.
Additional Context
Standard HDD disks are typically utilized for non-critical batch processes, infrequent log ingestion, or general file storage rather than active transactional databases.
Premium SSD
Premium SSD
What Premium SSD Is
Azure Premium SSD managed disks deliver high-performance, low-latency disk support for virtual machines running input/output-intensive production workloads.
Why It Doesn't Meet The Requirement
While Premium SSD is standard for production workloads, it does not fully satisfy the extreme constraints of the scenario:
- Lower maximum limits: Standard Premium SSD disks top out at 20,000 IOPS and 900 MB/s throughput per disk (or up to 7,500 IOPS on P50 tiers), which is insufficient for workloads needing hundreds of thousands of IOPS on a single disk.
- Fixed performance scaling: Performance is largely tied to provisioned disk capacity or specific performance tier upgrades, rather than providing the extreme dynamic range of Ultra Disks.
Key Characteristics and Limitations
- High performance: Offers single-digit millisecond latency backed by high-speed solid-state drives.
- Baseline production tier: Recommended for standard production database instances and enterprise applications.
- Performance tier changes: Allows tier adjustments without downtime for Premium SSD managed disks.
This Answer Would Be Correct If
This option would be correct if the database required standard production-grade performance with single-digit millisecond latencies and moderate IOPS requirements (up to 20,000 IOPS per disk).
Additional Context
For extreme database systems needing hundreds of thousands of IOPS and throughput caps up to 10,000 MB/s, Ultra Disk is required.
Try 10 interactive questions like this one, free
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
- 688 practice questions across all 3 exam domains
- Every answer explained: why it is right, and why the others are not
- Scout, an AI tutor that answers your follow-up questions
- Readiness tracking by domain, so you know when to book the exam
Related questions
Keep the momentum going with these hand-picked practice scenarios
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Table Storage
Compare Azure Storage services
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure File Sync Cloud Tiering
Compare Azure Storage services
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Queue Storage
Compare Azure Storage services
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Blob Storage
Compare Azure Storage services
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
IaaS Scalability Control and Cost-Efficiency
Describe infrastructure as a service (IaaS)
ExpertAZ-500 Microsoft Azure Security Technologies Exam
Application Permissions vs Delegated Permissions
Configure app registration permission scopes
Last updated Validated