What is the primary purpose of row-level security (RLS) in a Microsoft Fabric semantic model?

To restrict which columns a user can see in a table

To control who can access the semantic model itself

To restrict which rows of data a user can see based on their role or identity

To encrypt the data in the semantic model

A data steward needs to ensure that a dataset containing health information is labeled as sensitive and that it is marked as approved for use across the organization. What should they do?

Apply column-level security (CLS) to hide all columns.

Apply row-level security (RLS) to the dataset.

Apply a 'Highly Confidential' sensitivity label and endorse the dataset as certified.

Change the workspace role to Admin for all users.

Which of the following can be assigned a sensitivity label in Microsoft Fabric?

Semantic models, reports, and files

A sales dataset contains a 'Revenue' column and a 'Region' column. Regional managers should see only their own region's rows, but all managers should see the Revenue column. What should you implement?

Column-level security (CLS) hiding Revenue, and no row-level security.

Both row-level security (RLS) and column-level security (CLS) hiding Region.

Object-level security (OLS) on the table, and no row-level security.

Row-level security (RLS) filtering by Region, and no column-level security.

A multinational company uses Fabric and must comply with data residency requirements. The compliance team requires that all data in a specific workspace be labeled as 'Confidential' and that the label automatically applies to all new items created in the workspace. You need to ensure that new items inherit the label. What should you do?

Configure a default sensitivity label for the workspace that applies to all new items.

Use a OneLake data access role to enforce the label on new files.

Endorse all items as 'Certified' to indicate they are confidential.

Apply the 'Confidential' label to each item manually after creation.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 1Objective 1

Implement Security and Governance DP-600 Practice Questions (Page 3)

Part of the Maintain a data analytics solution domain, which accounts for 25–30% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 5–10 from this objective — we provide 36 practice questions to prepare you well beyond it. (estimate)

36questions here

8free pages

8concepts

25–30%of the exam

Questions 11–15

11foundation · easy
What is the primary purpose of row-level security (RLS) in a Microsoft Fabric semantic model?
Select an answer first
12application · medium
A data steward needs to ensure that a dataset containing health information is labeled as sensitive and that it is marked as approved for use across the organization. What should they do?
Select an answer first
13foundation · easy
Which of the following can be assigned a sensitivity label in Microsoft Fabric?
Select an answer first
14application · medium
A sales dataset contains a 'Revenue' column and a 'Region' column. Regional managers should see only their own region's rows, but all managers should see the Revenue column. What should you implement?
Select an answer first
15expert · hard
A multinational company uses Fabric and must comply with data residency requirements. The compliance team requires that all data in a specific workspace be labeled as 'Confidential' and that the label automatically applies to all new items created in the workspace. You need to ensure that new items inherit the label. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-600

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-600” is a trademark of its owner, used for identification only.