AWS Certified Database – Specialty — Question 358

A bank is using an Amazon RDS for MySQL DB instance in a proof of concept. A database specialist is evaluating automated database snapshots and cross-

Region snapshot copies as -
part of this proof of concept. After validating three automated snapshots successfully, the database specialist realizes that the fourth snapshot was not created.
Which of the following are possible reasons why the snapshot was not created? (Choose two.)

Answer options

• A. A copy of the automated snapshot for this DB instance is in progress within the same AWS Region.
• B. A copy of a manual snapshot for this DB instance is in progress for only certain databases within the DB instance.
• C. The RDS maintenance window is not specified.
• D. The DB instance is in the STORAGE_FULL state.
• E. RDS event notifications have not been enabled.

Correct answer: A, D

Explanation

Amazon RDS will not initiate a new automated snapshot if a copy of a previous automated snapshot for the same DB instance is currently in progress within the same AWS Region. Additionally, automated snapshots are suspended when a DB instance enters the STORAGE_FULL state due to a lack of available storage space. Other factors, such as maintenance window settings, event notifications, or manual snapshots (which apply to the entire instance rather than specific databases), do not prevent automated snapshots from occurring.