You are designing a SQL-based data pipeline for gcp video

Full Certification Question

You are designing a SQL-based data pipeline for InsightNova Ltd . This pipeline runs an aggregate SQL transformation on a BigQuery table every two hours , and the resulting output is appended to an existing BigQuery table . You must ensure that the pipeline automatically retries on failure , and sends an email notification after three consecutive failures . What should you do?