Monitoring and Alerting Questions
Practice questions for Monitoring and Alerting topic in Databricks Certified Data Engineer Professional. 20 questions covering this domain.
A data engineer wants to monitor the number of records dropped by a `@dp.expect_or_drop` expectation in a Lakeflow SDP pipeline over time. Where can t...
A data engineer streams incremental data from `system.billing.usage` into a Delta table for near-real-time cost monitoring. The streaming job intermit...
A FinOps team wants to build a dashboard showing daily Databricks compute spend broken down by workspace and SKU, covering all workspaces in the accou...
A data engineer wants to identify all SQL queries that ran on a specific SQL warehouse in the past 7 days and took longer than 5 minutes. Which system...
What is the minimum prerequisite for a Databricks workspace to access system tables?
A FinOps engineer wants to identify which Lakeflow Jobs in the account consumed the most DBUs in the past 7 days and join this with job run metadata t...
Which system table records a history of all changes made to a Unity Catalog object's permissions (grants and revocations) for audit purposes?
A data engineer is streaming from `system.billing.usage` into a Delta table for near-real-time cost monitoring. The stream fails with an error indicat...
A data engineer wants to build a dashboard showing the P95 query duration for all SQL warehouse queries over the past 30 days, grouped by warehouse. W...
A data engineering team wants to alert on-call engineers automatically when any Lakeflow Job in the production workspace fails. They want to avoid che...
Which system table tracks the start and end times of Lakeflow Job runs?
A workspace that is not enabled for Unity Catalog needs to query the `system` catalog. What is the documented blocker?
A streaming job reads from `system.billing.usage` with `Trigger.AvailableNow()`, but the run behaves like a one-shot batch and later fails when it fal...
A team streams `system.query.history` into a Delta table and wants the pipeline to keep working if Databricks adds new columns to the system table. Wh...
Which privileges must an admin grant so a user can query a system schema such as `system.billing`?
A FinOps team needs an account-wide view of DBU consumption by workspace and SKU. Which system table should they query?
A job streams from `system.billing.usage` with `Trigger.AvailableNow()` and then falls more than a week behind. Which explanation best matches Databri...
An admin wants an analyst to query `system.billing.usage`. Which privileges must be granted?
A streaming job reads incrementally from `system.billing.usage` and sometimes fails when Databricks expires old records. Which read option is recommen...
A platform team wants to query Databricks system tables from a workspace. What is the minimum workspace requirement?
Sign in to see all 20 questions
Create a free account to browse all questions — completely free during our launch phase.