Google Cloud Professional Cloud Architect · Free practice question 11 of 12
Datastream change data capture into BigQuery
Fothergill Foods wants near-real-time analytics in BigQuery on orders stored in a Cloud SQL for MySQL database. The deciding constraints are minimal load on the source database and no custom replication code. What should the architect recommend?
- A.A nightly mysqldump loaded into BigQuery with bq load
- B.Hourly scheduled queries that read the whole orders table through a federated connection to Cloud SQL
- C.Application code that writes every order to both MySQL and BigQuery
- D.A Datastream stream that reads the MySQL binary log and writes changes to BigQuery
Show answer and explanation
Correct answer: D. A Datastream stream that reads the MySQL binary log and writes changes to BigQuery
Why: Datastream is a serverless change data capture service that reads the MySQL binary log, which places little load on the source, and replicates changes into BigQuery continuously. Full-table federated reads every hour load the source and are not near real time. Nightly dumps are stale, and dual writes are custom code that can drift out of sync.
More free Google Cloud Professional Cloud Architect questions
- Config Sync GitOps across a cluster fleet
- Chirp speech model for call transcription
- AlloyDB read pools for read scaling
- VM Manager OS patch management
- BigQuery long-term storage pricing
- Feature Store against training-serving skew
- Autoclass for unpredictable object access
- Workflows orchestrating serverless steps
- Managed Service for Apache Airflow for complex DAGs
- Cloud DNS failover routing policy
- Cloud Asset Inventory IAM policy analysis