DP-700 · Question #63
You're working with a Microsoft Fabric dataset containing sensitive customer information. You need to ensure that different users can only see their data. Which of the following methods can be used…
The correct answer is D. Configure RLS rules based on user attributes. To implement row-level security (RLS) in a Microsoft Fabric dataset, you configure RLS rules that filter data based on the current user's attributes, ensuring users only see their authorized data.
Question
Options
- ACreate custom workspace roles with row-level permissions.
- BApply data sensitivity labels to individual rows.
- CUse Azure Active Directory (Azure AD) dynamic groups to control access.
- DConfigure RLS rules based on user attributes.
How the community answered
(34 responses)- B3% (1)
- C6% (2)
- D91% (31)
Why each option
To implement row-level security (RLS) in a Microsoft Fabric dataset, you configure RLS rules that filter data based on the current user's attributes, ensuring users only see their authorized data.
Custom workspace roles primarily control access to the workspace artifacts themselves (e.g., viewing, editing reports), not the fine-grained row-level data within a dataset.
Data sensitivity labels classify the nature of the data (e.g., confidential, public) but do not inherently filter individual rows based on the user's identity or permissions.
Azure Active Directory (Azure AD) dynamic groups can be used to manage groups of users for applying RLS rules, but they don't define the RLS logic itself; the RLS rules still need to be configured based on attributes that these groups represent.
Row-level security (RLS) is implemented by configuring rules that filter the rows of data returned based on the identity or attributes of the user querying the dataset. These rules dynamically restrict data visibility, ensuring that users only see the data they are authorized to access, directly meeting the requirement for users to see "their data."
Concept tested: Row-level security (RLS) implementation
Source: https://learn.microsoft.com/en-us/fabric/data-warehousing/row-level-security
Topics
Community Discussion
No community discussion yet for this question.