Microsoft PL-200 Online Practice Questions and Exam Preparation

Microsoft PL-200 Online Questions & Answers

• Question 41:

  HOTSPOT

  You create a canvas app.

  The app requires access to data that is stored in collections. The app must provide the following actions:

  1. Create a new collection variable.

  2. Remove table values from a collection.

  You need to configure functions for the app.

  Which functions should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Collect

  Create a new collection variable.

  Collect, Clear, and ClearCollect functions in Power App creates and clears collections and adds records to any data source.

  Note: Power Apps has three types of variables:

  * Collections Scope: App

  Holds a table that can be referenced from anywhere in the app. Allows the contents of the table to be modified rather than being set as a whole. Can be saved to the local device for later use.

  Functions: Collect, ClearCollect

  Incorrect:

  * Global variables Scope: App

  Simplest to use. Holds a number, text string, Boolean, record, table, etc. that can be referenced from anywhere in the app.

  Function: Set

  * Context variables Scope: Screen

  Great for passing values to a screen, much like parameters to a procedure in other languages. Can be referenced from only one screen.

  Functions: UpdateContext, Navigate

  Box 2: Clear

  Remove table values from a collection.

  The Clear function deletes all the records of a collection. The columns of the collection will remain.

  References:

  https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-clear-collect-clearcollecthttps://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-variables

• Question 42:

  You manage Dynamics 365 for a company.

  You must prevent users from launching and using Power Automate.

  You need to hide the Flows button on the user interface.

  Which configuration setting should you change?

  A. the Customizations section of System Settings
  B. the Site Map
  C. the Buttons tab of Flow
  D. the Entity component of the default solution
  A. the Customizations section of System Settings

  ---

  Explanation

  References:

  https://www.inogic.com/blog/2018/10/show-or-hide-microsoft-flow-button-in-dynamics-365/

• Question 43:

  HOTSPOT

  A company deploys several model-driven apps. The company uses shared devices in their warehouse. The devices are always powered on. Users log on to the devices and then launch the apps to perform actions.

  Unauthorized users recently uploaded several files after another user failed to log out of a device. The company needs to prevent these incidents from occurring in the future.

  You need to configure the solution to prevent the reported security incidents.

  What should you do? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 44:

  A company is implementing Microsoft Power Platform solutions.

  The company requests information on the features that are supported by Power Fx.

  You need to identify the features of Power Fx.

  What should you identify?

  A. It uses an undefined value for uninitialized variables.
  B. It uses formulas that are similar to Microsoft Excel formulas.
  C. It uses synchronous data operations.
  D. It uses the model-driven app formula language.
  B. It uses formulas that are similar to Microsoft Excel formulas.

  ---

  Explanation

  The Fx formula logic recalculates the value automatically, similar to how a spreadsheet does, which affects the visibility of the control.

  Note: Power Fx is the low-code language that will be used across Microsoft Power Platform. It's a general-purpose, strong-typed, declarative, and functional programming language.

  Power Fx binds objects together with declarative spreadsheet-like formulas. For example, think of the Visible property of a UI control as a cell in an Excel worksheet, with an associated formula that calculates its value based on the properties of other controls. The formula logic recalculates the value automatically, similar to how a spreadsheet does, which affects the visibility of the control.

  Also, Power Fx offers imperative logic when needed. Worksheets don't typically have buttons that can submit changes to a database, but apps often do. The same expression language is used for both declarative and imperative logic.

  Incorrect:

  Not A: Fx is strongly typed.

  References:

  https://learn.microsoft.com/en-us/power-platform/power-fx/overview

• Question 45:

  You plan to create a dataflow by using Power Query to transform the data. You observe 'hat some cells display an error instead of the expected data.

  You need to obtain more details about the errors.

  What should you do?

  A. Select the row that includes the cell with the error.
  B. Use the Flow Checker.
  C. Select the cell with the error.
  D. Use the App Checker.
  E. Use the Advanced Editor.
  C. Select the cell with the error.

  ---

  Explanation

  When you select the cell with the error, a tooltip will appear with more details about the error. This will help you identify the cause of the error and take the necessary steps to fix it.

• Question 46:

  DRAG DROP

  A company is using Dataverse with a custom table named Prospects. The Prospects table has a lookup to the Account table.

  SharePoint document management is configured in the environment but is not configured for the Prospects table. All documents saved as part of the integration must be accessed by using an Account row linked to the Prospects table.

  Based on new requirements from end users, the Prospects table must be reconfigured for use with the document management feature.

  You need to configure the integration.

  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 47:

  You are developing a canvas app.

  You need to apply business rules to the app without writing code.

  Which three actions can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Validate data and show error messages.
  B. Enable or disable fields.
  C. Set field requirement levels.
  D. Set field values.
  E. Show or hide fields
  A. Validate data and show error messages.
  C. Set field requirement levels.
  D. Set field values.

  ---

  Explanation

  The following actions are not available on Canvas apps:

  1. Show or hide columns

  2. Enable or disable columns

  3. Create business recommendations based on business intelligence

  References:

  https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule

• Question 48:

  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.

  

  

  ---

  Box 1: In the Settings menu, select Document Templates Templates uploaded from the Settings page are available to all users. You don't need to take any further action.

  Administrators can use the Settings page to upload the Excel template. A template uploaded in Settings is available to all users.

  For admins: Upload the Excel template 1. Go to Settings > Templates > Document Templates.

  2. Click Upload Template.

  3. Drag the Excel file into the dialog box or browse to find and upload the file.

  4. Upload Template dialog box.

  5. Click Upload.

  Box 2: In the view for the email records, select Excel templates

  Note: For non-admins or admins wanting to create a personal template: Upload the Excel template Open a page with a list of records, for example, the list of Sales Opportunities. Go to Sales > Opportunities > My Open Opportunities.

  1. On the menu bar, click Excel Templates > Create Excel Template.

  2. Click Excel Template > Upload.

  3. Click Upload to add the Excel template.

  4. Drag the file into the dialog box or browse to find and upload the file.

  5. Click Upload.

  References:

  https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates

• Question 49:

  You must store relational enterprise data.

  What should you use?

  A. Dataverse
  B. Excel
  C. SharePoint only
  D. Power BI
  A. Dataverse

• Question 50:

  You are creating a model-driven app that has an embedded Power BI report. Another functional consultant set up an environment variable for the report.

  You add the dashboard to a solution in the development environment and then import the changes to a production environment as a managed solution.

  When you test the report, the data appears the same as it did in the development environment.

  You delete the solution in production.

  You need to resolve the development environment issue before redeploying the solution.

  What should you do?

  A. Update the environment variable current value
  B. Remove the environment variable current value.
  C. Update the environment variable default value.
  D. Create a new environment variable.
  B. Remove the environment variable current value.