nerdexam
Microsoft

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.

Manage data governance and security

Question

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 to implement row-level security (RLS) for the dataset ?

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)
  • B
    3% (1)
  • C
    6% (2)
  • D
    91% (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.

ACreate custom workspace roles with row-level permissions.

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.

BApply data sensitivity labels to individual rows.

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.

CUse Azure Active Directory (Azure AD) dynamic groups to control access.

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.

DConfigure RLS rules based on user attributes.Correct

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

#Row-Level Security (RLS)#Data Security#Microsoft Fabric#User Access Control

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice