Ultimate access to all questions.
What command should a data engineer use to grant the HR team full permissions on the 'employees' table?
Explanation:
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.