Google Cloud Professional Data Engineer PDE — Topic 1 Question 255

Question

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 to manage infrastructure. What should you do?

Accepted Answer

Correct answer: D. The correct answer is D. Option 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. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. A VPC provides a global, software-defined private network for your Google Cloud resources. Datastream provides serverless change-data-capture and replication into Google Cloud.

Google Cloud Professional Data Engineer PDE — Question 255