AWS Certified Database – Specialty — Question 259

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because modifying the rds.log_retention_period parameter to 1440 allows for the automatic deletion of logs after 24 hours, thus recovering storage without downtime. Option A would delete logs immediately, which could disrupt operations, while C would not effectively address the log retention issue, and D would cause unnecessary downtime due to the reboot requirement.