Microsoft Microsoft Certifications PL-400 Questions & Answers

• Question 211:

  You are creating a model-driven app for Contoso, Ltd. You add a button to the account page. The button must send a text message to the company's account team when a user selects the button.

  The account team reports that they are not receiving messages when users select the button. You are troubleshooting the app by using the following hyperlink:

  https://contoso.com.dynamics.com/main.aspx?appid=3b157789-5e5b-ec11-8f8f-002248087922andribbondebug=true

  What is the purpose of the hyperlink?

  A. Run Command Checker for all buttons on the page.

  B. Add the Power Apps Checker button to the page.

  C. Run Power Apps Checker for all buttons on the page.

  D. Add the Command Checker button to the page.

  Correct Answer: D

  To enable Command Checker, pass ribbondebug=true as a URL parameter (ex: https://myorg.crm.dynamics.com/main.aspx?appid=c26d1c44-e7c0-4c72-9d6d-0e82768cb5bdandribbondebug=true). You’ll see two new UI features light up. The

  first is a new button in the top right of the header which lets you inspect the global command bar

  Next, each command bar contains a new “Command checker” button. Note that this shows up at the end of the ribbon, so you may have to click the overflow flyout.

  Reference: https://powerapps.microsoft.com/en-us/blog/introducing-command-checker-for-model-app-ribbons/

• Question 212:

  You are developing a model-driven app for a company that sells sporting goods. You add a button to a page that displays information for a product.

  The button must copy information for the selected product and create a record in the data source. You add the following code to the button. (Line numbers are included for reference only.)

  

  You need to complete the code.

  Which function should you insert at line 01?

  A. UpdateContext(

  B. IsMatch(

  C. LoadData(

  D. Patch(

  E. SaveData(

  Correct Answer: A

  Use the UpdateContext function to create a context variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of a data operation.

  To create or update a context variable, pass a single record to the UpdateContext function. In each record, specify the name of a column, which defines or matches the name of the variable, and the value to which you want to set that variable.

  Example:

  UpdateContext( { Person: { Name: "Milton", Address: "1 Main St" } }

  Creates or modifies the context variable Person, setting its value to a record. The record contains two columns, named Name and Address. The value of the Name column is Milton, and the value of the Address column is 1 Main St.

  Reference:

  https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-updatecontext

• Question 213:

  You are creating a Power Apps app.

  The app must retrieve data from an API that requires two-factor authentication.

  You need to configure authentication.

  Which type of authentication should you implement?

  A. Server-to-server

  B. API key-based

  C. Basic

  D. OAuth

  Correct Answer: D

  OAuth 2.0 is the industry-standard protocol for authorization. After application users provide credentials to authenticate, OAuth determines whether they are authorized to access the resources.

  OAuth enables two-factor authentication (2FA) or certificate-based authentication for server-to-server application scenarios.

  Reference:

  https://docs.microsoft.com/en-us/power-apps/developer/data-platform/authenticate-oauth

• Question 214:

  You are creating a canvas app that realtors use to identify neighbors for properties that are for sale. The OnStart property includes the following code:

  ClearCollect(collectNeighborList, Filter(NeighborList, Status = “Active")); ClearCollect(collectRealtorList,CompanyList);ClearCollect(collectRegions, RegionList)

  The app is running slower than expected.

  You need to resolve the issue.

  What should you do?

  A. Replace all instances of the ClearCollectmethod with the connect method.

  B. Replace the existing code segment with the following code segment Concurrent (ClearCollect(collectNeighborList, Filter(NeighborList, Status = “Active”)), ClearCollect(collectRealtorList,CompanyList),ClearCollect(collectRegions, RegionList))

  C. Replace the existing code segment with the following code segment: ClearCollect(collectNeighborList, Filter(NeighborList, Status = “Active”)); Concurrent(ClearCollect(collectRealtorList,CompanyList)); Concurrent(ClearCollect(collectRegions, RegionList))

  Correct Answer: B

  Optimize the OnStart property

  Use the ClearCollect function to cache data locally if it doesn't change during the user session. Also, use the Concurrent function to load data sources simultaneously; this can cut the amount of time an app needs to load data in half.

  Example: Without the Concurrent function, the following formula loads each of four tables one at a time:

  ClearCollect( Product, '[SalesLT].[Product]' );

  ClearCollect( Customer, '[SalesLT].[Customer]' );

  ClearCollect( SalesOrderDetail, '[SalesLT].[SalesOrderDetail]' );

  ClearCollect( SalesOrderHeader, '[SalesLT].[SalesOrderHeader]' )

  You can enclose the same formula in the Concurrent function to reduce the overall time that the operation needs:

  Concurrent( ClearCollect( Product, '[SalesLT].[Product]' ), ClearCollect( Customer, '[SalesLT].[Customer]' ), ClearCollect( SalesOrderDetail, '[SalesLT].[SalesOrderDetail]' ), ClearCollect( SalesOrderHeader, '[SalesLT].[SalesOrderHeader]' ))

  Reference: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/performance-tips#optimize-the-onstart-property

• Question 215:

  You are developing a new Power Platform app.

  The checker fails with an error due to missing security roles.

  You need to add security roles to the Power Apps Checker application user.

  Which two security roles should you add? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Global Discover Service Role

  B. Export Customizations

  C. Environment Maker

  D. Solution Checker

  E. Resource Manager

  Correct Answer: BD

  Before you are able to run it, make sure you have the proper Security Roles in your Microsoft Dataverse environment. Two of the required permissions are Export Customizations and Solution Checker.

  Reference:

  https://learntoinspire.ca/2020/01/18/leveraging-the-power-of-solution-checker/

• Question 216:

  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?

  A. Create a security role for users in Group1 to grant users access to the column.

  B. Create multiple forms. Assign a form containing the sensitive data to Group1. Assign a form that does not contain the sensitive data to Group2.

  C. Use JavaScript to set visibility of the column based on the group of the current user.

  D. Create a field-level security profile for Group1 users to grant the users access to the column.

  Correct Answer: D

  There are two steps to set up security permissions for a column.

  1.

  Enable column security on one or more columns for a given table.

  2.

  Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.

  Reference: https://docs.microsoft.com/en-us/power-platform/admin/set-up-security-permissions-field

• Question 217:

  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?

  A. Add a Power Apps command function.

  B. Use Power Fx.

  C. Add column to the Account table in Dataverse.

  D. Create a key in the Account table in Dataverse.

  Correct Answer: D

  Work with alternate keys All Microsoft Dataverse table rows have unique identifiers defined as GUIDs. These are the primary key for each table. When you need to integrate with an external data store, you might be able to add a column to the external database tables to contain a reference to the unique identifier in Dataverse. This allows you to have a local reference to link to the Dataverse row. However, sometimes you can't modify the external database. With alternate keys you can now define a column in a Dataverse table to correspond to a unique identifier (or unique combination of columns) used by the external data store. This alternate key can be used to uniquely identify a row in Dataverse in place of the primary key. You must be able to define which columns represent a unique identity for your rows. Once you identify the columns that are unique to the table, you can declare them as alternate keys through the customization user interface (UI) or in the code.

  Reference: https://docs.microsoft.com/en-us/power-apps/developer/data-platform/define-alternate-keys-entity

• Question 218:

  A company uses Microsoft Dataverse rollup fields to calculate insurance exposure and risk profiles for customers.

  Users report that the system does not update values for the rollup fields when new insurance policies are written.

  You need to recalculate the value of the rollup fields immediately after a policy is created.

  What should you do?

  A. Create new calculated fields on the customer entity for insurance exposure and risk. Create a formula to calculate the sum of values from policy records.

  B. Change the frequency of the Calculate Rollup Field recurring job from every hour to every five minutes.

  C. Create a plug-in that uses the update method for the rollup fields. Configure a step on the Create event for the policy entity for this plug-in.

  D. Create a plug-in that uses the CalculateRollupFieldRequest method for the rollup field. Configure a step on the Create event for the policy entity for this plug-in.

  Correct Answer: D

• Question 219:

  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 university implements Dynamics 365 Sales. Several departments use opportunity records to bid for funding for projects within their own departments. You configure the system to ensure that each department can only work on their own

  records.

  Employees in multiple departments often need to work together on an opportunity. Employees report that they are not able to see opportunities from other departments.

  You need to ensure that employees from more than one department can work on the same opportunities when necessary.

  Solution: Share the individual opportunity that members of one department are working on with all members of the second department, and give those members the appropriate permissions.

  Does the solution meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead: Use position hierarchy security and define the two departments as positions.

  Two security models can be used for hierarchies, the Manager hierarchy and the Position hierarchy. The Position hierarchy allows data access across business units. If you are a financial organization, you may prefer the Manager hierarchy model, to prevent managers’ accessing data outside of their business units. However, if you are a part of a customer service organization and want the managers to access service cases handled in different business units, the Position hierarchy may work better for you.

  Note: The hierarchy security model is an extension to the existing security models that use business units, security roles, sharing, and teams. It can be used in conjunction with all other existing security models. The hierarchy security offers a more granular access to records for an organization and helps to bring the maintenance costs down.

  Reference: https://docs.microsoft.com/en-us/power-platform/admin/hierarchy-security

• Question 220:

  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.

  A. Map the value of a Choices column on the child table to the value of a Choices column on the parent table.

  B. Map the value of a column on the parent table that uses column values from the child table.

  C. Map 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.

  D. Map the value of a single line of text column on the child table to the value of a currency column on the parent record.

  Correct Answer: AC

  Incorrect:

  Not B: It is the opposite. The child table uses column values from the parent table.

  Not D: The data types need to match. Both columns must be of the same type and the same format.

  Reference: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/map-entity-fields