Q26 — AWS SAA-C03 Ch.13

Question 26 of 100 | ← Chapter 13

Q926. 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?

Correct Answer: A. Use an Amazon Athena SQL query with the Amazon Athena DynamoDB connector to calculate performance metrics on a recurring schedule.

Explanation

The best solution that meets the requirements with minimal effect on the table's provisioned read and write capacity is:A. Use an Amazon Athena SQL query with the Amazon Athena DynamoDB connector to calculate performance metrics on a recurring schedule.Here's why:Minimal Impact: Athena is a serverless query service that doesn't require any provisioned resources. It queries data directly from DynamoDB without affecting the table's provisioned capacity.Recurring Schedule: Athena supports scheduled queries, allowing you to calculate performance metrics on a daily basis without manual intervention.DynamoDB Connector: The Athena DynamoDB connector enables you to query DynamoDB tables directly using SQL, simplifying the process of data analysis.Why other options are less efficient:B. Use an AWS Glue job with the AWS Glue DynamoDB export connector to calculate performance metrics on a recurring schedule. Glue jobs involve data export, which can significantly impact DynamoDB's provisioned capacity and lead to increased latency.C. Use an Amazon Redshift COPY command to calculate performance metrics on a recurring schedule. Redshift requires data loading, which can impact DynamoDB's provisioned capacity and introduce latency.D. Use an Amazon EMR job with an Apache Hive external table to calculate performance metrics on a recurring schedule. EMR jobs involve data processing and storage, which can significantly impact DynamoDB's provisioned capacity and introduce complexity.In summary:Athena (option A) provides the most efficient and least impactful solution for calculating performance metrics from your DynamoDB table. It offers serverless querying, a dedicated connector, and scheduled execution, ensuring minimal impact on the table's provisioned capacity.