DBS-C01 · Question #221
A company is launching a new Amazon RDS for MySQL Multi-AZ DB instance to be used as a data store for a custom-built application. After a series of tests with point-in-time recovery disabled, the…
The correct answer is C. Modify the DB instance and configure a backup retention period. You can restore a DB instance to a specific point in time (PITR), creating a new DB instance. To support PITR, your DB instances must have backup retention set to a nonzero value. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-backup-sqlserver.html
Question
A company is launching a new Amazon RDS for MySQL Multi-AZ DB instance to be used as a data store for a custom-built application. After a series of tests with point-in-time recovery disabled, the company decides that it must have point-in-time recovery reenabled before using the DB instance to store production data. What should a database specialist do so that point-in-time recovery can be successful?
Options
- AEnable binary logging in the DB parameter group used by the DB instance.
- BModify the DB instance and enable audit logs to be pushed to Amazon CloudWatch Logs.
- CModify the DB instance and configure a backup retention period
- DSet up a scheduled job to create manual DB instance snapshots.
How the community answered
(43 responses)- A2% (1)
- C95% (41)
- D2% (1)
Explanation
You can restore a DB instance to a specific point in time (PITR), creating a new DB instance. To support PITR, your DB instances must have backup retention set to a nonzero value. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-backup-sqlserver.html
Topics
Community Discussion
No community discussion yet for this question.