Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.