Databricks Certified Data Engineer - Associate

Explanation

The correct answer is E because:

1. GRANT ALL PRIVILEGES ON DATABASE customers TO team; - This is the correct syntax for granting all privileges on a database to a user or group in Databricks Unity Catalog.

2. Why other options are incorrect:

   • A: GRANT USAGE ON DATABASE customers TO team; - This only grants USAGE privilege, not full privileges.
   • B: GRANT ALL PRIVILEGES ON DATABASE team TO customers; - This reverses the database and recipient, granting privileges on database 'team' to 'customers'.
   • C: GRANT SELECT PRIVILEGES ON DATABASE customers TO teams; - This only grants SELECT privileges, not full privileges, and has a typo ('teams' instead of 'team').
   • D: GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team; - This lists specific privileges but is not the standard way to grant all privileges. The correct syntax uses ALL PRIVILEGES.

3. Key Points:

   • In Databricks Unity Catalog, ALL PRIVILEGES on a database includes: CREATE TABLE, CREATE VIEW, CREATE FUNCTION, CREATE MATERIALIZED VIEW, MODIFY, SELECT, READ VOLUME, WRITE VOLUME, and USAGE.
   • The syntax follows the pattern: GRANT ALL PRIVILEGES ON DATABASE <database_name> TO <principal>;
   • This command gives the team complete control over the database, allowing them to create, modify, and manage all objects within it.

This question tests knowledge of Databricks Unity Catalog privilege management for database-level permissions.