AWS Certified Database – Specialty — Question 51

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

Answer options

• A. Log in to the host and run the rm $PGDATA/pg_logs/* command
• B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
• C. Create a ticket with AWS Support to have the logs deleted
• D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs

Correct answer: B

Explanation

The correct answer is B because modifying the rds.log_retention_period parameter to 1440 will ensure that logs are retained for a day and then automatically deleted, effectively freeing up space. Option A is incorrect as logging into the host is not permitted in RDS, while C is unnecessary since the logs will be managed automatically. Option D does not address the space issue since it only rotates the error logs without deleting them.