Databricks Certified Data Engineer Professional — Question 218

A data engineering team is configuring access controls in Databricks Unity Catalog. They grant the SELECT privilege on the sales catalog to the analyst_group, expecting that members of this group will automatically have SELECT access to all current and future schemas, tables, and views within the sales catalog.

What describes the privilege inheritance behavior in Unity Catalog?

Answer options

• A. Privileges in Unity Catalog do not cascade; SELECT most be explicitly granted on each schema and table, even if granted at the catalog level.
• B. Granting SELECT on a catalog automatically applies SELECT to all current and future schemas, tables, and views within that catalog.
• C. Granting SELECT at the catalog level applies to existing schemas and tables but not to those created in the future.
• D. Privileges granted at the schema level override any catalog-level privileges and prevent access unless explicitly revoked.

Correct answer: B

Explanation

The correct answer is B because granting the SELECT privilege at the catalog level automatically extends this access to all current and future objects within the catalog. Option A is incorrect as it states that privileges do not cascade, which is false in this context. Option C misinterprets the inheritance, and option D incorrectly suggests that schema-level privileges take precedence over catalog-level ones when they do not in this scenario.