Answer-first summary for fast verification
Answer: Use dynamic view functions
The correct answer is to use dynamic view functions. This method allows for the filtering of rows and the redaction of column data based on the user's group membership. For example, a view can be created to limit access to rows where the total amount is ≤ 1,000,000 for users not in the 'managers' group. Similarly, email information can be redacted for users not in the 'auditors' group. This approach provides a flexible and secure way to manage access control dynamically. For more details, refer to [Microsoft's documentation on dynamic view functions](https://docs.microsoft.com/en-us/azure/databricks/security/access-control/table-acls/object-privileges#dynamic-view-functions).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which technique enables the implementation of fine-grained access control to rows and columns in a Delta table, tailored to the user's access rights?
A
Row and column access control lists
B
Use dynamic view functions
C
Data access control lists
D
Dynamic Access control lists with Unity Catalog
E
Use Unity catalog to grant access to rows and columns