
Ultimate access to all questions.
Your company relies on data stored in BigQuery to generate its reports. Recently, you have identified that some fields in the weekly executive reports are not adhering to the required company standards. Common issues include inconsistent telephone number formats and varying country code identifiers. Recognizing that this is a recurring problem, you need to implement an automated, recurring job to normalize the data. You seek a fast and coding-free solution. What should you do?
A
Use Cloud Data Fusion and Wrangler to normalize the data, and set up a recurring job.
B
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.
C
Create a Spark job and submit it to Dataproc Serverless.
D
Use BigQuery and GoogleSQL to normalize the data, and schedule recurring queries in BigQuery.