Google Professional Data Engineer Exam Professional-Data-Engineer Question # 3 Topic 1 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 3 Topic 1 Discussion

Professional-Data-Engineer Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1

You have data located in BigQuery that is used to generate reports for your company. You have noticed some weekly executive report fields do not correspond to format according to company standards for example, report errors include different telephone formats and different country code identifiers. This is a frequent issue, so you need to create a recurring job to normalize the data. You want a quick solution that requires no coding What should you do?


A.

Use Cloud Data Fusion and Wrangler to normalize the data, and set up a recurring job.


B.

Use BigQuery and GoogleSQL to normalize the data, and schedule recurring quenes in BigQuery.


C.

Create a Spark job and submit it to Dataproc Serverless.


D.

Use Dataflow SQL to create a job that normalizes the data, and that after the first run of the job, schedule the pipeline to execute recurrently.


Get Premium Professional-Data-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.