Explanation:
Correct Answer: C
Why the other options are incorrect:
Your company uses BigQuery to generate weekly executive reports, but you've noticed inconsistencies in data fields, such as varying telephone formats and country code identifiers. What's the quickest, no-code solution to normalize this data on a recurring basis?
A
Create a Spark job and submit it to Dataproc Serverless.
B
Use BigQuery and GoogleSQL to normalize the data, and schedule recurring queries in BigQuery.
C
Use Cloud Data Fusion and Wrangler to normalize the data, and set up a recurring job.
D
Use Dataflow SQL to create a job that normalizes the data, and after the first run, schedule the pipeline to execute recurrently.
No comments yet.