ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 49 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 49
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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?

  • A. Configure an AWS Lambda function to load data from the S3 bucket into a pandas dataframe. Write a SQL SELECT statement on the dataframe to query the required column.
  • B. Use S3 Select to write a SQL SELECT statement to retrieve the required column from the S3 objects.
  • C. Prepare an AWS Glue DataBrew project to consume the S3 objects and to query the required column.
  • D. Run an AWS Glue crawler on the S3 objects. Use a SQL SELECT statement in Amazon Athena to query the required column.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by rralucard_ at Feb. 2, 2024, 10:29 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
imymoco
4 months ago
Selected Answer: B
only one column -> S3 select
upvoted 1 times
...
JoeAWSOCM
4 months, 3 weeks ago
Selected Answer: D
S3 select is for querying one object. Here the requirement is to query one column from multiple objects. Also S3 select is discontinued for new users. So answer could be D
upvoted 4 times
...
catoteja
8 months, 2 weeks ago
Amazon S3 Select is no longer available to new customers. Existing customers of Amazon S3 Select can continue to use the feature as usual But with it you can only query one object xD. Glue + athena
upvoted 1 times
...
dungct
10 months, 2 weeks ago
but s3 select can only select one object
upvoted 3 times
...
hogs
10 months, 2 weeks ago
Selected Answer: B
omly once
upvoted 2 times
...
FunkyFresco
11 months, 1 week ago
Selected Answer: B
if is one-time task
upvoted 2 times
...
GiorgioGss
1 year, 1 month ago
Selected Answer: B
https://docs.aws.amazon.com/AmazonS3/latest/userguide/using-select.html
upvoted 2 times
...
rralucard_
1 year, 2 months ago
Selected Answer: B
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.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago