High-Performing Architecture III

Question 58

An e-commerce company has more than 30 million users. The company receives thousands of orders per day. Order data is stored in the S3 bucket, whereas customer data is stored in Amazon RDS. The company plans to share the data with different teams for analytics. As a solutions architect, provide a solution with the fine grain capability and the least operational overhead.

Which solution meets these requirements?

A. Configure the e-commerce application to send data order data directly to Amazon RDS and migrate existing data to Amazon RDS. Use Amazon RDS access controls to manage user access.

B. Configure an AWS Lambda function to periodically copy data from Amazon RDS to Amazon S3. Use Amazon Athena to query the data in the S3 and configure S3 bucket policies to limit access.

C Configure a data lake using AWS Lake Formation. Create an AWS Glue JDBC connection to Amazon RDS. Register the order data S3 bucket in Lake Formation. Use Lake Formation access controls to limit user access.

D. Configure an AWS Redshift cluster. Set up an AWS Lambda function to periodically transfer data from Amazon S3 and Amazon RDS to Redshift. Use Redshift access control to limit user access.