Explanation:
In Databricks Unity Catalog, there is no separate DELETE privilege. The ability to delete rows is granted through the MODIFY privilege, which includes INSERT, UPDATE, and DELETE operations.
Therefore, the correct command is:
GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com
This aligns with the official Databricks documentation and explains why option B is correct, while options using DELETE are not valid in Unity Catalog.
Reference: https://docs.databricks.com/aws/en/data-governance/unity-catalog/manage-privileges/privileges#modify
Ultimate access to all questions.
John Smith, a new member of the Marketing team, currently has read access to sales tables but lacks the permission to delete rows. Which command would grant him the necessary delete access?
A
GRANT USAGE ON TABLE table_name TO john.smith@marketing.com
B
GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com
C
GRANT DELETE ON TABLE table_name TO john.smith@marketing.com
D
GRANT MODIFY TO TABLE table_name ON john.smith@marketing.com
E
GRANT DELETE TO TABLE table_name ON john.smith@marketing.com
