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

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to 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 Hide Answer
Suggested Answer: B 🗳️
by cleroy at March 10, 2020, 3:10 p.m.

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
cleroy
Highly Voted 5 years, 1 month ago
Use Dataprep ! It's THE tool for this
upvoted 56 times
...
rickywck
Highly Voted 5 years, 1 month 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, 3 months ago
True.. might be legal issue?!
upvoted 6 times
...
...
sergiomujica
Most Recent 1 year, 7 months ago
Selected Answer: A
A is the right way to do it... dataprepo is clumsy
upvoted 1 times
Wudihero2
1 year, 6 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, 8 months ago
Selected Answer: B
no programming -> B
upvoted 1 times
...
FP77
1 year, 9 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, 3 months ago
Selected Answer: B
It'B. DataPrep it's the right tool. https://cloud.google.com/dataprep
upvoted 2 times
...
zellck
2 years, 4 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, 7 months ago
I got this question on sept 2022.
upvoted 4 times
...
John_Pongthorn
2 years, 7 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
7 months ago
Datafusion is lo-code but not no-code. The only no-code system is dataprep.
upvoted 2 times
...
...
diagniste
2 years, 11 months ago
Selected Answer: A
A is the best answer !
upvoted 1 times
desertlotus1211
2 years, 3 months ago
dataflow IS Apache Beam...
upvoted 1 times
...
...
Venkat007
3 years, 2 months ago
Selected Answer: B
B Dataprep
upvoted 2 times
...
medeis_jar
3 years, 3 months ago
Selected Answer: B
https://cloud.google.com/dataprep/
upvoted 2 times
...
MaxNRG
3 years, 4 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
dattatray_shinde
2 years, 9 months ago
max you rock man!
upvoted 2 times
...
...
GirijaSrinivasan
3 years, 6 months ago
Answer is B. Data prep. The keyword here is no programming skills required.
upvoted 4 times
...
nguyenmoon
3 years, 7 months ago
B- Dataprep
upvoted 2 times
...
pass_gcp
3 years, 8 months ago
Use Dataprep ....is the answer
upvoted 2 times
...
sumanshu
3 years, 10 months ago
Vote for B
upvoted 2 times
sumanshu
3 years, 10 months ago
Cloud Dataprep - almost fully automated
upvoted 1 times
...
...
Load full discussion...
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