PROFESSIONAL-DATA-ENGINEER · Question #371
PROFESSIONAL-DATA-ENGINEER Question #371: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #371. The question stem and answer options stay visible for context.
Question
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?
Options
- AUse Cloud Data Fusion and Wrangler to normalize the data, and set up a recurring job.
- BUse 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.
- CCreate a Spark job and submit it to Dataproc Serverless.
- DUse BigQuery and GoogleSQL to normalize the data, and schedule recurring queries in BigQuery.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.