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…

The correct answer is E. GRANT ALL PRIVILEGES ON DATABASE customers TO team. The correct SQL syntax to grant all permissions on a database in Databricks is: GRANT ALL PRIVILEGES ON DATABASE <database_name> TO <principal>. Option E correctly names the database (customers) and the grantee (team). Option A only grants USAGE, which is insufficient for full…

Submitted by krish.m· Apr 18, 2026Data Management

Question

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?

Options

AGRANT USAGE ON DATABASE customers TO team;
BGRANT ALL PRIVILEGES ON DATABASE team TO customers;
CGRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
DGRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
EGRANT ALL PRIVILEGES ON DATABASE customers TO team;

How the community answered

(56 responses)

A
4% (2)
B
2% (1)
C
2% (1)
D
7% (4)
E
86% (48)

Explanation

The correct SQL syntax to grant all permissions on a database in Databricks is: GRANT ALL PRIVILEGES ON DATABASE <database_name> TO <principal>. Option E correctly names the database (customers) and the grantee (team). Option A only grants USAGE, which is insufficient for full management. Option B reverses the database and team names. Option C only grants SELECT. Option D uses an invalid syntax listing individual privileges without correct SQL structure.

Topics

#Access Control#SQL GRANT#Permissions#Data Security

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice