PL-900 Demonstrate the capabilities of Power Apps Practice Question
You have a canvas app that uses a Microsoft Dataverse table. Users need to see only their own records. What is the most efficient method to implement this security?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Filter function with User().Email or User().FullName.
The most efficient method is to use the Filter function with User().Email or User().FullName to filter records based on the current user. This approach leverages the app's built-in context without requiring additional security configuration. Option A is incorrect because removing datasource permissions undermines data security and is not a best practice. Option B is incorrect because while security roles can restrict access, they are more complex to set up and may not be the most efficient for simply filtering by user identity. Option D is incorrect because storing user ID in a global variable is less efficient and can be less secure compared to using the User() function directly in the filter.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Remove the datasource permissions and let the app handle all security.
Why it's wrong here
This would bypass security and is not recommended.
- ✗
Set up Dataverse security roles and assign them to users.
Why it's wrong here
Security roles control access at the table level but do not automatically filter records per user without additional configuration.
- ✓
Use the Filter function with User().Email or User().FullName.
Why this is correct
This leverages Power Apps built-in user context to filter records.
- ✗
Store the user ID in a global variable and use it in queries.
Why it's wrong here
Global variables are not secure and can be manipulated by users.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 904-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.