AWS Certified Solutions Architect – Associate (SAA-C03) — Question 937

A company uses an Amazon DynamoDB table to store data that the company receives from devices. The DynamoDB table supports a customer-facing website to display recent activity on customer devices. The company configured the table with provisioned throughput for writes and reads.

The company wants to calculate performance metrics for customer device data on a daily basis. The solution must have minimal effect on the table's provisioned read and write capacity.

Which solution will meet these requirements?

Answer options

• A. Use an Amazon Athena SQL query with the Amazon Athena DynamoDB connector to calculate performance metrics on a recurring schedule.
• B. Use an AWS Glue job with the AWS Glue DynamoDB export connector to calculate performance metrics on a recurring schedule.
• C. Use an Amazon Redshift COPY command to calculate performance metrics on a recurring schedule.
• D. Use an Amazon EMR job with an Apache Hive external table to calculate performance metrics on a recurring schedule.

Correct answer: B

Explanation

Using an AWS Glue job with the AWS Glue DynamoDB export connector leverages DynamoDB's native export to Amazon S3 feature, which does not consume any of the table's provisioned read capacity. Other options like Amazon Athena, Amazon Redshift COPY, and Amazon EMR Hive query the DynamoDB table directly, which consumes provisioned read capacity units (RCUs) and risks degrading the performance of the customer-facing website.