AWS Certified Database – Specialty — Question 191

Accompany is using Amazon Redshift for its data warehouse. During review of the last few AWS monthly bills, a database specialist notices charges for Amazon Redshift backup storage. The database specialist needs to decrease the cost of these charges in the future and must create a solution that provides notification if the charges exceed a threshold.

Which combination of actions will moot those requirements with the LEAST operational overhead? (Choose two.)

Answer options

• A. Migrate all manual snapshots to the Amazon S3 Standard-Infrequent Access (S3 Standard-IA) storage class
• B. Use an automated snapshot schedule to take a snapshot once each day
• C. Create an Amazon CloudWatch billing alarm to publish a message to an Amazon Simple Notification Service (Amazon SNS) topic if the threshold is exceeded
• D. Create a serverless AWS Glue job to run every 4 hours to describe cluster snapshots and send an email message if the threshold is exceeded
• E. Delete manual snapshots that are not required anymore

Correct answer: C, E

Explanation

The correct actions, C and E, effectively address the cost management and notification requirements with minimal ongoing management. Creating a CloudWatch billing alarm (C) allows for real-time alerts without manual intervention, while deleting unnecessary manual snapshots (E) directly reduces backup storage costs. Options A and B do not directly address the notification requirement, and option D introduces additional complexity with a serverless job that is not needed.