Home / Data Analyst practice test / Securing Data / Question

Databricks Data Analyst Associate · free practice question

A metastore admin grants the SELECT privilege on a catalog to a group of data analysts. According to Unity Catalog's inheritance model, which objects does this…

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

Updated November 10, 2026

Securing Data

A metastore admin grants the SELECT privilege on a catalog to a group of data analysts. According to Unity Catalog's inheritance model, which objects does this privilege automatically apply to?

  1. AThe catalog object itself; each child schema then needs its own GRANT SELECT statement before users can query its tables
  2. BThe catalog and its parent metastore, as privilege inheritance flows both down to child objects and up to the metastore
  3. CThe schemas and tables that existed when the GRANT ran, but not schemas or tables created after the statement executed
  4. DThe current and future schemas in that catalog, together with the tables and views those schemas contain or later gain
  5. EThe managed tables in the catalog; external tables need separate GRANT statements on each underlying external location
Answer & explanation

Correct answer: D

WHY D: Unity Catalog's privilege inheritance flows strictly downward. A GRANT on a catalog applies to all current and future schemas in the catalog, and transitively to the objects (tables, views, volumes, functions) within those schemas. This removes the need to re-grant when new schemas or tables are added.

WHY NOT A: A GRANT on a catalog does cascade to its child schemas and tables through inheritance, so re-granting on each child schema is not required.

WHY NOT B: Inheritance in Unity Catalog is unidirectional, downward only. A catalog-level GRANT does not propagate upward to the metastore, nor do metastore-level grants inherit downward to catalogs.

WHY NOT C: The inheritance model covers both current and future child objects. Schemas and tables created after the original GRANT inherit the privilege, unlike the Hive metastore model.

WHY NOT E: Privilege inheritance applies equally to managed and external tables. External tables registered in the catalog receive the same inherited privileges as managed tables and do not need separate GRANTs.

Take the full Data Analyst practice test free →

Would you pass today?

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

Start the free test →