SAA-C03 · Question #34
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 oncustomer devices The co
The correct answer is A. Use an Amazon Athena SQL query with the Amazon Athena DynamoDB connector to calculate. Amazon Athena provides a cost-effective, serverless way to query data without affecting the performance of DynamoDB. By using the Athena DynamoDB connector, the company can perform the necessary SQL queries without consuming read capacity on the DynamoDB table, which is essential
Question
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 oncustomer 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?
Options
- AUse an Amazon Athena SQL query with the Amazon Athena DynamoDB connector to calculate
- BUse an AWS Glue job with the AWS Glue DynamoDB export connector to calculate performance
- CUse an Amazon Redshift COPY command to calculate performance metrics on a recurring
- DUse an Amazon EMR job with an Apache Hive external table to calculate performance metrics on
How the community answered
(31 responses)- A77% (24)
- B3% (1)
- C13% (4)
- D6% (2)
Explanation
Amazon Athena provides a cost-effective, serverless way to query data without affecting the performance of DynamoDB. By using the Athena DynamoDB connector, the company can perform the necessary SQL queries without consuming read capacity on the DynamoDB table, which is essential for minimizing impact on provisioned throughput. Minimal Impact on Provisioned Capacity: Athena queries do not directly impact DynamoDB's read capacity, making it ideal for running analytics without affecting the customer-facing workloads. Cost-Effective: Athena is a serverless solution, meaning you pay only for the queries you run, making it highly cost-effective compared to running a dedicated cluster like Amazon EMR or AWS Documentation: The use of Athena to query DynamoDB through its connector aligns with AWS's best practices for performance efficiency and cost optimization.
Community Discussion
No community discussion yet for this question.