Databricks Certified Data Engineer Associate — Question 19

A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

Answer options

• 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;

Correct answer: E

Explanation

The correct answer is E because it explicitly grants all permissions on the customers database to the team, allowing them to manage it fully. Options A, B, C, and D do not provide the necessary full privileges, with some only granting limited access or incorrectly targeting the wrong entities.