Answer-first summary for fast verification
Answer: Use dynamic views to selectively expose columns based on user roles.
Dynamic views can be used to selectively expose columns based on user roles, ensuring that sales representatives only see the necessary data. This approach maintains data access while protecting sensitive information.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Consider a scenario where you need to control access to a table containing product data in a Databricks environment. The table includes product names, descriptions, and pricing details. Describe how you would use dynamic views to ensure that sales representatives can only see product names and descriptions, while hiding the pricing details.
A
Create separate tables for sales and other departments.
B
Use dynamic views to selectively expose columns based on user roles.
C
Disable access to the pricing details for sales representatives.
D
Manually filter data for each sales representative.