Data Engineering Associate with Databricks Practice Exam

How do you grant usage permissions to a user for a database in Databricks SQL?

1. GRANT ALL DATABASE name USER name

2. GRANT USAGE DATABASE name USER name

3. ALLOW USAGE DATABASE name FOR USER name

4. ASSIGN DATABASE name TO USER name

The correct answer is: GRANT USAGE DATABASE name USER name

Granting usage permissions to a user for a database in Databricks SQL is performed using the GRANT statement, specifically designed to manage user permissions. The correct syntax to allow a user to access and use a database is through the command which includes the USAGE keyword. The statement establishes that the user can utilize the database without offering broader privileges that may accompany other commands. This makes it a focused and appropriate way to manage access permissions, ensuring that the necessary level of access is given without over-privileging the user. Using the USAGE keyword specifically conveys the intent to allow the user to access the database, including the ability to see the database schema and other non-modifying interactions that do not alter data or structure. This is crucial for maintaining security and control within the database environment while still enabling users to perform necessary tasks. The other listed options, while they may seem similar, do not utilize the correct syntax for granting usage permissions within Databricks SQL and would result in errors or unintended consequences if executed. Thus, the choice encapsulates the standard approach recognized and implemented within Databricks for managing database permissions effectively.