Microsoft Power Platform Functional Consultant289 questions across 29 pages are complete and free, with no account or card.
289 questions in this bank
Free access · progress saved on this device
A company uses model-driven apps. Users in the sales department enter the first name, last name, and phone number of customers in the app. The users request a single screen in the app to enter the customer data. You need to configure the app. What should you do?
Answer: D
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: • Name • Company • Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a Microsoft Power Fx formula for the columns. Does the solution meet the goal?
Answer: B
Creating a Microsoft Power Fx formula for the columns will not prevent duplicate rows in a Dataverse table. Power Fx formulas are primarily used for calculations, validations, or conditional logic at the UI level in Power Apps, not for enforcing uniqueness constraints on data at the database level. Mojow!!!
Source: Adapted from community discussion — Masbee
A company is implementing advanced features for a Power Pages website. The company hosts documents and lists in several SharePoint environments that are hosted both on-premises and online. Users of the Power Pages site must be able to view, search for, and filter this data from a single, intuitive experience. You need to determine which advanced feature to implement. What should you implement?
Answer: A
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: • Name • Company • Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a duplicate detection rule for the columns. Does the solution meet the goal?
Answer: B
The answer for this question should be No. Though duplicate detection rule triggers before you save data to existing records, it needs 2 tables to make a duplicate detection rule, "Base record and Matching record". Base record is the table for checking whether the subject of the new record exist or not. Matching record is the table the new record is going to be added to. This question mentions only one table, so the answer must be "No". https://learn.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
Source: Adapted from community discussion — JohnChung
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: • Name • Company • Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a business rule for the columns. Does the solution meet the goal?
Answer: B
Creating a business rule for the columns will not ensure that the table does not contain duplicate rows. Business rules in Dataverse are used to apply logic and validations at the form level, but they do not enforce uniqueness constraints on the data at the table level. To prevent duplicate rows, you should use alternate keys or duplicate detection rules. Alternate keys enforce uniqueness directly in the database, while duplicate detection rules help identify potential duplicates.
Source: Adapted from community discussion — killionb12
You must create a new table to support a new feature for an app. Records for the table must be associated with a business unit and specify security roles for the business unit. You need to configure table ownership. Which table ownership type should you use?
Answer: A
The “User or Team owned” table ownership type in Dataverse is designed for scenarios where records are owned by teams or users and where access rights can be restricted based on business units and security roles. This would be the appropriate choice given that the records for the new table must be associated with a business unit and specify security roles for the business unit. So, the answer is A. User or team owned.
Source: Adapted from community discussion — 5f14337
DRAG DROP - A company uses Power Apps. You create a custom phone table that is a child of the contact table. You need to configure the cascading rules for each action. Which behavior should you use? To answer, drag the appropriate behaviors to the correct actions. Each behavior may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen. Support agents use a model-driven app while working on customer cases. Agents currently switch between multiple systems to locate help content. The need to switch systems makes it difficult to find relevant information. You need to provide an efficient way to display contextual knowledge directly within the case form without requiring the agent to refresh the record. Solution: Add a custom page that has a knowledge article lookup and link it by using a navigation button in the app. Does the solution meet the goal?
Answer: B
You are creating a business rule to implement new business logic. You must apply the business logic to a canvas app that has a single screen named Screen1. You need to configure the scope for the business rule. Which scope should you use?
Answer: B
Set the scope, according to the following: TABLE 1 If you select this item... The scope is set to... table Model Driven forms and server All Forms Model Driven forms Specific form (Account form, for example) Just that Model Driven form All applies to Model Driven App Only not to canvas Except Entity Level Rules
Source: Adapted from community discussion — abhinav123
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses Dataverse. The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption. You need to recommend a solution. Solution: Enable attachments for a table. Does the solution meet the goal?
Answer: B
Enabling attachments for a table will actually increase Dataverse storage consumption because attachments are stored within the Dataverse environment. To minimize storage consumption, you should consider using SharePoint integration for document management. This allows you to store documents in SharePoint while linking them to records in Dataverse, effectively reducing the storage used in Dataverse.
Source: Adapted from community discussion — killionb12
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
PL-200 practice, question 61. 289 questions available.
Version 1.0.0. How we source questions
