AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ66

Data Store Management

A marketing company stores clickstream data in Amazon S3. At the end of each day, the company queries the data by using a SQL JOIN clause on S3 objects stored in separate buckets.

The company creates key performance indicators (KPIs) from the objects. It needs a serverless solution that enables users to query data through data partitioning. The solution must preserve the data's atomicity, consistency, isolation, and durability (ACID) properties.

Which solution will meet these requirements MOST cost-effectively?

  • A Amazon S3 Select
  • B Amazon Redshift Spectrum
  • C Amazon Athena
  • D Amazon EMR
Explanation

Amazon Athena is a serverless SQL query service for data in Amazon S3 and can query partitioned tables, including joins across S3 locations. Athena supports Apache Iceberg tables, whose transactional operations provide ACID behavior and partition evolution. It is charged per query and requires no cluster management, making it the appropriate cost-effective serverless option.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!