Home / DE Professional practice test / Monitoring and Alerting / Question

Databricks Data Engineer Professional · free practice question

You are the owner of a Unity Catalog-enabled Lakeflow Spark Declarative Pipeline and want to query its event log directly in SQL without publishing the event…

Exam-style question on Monitoring and Alerting from the free DE Professional practice test, with the answer and a full explanation below.

Updated November 16, 2026

Monitoring and Alerting Medium

You are the owner of a Unity Catalog-enabled Lakeflow Spark Declarative Pipeline and want to query its event log directly in SQL without publishing the event log table name. Which query pattern is supported by default?

  1. ASELECT * FROM event_log(<pipelineId>)
  2. BSELECT * FROM system.event_log(<pipelineId>)
  3. CSELECT * FROM pipeline_event_log(<pipelineId>)
  4. DSELECT * FROM live.event_log(<pipelineId>)
Answer & explanation

Correct answer: A

WHY A: Databricks documents a function-style access pattern to query the hidden event log table as the pipeline owner: SELECT * FROM event_log(<pipelineId>). By default the underlying hidden table name is formatted like event_log_{pipeline_id}.

WHY NOT B: The event log is not queried via the system catalog in that way; it is associated with the pipeline's own event log table/function.

WHY NOT C: pipeline_event_log is not a documented function; the table-valued function is named event_log.

WHY NOT D: live was the legacy keyword for referencing datasets inside pipeline source code; it is not a schema that exposes an event log function, so this is not a documented query interface.

Take the full DE Professional practice test free →

Would you pass today?

This question is one of 60 in the free, timed Databricks Data Engineer Professional practice test. Take it and get a section-by-section score.

Start the free test →