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