Databricks Certified Data Engineer Associate — Question 16

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

Answer options

• A. GRANT VIEW ON CATALOG customers TO team;
• B. GRANT CREATE ON DATABASE customers TO team;
• C. GRANT USAGE ON CATALOG team TO customers;
• D. GRANT CREATE ON DATABASE team TO customers;
• E. GRANT USAGE ON DATABASE customers TO team;

Correct answer: E

Explanation

The correct command is E, as it grants the necessary USAGE permission on the customers database to the team, allowing them to access its tables. Options A and B do not provide the right permissions for viewing existing tables, while C and D target the wrong entities, either granting permissions to the wrong database or catalog.