Microsoft Certified: Power Platform Functional Consultant Associate — Practice Set 1

Question 1

You are a Power Platform functional consultant configuring Microsoft Dataverse for a customer relationship management solution. You need to store multiple phone numbers for each contact record, where each phone number has a type (mobile, work, home). Which data modeling approach should you use?

Accepted Answer

Creating a related Phone Number table with a one-to-many relationship to Contact is the correct normalized data modeling approach. It allows an unlimited number of phone numbers per contact, each with its own type, without requiring schema changes when new phone types are needed.

Question 2

Your organization needs to track the total value of all open opportunities associated with each account in Microsoft Dataverse. The value should update automatically when an opportunity is created, updated, or deleted. Which column type should you add to the Account table to implement this?

Accepted Answer

Rollup columns in Microsoft Dataverse are specifically designed to aggregate values from related records. They are configured with an aggregate function (SUM), a source table and column, and optional filter conditions. Dataverse recalculates rollup columns on a scheduled basis and on demand.

Question 3

You are configuring Microsoft Dataverse for an organization that uses a hierarchical business structure with multiple divisions. Users in each division should only see and update records belonging to their own division. Which security feature should you configure to enforce this restriction?

Accepted Answer

Business units in Dataverse create organizational hierarchy boundaries. Security roles are assigned access levels (User, Business Unit, Parent-Child Business Unit, or Organization). Assigning users to their division's business unit and scoping their role to the Business Unit level restricts them to viewing and editing only records owned within their business unit.

Question 4

You are a functional consultant reviewing a Dataverse configuration. Users report that they are creating duplicate account records with the same name and email address. You need to prevent new duplicate records from being created. What should you configure?

Accepted Answer

Dataverse's duplicate detection feature allows administrators to define rules that specify matching criteria (such as account name and email address). When duplicate detection is enabled, Dataverse checks new or updated records against existing records and alerts users or blocks save operations when a match is found.

Question 5

You are configuring cascading behaviors for a relationship between an Account table and a related Contact table in Microsoft Dataverse. When an account is assigned to a new owner, all related contact records should automatically be reassigned to the same owner. Which cascading behavior should you configure for the Assign operation on this relationship?

Accepted Answer

The 'Cascade All' behavior on the Assign operation propagates the ownership change to all related records regardless of their status. This ensures that when an account is reassigned, all related contact records are automatically reassigned to the new owner.

Question 6

You are building a model-driven app for a service team that manages support cases. The app must display a list of all cases assigned to the current user on the main page. Which Power Apps component should you configure to show this list?

Accepted Answer

Views in model-driven apps define which records are shown in a list and apply filter criteria. Configuring a view with a filter condition 'Assigned User equals [Current User]' creates a personal view that shows only cases assigned to the signed-in user, which can be set as the default view for the Cases list component.

Question 7

You are designing a model-driven app form for a Case table. When a user selects 'Escalated' in the Status Reason field, a text field called 'Escalation Reason' should become mandatory and visible. For all other status values, the field should be hidden. How should you implement this requirement without writing any code?

Accepted Answer

Business rules in Dataverse provide a no-code way to implement conditional form logic. A business rule can show/hide columns and set field requirement levels based on field values. This rule runs on both model-driven app forms and on the server side, providing consistent enforcement without custom JavaScript.

Question 8

You are building a Power Pages website for an external partner portal. Partners must be able to log in using their existing Microsoft Entra ID corporate accounts. Which authentication configuration should you use in Power Pages?

Accepted Answer

Power Pages supports multiple identity providers including Microsoft Entra ID (formerly Azure AD). Configuring Entra ID as an identity provider allows external partners to authenticate using their existing corporate accounts through standard OpenID Connect or OAuth 2.0, without requiring separate Power Pages credentials.

Question 9

You are building a canvas app that needs to display a read-only summary of an account record when the app is embedded within a model-driven app form. Users should see the account summary without navigating away from the case form. Which approach should you use?

Accepted Answer

Canvas apps can be embedded directly in model-driven app forms. The ModelDrivenFormIntegration control passes the current record's context (including the account ID) to the canvas app, allowing it to display account information without the user navigating away from the case form.

Question 10

You are building a Power Pages site for a customer self-service portal. Customers must be able to view and submit support cases. You need to configure security so that customers can only see their own cases and not other customers' cases. Which two security components should you configure in Power Pages? Choose 2.

Accepted Answer

Power Pages security is controlled through web roles and table permissions. Web roles define what authenticated users can do, and table permissions define which records they can access. The Contact scope on a table permission restricts access to records related to the authenticated contact, ensuring customers see only their own cases.

Question 11

You are a functional consultant implementing a solution that requires sending an automated email notification when a high-priority support case is created in Microsoft Dataverse. The email should include case details from the record. Which automation tool should you use?

Accepted Answer

Power Automate cloud flows with the Dataverse 'When a row is added' trigger are the modern recommended approach for automating actions when Dataverse records are created. The flow can filter by priority and use dynamic content from the trigger to include case details in the email notification.

Question 12

You are implementing a business process flow (BPF) for an opportunity management solution. The sales team follows a five-stage process: Qualify, Develop, Propose, Close, and Won. The team needs to be able to move backwards to a previous stage to revise a proposal. What behavior does a business process flow support by default for this scenario?

Accepted Answer

Business process flows in Dataverse allow users to navigate to any stage, including previous stages, simply by clicking the stage in the process bar. This supports scenarios where a team needs to revise work in an earlier stage. Stages are not locked by default, although you can add logic to restrict movement.

Question 13

You are implementing a Power Automate cloud flow that uses the Microsoft Dataverse connector. The flow must retrieve a list of active account records where the account rating is Gold. Which connector action should you use?

Accepted Answer

The 'List rows' action in the Dataverse connector retrieves multiple records and supports OData filter expressions in the 'Filter rows' field. You can specify conditions such as 'statecode eq 0 and accountratingcode eq 1' to return only active Gold-rated accounts.

Question 14

You are configuring a classic Dataverse workflow that sends reminder emails to sales representatives when an opportunity has been in the Develop stage for more than seven days with no activity. The workflow must be able to run multiple times on the same record if conditions continue to be met. What type of workflow should you configure?

Accepted Answer

Classic Dataverse background workflows can be configured to run on a recurring schedule and check field conditions each time they execute. A recurring background workflow is the appropriate choice for time-based checks that need to repeat on the same record until a condition is no longer met.

Question 15

You are a Power Platform functional consultant. A cloud flow that processes customer orders has started failing after a connector update. Users report that orders are not being processed. You need to investigate the issue. What should you do first?

Accepted Answer

The cloud flow run history in Power Automate is the first place to look when troubleshooting flow failures. It shows each run's status, the specific action that failed, the inputs and outputs for that action, and the error message, which provides the information needed to diagnose and resolve the issue.

Question 16

You are implementing low-code logic for a Power Platform solution. You need to create a reusable calculation that determines a customer's discount percentage based on their tier level. This logic will be used across multiple canvas apps and cloud flows in the same environment. Which Power Platform feature should you use?

Accepted Answer

Low-code plug-ins in Dataverse are reusable Power Fx functions that can be called from canvas apps, cloud flows, and other components within the same environment. They provide a centralized location for business logic that needs to be shared and reused across multiple solution components.

Question 17

You are a Power Platform functional consultant preparing to deploy a solution from a development environment to a user acceptance testing (UAT) environment. Which solution type should you export from development and import into UAT to allow further customization in UAT?

Accepted Answer

Unmanaged solutions are used during active development and testing because components remain editable in the target environment. Managed solutions are used for production deployments where you want to control changes. For UAT where further testing configuration may be needed, an unmanaged solution is appropriate.

Question 18

You are configuring integration between Microsoft Dataverse and Microsoft SharePoint so that users can manage documents related to Dataverse records from within a model-driven app. What must you configure to enable this integration?

Accepted Answer

Server-based SharePoint integration is the native integration mechanism between Dataverse and SharePoint. It is configured in the Power Platform admin center and links a Dataverse environment to a SharePoint site, enabling document management features directly within model-driven app record forms.

Question 19

Your organization is preparing to release a Power Platform solution to production. Before deployment, you want to identify any customization issues, deprecated components, or compatibility problems in the solution. Which tool should you use?

Accepted Answer

Solution Checker is a static analysis tool in the Power Apps maker portal that analyzes a solution for performance, reliability, supportability, and security issues. It identifies problems such as deprecated API usage, missing dependencies, and customization anti-patterns before production deployment.

Question 20

You are a Power Platform functional consultant managing an organization's Power Platform environments. The organization has development, test, and production environments. Developers frequently need to import solutions with environment-specific configuration values such as SharePoint site URLs and service account email addresses. Which two features should you use to manage these environment-specific values? Choose 2.

Accepted Answer

Environment variables allow environment-specific configuration values (such as URLs and email addresses) to be stored in the solution and overridden per-environment during import. Connection references abstract connector credentials from the solution components, allowing each environment to use its own connections without modifying the solution.

Question 21

You are a Power Platform functional consultant. Your organization stores customer contracts in Dataverse. The legal team needs to see contract amount values but must not be able to see the negotiated discount percentage, which is visible only to the sales team. Both teams use the same model-driven app. How should you implement this requirement?

Accepted Answer

Column security in Dataverse provides field-level security that controls which users can read, create, or update specific columns regardless of their form or view configuration. Column security profiles define the permissions and are assigned to teams or users. This is the correct and secure approach because business rules and form customizations can be bypassed, whereas column security is enforced at the data layer.

Question 22

You are implementing a Power Automate cloud flow for an order management solution. The flow uses a condition to check whether an order total exceeds $10,000. If true, it sends an approval request. The approval connector is classified in the Standard connector tier. However, your organization's DLP policy places the Approvals connector in a separate group from the Dataverse connector used by the same flow. What will happen when the flow runs?

Accepted Answer

DLP policies group connectors into Business, Non-business, and Blocked tiers. A cloud flow cannot mix connectors from the Business and Non-business groups. If the Dataverse connector is in the Business group and the Approvals connector is in the Non-business group, the flow will fail at runtime because it violates the DLP policy.

Question 23

You are building a model-driven app for a project management solution. Project managers need to run a command to generate a project status report from any project record. The command should appear in the project record command bar and call a Power Automate flow that generates and emails the report. How should you implement this command?

Accepted Answer

Modern commanding in Power Apps uses Power Fx to configure command bar actions for model-driven apps. You can add a command button to a table's command bar and configure it to run a Power Automate flow, passing the current record's context. This is the recommended low-code approach that replaces the legacy ribbon workbench.

Question 24

You are building a model-driven app. Business users need to see a summary of an account's total revenue and number of active contacts displayed directly on the Account form without navigating to related records. Which form component should you add to show this summary information?

Accepted Answer

Rollup columns in Dataverse automatically calculate aggregate values (such as total revenue or active contact count) from related records and are displayed as standard read-only columns on the form. Embedding a Power BI tile provides richer visualizations of account data directly on the form without requiring navigation.

Question 25

Your organization needs to search across multiple Dataverse tables simultaneously using a single search box in a model-driven app. Users need to find accounts, contacts, and cases by typing a name or keyword. Which Dataverse feature should you configure to enable this capability?

Accepted Answer

Dataverse search (formerly Relevance Search) provides a single cross-table search experience in model-driven apps. Administrators enable the feature and configure which tables and columns are included in the search index. Users can then search across all indexed tables simultaneously from a single search bar.

PL-200 — Microsoft Power Platform Functional Consultant