
Ultimate access to all questions.
Consider a scenario where you need to control access to a table containing customer data in a Databricks environment. The table includes customer names, email addresses, and purchase history. Describe how you would use dynamic views to ensure that customer service representatives can only see customer names and email addresses, while hiding the purchase history.
A
Create separate tables for customer service and other departments.
B
Use dynamic views to selectively expose columns based on user roles.
C
Disable access to the purchase history for customer service representatives.
D
Manually filter data for each customer service representative.