PL-200 — Microsoft Power Platform Functional Consultant Study Guide

Question 56

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?

Question 272

DRAG DROP - You are designing a chatbot for a sports outlet. You need to complete the chatbot. Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature 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. Select and Place:

Question 227

HOTSPOT - You have a model-driven app. You create five Microsoft Excel templates for analyzing customer data. Four of the templates must be available to all users. The remaining template must be available only to you. You configure the appropriate security roles for users. You need to determine how to upload the Excel templates. Which method should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 251

HOTSPOT - You develop a Power Apps app. Users report that the main form does not display data from other entities or allow them to edit data from other entities. You need to embed information from other entities in the form and allow users to edit the data. Which actions should you perform? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 57

HOTSPOT - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Background - Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices. Prospects are considered underage if they are younger than 18 years old at the time of registration. Current environment - Environment - • Custom code is not allowed in the system. • Server-side synchronization is configured for emails, appointments, contacts, and tasks. • The database and file storage of Dataverse must be minimized to keep costs low. Contact table - • Birthdate is a custom date and time field. • Age at Registration is a calculated field that displays the age of the prospect at the time of registration. • Current Age is a calculated field that displays the age of the prospect based on the current date and time. Evaluation table - • The Evaluation table is a custom table used to track evaluation criteria. • Evaluation records cannot be manually created. • Users must not be able to continue until an evaluation record is created automatically for the prospect. Consent table - • The consent forms completed by the parents are stored as records in the Consent table. • Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record. Team website - • The team website is created by using Power Pages. • A starter layout template was used to create the site. • The site consists of five pages: o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments. • Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles. Requirements - Registration - • Parents and prospects are created as contacts and must be linked. • The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team. • Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid. Parental consent - • When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved. • A view named Underage Prospects that lists all underaged prospects is required. • The Underage Prospects view must run once a week without requiring modifications to display correct information. • A consent email must meet the following requirements: o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year Evaluations - • Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill. • The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green. You need to create a filter for the Underage Prospects view. How should you set up the expression for the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 96

DRAG DROP - You are modifying a model-driven app. You set up a customer table in Microsoft Power Platform to retrieve user data. You set up a form with the following columns for users to enter their data. The form includes the following columns: The form must do the following: • The Country/region column must automatically populate with US when English is chosen as a language. If the user selects Other for this column, the column must remain blank so that user can enter a value. • The Passport expiration date column must appear only if the user selects Yes in the Passport ownership column. You need to configure the app with the least amount of effort. What should you configure? To answer, drag the appropriate solution component to the correct requirements. Each solution component 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.

Question 270

DRAG DROP - You create a report by using Power BI Desktop and publish the report to the Power BI service. You enable Power BI visualization embedding in a model-driven app. You need to configure the model-driven app to display a Power BI tile. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

Question 284

You are creating a Power Virtual Agents chatbot that uses multiple topics. Each user interaction can reference more than one topic. You need to be able to capture a value in an initial topic and use it in subsequent topics. Which type of variable should you create?

Question 223

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. On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Solution: Use Relevance Search to search for the word run. Does the solution meet the goal?

Question 47

DRAG DROP - A company has implemented server-side synchronization in Dataverse. Users have the following synchronization requirements: • As emails are moved to specific locations within an inbox, the emails must relate back to a specific record in Dataverse. • Information about key individuals must sync automatically to Outlook. • Tagged appointments in Outlook must sync automatically to Dataverse. You need to recommend a solution for each requirement. What should you recommend? To answer, move the appropriate features to the correct requirements. You may use each feature once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Question 73

HOTSPOT - You plan to create a Power Virtual Agents bot. The bot has the following requirements: • Ensure that user responses are available to any topic. • Recognize a list of words from spoken language of users. You need to configure the bot. Which features should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 136

HOTSPOT - You plan to create a Power BI dataflow. The Power BI dataflow has the following requirements: • Be able to create a copy of the dataflow to separate Power BI workspaces. • Schedule the dataflow to update every day at 11:00 AM. You need to configure the dataflow. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 285

DRAG DROP - You are designing a desktop user interface (UI) flow. The UI flow automates legacy software. You need to prepare data for transfer to Microsoft SharePoint list. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

Question 295

DRAG DROP - You are a Dynamics 365 Customer Service developer. A salesperson creates a chart. You need to ensure that the chart is available to all users on the team. Which actions should the salesperson perform? To answer, drag the appropriate actions to the correct users. Each action 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. Select and Place:

Question 17

Case Study - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Background - Contoso Suites is an animal shelter that specializes in finding homes for dogs that have been given up by their owners. The shelter can house up to 20 dogs. The shelter is implementing one model-driven Power Apps app to track the dogs and schedule meetings with potential adopters. No other apps will be created. The model-driven app uses Dataverse with out-of-the-box functionality when possible. Dataverse is set up with the following configuration: • The solution prefix “cs” is used for all new components. • Only the root business unit is used. • All tables are stored in Dataverse and do not require rapid scaling. • Exchange server-side sync is not configured. Adopters - • Adopter information is stored in a Contact table. • Contacts are considered to be duplicates if they have the same email address and last name. • Adopters are often late to meetings, so a reminder email is sent to them two hours before their meeting. • The email reminders must not be tracked in the system. Dogs - • Dog information is stored in a Dog table, which is organization owned. • Breed, size, and weight are fields in the table. Dog residency - • A Resident table tracks the stay of each dog. • Each resident record has a lookup for the dog and its food. • The food type and amount are logged on each resident record. Auto-posting is not configured for changes to food type and amount. • A fee of $120 is in a currency column named Adoption Fee. This fee can be changed depending on the adoption circumstances. • A formula column named Deposit is automatically populated with 20% of the adoption fee. • A resident record is generated automatically when a dog record is created. This is the only way a resident record can be created. Exercise and feedings - • Exercise for the dogs is tracked in an Exercise table. • Feedings are tracked in a Feeding table. • Exercise and feeding records appear in a resident record timeline. Care staff - • The care staff must be able to view who changed the food type and the amount that was given, for up to three months ago. • The staff must be able to update the weight of a dog on the resident record. • The staff report that the buttons are too small on the touch screen they use to log exercise and feeding. • The staff must be able to view who the adopters are for upcoming meetings. The staff must not be able to update adopter information. Administrative staff - • Administrative staff must receive a weekly list of duplicate contacts. Duplicate alerts must not appear when a staff member saves a new contact. • When an adopter wants to adopt a dog, the staff must perform a series of adoption duties in order. The following duty list must be displayed on the screen: o Commitment: - Obtain adopter signature in a commitment document. - Collect deposit. o Pre-pickup: - Document spay or neutering date. - Perform spay or neutering. - Document pickup date. o Pickup: - Collect full payment. - Verify dog is picked up. o A dog must be picked up no sooner than two days after spaying or neutering. o A pop-up window must appear with an error message if the Pickup date is too soon. o Only administrative staff must be able to add new adopters and dogs. You need to improve the user experience for the care staff to log exercise and feeding. What should you create?