Which of the following is a key feature of Dataform for data preparation and cleaning?

SQL-based transformation definitions with version control

Managed Apache Airflow environment

Visual drag-and-drop pipeline design

A logistics company has a complex data pipeline that involves multiple steps: ingesting data from Cloud Storage, running a Dataflow job, and then loading the results into BigQuery. The pipeline must run daily, and if a step fails, it should be retried up to 3 times before the entire pipeline is marked as failed. What is the most appropriate tool to orchestrate this pipeline?

Use Cloud Scheduler to trigger each step independently and manage retries in the application code.

Use Cloud Data Fusion to orchestrate the pipeline and manage retries.

Use Dataflow to orchestrate the entire pipeline, including the BigQuery load.

Use Cloud Composer to define a DAG that runs the steps in sequence and configure retries on the tasks.

A marketing company uses Cloud Data Fusion to build a pipeline that cleans and prepares customer data from a CSV file in Cloud Storage. The pipeline must handle missing values in the 'email' column by replacing them with a default value, and it must also ensure that the 'age' column contains only values between 18 and 65. What is the most efficient way to implement this in Cloud Data Fusion?

Use a 'Condition' transform to replace missing emails and a 'Validator' transform to check the age range.

Use a 'Filter' transform to remove rows with missing emails and a 'Validator' transform to check the age range.

Use a 'Wrangler' transform to manually clean the data and a 'Validator' transform to check the age range.

Use a 'Replace' transform to fill missing emails with a default value and a 'Validator' transform to check the age range.

Google CloudProfessional Data Engineer

Domain 1Objective 2

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

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 11–15

11foundation · easy
Which of the following is a key feature of Dataform for data preparation and cleaning?
Select an answer first
12application · medium
A logistics company has a complex data pipeline that involves multiple steps: ingesting data from Cloud Storage, running a Dataflow job, and then loading the results into BigQuery. The pipeline must run daily, and if a step fails, it should be retried up to 3 times before the entire pipeline is marked as failed. What is the most appropriate tool to orchestrate this pipeline?
Select an answer first
13application · medium
A marketing company uses Cloud Data Fusion to build a pipeline that cleans and prepares customer data from a CSV file in Cloud Storage. The pipeline must handle missing values in the 'email' column by replacing them with a default value, and it must also ensure that the 'age' column contains only values between 18 and 65. What is the most efficient way to implement this in Cloud Data Fusion?
Select an answer first
14foundation · easy
A data engineer needs to define a SQL-based transformation that cleans and prepares data in BigQuery as part of a scheduled pipeline. Which Google Cloud service is specifically designed for this purpose?
Select an answer first
15foundation · easy
Which ACID property ensures that once a transaction is committed, it will survive a system failure?
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 3)

Questions 11–15

Which of the following is a key feature of Dataform for data preparation and cleaning?

A data engineer needs to define a SQL-based transformation that cleans and prepares data in BigQuery as part of a scheduled pipeline. Which Google Cloud service is specifically designed for this purpose?

Which ACID property ensures that once a transaction is committed, it will survive a system failure?

Keep studying — Designing data processing systems