AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ237

Data Store Management

An airline company collects metrics about flight activity for analytics. The company is performing a proof-of-concept (POC) test to demonstrate how analytics can deliver insights that it can use to increase on-time departures.

The POC test uses Amazon S3 objects containing the metrics in .csv format. It uses Amazon Athena to query the data. The data is partitioned in the S3 bucket by date.

As the data volume grows, the company wants to optimize the storage solution to improve query performance.

Which combination of solutions meets these requirements?

Choose two
  • A Add a randomized string to the beginning of the keys in Amazon S3 to get more throughput across partitions.
  • B Use an S3 bucket that is in the same account that uses Athena to query the data.
  • C Use an S3 bucket that is in the same AWS Region where the company runs Athena queries.
  • D Preprocess the .csv data to JSON format by fetching only the document keys that the query requires.
  • E Preprocess the .csv data to Apache Parquet format by fetching only the data blocks that are needed for predicates.
Explanation

Keeping the Amazon S3 bucket in the same AWS Region as Athena avoids cross-Region S3 data transfer for queries. Apache Parquet is a columnar format; Athena can use predicate pushdown to read only the data blocks needed by query predicates, reducing I/O and improving query performance.

Learn more

Community Discussion

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