Home / Data Engineer Associate / Objective 7.2

Domain 7: Governance and Security · 15% of the exam · Full exam outline

7.2 Configure access controls using the UI and SQL by applying GRANT, REVOKE, and DENY privileges to principals (users, groups, and service principals) at appropriate levels of the security hierarchy.

Practice questions

Question 1easy

In Unity Catalog, the group contractors holds a direct SELECT grant on the table hr.payroll.salaries. A security engineer must remove that group's access to the table. Which statement does this?

Included in Sample: sample every domain.See plans

Choose an answer to check it. Afterward, select any option to review its explanation.

DENY is a real SQL statement, but it applies only to the legacy hive_metastore catalog and is not supported by Unity Catalog. Denial in Unity Catalog uses ABAC DENY policies (Beta), not this command.

BROWSE adds metadata visibility; granting it does not replace or remove the existing SELECT grant.

Transferring ownership would give the group all capabilities on the table, the opposite of removing access.

Unity Catalog access exists only through grants, so removing the direct SELECT grant with REVOKE removes the group's access to the table.

Question 2easy

An analyst was granted SELECT on the table sales.emea.orders but gets a permission error when querying it. The analyst holds no other grants. What is missing?

Included in Master: master every domain.See plans