Fundamental
Prepare and test your skills
Fundamental
Prepare and test your skills
Memory Optimized VMs for High Memory Databases
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.
An organization plans to migrate a large relational database server to Azure Virtual Machines. The database workload requires a high memory-to-vCPU ratio to support heavy in-memory data caching and fast query processing.
Which Azure virtual machine category should the administrator choose?
Explanations
General purpose
General purpose
What General Purpose VMs Are
General purpose VM sizes (such as the B-series, D-series, and Dd-series) provide a balanced CPU-to-memory ratio. They are designed for typical computing tasks where resource demands are relatively even across processing power and memory allocation.
Why It Doesn't Meet the Requirement
While general purpose virtual machines can host small or test databases, they do not offer the elevated memory-to-vCPU ratio required by large enterprise database workloads. Using a general purpose size for memory-intensive caching would require provisioning excess vCPUs just to acquire sufficient RAM, resulting in unnecessary compute overhead and higher costs.
Key Characteristics and Limitations
- Balanced Allocation: Typically offers approximately 4 GiB of RAM per vCPU.
- Target Workloads: Designed for web servers, small-to-medium databases, development environments, and application servers.
- Resource Scaling: Memory scales linearly with compute cores, preventing independent memory scaling.
This Answer Would Be Correct If
The organization needed to host basic web servers, testing environments, or low-traffic line-of-business applications with balanced compute and memory needs.
Compute optimized
Compute optimized
What Compute Optimized VMs Are
Compute optimized virtual machine sizes (such as the F-series) feature a high vCPU-to-memory ratio. These virtual machines emphasize raw processor speed, powerful turbo clock frequencies, and dedicated CPU cycles per gigabyte of RAM.
Why It Doesn't Meet the Requirement
Compute optimized VMs provide less memory per core than standard instances, making them unsuitable for large relational databases that rely heavily on large-scale in-memory data caching. A compute optimized instance would run out of physical memory for active database caches, forcing the system into slow disk paging.
Key Characteristics and Limitations
- High Processing Ratios: Typically provides around 2 GiB of RAM per vCPU.
- Workload Focus: Ideal for batch processing, video encoding, gaming servers, and scientific modeling.
- Constrained Memory: Does not provide sufficient memory headroom for large database buffering.
This Answer Would Be Correct If
The workload consisted of mathematical calculations, analytics processing algorithms, or compute-heavy web application processing with low memory footprints.
Memory optimized
Memory optimized
What Memory Optimized VM Sizes Are
Memory optimized virtual machine sizes in Azure are specifically engineered to offer a high memory-to-vCPU ratio. These instances are part of VM series such as the E-series (e.g., Ev5, Easv6) and M-series, designed specifically for workloads that require massive amounts of random access memory (RAM) to process large datasets directly in memory without frequent disk input/output bottlenecks.
How It Meets the Requirements
- High Memory-to-vCPU Ratio: Memory optimized instances deliver significantly more gigabytes of RAM per virtual processor (vCPU) compared to standard general-purpose sizes.
- Optimized for In-Memory Caching: Large relational database management systems (RDBMS) such as SQL Server, Oracle, or SAP HANA benefit directly from caching index pages and query results in memory, maximizing throughput and lowering latency.
Key Advantages and Capabilities
- Massive RAM Configurations: Provides memory configurations scaling up to hundreds or thousands of gigabytes.
- Enhanced Performance: Drastically reduces storage I/O operations by maintaining active database working sets directly in memory.
- Support for Advanced Storage: Fully supports high-performance remote disks such as Premium SSDs and Ultra Disks.
- Tailored Processing Power: Couples robust AMD or Intel multi-core processors with expansive memory channels.
Why This Is Optimal
Choosing memory optimized VM sizes ensures that database engines receive the dedicated memory footprint necessary to avoid expensive page swapping and disk reads, ensuring predictable response times and optimal resource utilization.
GPU accelerated
GPU accelerated
What GPU Accelerated VMs Are
GPU accelerated virtual machines (such as the NC-series, NV-series, and ND-series) are specialized instances featuring single or multiple hardware Graphics Processing Units (GPUs) alongside standard host CPUs.
Why It Doesn't Meet the Requirement
Relational database caching and SQL query engines rely on standard system RAM and general x86-64 instruction sets rather than parallelized graphics hardware. Provisioning GPU instances for traditional database workloads incurs unnecessary hardware costs without accelerating memory caching performance.
Key Characteristics and Limitations
- Specialized Accelerators: Built with dedicated NVIDIA or AMD graphics hardware.
- Specialized Workloads: Intended for artificial intelligence (AI), machine learning training, graphical workstations, and 3D rendering.
- Cost Considerations: Carries premium licensing and hardware pricing suited only for GPU-bound tasks.
This Answer Would Be Correct If
The organization required virtual workstations for CAD modeling, video rendering, deep learning model training, or simulation visualization.
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 Monitor
Describe the resources required for virtual machines
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Managed Disks
Describe the resources required for virtual machines
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Virtual Machine Scale Sets
Describe the resources required for virtual machines
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Network Security Group
Describe the resources required for virtual machines
FundamentalAZ-900 Microsoft Azure Fundamentals Exam
Azure Kubernetes Service
Compare compute types, including containers, virtual machines, and functions
IntermediateAZ-800 Administering Windows Server Hybrid Core Infrastructure Exam
Azure File Sync Event Logs and Azure Monitor
Configure and manage Azure File Sync
Last updated Validated