
Ultimate access to all questions.
In the context of an ELT (Extract, Load, Transform) project, a new data engineering team has been assembled. As part of their responsibilities, they require comprehensive control over a specific table named 'sales'. This control is necessary for them to effectively manage and perform operations related to the project. Which SQL command can be used to grant the new data engineering team full permissions on the 'sales' table?
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 ALL PRIVILEGES ON TABLE team TO sales;