AWS Certified SAP on AWS – Specialty (PAS-C01) — Question 34

Business users are reporting timeouts during periods of peak query activity on an enterprise SAP HANA data mart. An SAP system administrator has discovered that at peak volume, the CPU utilization increases rapidly to 100% for extended periods on the x1.32xlarge Amazon EC2 instance where the database is installed. However, the SAP HANA database is occupying only 1,120 GiB of the available 1,952 GiB on the instance. I/O wait times are not increasing. Extensive query tuning and system tuning have not resolved this performance problem.
Which solutions should the SAP system administrator use to improve the performance? (Choose two.)

Answer options

• A. Reduce the global_allocation_limit parameter to 1,120 GiB.
• B. Migrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs.
• C. Move to a scale-out architecture for SAP HANA with at least three x1. 16xlarge instances.
• D. Modify the Amazon Elastic Block Store (Amazon EBS) volume type from General Purpose to Provisioned IOPS for all SAP HANA data volumes.
• E. Change to a supported compute optimized instance type for SAP HANA.

Correct answer: B, E

Explanation

The correct answers, B and E, address the need for more computational resources by migrating to an instance with a larger number of vCPUs and ensuring the compute type is optimized for SAP HANA. The other options either do not increase CPU capacity or alter storage configurations, which are not the primary issue in this scenario.