Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON DATABASE customers TO team;
The command `GRANT ALL PRIVILEGES ON DATABASE customers TO team;` is correct because it provides the data engineering team with every possible permission on the 'customers' database. This includes the ability to read and write data, modify the database structure, and manage access for other users. Such comprehensive access is essential for a team responsible for the full management of an ELT project, ensuring they can perform all necessary tasks without any restrictions.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A newly formed data engineering team, 'team', is assigned an ELT project and needs full access to the 'customers' database to manage the project efficiently. Which command should be used to grant the team complete permissions on the 'customers' database?
A
GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
B
GRANT USAGE ON DATABASE customers TO team;
C
GRANT ALL PRIVILEGES ON DATABASE customers TO team;
D
GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
E
GRANT ALL PRIVILEGES ON DATABASE team TO customers;
No comments yet.