A healthcare company is building a Dataform pipeline to clean and prepare patient data in BigQuery. The pipeline must ensure that all patient IDs are unique and that age values are within a valid range (0-120). What is the most appropriate way to implement these checks?

Use Dataform's 'assertions' feature to define uniqueness and range checks on the data.

Create a BigQuery scheduled query that runs after the Dataform pipeline and checks for duplicates and invalid ages.

Write a separate Dataflow pipeline that reads the BigQuery table and validates the data, then writes the results to a separate table.

Use a Cloud Data Fusion pipeline to perform the validation and write the results back to the same table.

A data engineer is designing a disaster recovery plan for a data pipeline that loads data into BigQuery. Which strategy is most appropriate for ensuring data durability?

Setting up a Cloud Scheduler job to rerun the pipeline

Configuring BigQuery snapshots for the dataset

Using a multi-region BigQuery location

Enabling versioning on the source data in Cloud Storage

Google CloudProfessional Data Engineer

Domain 1Objective 2

1.2 Designing for Reliability and Fidelity PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 1)

Part of the Designing data processing systems domain, which accounts for ~22% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~11–18 in this domain), expect 3–5 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

11concepts

~22%of the exam

Questions 1–5

1foundation · easy
Which programming model does Dataflow use to define data processing pipelines?
Select an answer first
2application · medium
A healthcare company is building a Dataform pipeline to clean and prepare patient data in BigQuery. The pipeline must ensure that all patient IDs are unique and that age values are within a valid range (0-120). What is the most appropriate way to implement these checks?
Select an answer first
3foundation · easy
A data engineer is designing a disaster recovery plan for a data pipeline that loads data into BigQuery. Which strategy is most appropriate for ensuring data durability?
Select an answer first
4foundation · easy
Which data validation technique ensures that a column does not contain duplicate values?
Select an answer first
5foundation · easy
In a distributed database, which consistency model allows reads to return stale data but ensures that all replicas eventually converge to the same state?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

1.2 Designing for Reliability and Fidelity PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 1)

Questions 1–5

Which programming model does Dataflow use to define data processing pipelines?

A healthcare company is building a Dataform pipeline to clean and prepare patient data in BigQuery. The pipeline must ensure that all patient IDs are unique and that age values are within a valid range (0-120). What is the most appropriate way to implement these checks?

A data engineer is designing a disaster recovery plan for a data pipeline that loads data into BigQuery. Which strategy is most appropriate for ensuring data durability?

Which data validation technique ensures that a column does not contain duplicate values?

In a distributed database, which consistency model allows reads to return stale data but ensures that all replicas eventually converge to the same state?

Keep studying — Designing data processing systems