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