How to replicate Oracle data to BigQuery with minimal infrastructure?
Short answer
D Create a Datastream service from Oracle to BigQuery, use a private connectivity configuration to the same VPC network, and a connection profile to BigQuery.
Question
Key Takeaways
This question tests the ability to select a fully managed Change Data Capture (CDC) service over self-managed solutions like Apache Kafka, which require significant operational overhead.
To replicate Oracle database tables to BigQuery with minimal infrastructure, use Google Cloud Datastream. The community consensus confirms Datastream is the optimal fully managed solution for Change Data Capture (CDC) tasks.
Common mistake: Candidates often select Option A or C because they functionally replicate data, but they fail to meet the requirement of minimizing infrastructure management since they require deploying and maintaining Apache Kafka clusters.
Expert Analysis
Why the Answer Is Correct
Google Cloud Datastream is a fully managed, serverless Change Data Capture (CDC) and replication service. It allows users to stream data from sources like Oracle directly into BigQuery without provisioning or managing servers. By using a private connectivity configuration, it securely integrates with the existing VPC, fulfilling the requirement to minimize infrastructure management.
Why the Other Options Are Wrong
Options A and C involve deploying and maintaining Apache Kafka clusters, which introduces significant operational overhead and infrastructure management. Option B implies managing Debezium connectors and likely Kafka infrastructure to bridge the gap to Pub/Sub, failing the "minimize infrastructure" criteria. While these methods work technically, they are not the optimal choice for a serverless architecture.
Community Comment Notes
Community comments strongly support Option D, emphasizing that Datastream is specifically designed to be serverless and easy to use. Commenters highlight that the service directly addresses the prompt's requirement to minimize management by handling the CDC process natively.
Official Reference
- https://cloud.google.com/datastream/docs
- https://cloud.google.com/datastream/docs/private-connectivity
These links open the official vendor documentation in a new tab.
Exam Strategy
When questions ask to "minimize infrastructure management," immediately look for fully managed Google Cloud services like Datastream or Data Fusion before considering self-hosted solutions like Kafka. Avoid over-engineering the solution with complex open-source components if a managed service fits the use case.
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 3 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 3
-
raaad 👍 11 Answered D- Datastream is a serverless and easy-to-use change data capture (CDC) and replication service. - You would create a Datastream service that sources from your Oracle database and targets BigQuery, with private connectivity configuration to the same VPC. - This option is designed to minimize the need to manage infrastructure and is a fully managed service.
-
scaenruy 👍 2 Answered DD. Create a Datastream service from Oracle to BigQuery, use a private connectivity configuration to the same VPC network, and a connection profile to BigQuery.
-
JyoGCP 👍 2 Answered DD. Datastream
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.