Home / Data Analyst practice test / Securing Data / Question

Databricks Data Analyst Associate · free practice question

A data governance administrator needs to delegate the ability to grant and revoke privileges on a Unity Catalog schema to a senior analyst. Which principals…

Exam-style question on Securing Data from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Securing Data

A data governance administrator needs to delegate the ability to grant and revoke privileges on a Unity Catalog schema to a senior analyst. Which principals are authorized to perform this action?

  1. AAny workspace user who has been granted the MODIFY privilege on the schema that contains the object
  2. BThe account admin who provisioned the metastore, as the single principal able to change its grants
  3. CWorkspace admins of the attached workspace, who control privilege assignments across the metastore
  4. DThe metastore admin, the owner of the object, or a user holding the MANAGE privilege on the object
  5. EAny user holding the USE CATALOG privilege on the parent catalog, whatever their role on the object
Answer & explanation

Correct answer: D

WHY D: In Unity Catalog, privileges on a securable object can be granted or revoked by the metastore admin, the owner of that object, a user with the MANAGE privilege on the object, or the owner of the catalog or schema that contains the object. This is documented in the Unity Catalog privilege model.

WHY NOT A: MODIFY is a write-access privilege on data content; it does not confer the ability to manage access control grants on an object.

WHY NOT B: Account admins have broad capabilities, but the authority to grant privileges is also held by object owners and MANAGE-privilege holders; it does not belong to the account admin who created the metastore alone.

WHY NOT C: Workspace admins have administrative rights within their workspace, but privilege management in Unity Catalog rests with the metastore admin, object owners and users holding MANAGE, not with workspace admins as such.

WHY NOT E: USE CATALOG lets a user navigate into a catalog and reach objects within it; it does not authorize changing access-control grants on objects inside that catalog.

Take the full Data Analyst practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Analyst Associate practice test. Take it and get a section-by-section score.

Start the free test →