Databricks Certified Data Engineer Associate — Question 72

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 command 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 USAGE ON DATABASE customers TO team;

Correct answer: D

Explanation

The correct command is 'GRANT USAGE ON DATABASE customers TO team;' because it provides the team with access to the database, allowing them to see the tables. The other options either grant incorrect permissions or target the wrong objects, such as granting 'CREATE' or 'VIEW' which do not fit the requirement of accessing existing tables.