Microsoft Power Platform Functional Consultant Free Sample Questions

Description

Covers managing the Dataverse data model and security settings, building model-driven apps, canvas apps and Power Pages, creating cloud flows, and application lifecycle management.

20 free sample questions198 in the full practice test

Try simulator

PL-200 Sample Questions

  1. Question 1

    Intermediate

    Create and manage logic and process automation · Create and configure business rules

    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?

    Answer and explanation

    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.

  2. Question 2

    AdvancedMultiple answers

    Create apps by using Microsoft Power Apps · Build Microsoft Power Pages

    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)

    Answer and explanation

    Correct answers: 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).

  3. Question 3

    Advanced

    Manage environments · Participate in application lifecycle management (ALM)

    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?

    Answer and explanation

    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.

  4. Question 4

    Intermediate

    Configure Microsoft Dataverse · Manage the data model

    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?

    Answer and explanation

    Correct answer: C

    A Rollup column is the correct choice because it is designed to aggregate data from related records. By using the MAX function 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.

  5. Question 5

    Beginner

    Create apps by using Microsoft Power Apps · Create model-driven apps

    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?

    Answer and explanation

    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.

  6. Question 6

    Intermediate

    Create and manage logic and process automation · Create and manage cloud flows

    A Power Automate cloud flow is designed to process new rows in a 'Service Request' Dataverse table. The flow includes several actions, including sending an email and creating a task. During testing, the flow fails intermittently at the 'Send an email' action due to a transient issue with the mail server. The business requirement is that if the email fails, the flow should log the error to a 'Flow Errors' table and then proceed to the 'Create a task' action. How should the functional consultant configure this error handling?

    Answer and explanation

    Correct answer: C

    The 'Configure Run After' setting is the primary mechanism for error handling in Power Automate. By setting the error logging action to run after the email action fails, you create a specific error handling path. The subsequent 'Create a task' action should then run after the error logging action completes, ensuring it executes regardless of the email action's outcome, fulfilling the business requirement.

  7. Question 7

    Intermediate

    Create apps by using Microsoft Power Apps · Create model-driven apps

    True or False: When you embed a canvas app into a model-driven app's form, the canvas app automatically inherits the security permissions of the parent model-driven app and the underlying Dataverse record.

    Answer and explanation

    Correct answer: B

    This statement is false. An embedded canvas app is a separate app and must be explicitly shared with users. While it can receive context from the model-driven form (like the current record's ID), users must have separate permissions to run the canvas app itself. They also need appropriate permissions for any data sources the canvas app connects to, which may be different from the parent form's data source.

  8. Question 8

    Intermediate

    Configure Microsoft Dataverse · Manage the data model

    A project management office (PMO) uses Dataverse to track projects and associated risks. The 'Project' table and the 'Risk' table have a one-to-many relationship. The PMO director wants to prevent users from deleting a 'Project' record if there are any associated 'Risk' records with a status of 'Active'. How can this be enforced with minimal custom logic?

    Answer and explanation

    Correct answer: C

    By setting the relationship behavior to Referential and the Delete action to 'Restrict', you are configuring a standard database constraint. This setting tells Dataverse not to allow the deletion of the parent record (Project) if any related child records (Risks) exist. This is the most direct and efficient way to enforce this rule at the data layer without requiring additional logic like flows or plugins. The condition of 'Active' risks would require a plugin or flow, but the general prevention of deletion is handled by Restrict.

  9. Question 9

    Intermediate

    Create apps by using Microsoft Power Apps · Create model-driven apps

    You need to add a button to the command bar of a model-driven app's main grid for the Account table. This button should only be visible if the currently logged-in user belongs to the 'Sales Managers' security role. Which is the recommended, modern approach to implement this conditional visibility?

    Answer and explanation

    Correct answer: B

    The modern command designer is the recommended approach for customizing command bars. It uses Power Fx for both actions and visibility rules. You can write a formula in the 'Visible' property of the button that checks if the current user's security roles include 'Sales Managers'. This is a low-code, supported, and modern way to implement conditional visibility.

  10. Question 10

    IntermediateMultiple answers

    Configure Microsoft Dataverse · Manage Dataverse

    A functional consultant needs to configure Dataverse search for a custom app. Users must be able to search for records across the 'Customer', 'Order', and 'Product' tables from a single search bar. Which steps must be performed to enable this? (Select ALL that apply)

    Answer and explanation

    Correct answers: A, B, D

    Dataverse search must first be enabled at the environment level in the Power Platform admin center before it can be configured and used.

    Dataverse search uses the columns defined in a table's Quick Find View to determine which columns to search and which to display in the search results. This must be configured for each table intended to be part of the search.

    After enabling Dataverse search for the environment, you must explicitly select which tables should be included in the search index. This is done within the solution or the default configuration area for search.

Register free for 10 more questions

Or unlock all 198 PL-200 questions with explanations, timed mode and flashcards.