Answer-first summary for fast verification
Answer: GRANT MODIFY ON TABLE table_name TO john.smith@marketing.com
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
Author: LeetQuiz Editorial Team
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
