You need to continuously replicate 50 tables from an Oracle database running in a VM inside your VPC to BigQuery, minimizing infrastructure management. What is the best approach?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Datastream from Oracle to BigQuery with private connectivity to the same VPC and a BigQuery connection profile..
Why this is the answer
Datastream is a fully managed, serverless change data capture (CDC) service that directly supports replication from Oracle to BigQuery. Its private connectivity option ensures secure data transfer within your VPC, and a BigQuery connection profile simplifies setup. This approach minimizes infrastructure management because Datastream handles all underlying infrastructure. Deploying Apache Kafka or Pub/Sub with Debezium requires significant setup and ongoing management of Kafka clusters, Kafka Connect, or custom applications, increasing operational overhead. While technically feasible, these options don't minimize infrastructure management as effectively as Datastream. Using the Kafka Connect Google BigQuery Sink Connector still necessitates managing the Kafka environment.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed