PDE Ingesting and Processing the Data Practice Question
A company uses Cloud Datastream to replicate data from a MySQL database to BigQuery in near real-time. Which TWO BigQuery features are automatically used by Datastream for optimal performance and consistency? (Choose TWO.)
⚠ Common exam trap
Google often tests the misconception that Datastream requires an intermediate Dataflow pipeline or legacy streaming inserts, when in fact it natively leverages the Storage Write API and materialized views for optimal performance and consistency.
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
✓
BigQuery Storage Write API
Datastream uses the BigQuery Storage Write API (option D) to stream change data capture (CDC) events into BigQuery with exactly-once semantics and high throughput. It also automatically creates a materialized view (option E) that merges the change stream into the final table, ensuring consistent, near real-time replication without manual merge logic.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
BigQuery Data Transfer Service
Why it's wrong here
Datastream is a separate service, not part of BigQuery Data Transfer Service.
- ✗
BigQuery legacy streaming inserts
Why it's wrong here
Datastream uses the Storage Write API, not legacy streaming inserts.
- ✗
A Dataflow pipeline to transform the data
Why it's wrong here
Datastream is a managed service and does not require Dataflow.
- ✓
BigQuery Storage Write API
Why this is correct
Datastream uses the Storage Write API for streaming replication.
- ✓
A materialized view that merges the change stream into the final table
Why this is correct
Datastream creates a materialized view to apply CDC changes to the target table.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PDE question from scratch — 890 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.