PL-400 practice questions 101–110

1. Question 101 · 388 in bank

   Select 2

   You are developing a model-driven app for a company. The app must map child records to a parent record. You need to use the column mapping feature to configure the app. Which two actions can you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AMap the value of a Choices column on the child table to the value of a Choices column on the parent table.
   • BMap the value of a column on the parent table that uses column values from the child table.
   • CMap the value of columns on both the child table quick-create and main forms to the value for the same columns on the parent table.
   • DMap the value of a single line of text column on the child table to the value of a currency column on the parent record.

   Show answer

   Answer: AC

   Explanation

   Are you all serious? B is the MOST WRONG option. Column mapping can set a value of parent table field to the filed of sub table, B does it in reverse. And the wording of 'map xxx to xxx' is very confused than 'set xxx to xxx' I refer to AC.

   Source: Adapted from community discussion — justin_s

   References

   • Microsoft Learn

   Next question

2. Question 102 · 388 in bank

   DRAG DROP - You are creating a Power Platform solution for a fitness studio. Members of the studio will use the solution to track their progress towards fitness goals. Personal trainers create programs with different exercises to match a member's fitness level. Members can opt into a program to submit information about their progress with exercises suggested by a trainer. Fitness programs and exercises have specific durations, prices, and dates. You need to ensure that members can see all of the exercises that a trainer suggests in their calendars. What should you use? To answer, drag the appropriate options to the data types. Each option 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. Select and Place:

   

   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.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Standard table with User or Team ownership Table ownership - There are two different types of standard and custom table ownership. When you create a custom table the ownership options are User or team or Organization owned. Once a table is created, the ownership type can't be changed. Organization - Data belongs to the organization. Access to the data is controlled at the organization level. User or team - Data belongs to a user or a team. Actions that can be performed on these rows can be controlled on a user level. Note: Tables appear in Power Apps as one of three different types, which indicate how the table came into the environment, whether the table is managed or unmanaged, and whether it can be customized. * Standard: Several standard tables, also known as out-of-box tables, are included with a Power Platform environment, that includes Microsoft Dataverse. Account, business unit, contact, task, and user tables are examples of standard tables in Dataverse. Most of the standard tables included with Dataverse can be customized. Tables that are imported as part of a managed solution and set as customizable also appear as standard tables. Any user with appropriate privileges can customize these tables where the table property has customizable set to true. * Managed: Are tables that aren't customizable and have been imported into the environment as part of a managed solution. * Custom: Custom tables are unmanaged tables that are either imported from an unmanaged solution or are new tables created directly in the environment. Any user with appropriate privileges can fully customize these tables. Box 2: Activity table with User or Team ownership Activity tables - An activity can be thought of as any action for which an entry can be made on a calendar. An activity has time dimensions (start time, stop time, due date, and duration) that help determine when the action occurred or will occur. Activities also contain data that helps determine what action the activity represents, for example, subject and description. An activity can be opened, canceled, or completed. The completed status of an activity will have several sub-status values associated with it to clarify the way that the activity was completed. Activity tables are a special kind of table that can only be owned by a user or team, but can't be owned by an organization. When you create a table, you can specify it as a standard or activity table. Reference: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/types-of-entities

   Source: Adapted from community discussion — 700157a

   

   Next question

3. Question 103 · 388 in bank

   DRAG DROP - You have a Microsoft Power Platform solution that includes canvas apps and Power Automate cloud flows. The canvas apps and flows interact with a third-party content management system (CMS). You store the URL for the CMS version (development or production) in an environment variable. You deploy the solution to a production environment. You observe that the environment variable references the development URL for the CMS. You update the URL value of the variable directly in the production environment. You need to assess which environment variable value will be used in the following scenarios. Which versions of the environment variable will the solution use? To answer, drag the appropriate environment variable versions to the correct scenarios. Each environment variable version 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:

   

   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.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Development - Box 2: Production - Environment variables can be created and modified within the modern solution interface, automatically created when connecting to certain data sources in canvas apps, or by using code. They can also be imported to an environment via solutions. Once environment variables are present in an environment, they can be used as inputs when authoring canvas apps, Power Automate flows, when developing plug-ins, as well as many other places such as adding a Power BI dashboard to a model-driven app. When these types of objects use environment variables, the values are then derived from the environment variables and can be changed when solutions are imported to other environments. Box 3: Production - Environment variables can be used in solution cloud flows since they are available in the dynamic content selector. All types of environment variables can be used in triggers and actions. Reference: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables

   

   Next question

4. Question 104 · 388 in bank

   HOTSPOT - You are developing a canvas app for a healthcare center. You need to create custom tables for the solution. You have the following requirements:

   

   You need to create the tables. Which table type should you create? To answer, select the appropriate options in the answer area. 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.

   Show the answer figure

   Answer: See figure below

   

   Next question

5. Question 105 · 388 in bank

   You are mapping data from an enterprise resource planning (ERP) system to Microsoft Dataverse. You must reference the Name and Email from the ERP system during mapping to ensure that records are unique. You need to create an alternate key that references the Name and Email columns. How should you create the key?

   • AAdd a Power Apps command function.
   • BUse Power Fx.
   • CAdd column to the Account table in Dataverse.
   • DCreate a key in the Account table in Dataverse.

   Show answer

   Answer: D

   References

   • Microsoft Learn

   Next question

6. Question 106 · 388 in bank

   You develop a model-driven app to include a form containing several columns. Two groups of users. named Group1 and Group2 will access the form. A column contains sensitive data that should not be read by Group2. Group1 must be able to access the column. You need to prevent Group2 users from viewing the sensitive data. What should you do?

   • ACreate a security role for users in Group1 to grant users access to the column.
   • BCreate multiple forms. Assign a form containing the sensitive data to Group1. Assign a form that does not contain the sensitive data to Group2.
   • CUse JavaScript to set visibility of the column based on the group of the current user.
   • DCreate a field-level security profile for Group1 users to grant the users access to the column.

   Show answer

   Answer: D

   Explanation

   D. Create a field-level security profile for Group1 users to grant the users access to the column. Field-level security allows you to restrict access to specific fields in a table based on a user's security role.

   Source: Adapted from community discussion — Montoi

   Next question

7. Question 107 · 388 in bank

   HOTSPOT - A company deploys a set of automation processes. A process generates errors. A portion of the error log is displayed below.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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.

   Show the answer figure

   Answer: See figure below

   Explanation

   Yes, No and No. This is a flow action to post a message to the teams channel. This error is raised when an incorrect team id and channel id is passed.

   Source: Adapted from community discussion — DummyTest1

   

   Next question

8. Question 108 · 388 in bank

   HOTSPOT - The following code updates the customersizecode choice column on the Account table if the numberofemployees column value is greater than 100. Line numbering is provided for information only.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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.

   Show the answer figure

   Answer: See figure below

   Explanation

   The first one should be No, because the Retrieve method will take GUID as a parameter but given the function sending string as AccountID, the account needs to convert to GUID.

   Source: Adapted from community discussion — DimpleG

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

9. Question 109 · 388 in bank

   You are developing a Power Apps app to manage records in the Account table in Microsoft Dataverse. You must configure a Web API request to retrieve changes from the table. You need to configure the preference header for the API request. What should you include in the request header?

   • Aodata.nextLink
   • Bodata.context
   • Codata.deltaLink

   Show answer

   Answer: C

   Explanation

   The correct answer is C. odata.deltaLink. The odata.deltaLink header is used to retrieve changes from a table in Dataverse. It is a more efficient way to retrieve changes than using the odata.nextLink header. To configure the odata.deltaLink header, you need to include the following in the request header: odata.deltaLink=https://{server}/{organization}/api/data/v9.0/Accounts?$filter=Id eq guid'{AccountId}'

   Source: Adapted from community discussion — MikeAWS

   Next question

10. Question 110 · 388 in bank

    DRAG DROP - An international organization has a series of client-server applications that manage red light cameras and traffic violations across a wide geographic region. The daily volume of traffic violations is very high and growing. You plan to use Microsoft Power Platform apps to manage the following types of data: ✑ Existing vehicle licensing data must be imported into Microsoft Dataverse and easily queried. ✑ Red light camera images must be stored in a repository for later analysis. ✑ Information about traffic violations must be stored and related to vehicle details. You need to select data storage mechanisms for the new apps. Which data storage mechanisms should you use? To answer, drag the appropriate data storage mechanisms to the correct data types. Each storage mechanism 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:

    

    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.

    Show the answer figure

    Answer: See figure below

    Explanation

    Box 1: Entity - Existing vehicle licensing data must be imported into Microsoft Dataverse and easily queried. Virtual tables (also known as virtual entities) enable the integration of data residing in external systems by seamlessly representing that data as tables in Microsoft Dataverse, without replication of data and often without custom coding. A virtual table is a definition of a table in the Dataverse platform without the associated physical tables for table instances created in the Dataverse database. Instead during runtime, when a table instance is required, its state is dynamically retrieved from the associated external system. The following data providers ship with Dataverse: An OData v4 provider is included with the service and is installed by default. This provider supports create, read (retrieve, retrieve multiple), update and delete operations. An Azure Cosmos DB - Box 2: Azure Storage Blob - Red light camera images must be stored in a repository for later analysis. Use Azure Storage Blob for binary data. Azure Blob storage stores massive amounts of unstructured object data, such as text or binary data. Box 3: Azure Cosmos DB - Information about traffic violations must be stored and related to vehicle details. Reference: https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/get-started-ve https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blobs-introduction

    Source: Adapted from community discussion — d365gkv

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-400 practice, question 101. 388 questions available.