Topic 1 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?
Develop a custom data replication service to send data into BigQuery.
Use Cloud SQL federated queries.
Use Database Migration Service to replicate tables into BigQuery.
Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
ユーザの投票
コメント(3)
D: Use Datastream to capture *** changes, and use Dataflow to write those changes to BigQuery. Dataflow is a fully managed streaming analytics service that minimizes latency, processing time, and cost through autoscaling and batch processing. Dataflow is a managed service for executing a wide variety of data processing patterns. The documentation on this site shows you how to deploy your batch and streaming data processing pipelines using Dataflow, including directions for using service features.
👍 3pk3492022/12/24D. Anytime you see words like “develop” or “manually” be suspicious given this is cloud and everything is supposed to be automated and point-and-click easy. Eliminate A. Federated queries are SQL queries initiated FROM BigQuery to Cloud Spanner or Cloud SQL databases. So B doesn’t make sense. The Database Migration Service does not support BigQuery as a destination database engine. Eliminate C. That leaves D. From Google’s documentation, “Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures.”
👍 3dynamic_dba2023/03/14- 正解だと思う選択肢: D
I'll go for D
👍 2chelbsik2022/12/25
シャッフルモード