Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 147 discussion

A. Use Amazon DynamoDB with auto scaling. Use on-demand backups and AWS CloudTrail. CORRECT - Scalable, with backup and AWS Managed Auditing B. Use Amazon DynamoDB with auto scaling. Use on-demand backups and Amazon DynamoDB Streams. INCORRECT - AWS DDB Streams can be used for auditing, but its not AWS managed auditing. C. Use Amazon Redshift Configure concurrency scaling. Enable audit logging. Perform database snapshots every 4 hours. INCORRECT - Not a database. Datalake D. Use Amazon RDS with Provisioned IOPS. Enable the database auditing parameter. Perform database snapshots every 5 hours. INCORRECT - This does not scale E. Use Amazon RDS with auto scaling. Enable the database auditing parameter. Configure the backup retention period to at least 1 day. CORRECT - Scalable, AWS managed auditing and backup. The backup frequency is not stated but have no technical limitation which states it cannot be less 5 hours (1 day is retention period of the backup).

Should be A and D.

Why not A & D when D specifically stated snapshots taken every 5 hours to meet the RPO requirement.

A and B are the answers

depending on the time of the day.

I go with A and E.

AB https://aws.amazon.com/blogs/database/dynamodb-streams-use-cases-and-design-patterns/

WHERE ARE U MLANTONIS <3

lets hope this question is not come on exam. A. Correct. Scalable, on-demand backup is manual backup, aws managed auditlog B. Incorrect. Scalable, on-demand backup, but streams need the uses of AWS sdk. its not AWS managed audit log C. Correct. Scalable, audit logging by AWS redshift log. you can call this Datalake or warehouse. but its still RDBMS D. incorrect. it doesnt scale E. May be correct. but its only scale the storage, not CPU and memory like aurora

E is correct for sure: RDS saves the automated backups of your DB instance according to the backup retention period that you specify. If necessary, you can recover your database to any point in time during the backup retention period. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html

A & E seems correct

A E correct

In my opinion, I will select B&E. I do not see the need for introducing cloud trail, since DB auditing is a feature that can be enabled by DynamoDB and RDS. CloudTrail is mainly for general API call to AWS infra. but for detail auditing you need to enable DB auditing. this cancels out A. leaving the Ans B & E.

ABC B works because Streams can be sent to KCl,Lambda,KDS. Create/update/delete actions can be tracked. D is incorrect because it does not talk about scaling. E is incorrect because RDS autoscaling does not refer to compute level-its only for storage Further,by default,backups are daily--wil not help with RPO of 5 hrs

I'll go for AD

When you enable DynamoDB Streams, it captures a time-ordered sequence of item-level modifications in a DynamoDB table and durably stores the information for up to 24 hours.

Amazon RDS does not provide managed auditing, developers have to use plugins to capture events and publish logs to cloudwatch. So options D and E are out. Correct answers: A & B