DBS-C01 practice question 8 of 35

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?

Full set: 322 questions
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 Correct answer
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. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
Explanation

To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days). The maximum value is 10,080 (seven days). https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.Concepts.Post greSQL.html

Scroll to Top