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

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 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

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

Submit Cancel

XP_2600

2 months, 1 week ago

Selected Answer: D

B is no longer valid: https://docs.aws.amazon.com/AmazonS3/latest/userguide/using-select.html Important Amazon S3 Select is no longer available to new customers. Existing customers of Amazon S3 Select can continue to use the feature as usual.

upvoted 1 times

AminTriton

2 weeks, 1 day ago

Even if S3 Select is no longer valid, it doesn’t mean you ignore that answer. AWS exams take time to get updated and as they say, they don’t put made-up solutions in the choices. Keep that in mind everyone that obsolete solutions doesn’t necessarily mean they cannot be the correct choice in the exam.

upvoted 1 times

...

imymoco

7 months, 4 weeks ago

Selected Answer: B

only one column -> S3 select

upvoted 1 times

...

JoeAWSOCM

8 months, 2 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

1 year 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

1 year, 2 months ago

but s3 select can only select one object

upvoted 3 times

...

hogs

1 year, 2 months ago

Selected Answer: B

omly once

upvoted 2 times

...

FunkyFresco

1 year, 2 months ago

Selected Answer: B

if is one-time task

upvoted 2 times

...

GiorgioGss

1 year, 5 months ago

Selected Answer: B

https://docs.aws.amazon.com/AmazonS3/latest/userguide/using-select.html

upvoted 2 times

...

rralucard_

1 year, 6 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

...