Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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
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...