Explanation:
The MODIFY privilege comprehensively grants the ability to add, delete, and modify data in a table. This ensures that the grantee can perform all necessary data manipulation operations on the specified object. For more details, refer to the Databricks documentation on object privileges.
Ultimate access to all questions.
What capabilities does the MODIFY privilege grant when a data engineer executes the SQL query: GRANT MODIFY ON TABLE employees TO hr_team?
A
Enables the addition of data to the table
B
Allows the deletion of data from the table
C
Permits the modification of existing data within the table
D
Combines the abilities to add, delete, and modify data in the table
E
None of the options accurately describe the MODIFY privilege's capabilities
No comments yet.