Courseiva
← PDE
Full test
Ingesting and Processing the Data →hardMultiple ChoiceObjective-mapped

PDE Ingesting and Processing the Data Practice Question

A company needs to continuously synchronize customer data changes from an on-premises Oracle database to BigQuery for near-real-time analytics. The Oracle database has Change Data Capture (CDC) enabled. Which Google Cloud service should be used to stream these changes with minimal latency and schema evolution support?

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

✓

Use Datastream to stream CDC changes from Oracle to BigQuery

Datastream is designed to stream CDC from Oracle (and MySQL/PostgreSQL) directly to BigQuery or GCS, supporting schema evolution and low-latency replication.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Deploy a Dataflow pipeline with a JDBC source and Pub/Sub

    Why it's wrong here

    This approach can be built but requires custom development and lacks native CDC support.

  • ✗

    Use Cloud SQL with a read replica and enable binary logging

    Why it's wrong here

    This would capture changes to Cloud SQL, not on-prem Oracle.

  • ✗

    Use Transfer Appliance to copy Oracle data periodically

    Why it's wrong here

    Transfer Appliance is for offline bulk transfer, not continuous CDC.

  • ✓

    Use Datastream to stream CDC changes from Oracle to BigQuery

    Why this is correct

    Datastream directly supports Oracle CDC and streams to BigQuery with schema evolution.

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 →

How Courseiva writes practice questions · Editorial policy

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.