A global company has a Fabric semantic model with sales data. Regional managers should see only their region's data, and the 'Profit' column should be hidden from all regional managers. The executive team should see all data including profit. You need to implement both row-level and column-level security. What should you configure?

Create only a CLS role that hides the 'Profit' column and use a sensitivity label to filter rows by region.

Create only an RLS role for each region and rely on the workspace role to hide the 'Profit' column.

Create separate semantic models for each region and hide the 'Profit' column in each model.

Create an RLS role for each region that filters rows, and a CLS role that denies access to the 'Profit' column; assign managers to both roles.

A company has a Fabric semantic model with sales data. Regional managers should see only their region's sales, but the finance team must see all regions. Additionally, the 'Cost' column must be hidden from regional managers. You need to configure the semantic model. What should you do?

Use workspace roles to give regional managers 'Viewer' access and finance 'Member' access, then rely on the workspace to filter data.

Create separate semantic models for each region and grant finance access to all models.

Define a row-level security role for regional managers using a username-to-region mapping, and apply column-level security to hide the Cost column from that role.

Apply a sensitivity label to the Cost column and configure the label to restrict access.

A company stores data in OneLake and needs to ensure that only users in the finance department can access the finance data folders. The finance users are in a Microsoft Entra ID group. You need to configure security for the OneLake folders. What should you configure?

Move the finance folders to a separate lakehouse and share that lakehouse with the finance group.

Apply sensitivity labels to the finance folders and block access for non-finance users.

Set the workspace role for the finance group to Viewer.

Create OneLake data access roles and assign the finance group to the role with read access to the finance folders.

A data team has created a semantic model that is now the official source for sales reporting. The team wants to make it clear to all users that this model is the trusted version, while other models are not yet approved. You need to help users identify the trusted model. What should you configure?

Share the semantic model with all users and grant them Build permission.

Promote the semantic model by endorsing it with the 'Promoted' status.

Apply a sensitivity label of 'Confidential' to the semantic model.

Create a new workspace and move the semantic model there.

Where can a Fabric administrator access the audit logs for Microsoft Fabric activities?

Microsoft Purview compliance portal

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 3

Configure Security and Governance DP-700 Practice Questions (Page 7)

Part of the Implement and manage an analytics solution domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 3–6 from this objective — we provide 36 practice questions to prepare you well beyond it. (estimate)

36questions here

8free pages

11concepts

30–35%of the exam

Questions 31–35

31application · medium
A global company has a Fabric semantic model with sales data. Regional managers should see only their region's data, and the 'Profit' column should be hidden from all regional managers. The executive team should see all data including profit. You need to implement both row-level and column-level security. What should you configure?
Select an answer first
32application · medium
A company has a Fabric semantic model with sales data. Regional managers should see only their region's sales, but the finance team must see all regions. Additionally, the 'Cost' column must be hidden from regional managers. You need to configure the semantic model. What should you do?
Select an answer first
33application · medium
A company stores data in OneLake and needs to ensure that only users in the finance department can access the finance data folders. The finance users are in a Microsoft Entra ID group. You need to configure security for the OneLake folders. What should you configure?
Select an answer first
34application · medium
A data team has created a semantic model that is now the official source for sales reporting. The team wants to make it clear to all users that this model is the trusted version, while other models are not yet approved. You need to help users identify the trusted model. What should you configure?
Select an answer first
35foundation · easy
Where can a Fabric administrator access the audit logs for Microsoft Fabric activities?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

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-700” is a trademark of its owner, used for identification only.