ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 795 - SAA-C03 discussion

Report
Export

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?

A.
Use an Amazon Athena SQL query with the Amazon Athena DynamoDB connector to calculate performance metrics on a recurring schedule.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
Use an Amazon EMR job with an Apache Hive external table to calculate performance metrics on a recurring schedule.
Suggested answer: A

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.

Key benefits:

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 Redshift.

AWS Documentation: The use of Athena to query DynamoDB through its connector aligns with AWS's best practices for performance efficiency and cost optimization.

asked 16/09/2024
Earl Frederick
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first