You are integrating your legacy on-premises MySQL database into a new Google Cloud data warehouse. The database contains historical customer loyalty data which needs to be extracted daily and loaded into BigQuery. You want a managed integration solution that is secure and supports incremental loads. What should you do?

You need to create a SQL pipeline. The pipeline runs an aggregate SQL transformation on a BigQuery table every two hours and appends the result to another existing BigQuery table. You need to configure the pipeline to retry if errors occur. You want the pipeline to send an email notification after three consecutive failures. What should you do?

You are creating a model to predict housing prices. Due to budget constraints, you must run it on a single resource-constrained virtual machine. Which learning algorithm should you use?

Which methods can be used to reduce the number of rows processed by BigQuery?

Your United States-based company has created an application for assessing and responding to user actions. The primary table's data volume grows by 250,000 records per second. Many third parties use your application's APIs to build the functionality into their own frontend applications.
Your application's APIs should comply with the following requirements:
- Single global endpoint
- ANSI SQL support
- Consistent access to the most up-to-date data
What should you do?