AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
An online retail firm with over 50M active customers and 25k+ daily orders stores purchase data in Amazon S3 and additional customer data in Amazon RDS. They seek a solution for analytics teams to access all data with fine-grained permissions and minimal operational overhead. Which solution meets these criteria?
A
Migrate purchase data to Amazon RDS, applying RDS access controls for permission management.
B
Use AWS Lambda to sync Amazon RDS to Amazon S3 periodically, implement an AWS Glue crawler, query with Amazon Athena, and enforce access limits with S3 policies.
C
Establish a data lake with AWS Lake Formation, connect to Amazon RDS via AWS Glue JDBC, register the S3 bucket, and manage access with Lake Formation controls.
D
Deploy an Amazon Redshift cluster, use AWS Lambda for regular data replication from S3 and RDS to Redshift, and restrict access using Redshift's access controls.