Weekly reports from BigQuery have inconsistent formats (phone formats, country codes). You need a no-code recurring job to normalize the data. What do you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Cloud Data Fusion and Wrangler to normalize the data, and set up a recurring job..
Why this is the answer
Cloud Data Fusion is a fully managed, code-free data integration service that allows users to build and manage ETL/ELT data pipelines. Its Wrangler component provides an interactive, visual interface for data cleansing, transformation, and normalization, making it ideal for handling inconsistent formats without writing code. Cloud Data Fusion also supports scheduling recurring jobs. Dataflow SQL requires SQL knowledge and is primarily for stream processing, not the best fit for a no-code requirement. Creating a Spark job and submitting it to Dataproc Serverless requires coding in Spark, which goes against the no-code requirement. While BigQuery and GoogleSQL can normalize data and schedule recurring queries, this solution requires writing SQL, which is not a no-code approach.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed