Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A new data engineering team has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to manage the project. Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
Other Sources
Community
NN
A
GRANT USAGE ON DATABASE customers TO team;
B
GRANT ALL PRIVILEGES ON DATABASE customers TO team;
C
GRANT SELECT PRIVILEGES ON DATABASE customers TO team;
D
GRANT SELECT, CREATE, MODIFY ON DATABASE customers TO team;
E
GRANT ALL PRIVILEGES ON DATABASE customers TO DATABASE
Explanation:
In Databricks SQL, the GRANT ALL PRIVILEGES command provides the specified user or group with full access rights to the database, including the ability to read, write, modify, and manage objects within it. This is appropriate when a team needs complete control over a database for an ELT project. Other options like GRANT USAGE or GRANT SELECT only provide limited access, such as the ability to reference the database or read data, but not to modify or manage it.
Comments
Loading comments...