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

Questions 1–5

1. 1foundation · easy

   In Unity Catalog, how do permissions on a view relate to the underlying tables?

   • ASELECT on the underlying tables is sufficient; no permission on the view is needed
   • BPermissions on views are not inherited from schemas
   • CThe user needs SELECT on the view and on the underlying tables
   • DSELECT on the view is sufficient; no permission on underlying tables is needed
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A company has a metastore with multiple catalogs. The `finance` catalog has `USAGE` granted to the `finance_team` group. The `finance_team` group also has `SELECT` on the `finance.raw` schema. A new schema `finance.analytics` is created. What access does `finance_team` have to `finance.analytics`?

   • A`USAGE` and `SELECT` on the schema, because both are inherited from the catalog and schema grants.
   • B`SELECT` on the schema, because it is inherited from the `finance.raw` schema.
   • CNo access, because privileges must be explicitly granted on each new schema.
   • D`USAGE` on the schema, because it is inherited from the catalog.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A team creates a function `analytics.ml.predict_churn` in the `analytics` catalog. The `ml_team` group has `USAGE` on the `analytics` catalog and `EXECUTE` on the `analytics.ml` schema. What privileges does `ml_team` have on the function?

   • AOnly `USAGE` on the function, because `EXECUTE` must be granted directly on the function.
   • BNo access, because functions require explicit grants separate from catalog and schema privileges.
   • C`USAGE` and `EXECUTE` on the function, because both are inherited from the catalog and schema.
   • DOnly `EXECUTE` on the function, because `USAGE` is not inherited by functions.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What privileges does the owner of a schema have by default?

   • AAll privileges on the schema and all child objects
   • BNo privileges until they are granted
   • COnly USAGE and CREATE on the schema
   • DOnly the privileges explicitly granted to them
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the principle of least privilege in the context of Unity Catalog permission inheritance?

   • AGrant users only the privileges they need to perform their job
   • BGrant privileges at the metastore level to all users
   • CGrant all users the same privileges to simplify management
   • DUse DENY rules to block all access by default
   Reveal Solution Discussion Select an answer first