Explanation:
Because the data is frequently changing, you can query the data in-place by using federated queries from BigQuery.
Ultimate access to all questions.
No comments yet.
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.