Amazon SAA-C02: Solution to retain audit records for database for 7 days and RPO must be less than 5 hours.

Table of Contents

Question
Answer
Explanation
Reference

Question

A solutions architect is designing a customer-facing application for a company. The application’s database will have a clearly defined access pattern throughout the year and will have a variable number of reads and writes that depend on the time of year. The company must retain audit records for the database for 7 days. The recovery point objective (RPO) must be less than 5 hours. Which solution meets these requirements?

A. Use Amazon DynamoDB with auto scaling Use on-demand backups and Amazon DynamoDB Streams
B. Use Amazon Redshift. Configure concurrency scaling. Activate audit logging. Perform database snapshots every 4 hours
C. Use Amazon RDS with Provisioned IOPS Activate the database auditing parameter. Perform database snapshots every 5 hours
D. Use Amazon Aurora MySQL with auto scaling. Activate the database auditing parameter

Answer

C. Use Amazon RDS with Provisioned IOPS Activate the database auditing parameter. Perform database snapshots every 5 hours

Explanation

To meet the requirements of a customer-facing application with a clearly defined access pattern, variable read/write demands, and specific data retention and recovery objectives, the most suitable solution is:

C. Use Amazon RDS with Provisioned IOPS, activate the database auditing parameter, and perform database snapshots every 5 hours.

A. Using Amazon DynamoDB with auto scaling is a valid option for a highly scalable NoSQL database. However, it does not provide native audit logging functionality for the database. While DynamoDB Streams can capture changes to the data, it does not address the audit record retention requirement.

B. Amazon Redshift is a powerful data warehousing solution, but it may not be the best fit for this scenario. It is optimized for analytics workloads rather than a customer-facing application with variable read/write demands. Database snapshots every 4 hours may not meet the specified recovery point objective (RPO) of less than 5 hours.

C. Amazon RDS with Provisioned IOPS is a good choice for a customer-facing application with a clearly defined access pattern. It allows you to provision the required input/output operations per second (IOPS) for the database to handle the workload efficiently. Activating the database auditing parameter ensures that audit logs are generated and retained as required. Performing database snapshots every 5 hours helps meet the RPO of less than 5 hours, allowing for relatively frequent recovery points.

D. While Amazon Aurora MySQL with auto scaling is a scalable and high-performance database option, it does not provide native audit logging functionality. Therefore, it does not meet the requirement for retaining audit records for 7 days.

In summary, Option C is the most suitable solution as it combines the benefits of Amazon RDS with Provisioned IOPS, database auditing, and regular database snapshots. This solution meets the specific requirements of the customer-facing application, including the defined access pattern, variable read/write demands, audit record retention, and recovery point objective (RPO) of less than 5 hours.

Reference

Amazon AWS Certified Solutions Architect – Associate SAA-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Associate SAA-C02 exam and earn Amazon AWS Certified Solutions Architect – Associate SAA-C02 certification.