DEA-C01 · Question #26
A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data. Which solution wil
The correct answer is B. Use S3 Select to write a SQL SELECT statement to retrieve the required column from the S3. https://docs.aws.amazon.com/AmazonS3/latest/userguide/storage-inventory-athena-query.html S3 Select allows you to retrieve a subset of data from an object stored in S3 using simple SQL expressions. It is capable of working directly with objects in Parquet format.
Question
A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data. Which solution will meet these requirements with the LEAST operational overhead?
Options
- AConfigure an AWS Lambda function to load data from the S3 bucket into a pandas dataframe.
- BUse S3 Select to write a SQL SELECT statement to retrieve the required column from the S3
- CPrepare an AWS Glue DataBrew project to consume the S3 objects and to query the required
- DRun an AWS Glue crawler on the S3 objects. Use a SQL SELECT statement in Amazon Athena
How the community answered
(32 responses)- A13% (4)
- B78% (25)
- C6% (2)
- D3% (1)
Explanation
https://docs.aws.amazon.com/AmazonS3/latest/userguide/storage-inventory-athena-query.html S3 Select allows you to retrieve a subset of data from an object stored in S3 using simple SQL expressions. It is capable of working directly with objects in Parquet format.
Topics
Community Discussion
No community discussion yet for this question.