PDE Maintaining and Automating Data Workloads Practice Question
You are configuring Dataplex data quality rules for a BigQuery table. Which three types of rules can be defined using Dataplex's SQL-based rule engine? (Choose three.)
⚠ Common exam trap
Google often tests the distinction between rule categories that are natively supported versus those that require custom SQL workarounds, leading candidates to mistakenly select set-level or pattern matching rules as separate types when they are actually implemented within row-level rules.
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-level rules (e.g., condition must be true for every row)
Dataplex's SQL-based rule engine supports row-level rules that enforce a condition that must be true for every row in a BigQuery table. These rules are defined using a SQL expression that is evaluated per row, and if any row fails the condition, the rule is violated. This allows you to validate data integrity at the most granular level, such as ensuring a column value is always positive.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Row-level rules (e.g., condition must be true for every row)
Why this is correct
Row-level rules validate each row against a condition.
- ✗
Set-level rules (e.g., intersection or difference between two tables)
Why it's wrong here
Set-level rules are not supported in Dataplex's SQL-based rules.
- ✗
Pattern matching rules (e.g., regex on column values)
Why it's wrong here
While regex can be used in SQL, pattern matching is not a distinct rule type; it's covered by column-level rules.
- ✓
Table-level rules (e.g., row count threshold)
Why this is correct
Table-level rules check aggregate properties like row count.
- ✓
Column-level rules (e.g., uniqueness, nullness, range)
Why this is correct
Column-level rules apply to specific columns.
Go deeper
Related to this question
About these practice questions
This PDE question is part of Courseiva's 890-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.