exam questions

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 334 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 334
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. The company recently conducted tests on the database after business hours, and the tests generated additional database logs. As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.

The company wants to recover the free storage that the additional logs consumed. The solution must not result in downtime for the database.

Which solution will meet these requirements?

  • A. Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.
  • B. Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.
  • C. Modify the temp_file_limit parameter to a smaller value to reclaim space on the DB instance.
  • D. Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
KikiNoviandi
1 year, 8 months ago
Selected Answer: B
B Correct, https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Parameters.html
upvoted 1 times
...
dbkorn
1 year, 8 months ago
I thnik B rds.log_retention_period is Sets log retention such that Amazon RDS deletes PostgreSQL logs that are older than 1440 minutes = 1 Day. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Parameters.html dynamic parameter doesn't need to reboot.
upvoted 2 times
...
Ram_xyz
1 year, 8 months ago
Selected Answer: B
parameter is dynamic so it doesn't need to reboot. Closet answer seems B
upvoted 3 times
...
marll88
1 year, 8 months ago
I think B. A and D cannot be selected because downtime must not occur. Please give me information that C can be done.
upvoted 1 times
Ram_xyz
1 year, 8 months ago
C has nothing to do with logs https://postgresqlco.nf/doc/en/param/temp_file_limit/
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...