PL-200 Practice Questions
Prepare for PL-200 with more than an answer.
- Exam fee
- $165 USD
- Level
- Associate
- Valid for
- 1 year
Domains covered on the exam 4
- Configure Microsoft Dataverse27.5%
- Create apps by using Microsoft Power Apps27.5%
- Create and manage logic and process automation27.5%
- Manage environments17.5%
- 1
A new low-code plug-in is created to perform a complex validation when an 'Opportunity' row is created. The plug-in is configured to run synchronously in the pre-operation stage. If the validation fails, the plug-in should prevent the record from being saved and show a specific error message to the user. How should the plug-in signal the failure and provide the error message?
Show answer details
Correct answer: C
In a synchronous low-code plug-in, the
Error()function is used to terminate the operation and roll back the transaction. The arguments passed to theError()function are used to create anInvalidPluginExecutionException, which presents the specified error message to the user in the application's user interface. This is the correct method for handling validation failures in plug-ins. - 2
A real estate company's model-driven app has a 'Property' table. The marketing team wants to easily view and manage property photos, which are stored in a SharePoint document library. Users should be able to upload, view, and organize photos related to a specific property record directly from the property form. Which integration should be configured to support this requirement?
Show answer details
Correct answer: C
The native SharePoint integration for document management is the feature designed for this purpose. After configuring the integration in the Power Platform settings and enabling it for the 'Property' table, a 'Documents' tab will appear on the property form. This provides a user interface for uploading and managing files in a contextually-aware SharePoint folder structure created automatically for each property record.
- 3
You are building a canvas app that needs to display a list of 'Tasks' for the current user. To improve performance, you want to load the tasks into a local cache when the app starts and then reference that cache on multiple screens. Which Power Fx function should you use on the app's
OnStartproperty to retrieve the tasks from Dataverse and store them locally?Show answer details
Correct answer: C
The
Collectfunction is used to add records to a data source. When used with a name that doesn't exist, it creates a new local data source called a collection. Collections are ideal for caching tabular data, like a list of tasks, for use throughout the app. TheSetfunction is for single values (global variables), andUpdateContextis for screen-specific variables (context variables). - 4
When configuring a many-to-many relationship between the 'Student' and 'Club' tables in Dataverse, the system automatically creates an intersect table. True or False: You must manually add columns to this system-generated intersect table to store additional information about the relationship, such as the student's role in the club (e.g., 'President', 'Member').
Show answer details
Correct answer: B
This statement is false. The intersect table created by a native many-to-many relationship is managed by the system and cannot be customized with additional columns. If you need to store attributes about the relationship itself (like a role or a join date), you must manually create a custom intersect table (also known as a manual N:N or associative table) and create two separate one-to-many relationships from the 'Student' and 'Club' tables to this new custom table.
- 5
You are building a canvas app that displays a gallery of product records from a Dataverse table containing 50,000 records. You need to allow users to search for products by name and filter by category. To ensure good performance and avoid processing limits, which Power Fx function should be used for searching?
graph TD A[User Enters Search Text] --> B{Power Fx Function}; B --> C[Dataverse Query]; C --> D{Delegable?}; D -- Yes --> E[Server-side Search]; D -- No --> F[Client-side Search on limited data]; E --> G[Full Results Returned]; F --> H[Incomplete Results];Show answer details
Correct answer: A
The
Search()function is delegable to Dataverse for text columns, meaning the search operation is performed on the server. This is critical for large datasets as it avoids the non-delegable query limit (default 500, max 2000 records).Search()is optimized for finding matches within one or more text columns across the entire table. - 6
A financial services firm is using a model-driven app to manage client portfolios. A business rule is configured on the Portfolio table to set a 'Review Required' flag if the portfolio's risk score exceeds 80. The business rule is scoped to 'All Forms'. A junior developer creates a new Power Automate cloud flow that updates the risk score of multiple portfolios in bulk using the Dataverse connector's 'Update a row' action. Testers report that the 'Review Required' flag is not being set by the flow. What is the most likely cause of this issue?
Show answer details
Correct answer: B
Business rules with a scope of 'All Forms' or a specific form execute on the client-side (in the user's browser) and will only trigger when a user interacts with a form in a model-driven app. To ensure the logic runs for server-side changes, such as those made by Power Automate flows or other API calls, the scope must be set to 'Entity'. This makes the business rule execute on the Dataverse server, regardless of how the data is modified.
- 7
A university is building a Power Pages website for student course registration. The site must allow authenticated students to view their own enrolled courses and available courses for their major. The data is stored in Dataverse tables: 'Student', 'Course', and a many-to-many relationship table 'Enrollment'. Which combination of Power Pages security components is required to meet this requirement? (Select TWO)
Show answer details
Correct answer: B, D
To allow all authenticated students to see all available courses for their major, a Table Permission with a 'Global' scope is appropriate for the 'Course' table, which can then be filtered by the student's major on the list component.
To ensure students can only see their own enrollments, a Table Permission with a 'Contact' scope is necessary. This scope filters the 'Enrollment' records to only those associated with the currently logged-in student (who is represented as a contact record).
- 8
A logistics company is deploying a core Power Platform solution containing shared tables (e.g., 'Vehicle', 'Shipment') to multiple regional environments. Each regional environment will have its own unmanaged solution with region-specific apps and flows that depend on the core tables. The company needs to update a shared choice column in the 'Shipment' table within the core solution. What is the correct application lifecycle management (ALM) process to deploy this update without breaking regional dependencies?
Show answer details
Correct answer: B
The correct ALM process for updating a foundational or core managed solution is to increment the version number, export it again as a managed solution, and import it into the target environments using the 'Upgrade' option. This approach properly applies the updates, maintains the solution layers, and ensures that dependent solutions in the regional environments are not broken. This is a standard practice for solution patching and upgrades.
- 9
You are designing a data model for a non-profit organization. You have a 'Donation' table and a 'Donor' table. You need to create a column on the 'Donor' table that displays the date of their most recent donation. This value must be updated automatically whenever a new donation is recorded for that donor and must be available for sorting and filtering in views. Which type of column should you create on the 'Donor' table?
Show answer details
Correct answer: C
A Rollup column is the correct choice because it is designed to aggregate data from related records. By using the
MAXfunction on the 'Donation Date' column of the child 'Donation' records, it will find the most recent date. Crucially, rollup columns store the calculated value in the database, which allows the data to be used in sorting and filtering within views, satisfying all requirements. Calculated and Formula columns are computed on-the-fly when retrieved and cannot be used for sorting in views. - 10
A consultant is building a model-driven app for an insurance company. The main 'Claim' form needs to display a read-only summary of the related 'Policyholder' information, including their name, policy number, and contact details, without requiring the user to navigate away from the claim form. Which form component should the consultant use to achieve this?
Show answer details
Correct answer: C
A Quick View form is specifically designed to display read-only information from a related record on another record's form. By creating a Quick View form for the 'Policyholder' table and adding it to the 'Claim' form via the lookup field, the consultant can display the required summary information directly on the claim record.
