PDE Ingesting and Processing the Data Practice Question
A company wants to ingest data from an on-premises Oracle database into BigQuery in near real-time with minimal latency. The database has a high volume of inserts and updates. Which service 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
✓
Datastream
Datastream is designed for CDC from Oracle and other sources to BigQuery or GCS in near real-time.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Datastream
Why this is correct
Datastream streams change data from Oracle, MySQL, PostgreSQL to BigQuery or GCS in near real-time.
- ✗
BigQuery Data Transfer Service
Why it's wrong here
Used for scheduled batch imports from SaaS applications like Google Ads, not for real-time CDC.
- ✗
Pub/Sub
Why it's wrong here
Pub/Sub is a messaging service; it would require additional components to capture CDC from Oracle.
- ✗
Storage Transfer Service
Why it's wrong here
Used for bulk transfers of files from S3/Azure/internet to GCS, not for CDC from databases.
Go deeper
Related to this question
About these practice questions
One of 890 original PDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.