GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #56
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #56: Real Exam Question with Answer & Explanation
The correct answer is D: Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.. See the full explanation below for the reasoning.
Designing and Implementing Data Replication and Integration Solutions
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?
Options
- ADevelop a custom data replication service to send data into BigQuery.
- BUse Cloud SQL federated queries.
- CUse Database Migration Service to replicate tables into BigQuery.
- DUse Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
Topics
#Data Replication#Change Data Capture#Cloud SQL#BigQuery
Community Discussion
No community discussion yet for this question.