SAA-C03 · Question #516
A company operates a data lake in Amazon S3 that stores large datasets in multiple formats. The company has an application that retrieves and processes subsets of data from multiple objects in the…
The correct answer is A. Use Amazon Athena to query and filter the objects in Amazon S3. The best solution to query and filter S3 data directly without downloading the full object is to use Amazon Athena is an interactive query service that lets you use SQL to analyze structured, semi- structured, and unstructured data directly in Amazon S3, without needing to move…
Question
A company operates a data lake in Amazon S3 that stores large datasets in multiple formats. The company has an application that retrieves and processes subsets of data from multiple objects in the data lake based on filtering criteria. For each data query, the application currently downloads the entire S3 object and performs transformations. The current process requires a large amount of transformation time. The company wants a solution that will give the application the ability to query and filter directly on S3 objects without downloading the objects. Which solution will meet these requirements?
Options
- AUse Amazon Athena to query and filter the objects in Amazon S3.
- BUse Amazon EMR to process and filter the objects.
- CUse Amazon API Gateway to create an API to retrieve filtered results from Amazon S3.
- DUse Amazon ElastiCache (Valkey) to cache the objects.
How the community answered
(59 responses)- A86% (51)
- B3% (2)
- C8% (5)
- D2% (1)
Explanation
The best solution to query and filter S3 data directly without downloading the full object is to use Amazon Athena is an interactive query service that lets you use SQL to analyze structured, semi- structured, and unstructured data directly in Amazon S3, without needing to move or transform It supports formats like CSV, JSON, ORC, Parquet, and Avro and integrates with AWS Glue Data Catalog for schema management. Athena is serverless, meaning there's no infrastructure to manage, and it's billed per query, which keeps it cost-effective. Option B (EMR) is heavier and requires managing a cluster. Option C (API Gateway) is not suited for querying S3 datasets. Option D (ElastiCache) is a memory store, not a query engine.
Community Discussion
No community discussion yet for this question.