Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam

Exam Professional Data Engineer topic 1 question 97 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 97
Topic #: 1

[All Professional Data Engineer Questions]

You store historic data in Cloud Storage. You need to perform analytics on the historic data. You want to use a solution to detect invalid data entries and perform data transformations that will not require programming or knowledge of SQL.
What should you do?

A. Use Cloud Dataflow with Beam to detect errors and perform transformations.
B. Use Cloud Dataprep with recipes to detect errors and perform transformations.
C. Use Cloud Dataproc with a Hadoop job to detect errors and perform transformations.
D. Use federated tables in BigQuery with queries to detect errors and perform transformations.

Show Suggested Answer

Suggested Answer: B 🗳️

by cleroy at March 10, 2020, 3:10 p.m.

Comments

Submit Cancel

cleroy

Highly Voted 5 years, 3 months ago

Use Dataprep ! It's THE tool for this

upvoted 56 times

...

rickywck

Highly Voted 5 years, 3 months ago

Yes B. Honest speaking, sometime I thought the answers being posted here were intentionally to mislead people whose do not have proper knowledge on the subject, but just memorizing answers to pass the exam.

upvoted 53 times

[Removed]

4 years, 4 months ago

True.. might be legal issue?!

upvoted 6 times

...

sergiomujica

Most Recent 1 year, 9 months ago

Selected Answer: A

A is the right way to do it... dataprepo is clumsy

upvoted 1 times

Wudihero2

1 year, 8 months ago

...Did you even read through the question? It says "not require programming or knowledge of SQL". YOU are the one who's clumsy, not dataprep.

upvoted 7 times

...

crazycosmos

1 year, 10 months ago

Selected Answer: B

no programming -> B

upvoted 1 times

...

FP77

1 year, 10 months ago

Selected Answer: B

I honestly do not understand what is the deal with this website. The correct answer is obviously Dataprep. How can they say it's A?

upvoted 2 times

...

Besss

2 years, 5 months ago

Selected Answer: B

It'B. DataPrep it's the right tool. https://cloud.google.com/dataprep

upvoted 2 times

...

zellck

2 years, 6 months ago

Selected Answer: B

B is the answer. https://cloud.google.com/dataprep Dataprep by Trifacta is an intelligent data service for visually exploring, cleaning, and preparing structured and unstructured data for analysis, reporting, and machine learning.

upvoted 2 times

...

sedado77

2 years, 9 months ago

I got this question on sept 2022.

upvoted 4 times

...

John_Pongthorn

2 years, 9 months ago

Selected Answer: B

B. Actually there are two tools to fix this problem. Dataprep rely on dataflw Datafusion rely on dataproc

upvoted 2 times

baimus

8 months, 3 weeks ago

Datafusion is lo-code but not no-code. The only no-code system is dataprep.

upvoted 2 times

...

diagniste

3 years, 1 month ago

Selected Answer: A

A is the best answer !

upvoted 1 times

desertlotus1211

2 years, 5 months ago

dataflow IS Apache Beam...

upvoted 1 times

...

Venkat007

3 years, 3 months ago

Selected Answer: B

B Dataprep

upvoted 2 times

...

medeis_jar

3 years, 5 months ago

Selected Answer: B

https://cloud.google.com/dataprep/

upvoted 2 times

...

MaxNRG

3 years, 5 months ago

Selected Answer: B

B, “Cloud Dataprep by Trifacta is an intelligent data service for visually exploring, cleaning, and preparing structured and unstructured data for analysis, reporting, and machine learning” https://cloud.google.com/dataprep/

upvoted 6 times