Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are processing large amounts of input data in BigQuery. You need to combine this data with a small amount of frequently changing data that is available in Cloud SQL. What should you do?
A
Create a Dataflow pipeline to combine the BigQuery and Cloud SQL data when the Cloud SQL data changes.
B
Use a federated query to get data from Cloud SQL.
C
Copy the data from Cloud SQL to a new BigQuery table hourly.
D
Copy the data from Cloud SQL and create a combined, normalized table hourly.
