Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON DATABASE customers TO team;
The correct command to grant full permissions on the database to the new data engineering team is 'GRANT ALL PRIVILEGES ON DATABASE customers TO team;'. This command provides the team with all possible privileges on the specified database, allowing them to fully manage it. Options A, B, C, and D do not provide full privileges or have incorrect syntax.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As part of an ELT (Extract, Load, Transform) project implementation, a new data engineering team has been brought on board. To enable this team to effectively manage and execute the project, they will need full access rights to the customers database. Which of the following SQL commands can be used to grant comprehensive permissions on the database to the new data engineering team?
A
GRANT USAGE ON DATABASE customers TO team;
B
GRANT ALL PRIVILEGES ON DATABASE team TO customers;
C
GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
D
GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
E
GRANT ALL PRIVILEGES ON DATABASE customers TO team;
No comments yet.