Free Google Professional Cloud Database Engineer Actual Exam Questions - Question 10 Discussion
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?
D, because custom services (A) add complexity and federated queries (B) aren’t real-time.
C/D? Database Migration Service (C) is usually for one-time migrations, not continuous replication. Datastream with Dataflow (D) fits near-real-time needs better and is fully managed, so D still seems more solid here.
Option D stands out since it’s designed for change data capture with minimal lag, and it’s fully managed. B and C don’t really fit because federated queries won’t give near-real-time replication, and Database Migration Service is more for one-time or bulk migrations, not continuous sync. A is out since they want Google-managed, and building a custom service would be more complex and less reliable. Even if binary logging needs to be enabled, that’s a typical prerequisite for CDC tools like Datastream, so D still makes the most sense here.
It’s D since Datastream handles CDC well and is Google-managed, unlike A or C.
It’s D because Datastream is designed for change data capture and works well with Dataflow to stream changes into BigQuery. But the question doesn’t say if the Cloud SQL instance is already set up with binary logging enabled, which is required for Datastream. Does anyone know if that’s a given here or should we include enabling that as a step?