Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
As part of an ELT (Extract, Load, Transform) project implementation, a new data engineering team has been brought on board. To enable this team to effectively manage and execute the project, they will need full access rights to the customers database. Which of the following SQL commands can be used to grant comprehensive permissions on the database to the new data engineering team?
Explanation:
The correct command to grant full permissions on the database to the new data engineering team is 'GRANT ALL PRIVILEGES ON DATABASE customers TO team;'. This command provides the team with all possible privileges on the specified database, allowing them to fully manage it. Options A, B, C, and D do not provide full privileges or have incorrect syntax.