
Ultimate access to all questions.
In the context of an Extract, Load, and Transform (ELT) project, a newly formed data engineering team needs the necessary permissions to manage the table named sales. Full privileges grant the team the capability to perform any action required for the project's management. Which of the following commands should be executed to grant full permissions on the sales table to the new data engineering team?
A
GRANT ALL PRIVILEGES ON TABLE sales TO team;
B
GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
C
GRANT SELECT ON TABLE sales TO team;
D
GRANT USAGE ON TABLE sales TO team;
E
GRANT ALL PRIVILEGES ON TABLE team TO sales;