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

Databricks Data Engineer Professional · free practice question

A data engineer cannot query `system.query`- and `system.billing`-related system tables from a notebook. They get a permissions error even though they can…

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 Easy

A data engineer cannot query system.query- and system.billing-related system tables from a notebook. They get a permissions error even though they can query normal Unity Catalog tables. What is the most likely missing requirement?

  1. AThey need to attach the notebook to an all-purpose cluster, as job clusters are blocked from system tables.
  2. BThey need Unity Catalog privileges on the system catalog and SELECT on the relevant system schemas.
  3. CThey need to enable Change Data Feed (CDF) on the system tables before those tables can be read.
  4. DThey need an external location and a storage credential for the storage behind the system tables.
Answer & explanation

Correct answer: B

WHY B: System tables live in the system catalog and are governed by Unity Catalog. A common cause of access errors is missing privileges such as USE CATALOG on system and SELECT on the specific schemas/tables, even when the user can query ordinary Unity Catalog tables.

WHY NOT A: System tables are not restricted to interactive all-purpose clusters as a rule; the cluster type is not what produces a permissions error. Missing privileges are the typical blocker.

WHY NOT C: Change Data Feed is a Delta table feature for your own data, not a prerequisite for reading system tables.

WHY NOT D: External locations and storage credentials govern access to object storage paths. They are not how access to the system catalog is granted.

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 →