
Ultimate access to all questions.
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.