Google Professional Data Engineer
Comments
Loading comments...
Ultimate access to all questions.
You receive terabytes of customer behavioral data daily, streaming from Google Analytics into BigQuery. Additionally, customer information, such as their preferences, is stored in a Cloud SQL for MySQL database, while your CRM database is housed in a Cloud SQL for PostgreSQL instance. The marketing team aims to leverage this comprehensive customer data from both databases and the behavioral data to craft marketing campaigns targeting yearly active customers. The requirement is to enable the marketing team to execute these campaigns over 100 times daily on regular days and up to 300 times during sales periods. Meanwhile, it’s crucial to minimize the load on the Cloud SQL databases. What should you do?
A
Create BigQuery connections to both Cloud SQL databases. Use BigQuery federated queries on the two databases and the Google Analytics data on BigQuery to run these queries.
B
Create a job on Apache Spark with Dataproc Serverless to query both Cloud SQL databases and the Google Analytics data on BigQuery for these queries.
C
Create streams in Datastream to replicate the required tables from both Cloud SQL databases to BigQuery for these queries.
D
Create a Dataproc cluster with Trino to establish connections to both Cloud SQL databases and BigQuery, to execute the queries.