Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 326 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 326
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database. The company created a new DB instance from the snapshot to test a new application feature while providing isolation from the production database.

During testing of the new application feature, the company noticed that read latency on the new database was higher than normal. A database specialist needs to resolve the latency issue.

Which solution will meet these requirements with the MOST operational efficiency?

A. Log in to the database by using the PostgreSQL administration tool. Issue a SELECT * command against each table in the database.
B. Create a new parameter group and set the max_connections parameter to 100. Assign the parameter group to the new database. Apply the changes immediately.
C. Edit the default parameter group for the matching PostgreSQL engine. Set the max_connections parameter to 100. Reboot the new database to pick up the changes to the parameter group.
D. Login to the database by using the PostgreSQL administration tool. Issue the VACUUM (ANALYZE, DISABLE_PAGE_SKIPPING) command.

Show Suggested Answer

Suggested Answer: D 🗳️

by TQM__9MD at July 14, 2023, 1:30 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

HSong

1 year, 2 months ago

A to mitigate the lazy loading impact to the performance.

upvoted 1 times

...

MultiAZ

1 year, 4 months ago

Selected Answer: D

A will work, but D is more operationally efficient

upvoted 1 times

...

Sathish_dbs

1 year, 7 months ago

Selected Answer: A

to avoid first touch penalty we can do select * for all the tables when the read replica is created, VACCUM can be done during the DB running not so effective for first time running.

upvoted 1 times

...

Pranava_GCP

1 year, 8 months ago

Selected Answer: D

D. run VACUUM (ANALYZE, DISABLE_PAGE_SKIPPING) command https://www.enterprisedb.com/blog/postgresql-vacuum-and-analyze-best-practice-tips

upvoted 1 times

...

chen0305_099

1 year, 8 months ago

Selected Answer: D

I THINK D

upvoted 1 times

...

kerl

1 year, 9 months ago

https://stackoverflow.com/questions/47545414/aws-rds-instance-created-from-snapshot-very-slow

upvoted 4 times

...

Windy

1 year, 10 months ago

it is D.

upvoted 1 times

...

saikarthikeya777

1 year, 10 months ago

Selected Answer: D

VACUUM is effective to improve the query performance and to reduce the latency.

upvoted 2 times

...

TQM__9MD

1 year, 10 months ago

Selected Answer: C

In option C, editing the default parameter group of the PostgreSQL engine and setting the max_connections parameter to 100 is a way to increase the limit on simultaneous connections. By restarting the new database to reflect the changes in the parameter group, it is possible to increase the number of concurrently executed queries and potentially alleviate read latency.

upvoted 1 times

...