Google Professional Data Engineer Exam - Topic 5 Question 34 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 34
Topic #: 5

[All Professional Data Engineer Questions]

You have uploaded 5 years of log data to Cloud Storage A user reported that some data points in the log data are outside of their expected ranges, which indicates errors You need to address this issue and be able to run the process again in the future while keeping the original data for compliance reasons What should you do?

AImport the data from Cloud Storage into BigQuery Create a new BigQuery table, and skip the rows with errors.

BCreate a Compute Engine instance and create a new copy of the data in Cloud Storage Skip the rows with errors

CCreate a Cloud Dataflow workflow that reads the data from Cloud Storage, checks for values outside the expected range, sets the value to an appropriate default, and writes the updated records to a new dataset in
Cloud Storage

DCreate a Cloud Dataflow workflow that reads the data from Cloud Storage, checks for values outside the expected range, sets the value to an appropriate default, and writes the updated records to the same dataset in Cloud Storage

Show Suggested Answer

Suggested Answer: C

by Yoko at May 09, 2022, 03:58 AM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Hoa

4 months ago

I think we should avoid overwriting data, so C is safer.

upvoted 0 times

...

Lauran

4 months ago

Definitely need to keep original data for compliance.

upvoted 0 times

...

Andra

4 months ago

Surprised that skipping rows is even an option!

upvoted 0 times

...

Lashawnda

4 months ago

I disagree, D could work too if you want to keep it simple.

upvoted 0 times

...

Thurman

5 months ago

Option C seems like the best choice for handling errors.

upvoted 0 times

...

Cordelia

5 months ago

I’m not completely confident, but I think we should avoid writing back to the same dataset to prevent losing the original data. So maybe option C is safer than D?

upvoted 0 times

...

Ronald

5 months ago

I feel like we practiced a similar question where we had to choose between creating new datasets or modifying existing ones. I think option C might be the right approach.

upvoted 0 times

...

Kate

5 months ago

I remember we discussed the importance of keeping original data for compliance, so I think options that overwrite the original data might not be the best.

upvoted 0 times

...