
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company's SAP application has a backend SQL Server database in an on-premises environment. The company wants to migrate its on-premises application and database server to AWS. The company needs an instance type that meets the high demands of its SAP database. On-premises performance data shows that both the SAP application and the database have high memory utilization.
Which solution will meet these requirements?
A
Use the compute optimized instance family for the application. Use the memory optimized instance family for the database.
B
Use the storage optimized instance family for both the application and the database.
C
Use the memory optimized instance family for both the application and the database.
D
Use the high performance computing (HPC) optimized instance family for the application. Use the memory optimized instance family for the database.
Explanation:
Correct Answer: C - Use the memory optimized instance family for both the application and the database.
Why this is correct:
High memory utilization requirement: The problem states that both the SAP application and the database have high memory utilization based on on-premises performance data. Memory optimized instance families (like R5, R5a, R5b, R5n, X1, X1e, z1d) are specifically designed for workloads that require large amounts of memory.
SAP application characteristics: SAP applications are typically memory-intensive, especially for processing and caching data. Using memory optimized instances ensures the application has sufficient RAM for optimal performance.
SQL Server database requirements: SQL Server databases, particularly for SAP workloads, benefit from large memory allocations for buffer pools, query processing, and in-memory OLTP features.
Why other options are incorrect:
Option A: Using compute optimized instances for the application would not address the high memory utilization requirement. Compute optimized instances (C5, C5a, C5n, C6i, C6a, C6g) are designed for compute-intensive workloads, not memory-intensive ones.
Option B: Storage optimized instances (I3, I3en, D2, D3, D3en) are designed for workloads requiring high sequential read/write access to large datasets, not specifically for memory-intensive applications.
Option D: HPC optimized instances are designed for high-performance computing workloads with low-latency networking requirements, not specifically for memory-intensive SAP applications.
Key AWS Concepts: