Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A data practitioner is configuring a data transformation pipeline in Google Cloud using Dataform. To ensure compliance with business rules and quality standards before downstream analytics processing, the dataset must meet specific validation requirements:
email column must match a specific format pattern (%@%.%).signup_date column must fall within a valid date range (greater than 2022-08-01).Which feature in Dataform should the practitioner configure in the table definition?
A standard BigQuery view is a virtual table defined by a SQL query. Filtering records using a WHERE clause can exclude invalid or non-compliant rows from being displayed to downstream query consumers.
WHERE clauses for row filtering; EXCLUDE is not a standard row-filtering clause in BigQuery SQL.The goal was to build a presentation-layer view that provides business analysts with only valid customer records without halting upstream transformation pipelines when bad records arrive.
In Google Cloud Dataform, assertions are automated data quality testing mechanisms executed during workflow runs. Within a table definition's config block, rowConditions allows data practitioners to define custom SQL expressions that every row in the resulting table must satisfy. If any row evaluates to false against any defined row condition, Dataform flags the assertion as failed.
'email like "%@%.%"' can be added directly to the rowConditions array to verify that string values conform to expected email patterns.'signup_date is null or signup_date > "2022-08-01"' ensure that date values stay within permissible historical boundaries.dataform_assertions dataset).Using rowConditions inside the table's config block provides a built-in, native method to enforce pattern and range constraints without needing to write external validation pipelines or separate testing scripts.
Identity and Access Management (IAM) conditions in Google Cloud allow administrators to define conditional access control policies. They grant or restrict user and service account permissions based on contextual attributes such as resource tags, access time, or network origin.
bigquery.tables.create or bigquery.jobs.create.The requirement involved restricting which data practitioners or service accounts have permission to run Dataform workflows or modify BigQuery datasets based on specific schedules or corporate network IP ranges.
In Dataform, nonNull is a built-in assertion type specified within the config block of a table definition. Its primary function is to verify that specified columns do not contain any NULL values across all rows in the dataset.
nonNull assertion only checks for the existence of values; it cannot evaluate whether a string matches a format pattern (like an email regex or LIKE pattern) or whether a date falls within a specific range.nonNull cannot enforce custom business rules such as signup_date > '2022-08-01'.NULL or not NULL.nonNull: ["user_id", "customer_id"]).The scenario solely required verifying that critical identification fields (such as user_id or order_id) are never populated with NULL values before writing to the target warehouse.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated