Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 84

Question

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Dataflow runs serverless Apache Beam pipelines for stream and batch data processing with autoscaling. Datastream provides serverless change-data-capture and replication into Google Cloud. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 84