Topic 1 Question 223
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?
Build BigQuery user-defined functions (UDFs).
Create Dataplex data quality tasks.
Build Dataform assertions into your code.
Write a Spark-based stored procedure.
ユーザの投票
コメント(4)
- 正解だと思う選択肢: C
Native Integration:
Dataform assertions are designed specifically for data quality checks within Dataform pipelines, ensuring seamless integration and compatibility. They leverage Dataform's execution model and configuration, aligning with the existing workflow. Declarative Syntax:
Assertions are defined using a simple, declarative syntax within Dataform code, making them easy to write and understand, even for users with less SQL expertise.
👍 2e70ea9e2023/12/30 - 正解だと思う選択肢: C
- Dataform provides a feature called "assertions," which are essentially SQL-based tests that you can define to verify the quality of your data.
- Assertions in Dataform are a built-in way to perform data quality checks, including checking for uniqueness and null values in your tables.
👍 2raaad2024/01/04 agree with C
👍 1Alex35512024/01/07
シャッフルモード