Google Sample Question 11 of 27

You are building an ELT solution in BigQuery by using Dataform. You need to perform uniqueness and null value checks on your final tables. What should you do to efficiently integrate these checks into your pipeline?

Source: Google Cloud OFFICIAL

Official sample question published by Google Cloud. WiseOwlLearns is not affiliated with Google LLC.

All explanations and Option Analyzer™ content are generated by WiseOwlLearns and are not endorsed by Google Cloud.

A Build Dataform assertions into your code. ✓ Correct
B Create Dataplex data quality tasks.
C Build BigQuery user-defined functions (UDFs).
D Write a Spark-based stored procedure.
🦉 Explanation by WiseOwl Tutor™ — not endorsed by Google

A Is correct as Dataform assertions are used to execute data quality checks within dataform and as part of a job. B Is not correct because Dataplex tasks are outside your pipeline. C Is not correct as BigQuery UDFs are not generally used for data quality checks D Is not correct as BigQuery Spark based stored procedures are not generally used for data quality checks

Ready to practice?

These 27 official sample questions are free to practice on WiseOwlLearns — no account required. Get real-time tutoring from WiseOwl Tutor™ and step-by-step elimination reasoning from Option Analyzer™.

Start Practicing Free View Professional Data Engineer Course →