Google Cloud Professional Cloud Database Engineer — Question 84

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?

Answer options

• A. Develop a custom data replication service to send data into BigQuery.
• B. Use Cloud SQL federated queries.
• C. Use Database Migration Service to replicate tables into BigQuery.
• D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

Correct answer: D

Explanation

Option D is correct because Datastream efficiently captures changes in real-time, and Dataflow is designed to process and move data seamlessly into BigQuery. Option A is incorrect as developing a custom solution goes against the requirement for using Google-managed services. Option B does not facilitate real-time replication as required, and Option C is intended for migration rather than ongoing replication.