Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON TABLE employees TO hr_team
The correct command is `GRANT ALL PRIVILEGES ON TABLE employees TO hr_team`. This command grants the HR team full permissions on the 'employees' table, including SELECT, CREATE, MODIFY, USAGE, and READ_METADATA privileges. For more details, refer to the [Databricks documentation on table ACLs](https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What command should a data engineer use to grant the HR team full permissions on the 'employees' table?
A
GRANT FULL PRIVILEGES ON TABLE hr_team TO employees
B
GRANT ALL PRIVILEGES ON TABLE employees TO hr_team
C
GRANT SELECT, MODIFY, CREATE, READ_METADATA ON TABLE employees TO hr_team
D
GRANT FULL PRIVILEGES ON TABLE employees TO hr_team
E
GRANT ALL PRIVILEGES ON TABLE hr_team TO employees
No comments yet.