You must replicate changes from an operational database into BigQuery continuously. What fits?
Why B is the answer
Datastream
Datastream provides change data capture.
In detail
- Datastream replicates database changes continuously.
- This avoids repeated full extracts.
Use case
An illustrative scenario, not a real incident.
Orders change in an operational database, and Datastream sends each change on to BigQuery.
See it in different ways
flowchart TD
A{"What are you moving?"} -->|"Huge offline data"| B["Transfer Appliance"]
A -->|"SaaS or warehouse data into BigQuery"| C["BigQuery Data Transfer Service"]
A -->|"A relational database"| D["Database Migration Service"]
A -->|"Ongoing change data capture"| E["Datastream"]stateDiagram-v2 [*] --> Source Source --> TransferAppliance: petabytes, slow network Source --> Datastream: database changes, continuous Source --> DataTransferService: SaaS on a schedule TransferAppliance --> Validate Datastream --> Validate DataTransferService --> Validate Validate --> [*]
flowchart LR S0["Database change"] --> S1["Datastream"] --> S2["BigQuery"]
Key point: Datastream provides change data capture.
Why the other options are wrong
- A. BI Engine
- BI Engine speeds up queries.
- C. Transfer Appliance
- An appliance is a one-time move.
- D. A weekly CSV export
- A weekly export is not continuous.