Google Cloud Professional Data Engineer — Question 149

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?

Answer options

• A. Build BigQuery user-defined functions (UDFs).
• B. Create Dataplex data quality tasks.
• C. Build Dataform assertions into your code.
• D. Write a Spark-based stored procedure.

Correct answer: C

Explanation

The correct answer is C because Dataform assertions allow you to directly integrate data quality checks into your SQL code, making them an efficient part of your pipeline. Options A and D, while useful in other contexts, do not specifically address the integration of checks into the Dataform workflow, and option B is more suited for broader data governance rather than specific table checks.