Demonstrate Understanding of Unity Catalog Permission Inheritance Model. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   In Unity Catalog, which of the following correctly describes the order of the permission inheritance hierarchy?

   • ACatalog → Metastore → Schema → Table
   • BTable → Schema → Catalog → Metastore
   • CMetastore → Catalog → Schema → Table
   • DSchema → Catalog → Metastore → Table
   Reveal Solution Discussion Select an answer first
2. 12foundation · medium

   A data engineer grants the USAGE privilege on a catalog to a group. The catalog contains several schemas, each with multiple tables. Which statement accurately describes how the USAGE privilege applies to the child objects?

   • AThe group automatically receives USAGE on all schemas and tables in the catalog, because privileges granted on a catalog are inherited by all child objects.
   • BThe group receives USAGE only on the catalog object itself, and must be granted USAGE on each schema and table individually.
   • CThe group receives USAGE on the catalog and schemas, but only if the tables were created after the grant was made.
   • DThe group receives USAGE only on the schemas, not on the tables, because table privileges must always be granted separately.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A user `alice@example.com` creates a schema `finance.reporting` in the `finance` catalog. The `finance` catalog is owned by `bob@example.com`. Who owns the `finance.reporting` schema?

   • AThe workspace admin, because they manage all objects in the metastore.
   • BBoth `alice@example.com` and `bob@example.com` share ownership.
   • C`alice@example.com`, because the creator of an object becomes its owner.
   • D`bob@example.com`, because the schema inherits ownership from the catalog.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In Unity Catalog, what happens to the ownership of a table when the owner is removed from the metastore?

   • AThe ownership is transferred to the metastore admin
   • BThe ownership is automatically transferred to the schema owner
   • CThe table is automatically dropped
   • DThe table becomes ownerless and can only be managed by metastore admins
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   In Unity Catalog, what is the effect of a DENY rule on a child object when the user has a GRANT on the parent object?

   • AThe user can access the child object only if they are the owner
   • BThe GRANT overrides the DENY, so the user can access the child object
   • CThe user can access the child object only if they have another GRANT on the child
   • DThe DENY overrides the inherited GRANT, so the user cannot access the child object
   Reveal Solution Discussion Select an answer first