Databricks Certified Data Engineer Professional · Free Practice Question Medium
Question 11
A data engineer uses the following SQL query:
GRANT USAGE ON DATABASE sales_db TO finance_team
Which of the following is the benefit of the USAGE privilege ?
-
A
Gives read access on the database
-
B
Gives full permissions on the entire database
-
C
Gives the ability to view database objects and their metadata
-
D
No effect! but it's required to perform any action on the database
-
E
USAGE privilege is not part of the Databricks governance model
Reveal correct answer
Correct answer: D
Explanation
The USAGE does not give any abilities, but it's an additional requirement to perform any action on a schema (database) object.
Reference: https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges
Study materials from our exam preparation course on Udemy:
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
