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?
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.