Explanation:
The correct command to grant full permissions on an object to a user or group is GRANT ALL PRIVILEGES ON TABLE employees TO hr_team. This command is translated into all the necessary privileges: SELECT, CREATE, MODIFY, USAGE, and READ_METADATA. For more details, refer to the Databricks documentation on object privileges.
Ultimate access to all questions.
No comments yet.
What command should a data engineer use to grant the HR team full permissions on the 'employees' table?
A
GRANT ALL PRIVILEGES ON TABLE hr_team TO employees
B
GRANT SELECT, MODIFY, CREATE, READ_METADATA ON TABLE employees TO hr_team
C
GRANT FULL PRIVILEGES ON TABLE hr_team TO employees
D
GRANT ALL PRIVILEGES ON TABLE employees TO hr_team
E
GRANT FULL PRIVILEGES ON TABLE employees TO hr_team