Topic 1 Question 286

AWS Certified SysOps Administrator - Associate

Topic 1 Question 286
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?

2 つ選択
- Identify the most recent automated snapshot. Restore the snapshot to a new RDS DB cluster.
- 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.
- Create a read replica instance in the original RDS DB cluster. Promote the read replica to a standalone DB cluster.
- 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.
- 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.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: AC
  There are actually CLI commands defined to do both "A" and "C". I believe the DB Migration Service is used to migrate and reformat external databases to AWS. I see no references to it being used to copy/migrate data within AWS. Anyway, here are the CLI examples I mentioned which I found online:
  
  Promotes specified read replica to become a standalone DB cluster.
  
  aws rds promote-read-replica-db-cluster --db-cluster-identifier mydbcluster-1
  
  Creates a new DB cluster by resoring a DB cluster snapshot named test-instance-snapshot.
  
  aws rds restore-db-cluster-from-snapshot --db-cluster-identifier newdbcluster --snapshot-identifier test-instance-snapshot --engine aurora-postgresql --engine-version 10.7
  
  👍 4
  Gomer2023/05/02
- 正解だと思う選択肢: AC
  A C looks good
  
  👍 2
  tts12342023/05/04
- 正解だと思う選択肢: AC
  A - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
  
  C - You can promote a read replica into a standalone DB instance. When you promote a read replica, the DB instance is rebooted before it becomes available.
  
  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
  
  👍 2
  kondratyevmn2023/05/11
シャッフルモード

ユーザの投票

コメント(3)

Promotes specified read replica to become a standalone DB cluster.

Creates a new DB cluster by resoring a DB cluster snapshot named test-instance-snapshot.