Power Platform Data Access Design for Multinational Corp
Short answer
A Implement row-level security to restrict data visibility based on user attributes such as country or region.
Question
Key Takeaways
Tests the ability to distinguish between governance policies (DLP) and granular data access controls (RLS), with the common trap being the selection of DLP as a data restriction tool rather than an app usage policy.
This question explores designing data access controls in Microsoft Power Platform for a multinational organization with hierarchical reporting structures. It establishes that Row-Level Security (RLS) is the appropriate mechanism to restrict data visibility based on user attributes like country or region.
Common mistake: Option B (DLP Policy) is chosen by some learners who confuse data protection policies with row-level data filtering; DLP prevents apps from connecting to certain data sources but does not hide specific rows within a dataset.
Expert Analysis
Why the Answer Is Correct
Correct answer: A — Implementing row-level security allows you to define rules that filter data records based on the logged-in user's attributes, such as their assigned country or region. This perfectly satisfies the requirement for sales representatives to see only their specific country's data while allowing regional managers to view broader scopes through different roles.Why the Other Options Are Wrong
Option B is incorrect because Data Loss Prevention (DLP) policies control which connectors can be used together (e.g., preventing Power Apps from writing to SharePoint), not the internal visibility of rows within Dataverse. Option C fails because organization-level access would grant sales reps visibility across all regions, violating the "specific country/region" constraint. Option D is invalid because using a single business unit contradicts the requirement for independent regional operations and makes it difficult to enforce hierarchical access boundaries effectively.Community Comment Notes
The community consensus strongly favors Option A, with users noting that it is the only viable option for granular data separation. One user dismissed Option D as unconvincing for a worldwide company, while another highlighted that RLS is the standard solution for this type of hierarchical data access challenge.Official Reference
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/security-row-level-security
This link opens the official vendor documentation in a new tab.
Exam Strategy
When designing solutions involving 'access only to specific data' based on user location or role, always consider Row-Level Security first. Reserve DLP policies for scenarios where you need to prevent data exfiltration via unauthorized connector combinations.
Frequently Asked Questions
Why isn't DLP used to restrict data?
Can RLS handle multiple regions?
Community Votes
80% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 4 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 4
-
Tootru2bReal 👍 2 Answered AOption A - the only viable option. I looked at D briefly but no, not with the organization's setup and separation of countries, regions, and units.
-
inboxofdt 👍 1 Answered BI'd eliminate C and D first: not C - it won't restrict their access to specific country/region not D - single business unit sounds not very convincing for a worldwide company with external contractors. Now, between A and B... honestly, I'd just guess that it's B, as setting up row-level security for all these cases would be a six-month project..
-
Kyol 👍 1 Answered ASecurity role for a third party? "ok"
-
loftuscheek 👍 1 Answered Aanswer is A
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.