You have an Oracle database deployed in a VM as part of a Virtual Private Cloud (VPC) network. You want to replicate and continuously synchronize 50 tables to BigQuery. You want to minimize the need…

Question

Options

• ADeploy Apache Kafka in the same VPC network, use Kafka Connect Oracle Change Data Capture (CDC), and Dataflow to stream the Kafka topic to BigQuery.
• BCreate a Pub/Sub subscription to write to BigQuery directly. Deploy the Debezium Oracle connector to capture changes in the Oracle database, and sink to the
• CDeploy Apache Kafka in the same VPC network, use Kafka Connect Oracle change data capture (CDC), and the Kafka Connect Google BigQuery Sink
• DCreate a Datastream service from Oracle to BigQuery, use a private connectivity configuration to the same VPC network, and a connection profile to BigQuery.

• A
  16% (6)
• B
  8% (3)
• C
  5% (2)
• D
  71% (27)

Explanation

Datastream is Google Cloud's fully managed, serverless CDC (Change Data Capture) service built precisely for this scenario - replicating Oracle tables to BigQuery continuously with no infrastructure to provision or maintain, and its private connectivity configuration handles VPC network access seamlessly.

Why the distractors fail: Options A and C both require self-managing an Apache Kafka cluster inside the VPC, which directly contradicts the "minimize infrastructure management" requirement - you'd be responsible for Kafka brokers, scaling, and uptime. Option B introduces Debezium, a self-hosted connector framework that also requires you to deploy and manage compute, making it similarly infrastructure-heavy; additionally, Pub/Sub-to-BigQuery subscriptions add unnecessary complexity compared to Datastream's native BigQuery destination.

Memory tip: On GCP exam questions, whenever you see Oracle/MySQL/PostgreSQL → BigQuery continuous sync + minimize management, the answer is almost always Datastream - it's Google's purpose-built, fully managed CDC pipeline. If you see Kafka or Debezium in the choices, they signal self-managed infrastructure and are typically wrong when the question asks for low operational overhead.

No community discussion yet for this question.