In Microsoft Fabric, how is column-level security typically implemented?

By using row-level security with a filter on the column

By using object-level security (OLS) in the semantic model to restrict column visibility

By applying a sensitivity label to the column

By creating a separate table for each user

A data governance policy requires that all files containing personal data be labeled as 'Confidential' and that only authorized users can access them. Additionally, the files must be marked as trusted for reporting. What is the most comprehensive approach?

Apply sensitivity labels and object-level security (OLS) to the files.

Apply sensitivity labels and row-level security (RLS) to the files.

Configure file-level permissions and endorse the files as certified.

Apply sensitivity labels to the files, configure file-level permissions, and endorse the files as promoted.

A Fabric workspace contains a semantic model with multiple tables. A group of analysts needs to see the 'Sales' table but not the 'EmployeeDetails' table. They currently have Viewer access to the workspace. What should you do?

Use object-level security (OLS) on the semantic model to deny access to the EmployeeDetails table for the analysts.

Apply row-level security (RLS) to filter out EmployeeDetails rows.

Create a separate workspace and share only the Sales table.

Change the analysts' workspace role to Contributor and rely on item-level permissions.

In Microsoft Fabric, how can you grant a user access to a single report without giving them access to the entire workspace?

Create a new workspace and move the report there

Share the report directly with the user and assign item-level permissions

Use row-level security to filter the report for that user

Add the user to the workspace as a Viewer

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 1Objective 1

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

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 26–30

26foundation · easy
In Microsoft Fabric, how is column-level security typically implemented?
Select an answer first
27foundation · easy
In Microsoft Fabric, which endorsement type indicates that an item is certified by a central authority?
Select an answer first
28expert · hard
A data governance policy requires that all files containing personal data be labeled as 'Confidential' and that only authorized users can access them. Additionally, the files must be marked as trusted for reporting. What is the most comprehensive approach?
Select an answer first
29application · medium
A Fabric workspace contains a semantic model with multiple tables. A group of analysts needs to see the 'Sales' table but not the 'EmployeeDetails' table. They currently have Viewer access to the workspace. What should you do?
Select an answer first
30foundation · easy
In Microsoft Fabric, how can you grant a user access to a single report without giving them access to the entire workspace?
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.