Google Professional Data Engineer
Get started today
Ultimate access to all questions.
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?
Explanation:
The correct answer is C. Datastream is a fully managed, serverless service for real-time data replication, which allows you to stream data from various sources, including Cloud SQL, into BigQuery. By replicating the required tables from both Cloud SQL databases to BigQuery, you minimize the load on the Cloud SQL instances. The marketing team's queries will be executed against BigQuery, which is designed to handle high-frequency queries and large-scale data analytics. This approach ensures efficiency and performance, allowing queries to run over 100 times a day on typical days and up to 300 during sales events without overloading the Cloud SQL databases.