Which Azure VM Family is Best for Memory-Heavy Analytics Workloads?
A reporting server will run an in-memory analytics application that needs 8 vCPUs and 64 GiB of RAM. The administrator wants a VM family that is a good fit for memory-heavy workloads. Which VM family should be chosen?
Quick Answer
The answer is the memory-optimized VM family, such as the Azure E-series, because these families are specifically engineered for memory-heavy analytics workloads that demand a high memory-to-vCPU ratio. With a requirement of 64 GiB of RAM for 8 vCPUs, you get an 8:1 ratio, which perfectly matches the memory-optimized profile designed to keep large datasets entirely in RAM for low-latency processing. On the AZ-104 exam, this concept tests your ability to match workload characteristics to the correct VM family, often appearing in scenario-based questions where a trap is choosing a general-purpose family like the D-series, which offers a lower memory ratio. A common memory tip is to associate "memory-heavy" with "E for Extra RAM" or think of the E-series as "Enterprise memory" for analytics.
⚠ Common exam trap
Many exam-takers confuse 'memory-heavy' with 'compute-heavy' and choose compute-optimized VMs, overlooking the specific memory-to-vCPU ratio required for in-memory analytics.
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 VM family
Memory-optimized VM families (e.g., Azure E-series) are designed for workloads that require a high memory-to-vCPU ratio, such as in-memory analytics applications. The requirement of 64 GiB of RAM for 8 vCPUs (8:1 ratio) aligns with the memory-optimized profile, which offers up to 8 GiB per vCPU or more, ensuring the application's data fits entirely in RAM for low-latency processing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Memory-optimized VM family
Why this is correct
Memory-optimized sizes are designed for workloads that need a higher memory-to-vCPU ratio than general-purpose sizes. They are a practical fit for analytics engines, large caches, and in-memory databases where RAM is the main constraint. Choosing this family helps the team meet the workload requirement without paying for unnecessary specialized features that do not address the sizing need.
- ✗
Burstable VM family
Why it's wrong here
Burstable sizes are intended for light workloads with occasional CPU spikes, not sustained memory-heavy processing.
When this WOULD be correct
A correct scenario would be: 'A small web server that experiences sporadic traffic spikes and needs cost-effective compute for low-utilization periods.'
- ✗
Compute-optimized VM family
Why it's wrong here
Compute-optimized sizes prioritize CPU performance, which is less important than memory for this workload.
When this WOULD be correct
A question asks for a VM family for a CPU-intensive application, such as a high-frequency trading platform or batch processing, that requires high vCPU performance but not large memory.
- ✗
Storage-optimized VM family
Why it's wrong here
Storage-optimized sizes focus on high disk throughput and IOPS rather than the memory capacity required here.
When this WOULD be correct
A question asks: 'An application requires high disk throughput and low latency for large data sets, with moderate CPU and memory needs. Which VM family should be chosen?' In that case, storage-optimized would be correct.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The AZ-104 exam frequently reuses these exact scenarios with slightly different constraints.
✓Memory-optimized VM familyCorrect answer▾
Why this is correct
Memory-optimized sizes are designed for workloads that need a higher memory-to-vCPU ratio than general-purpose sizes. They are a practical fit for analytics engines, large caches, and in-memory databases where RAM is the main constraint. Choosing this family helps the team meet the workload requirement without paying for unnecessary specialized features that do not address the sizing need.
✗Burstable VM familyWrong answer — click to see why▾
Why this is wrong here
The question specifies a memory-heavy workload requiring 64 GiB of RAM, and burstable VM families are designed for workloads with variable CPU usage, not consistent high memory demands.
★ When this WOULD be the correct answer
A correct scenario would be: 'A small web server that experiences sporadic traffic spikes and needs cost-effective compute for low-utilization periods.'
Why candidates choose this
Candidates may confuse 'burstable' with 'scalable' or think it implies flexibility for any resource, including memory, without understanding its CPU-centric design.
✗Compute-optimized VM familyWrong answer — click to see why▾
Why this is wrong here
The question specifies a memory-heavy workload with 64 GiB of RAM, and compute-optimized VMs prioritize high CPU performance over memory capacity, making them unsuitable for this requirement.
★ When this WOULD be the correct answer
A question asks for a VM family for a CPU-intensive application, such as a high-frequency trading platform or batch processing, that requires high vCPU performance but not large memory.
Why candidates choose this
Candidates may confuse 'in-memory analytics' with needing high compute power, overlooking that the primary bottleneck is memory capacity, not CPU speed.
✗Storage-optimized VM familyWrong answer — click to see why▾
Why this is wrong here
Storage-optimized VM families are designed for high disk throughput and I/O, not for large memory requirements. The question specifies a memory-heavy workload needing 64 GiB of RAM, which is not a storage concern.
★ When this WOULD be the correct answer
A question asks: 'An application requires high disk throughput and low latency for large data sets, with moderate CPU and memory needs. Which VM family should be chosen?' In that case, storage-optimized would be correct.
Why candidates choose this
Candidates may confuse 'in-memory analytics' with 'storage' because analytics often involves large data sets, leading them to think storage optimization is key, rather than recognizing the primary constraint is memory capacity.
Analysis generated from the official AZ-104blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
One of 1,049 original AZ-104 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
3 more ways this is tested on AZ-104
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A reporting server VM will run an analytics engine that uses a large in-memory cache. Required minimums are 8 vCPUs and 64 GiB of RAM, and the workload benefits more from memory than from extra compute. Which Azure VM series is the best fit?
medium- A.B-series, because burstable credits handle temporary spikes economically
- B.D-series, because it balances general-purpose CPU and memory
- ✓ C.E-series, because it provides memory-optimized sizing for data-intensive workloads
- D.F-series, because it is optimized for high CPU throughput
Why C: The E-series (specifically Ev3, Esv3, or Ebsv5) is memory-optimized, offering the highest memory-to-vCPU ratio among Azure general-purpose families. With a requirement of 64 GiB RAM and only 8 vCPUs, the workload benefits more from memory than compute, making the E-series the best fit. D-series provides balanced ratios but not the memory density needed, while F-series and B-series are compute- or burst-oriented and lack sufficient memory per vCPU.
Variation 2. A reporting server will run an analytics engine that needs 8 vCPUs and 64 GiB of RAM. Average CPU use is expected to stay moderate, but the workload is memory heavy and should not use a burstable SKU. Which two deployment choices best align with the requirement? Select two.
hard- ✓ A.Select a memory-optimized VM family.
- ✓ B.Choose a size with at least 8 vCPUs and 64 GiB of RAM.
- C.Choose a burstable B-series size to lower cost.
- D.Pick a compute-optimized F-series size because CPU use is only moderate.
- E.Select the smallest VM size that supports managed disks.
Why A: The workload is memory heavy, and memory-optimized VM families (e.g., E-series) are designed with a higher memory-to-vCPU ratio to handle such workloads efficiently. Option B is correct because the requirement explicitly states 8 vCPUs and 64 GiB of RAM, so selecting a size that meets these exact specifications is necessary, regardless of family, as long as it is not burstable.
Variation 3. A reporting server will run an in-memory analytics workload that needs 8 vCPUs and 64 GiB RAM. CPU usage is expected to stay moderate, but the application benefits most from memory capacity. Which VM family should the administrator choose as the starting point?
medium- A.B-series
- B.D-series
- C.F-series
- ✓ D.E-series
Why D: The E-series (memory-optimized) VM family is designed for in-memory analytics workloads that require high memory-to-CPU ratios. With 8 vCPUs and 64 GiB RAM, the workload demands 8 GiB per vCPU, which aligns with E-series specifications (typically 8–16 GiB per vCPU). D-series offers a balanced ratio (4 GiB per vCPU) and would not provide sufficient memory capacity for this workload.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-104 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-104 exam.