Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON TABLE sales TO team;
The correct command to grant full privileges on the table sales to the new data engineering team is 'GRANT ALL PRIVILEGES ON TABLE sales TO team;'. This command grants all possible permissions (e.g., SELECT, INSERT, UPDATE, DELETE) on the specified table (sales) to the mentioned user or group (team). The other options either grant only specific permissions or reference incorrect objects and therefore do not provide the required full privileges.
Author: LeetQuiz Editorial Team
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;
No comments yet.