A company runs an Amazon RDS for MySQL database with automated backups enabled. A developer accidentally deleted a critical table at 10:15 AM. The company needs to restore the database to a state as close as possible to just before the deletion, with minimal data loss. What is the most appropriate restore method?

Restore the latest manual snapshot to the existing DB instance.

Use the AWS CLI to copy the table from the binlog and reinsert it into the existing database.

Restore the most recent automated backup to a new DB instance.

Restore to a new DB instance using point-in-time recovery to a time just before 10:15 AM.

A company runs a web application in the us-east-1 Region. The application uses an Amazon RDS database and an S3 bucket for static content. The company's disaster recovery plan requires an RTO of 30 minutes and an RPO of 5 minutes. The company has a moderate budget and wants to minimize costs while meeting the requirements. Which DR strategy should the company implement?

Active/active: run the application in both regions with traffic split between them.

Backup and restore: take daily snapshots and copy them to us-west-2.

Pilot light: replicate data to us-west-2 and keep only the database running; start the application servers in a disaster.

Warm standby: run a scaled-down version of the application in us-west-2 with a read replica for the database and replicate S3 data using Cross-Region Replication.

When restoring an Amazon RDS database from an automated backup, which of the following is true?

The restore can only be done to the same DB instance.

The restore can be done to an existing instance without downtime.

The restore creates a new DB instance with a new endpoint.

AWSCertified CloudOps Engineer - Associate

Domain 2Objective 3

Task 2.3: Implement Backup and Restore Strategies. SOA-C03 Practice Questions (Page 6)

Part of the Content Domain 2: Reliability and Business Continuity domain, which makes up ~25% of our current practice bank. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~13–21 in this domain), expect 4–7 from this objective — we provide 32 practice questions to prepare you well beyond it. (estimate)

32questions here

7free pages

9concepts

Questions 26–30

26application · medium
A company runs an Amazon RDS for MySQL database with automated backups enabled. A developer accidentally deleted a critical table at 10:15 AM. The company needs to restore the database to a state as close as possible to just before the deletion, with minimal data loss. What is the most appropriate restore method?
Select an answer first
27foundation · easy
Which disaster recovery strategy involves running a fully functional, scaled-down version of your production environment in another region, and scaling it up during a disaster?
Select an answer first
28expert · hard
A company runs a web application in the us-east-1 Region. The application uses an Amazon RDS database and an S3 bucket for static content. The company's disaster recovery plan requires an RTO of 30 minutes and an RPO of 5 minutes. The company has a moderate budget and wants to minimize costs while meeting the requirements. Which DR strategy should the company implement?
Select an answer first
29foundation · easy
When restoring an Amazon RDS database from an automated backup, which of the following is true?
Select an answer first
30foundation · easy
A CloudOps engineer needs to create a one-time backup of an Amazon EBS volume immediately, without setting up a recurring schedule. Which action should the engineer take?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SOA-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by AWS. “SOA-C03” is a trademark of its owner, used for identification only.

Task 2.3: Implement Backup and Restore Strategies. SOA-C03 Practice Questions (Page 6)

Questions 26–30

Which disaster recovery strategy involves running a fully functional, scaled-down version of your production environment in another region, and scaling it up during a disaster?

When restoring an Amazon RDS database from an automated backup, which of the following is true?

A CloudOps engineer needs to create a one-time backup of an Amazon EBS volume immediately, without setting up a recurring schedule. Which action should the engineer take?

Keep studying — Content Domain 2: Reliability and Business Continuity