Amazon Exam PAS-C01 Topic 4 Question 44 Discussion

Actual exam question for Amazon's PAS-C01 exam

Question #: 44
Topic #: 4

Business users are reporting timeouts during periods of peak query activity on an enterprise SAP HANAdata 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 10 wart 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? (Select TWO.)

AReduce the global_allocation_limit parameter to i 120 GiB

BMigrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs

CMove to a scale-out architecture for SAP HANA with at least three x1 16xlarge instances

DModify the Amazon Elastic Block Store (Amazon EBS) volume type from General Purpose to Provisioned lOPS for ail SAP HANA data volumes

EChange to a supported compute optimized instance type for SAP HANA

Show Suggested Answer

Suggested Answer: C, E

by Alethea at Sep 18, 2024, 10:23 AM

Limited Time Offer

25%

Off

Get Premium PAS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Elfriede

2 months ago

Hey, at least they're not reporting timeouts during periods of peak query activity on a non-enterprise SAP HANA data mart. That would be just plain embarrassing.

upvoted 0 times

Val

1 months ago

B) Migrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs

upvoted 0 times

...

Huey

1 months ago

A) Reduce the global_allocation_limit parameter to i 120 GiB

upvoted 0 times

...

Natalya

2 months ago

A scale-out architecture could be a good long-term solution, but it might be overkill for this issue. Let's try the simpler options first.

upvoted 0 times

Lashaun

2 months ago

I agree, starting with these simpler options could help improve performance before considering a scale-out architecture.

upvoted 0 times

...

Bettyann

2 months ago

D) Modify the Amazon Elastic Block Store (Amazon EBS) volume type from General Purpose to Provisioned lOPS for ail SAP HANA data volumes

upvoted 0 times

...

Gladys

2 months ago

B) Migrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs

upvoted 0 times

...

Natalya

2 months ago

I don't know, man. Have you tried turning it off and on again? That usually works, right?

upvoted 0 times

...

Tiera

2 months ago

Reducing the global_allocation_limit seems like a risky move. We don't want to artificially limit the database's memory usage when it's not the root cause of the problem.

upvoted 0 times

Graciela

1 months ago

C) Move to a scale-out architecture for SAP HANA with at least three x1 16xlarge instances

upvoted 0 times

...

German

1 months ago

I agree, reducing the global_allocation_limit could cause more issues. Migrating to a High Memory instance seems like a better solution.

upvoted 0 times

...

Lina

1 months ago

D) Modify the Amazon Elastic Block Store (Amazon EBS) volume type from General Purpose to Provisioned lOPS for ail SAP HANA data volumes

upvoted 0 times

...

Pa

1 months ago

I agree, reducing the global_allocation_limit could cause more issues. Migrating to a High Memory instance and changing the EBS volume type seem like safer options.

upvoted 0 times

...

Joesph

2 months ago

D) Modify the Amazon Elastic Block Store (Amazon EBS) volume type from General Purpose to Provisioned lOPS for all SAP HANA data volumes

upvoted 0 times

...

Marylyn

2 months ago

B) Migrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs

upvoted 0 times

...

Mireya

2 months ago

B) Migrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs

upvoted 0 times

...

Elfrieda

2 months ago

I'm not sure about option A. Reducing the global_allocation_limit parameter may not address the underlying issue of high CPU utilization.

upvoted 0 times

...

Vallie

3 months ago

I agree with Katheryn. Option C might also be beneficial to distribute the workload across multiple instances.

upvoted 0 times

...

Katheryn

3 months ago

I think option B could help by providing more vCPUs for better performance.

upvoted 0 times

...

Noel

3 months ago

Hmm, I think the solution is to migrate to a larger EC2 instance with more vCPUs. The CPU is maxing out, so we need more horsepower to handle the load.

upvoted 0 times

Matt

2 months ago

B) Migrate the SAP HANA database to an EC2 High Memory instance with a larger number of available vCPUs

upvoted 0 times

...

Daniel

2 months ago

A) Reduce the global_allocation_limit parameter to i 120 GiB

upvoted 0 times

...