PDE Designing Data Processing Systems Practice Question
A company uses Cloud Data Fusion for ETL pipelines. They need to transform sensitive data (PII) by masking certain columns before writing to BigQuery. They also need to ensure the pipeline can be monitored and restarted from failure points. Which THREE features should they use?
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
✓
Enable pipeline monitoring with alerts in Cloud Data Fusion
Data Fusion Wrangler provides a step-by-step recipe for transformations, including masking. Pipeline monitoring and restart from failure are supported by the orchestration framework and checkpointing. Dataproc Metastore is for Hive metadata, not relevant. Data Fusion Studio is the UI, not a feature for monitoring. Cloud Composer is for workflow orchestration, not needed if Data Fusion handles it.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Cloud Composer to schedule and retry the pipeline
Why it's wrong here
While possible, Cloud Data Fusion has built-in scheduling and retry capabilities. Adding Cloud Composer increases complexity unnecessarily.
- ✗
Create a Dataproc Metastore service to store pipeline metadata
Why it's wrong here
Dataproc Metastore is for Hive metastore, not for pipeline checkpointing or monitoring.
- ✓
Enable pipeline monitoring with alerts in Cloud Data Fusion
Why this is correct
Cloud Data Fusion provides monitoring dashboards and alerting for pipeline status, including failures.
- ✓
Configure pipeline checkpointing to allow restart from failure
Why this is correct
Data Fusion pipelines can be configured with checkpointing (using Dataproc), enabling restart from the last successful state.
- ✓
Use Wrangler transformations to apply masking directives
Why this is correct
Wrangler allows you to apply transformations like 'Mask' or 'Hash' on columns to protect PII.
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.