Home / DE Professional practice test / Data Governance / Question

Databricks Data Engineer Professional · free practice question

A data engineer runs the following command: ```sql GRANT SELECT ON CATALOG main TO `analyst_team`; ``` A new table called `main.reporting.revenue` is created…

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

Updated November 16, 2026

Data Governance Hard

A data engineer runs the following command:

GRANT SELECT ON CATALOG main TO `analyst_team`;


A new table called main.reporting.revenue is created one week later. Which of the following statements CORRECTLY describes analyst_team's access to this new table?

  1. Aanalyst_team has no access to main.reporting.revenue because privileges must be re-granted after new objects are created.
  2. Banalyst_team has SELECT on main.reporting.revenue but still needs USE SCHEMA on main.reporting and USE CATALOG on main granted separately, since catalog-level grants do not cover navigation privileges.
  3. Canalyst_team can SELECT from main.reporting.revenue only after the table owner explicitly grants SELECT on that specific table.
  4. Danalyst_team can SELECT from main.reporting.revenue because privilege inheritance causes the catalog-level SELECT grant to automatically apply to all current and future tables in the catalog.
Answer & explanation

Correct answer: D

WHY D is correct: Unity Catalog uses a privilege inheritance model where privileges granted at a higher level in the object hierarchy automatically apply to all current AND future objects beneath it. The documentation explicitly states: 'Since privileges are inherited, you can grant a user the SELECT privilege on a catalog or schema, which automatically grants the user SELECT privilege on all current and future tables, and views in the catalog or schema.' Furthermore, granting SELECT at the catalog level implicitly covers the necessity to traverse the hierarchy — the GRANT at the catalog level encompasses the USE CATALOG privilege on that same catalog. Similarly, USE SCHEMA is also covered by the catalog-level grant because all descendant privileges inherit downward. The analyst team can therefore immediately query main.reporting.revenue without any further explicit grants.

WHY NOT A: This is incorrect. Privilege inheritance means existing catalog-level grants propagate to future objects automatically. There is no requirement to re-grant privileges each time a new object is created when the grant was made at the catalog level.

WHY NOT C: With a catalog-level SELECT grant in place, there is no need for the table owner to grant SELECT on individual tables. Inheritance eliminates the need for object-by-object grants for users who already have the privilege at a higher level.

WHY NOT B: When SELECT is granted at the catalog level, USE CATALOG and USE SCHEMA are implicitly satisfied as part of the catalog-level inheritance. They do not need to be granted separately; the catalog-level grant covers the full navigation chain needed to access objects within that catalog.

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 →