Databricks Certified Data Engineer Associate — Question 93

A data engineer needs to access the view created by the sales team, using a shared cluster. The data engineer has been provided usage permissions on the catalog and schema. In order to access the view created by sales team.

What are the minimum permissions the data engineer would require in addition?

Answer options

• A. Needs SELECT permission on the VIEW and the underlying TABLE.
• B. Needs SELECT permission only on the VIEW
• C. Needs ALL PRIVILEGES on the VIEW
• D. Needs ALL PRIVILEGES at the SCHEMA level

Correct answer: B

Explanation

The correct answer is B because the data engineer only needs SELECT permission on the VIEW to access it, given that they already have the necessary permissions on the catalog and schema. Options A, C, and D are incorrect as they require more permissions than what is necessary for accessing just the VIEW.