QuestionQ136
VerifiedDesigning data processing systemsYou have terabytes of customer behavioral data streaming daily from Google Analytics into BigQuery. Your customers’ information, including their preferences, is hosted in a Cloud SQL for MySQL database. Your CRM database runs on a Cloud SQL for PostgreSQL instance. The marketing team wants to use customer information from both databases and the customer behavioral data to create marketing campaigns for yearly active customers.
You need to ensure that the marketing team can run the campaigns more than 100 times per day on typical days and up to 300 times during sales. At the same time, you want to minimize the load on the Cloud SQL databases. What should you do?
Community Discussion