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

Questions 6–10

1. 6application · medium

   A governance team grants `SELECT` on the `hr` catalog to the `hr_analysts` group. They then revoke `SELECT` on the `hr.sensitive` schema from the same group. What access does `hr_analysts` have to tables in `hr.sensitive`?

   • A`SELECT` on all tables in `hr.sensitive`, because the catalog-level grant overrides the schema-level revoke.
   • BNo access to tables in `hr.sensitive`, because the schema-level revoke overrides the catalog-level grant.
   • C`SELECT` on tables in `hr.sensitive` only if they are managed tables.
   • D`SELECT` on tables in `hr.sensitive` only if they were created before the revoke.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which of the following is a best practice for managing permission inheritance in Unity Catalog?

   • AGrant privileges at the catalog or schema level whenever possible
   • BUse DENY rules to restrict access instead of revoking privileges
   • CGrant all users the same privileges at the metastore level
   • DGrant privileges on individual tables to ensure fine-grained control
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A user is granted the USAGE privilege on a catalog. Which objects will the user automatically have USAGE on?

   • AAll schemas and tables within that catalog
   • BOnly the tables in the catalog, not schemas
   • COnly the schemas directly in the catalog, not tables
   • DNo other objects; USAGE must be granted separately on each schema and table
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the relationship between external locations and storage credentials in Unity Catalog?

   • AExternal locations are only for managed tables
   • BExternal locations use storage credentials to access cloud storage
   • CThey are independent and not related
   • DStorage credentials are created from external locations
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   How can an administrator prevent a user from inheriting a privilege on a specific table while still allowing inheritance on other tables in the same schema?

   • ADrop and recreate the table
   • BRevoke the privilege on the schema
   • CGrant the privilege to another user
   • DRevoke the privilege directly on that table
   Reveal Solution Discussion Select an answer first