AWS Certified SysOps Administrator – Associate — Question 201

An Amazon RDS for PostgreSQL DB cluster has automated backups turned on with a 7-day retention period. A SysOps administrator needs to create a new RDS DB cluster by using data that is no more than 24 hours old from the original DB cluster.

Which solutions will meet these requirements with the LEAST operational overhead? (Choose two.)

Answer options

• A. Identify the most recent automated snapshot. Restore the snapshot to a new RDS DB cluster.
• B. Back up the database to Amazon S3 by using native database backup tools. Create a new RDS DB cluster and restore the data to the new RDS DB cluster.
• C. Create a read replica instance in the original RDS DB cluster. Promote the read replica to a standalone DB cluster.
• D. Create a new RDS DB cluster. Use AWS Database Migration Service (AWS DMS) to migrate data from the current RDS DB cluster to the newly created RDS DB cluster.
• E. Use the pg_dump utility to export data from the original RDS DB cluster to an Amazon EC2 instance. Create a new RDS DB cluster. Use the pg_restore utility to import the data from the EC2 instance to the new RDS DB cluster.

Correct answer: A, C

Explanation

Option A is correct because restoring the most recent automated snapshot is straightforward and requires minimal effort. Option C is also valid since promoting a read replica to a standalone cluster is a simple process. The other options involve more complex procedures and additional tools, leading to increased operational overhead.