Databricks Certified Data Engineer Associate — Question 132

A data engineer is configuring Unity Catalog in Databricks and needs to assign a role to a user who should have the ability to grant and revoke privileges on various data objects within a specific schema, but should not have read/write access over the schema or its objects.

Which role should the data engineer assign to this user?

Answer options

• A. Table Owner
• B. Catalog Owner
• C. Schema Owner
• D. USE catalog/schema privilege on the schema

Correct answer: C

Explanation

The correct answer is C because the Schema Owner role allows the user to manage privileges on the schema's objects without giving them direct access to the data itself. The other options either grant broader access or do not provide the needed ability to manage privileges.