Exam AWS Certified Database - Specialty topic 1 question 275 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 275
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application. The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.

How can the database specialist minimize the performance degradation after failover?

A. Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0
B. Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1
C. Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture
D. Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan

Show Suggested Answer

Suggested Answer: A 🗳️

by Sab at Dec. 1, 2022, 2:29 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Sab

Highly Voted 2 years, 7 months ago

A Failover priority of writer and reader needs to be Tier-0 https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.cluster-cache-mgmt.html

upvoted 5 times

...

MultiAZ

Most Recent 1 year, 6 months ago

Selected Answer: A

A Tier-o is needed as per https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.cluster-cache-mgmt.html

upvoted 1 times

...

Don2021

2 years, 6 months ago

A Set the value of the apg_ccm_enabled cluster parameter to 1 and both writer and reader tier 0 for failover priority.

upvoted 1 times

...

Llytle

2 years, 6 months ago

I don’t know guys & gals, distributing optimizer plans globally seem to me to be a better way to get consistent query performance from the failover. https://aws.amazon.com/about-aws/whats-new/2018/12/amazon-aurora-postgresql-compatibility-adds-query-plan-management/

upvoted 1 times

...

Mardoyyy

2 years, 7 months ago

Selected Answer: A

A Failover priority of writer and reader needs to be Tier-0

upvoted 1 times

...

amulbaba

2 years, 7 months ago

Selected Answer: A

refer the link given by Sab

upvoted 2 times

...