Google Cloud Professional Data Engineer PDE — Topic 1 Question 270

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Create a BigQuery scheduled query to run the SQL transformation with schedule options that repeats every two hours, and enable notification to Pub/Sub topic. Use Pub/Sub and Cloud Functions to send an email after thre... Cloud Functions runs event-driven code without managing servers and scales automatically. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Pub/Sub is a serverless, global messaging service that decouples services and ingests high-volume event streams.

Google Cloud Professional Data Engineer PDE — Question 270