AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ294

Data Operations and Support

A company must create a one-time performance report by joining data stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3. The company wants to prevent unnecessary data movement and minimize query execution time.

Which solution meets these requirements?

  • A Capture data from DynamoDB by using DynamoDB Streams. Migrate data from Amazon RDS by using AWS DMS. Export Amazon Redshift data. Store all data in Amazon S3. Use Redshift Spectrum to run queries.
  • B Set up an AWS Glue ETL pipeline to extract, transform, and centralize data in Amazon S3. Use Amazon Athena to run analytical queries.
  • C Deploy an Amazon EMR cluster powered by Apache Spark to ingest, process, and merge datasets from multiple sources. Run analytical workloads on the merged data.
  • D Use Amazon Athena Federated Query to perform one-time joins and analysis across DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.
Explanation

Amazon Athena Federated Query runs SQL across data in Amazon S3 and supported external sources in place, including DynamoDB and Redshift through Athena connectors and Amazon RDS through JDBC-compatible database connectors. It supports cross-source joins and predicate pushdown, so it avoids first copying and centralizing the datasets for a one-time report.

Learn more

Community Discussion

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