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

Questions 16–18

1. 16foundation · easy

   A user has EXECUTE privilege on a schema. What does this allow the user to do with functions in that schema?

   • AExecute only functions created after the grant
   • BExecute all functions in the schema
   • CExecute only functions they own
   • DCannot execute any functions without a separate grant
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is the difference in permission inheritance between managed and external tables in Unity Catalog?

   • ABoth managed and external tables inherit permissions from their schema in the same way
   • BExternal tables inherit permissions from the external location, not the schema
   • CExternal tables do not inherit permissions from any parent object
   • DManaged tables inherit permissions from the metastore, external tables from the catalog
   Reveal Solution Discussion Select an answer first
3. 18application · medium

   A company wants to minimize administrative overhead for granting access to new tables while ensuring least privilege. They have three teams: `analysts`, `data_engineers`, and `ml_engineers`. What is the best practice for designing the permission hierarchy?

   • AGrant privileges at the table level for every table to ensure precise control.
   • BCreate separate catalogs for each team and grant privileges at the catalog level.
   • CGrant privileges at the metastore level to all teams, then revoke on specific catalogs as needed.
   • DGrant privileges at the schema level and avoid catalog-level grants.
   Reveal Solution Discussion Select an answer first