Answer-first summary for fast verification
Answer: All of the above capabilities are granted by the `MODIFY` privilege
The `MODIFY` privilege encompasses the ability to add, delete, and modify data within an object. This comprehensive access control is crucial for teams requiring full data manipulation capabilities. For further details, refer to the [Databricks documentation on object privileges](https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What capabilities does the MODIFY privilege grant when a data engineer executes the SQL query: GRANT MODIFY ON TABLE employees TO hr_team?
A
It enables the addition of data to the table
B
It allows the deletion of data from the table
C
It permits the modification of data within the table
D
All of the above capabilities are granted by the MODIFY privilege
E
None of these options accurately describe the MODIFY privilege's capabilities