Alerting DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   A data engineer wants to create a SQL alert that monitors a data quality metric. Which Databricks interface is used to create SQL alerts?

   • AThe Notebook editor in the Workspace
   • BThe SQL editor in the Databricks SQL workspace
   • CThe Cluster UI in the Compute area
   • DThe Jobs UI in the Lakeflow Jobs interface
   Reveal Solution Discussion Select an answer first
2. 2application · easy

   A SQL alert has been firing for a week due to a data quality issue that has now been resolved. The team wants to verify that the alert is no longer triggering and review past occurrences. What should they do?

   • ACheck the job run history for the job that runs the alert query.
   • BDelete the alert and recreate it to see if it triggers again.
   • CEdit the alert condition to a different value and check if it triggers.
   • DView the alert history in the SQL alert management page.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which of the following is a supported notification destination for a Databricks SQL alert?

   • AFax
   • BSMS text message
   • CPhone call
   • DEmail
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A data platform team manages hundreds of jobs and wants to standardize notification settings across all jobs. They plan to use the Jobs API to programmatically configure notifications. Which approach should they use?

   • AUse the Jobs API to update each job's settings with the desired notification configuration.
   • BManually configure notifications in the Lakeflow Jobs UI for each job.
   • CUse the SQL Alert API to create alerts for each job.
   • DCreate a single job notification that applies to all jobs.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A team has a SQL alert that monitors data quality. They want to notify different stakeholders based on the severity of the issue. For example, if the alert condition is 'count > 100', notify the data engineering team; if 'count > 1000', notify the data engineering team and the operations team. What should they do?

   • ACreate two SQL alerts with different conditions and notification destinations.
   • BUse a job notification to monitor the count and notify different teams based on the result.
   • CCreate one SQL alert with a condition of 'count > 1000' and add both teams as notification destinations.
   • DCreate one SQL alert with a condition of 'count > 100' and add both teams as notification destinations.
   Reveal Solution Discussion Select an answer first