Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
A data engineering team is implementing a data cleansing and quality governance framework for raw transaction data ingested daily into BigQuery. To prevent data corruption from impacting downstream analytics, the team must meet the following requirements:
Which solution should the team implement in Dataplex to satisfy these requirements?
BigQuery ML built-in functions such as ML.DESCRIBE_DATA, ML.VALIDATE_DATA_DRIFT, and ML.VALIDATE_DATA_SKEW provide descriptive statistics and detect distribution shifts between training and evaluation datasets for machine learning workflows.
The scenario specifically required identifying training-serving skew or feature drift across ML feature stores prior to model retraining.
Sensitive Data Protection (formerly Cloud DLP) scans data assets to identify, classify, and measure risks associated with personally identifiable information (PII), regulatory data, and sensitive elements (such as credit card numbers or national IDs).
sqlAssertion) or track column-level data quality dimensions (dataQualitySpec).The primary goal was to discover unprotected PII across storage assets and generate data sensitivity findings for compliance auditing.
Dataplex DataScan is a fully managed, serverless governance capability in Google Cloud that automates data profiling and data quality validation directly across BigQuery tables and Cloud Storage data lakes without requiring data movement.
dataProfileSpec) compute column-level summary statistics, distinct values, null percentages, and distributions, allowing engineers to visually assess anomalies and data distributions directly within the Google Cloud console.dataQualitySpec) execute declarative rules, such as rangeExpectation, regexExpectation, setExpectation, and custom sqlAssertion checks against datasets on a defined schedule.postScanActions.bigqueryExport.resultsTable) write comprehensive execution metadata—including rows_validated, success_percentage, failed_count, and a diagnostic failed_records_query SQL statement—directly into a target BigQuery table for historical auditing.postScanActions.notificationReport.scoreThresholdTrigger triggers automated email alerts when the overall quality score drops below the specified tolerance.This approach provides an end-to-end, native Google Cloud framework for profiling, automated quality rule enforcement, auditing, and alert management, minimizing operational overhead while establishing automated data reliability.
Looker Studio is a self-service business intelligence (BI) and data visualization platform designed to build interactive dashboards, charts, and executive reports for end users.
rows_validated, failed_count, failed_records_query).The primary goal was to provide business stakeholders with interactive dashboards and charts summarizing high-level KPIs.
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 Validated