Google Cloud Professional Data Engineer PDE — Topic 1 Question 220

Question

You are migrating your on-premises data warehouse to BigQuery. One of the upstream data sources resides on a MySQL. database that runs in your on-premises data center with no public IP addresses. You want to ensure that the data ingestion into BigQuery is done securely and does not go through the public internet. What should you do?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use Datastream to replicate data from your on-premises MySQL database to BigQuery. Set up Cloud Interconnect between your on-premises data center and Google Cloud. Use Private connectivity as the connectivity method a... BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Cloud Interconnect provides a dedicated, private, high-bandwidth link between on premises and Google Cloud. A VPC provides a global, software-defined private network for your Google Cloud resources.

Google Cloud Professional Data Engineer PDE — Question 220