Databricks Certified Data Engineer Professional — Question 216

When a new Databricks project starts, the central IP team provisions the required infrastructure using Terraform and a Service Principal. This includes creating a Databricks workspace, a Unity Catalog linked to an External Location, and a Databricks group containing all project team members. Project teams must store all assets – e.g., tables and volumes, as Managed assets in Unity Catalog. This model hides infrastructure complexity while giving teams autonomy within their catalog. They can create and manage schemas, tables, volumes, and related objects but cannot rename, delete, or change catalog permissions, those remain under IT’s control.

Which rights should the project group be granted to enable this model?

Answer options

• A. The group needs to have USE CATALOG and USE SCHEMA on the catalog.
• B. The group needs to have ALL PRIVILEGES and the MANAGE on the catalog.
• C. The group needs to have ALL PRIVILEGES on the catalog.
• D. The group should be made OWNER of the catalog.

Correct answer: C

Explanation

The correct answer is C, as granting ALL PRIVILEGES on the catalog allows the project group to create and manage schemas, tables, volumes, and related objects without giving them the ability to rename or delete the catalog or change permissions. Options A and B do not provide the necessary level of access for full management of the assets, while option D would give ownership, which contradicts the model's intent to keep control with IT.