Question 54 of 981
AZ-900 Describe Azure architecture and services Practice Question
Which Azure compute size family is optimized for memory-intensive workloads like large in-memory analytics or SAP HANA?
⚠ Common exam trap
It's easy for candidates to confuse 'memory-optimized' with 'compute-optimized' because both sound performance-related, but the key differentiator is the memory-to-core ratio and specific workload certification (e.g., SAP HANA) that only memory-optimized families provide.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Memory-optimized VMs (M-series, E-series)
Memory-optimized VMs, such as the M-series and E-series, are designed with a high memory-to-core ratio and large memory capacities (up to 12 TB for M-series) to handle workloads that require massive amounts of RAM, such as large in-memory analytics and SAP HANA. SAP HANA specifically requires certified VM sizes with sufficient memory to load the entire database into RAM, and Azure's M-series is SAP-certified for this purpose.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Compute-optimized VMs (Fsv2-series)
Why it's wrong here
Fsv2-series compute-optimized VMs are engineered around a high CPU-to-memory ratio, typically offering only 2 GiB of RAM per vCPU. This makes them powerful for batch processing, web serves, and other compute-bound tasks, but their limited memory capacity and bandwidth cannot accommodate large in-memory workloads like SAP HANA or giant databases. Choosing these for a memory-intensive workload would result in exhausting RAM and relying on slow disk paging, degrading performance severely.
- ✓
Memory-optimized VMs (M-series, E-series)
Why this is correct
Memory-optimized M-series and E-series VMs are specifically built to support very large memory footprints, offering high memory-to-CPU ratios and RAM capacities ranging from hundreds of GiB to multiple terabytes. These families are certified for SAP HANA, in-memory analytics, and large relational databases because they provide the RAM capacity and memory bandwidth to keep entire datasets resident in memory. This design ensures the SQL Pool or SAP workloads can run without constant disk reads, delivering the low-latency query performance expected from a memory-intensive deployment.
- ✗
Storage-optimized VMs (Lsv2-series)
Why it's wrong here
Lsv2-series storage-optimized VMs focus on high disk I/O throughput and low latency, featuring direct-attached NVMe storage for scratch and cache-heavy applications. Their local ephemeral disks and CPU/memory layout are selected for storage throughput, not for maximizing RAM capacity or memory bandwidth. While they may handle some database workloads, their memory size is generally insufficient and the design intent is to eliminate storage bottlenecks rather than host enormous in-memory data sets, making them inappropriate for a primarily memory-intensive scenario.
- ✗
GPU VMs (NC-series)
Why it's wrong here
NC-series GPU VMs are designed for massively parallel compute tasks such as AI training, deep learning, and graphics rendering. Their powerful NVIDIA GPUs accelerate matrix math and visualization, yet the underlying CPU and RAM configuration is not tuned for memory density or high memory-to-core ratios. Large in-memory databases do not benefit from GPU parallelism in the same way, so this family lacks the massive memory footprint and memory bandwidth that such workloads demand.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 11, 2026
This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.