Data Engineering Associate with Databricks Practice Exam

Which Table ACL role has the highest level of access to data management in Databricks?

1. Catalog owner

2. Database owner

3. Databricks admin

4. Table owner

The correct answer is: Databricks admin

The Databricks admin role has the highest level of access to data management within the Databricks environment. This role encompasses broad administrative capabilities, allowing the admin to manage not just access control lists (ACLs) for individual tables, but also broader governance over the entire workspace. A Databricks admin can grant or revoke permissions across various resources, configure workspace settings, manage clusters, and perform overall management tasks that impact multiple elements within the environment. This includes the ability to access and modify settings and data across all objects, such as tables, catalogs, and databases. In contrast, other roles like catalog owner, database owner, or table owner are more limited in scope. The catalog owner can manage a specific catalog and permissions within it, the database owner has control over a single database, and the table owner can manage access and permissions for a particular table. While these roles allow significant control within their defined scopes, they do not match the comprehensive authority of a Databricks admin. Therefore, the admin role stands out for its all-encompassing access and management capabilities.