DATABRICKS-DEP Question 44

Question

A new user who currently does not have access to the catalog or schema is requesting access to the customer table in sales schema, but the customer table contains sensitive information, so you have decided to create view on the table excluding columns that are sensitive and granted access to the view GRANT SELECT ON view_name to [email protected] but when the user tries to query the view, gets the error view does not exist. What is the issue preventing user to access the view and how to fix it?
A. User requires SELECT on the underlying table
B. User requires to be put in a special group that has access to PII data
C. User has to be the owner of the view
D. User requires USAGE privilege on Sales schema
E. User needs ADMIN privilege on the view

Accepted Answer

Marked answer: D. User requires USAGE privilege on Sales schema

DATABRICKS-DEP Question 44

Community Discussion

Preparing Practice Exam…

DATABRICKS-DEP Question 44

Community Discussion