PDE Maintaining and Automating Data Workloads Practice Question
You are setting up Dataplex data quality rules for a BigQuery table. You want to define rules that check for non-null values in key columns and also validate that a column's values fall within a certain range. Which TWO rule types must you use? (Choose 2)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Row rule (e.g., not null)
Dataplex data quality rules include row rules (for null checks) and column rules (for range or value checks). Table rules apply to the entire table; custom SQL can be used but row and column rules are the standard.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Table rule (e.g., row count)
Why it's wrong here
Table rules check table-level properties, not column values.
- ✓
Row rule (e.g., not null)
Why this is correct
Row rules can enforce null checks on specific columns.
- ✗
Partition rule
Why it's wrong here
Partition rules are not a built-in type; partitioning is a table property.
- ✓
Column rule (e.g., value range)
Why this is correct
Column rules validate data within a column, such as range checks.
- ✗
Custom SQL rule
Why it's wrong here
Custom SQL rules are used for complex checks but are not required for simple null and range checks.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PDE question from scratch — 890 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.