Answer-first summary for fast verification
Answer: Has no effect but is required to perform any action on the database
The USAGE privilege does not grant any specific abilities by itself. However, it is a necessary requirement to perform any action on a schema (database) object. For more details, refer to the [Databricks documentation on object privileges](https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the primary benefit of the USAGE privilege in Databricks when a data engineer executes the SQL query: GRANT USAGE ON DATABASE sales_db TO finance_team?
A
Enables full permissions on the entire database
B
Allows viewing of database objects and their metadata
C
Grants read access on the database
D
Has no effect but is required to perform any action on the database
E
Is not part of the Databricks governance model
No comments yet.