Microsoft PL-200 Online Practice Questions and Exam Preparation

Microsoft PL-200 Online Questions & Answers

• Question 311:

  HOTSPOT

  You plan to create a Power Bi dataflow.

  The Power BI dataflow has the following requirements:

  1. Be able to create a copy of the dataflow to separate Power Bl workspaces-

  2. Schedule the dataflow to update every day at 11:00 AW.

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

  A company is planning to create a Power Virtual Agents bot.

  The bot has the following requirements:

  1. The bot must provide address information for the company.

  2. The bot must be available from Microsoft Teams and from the internet website of the company.

  You need to configure the bot.

  Which component should you use?

  A. Channel
  B. Template
  C. Composer
  D. Skill
  A. Channel

  ---

  Explanation

  In Power Virtual Agents, channels are used to make a bot available across different platforms such as Microsoft Teams and external websites.

  To meet the requirements:

  Provide address information implemented within topics (not part of the answer) Make the bot available in Teams and on a website requires configuring channels

  By enabling channels, you can:

  Publish the bot to Microsoft Teams Embed the bot in a website using the Custom website (Web Chat) channel Option Analysis Option

  A. Channel Correct (used to publish and expose the bot across platforms) Option

  B. Template Used only for initial bot creation Option

  C. Composer Advanced bot development tool, not required here Option

  D. Skill Used for bot-to-bot interaction, not for publishing

  To make the bot accessible from both Teams and a website, you must configure channels.

• Question 313:

  You must update a component without affecting the entire solution.

  What should you use?

  A. Full solution
  B. Patch solution
  C. Delete solution
  D. Clone environment
  B. Patch solution

• Question 314:

  DRAG DROP

  You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle.

  After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table. Contact information is brought over to the custom table.

  You add the following columns to the table:

  1. Bicycle type

  2. Tire brand

  3. Special equipment

  Users must be able to perform the following types of searches:

  1. Search for all customers who have a bicycle type of Contoso and live in Florida.

  2. Search all tables for any record that contains the word broken.

  You need to decide which type of search will give you the results desired.

  Which search should you configure? To answer, drag the appropriate search types to the correct requirements. Each search type 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:

  

  

  ---

  Box 1: Advanced find

  Operators for advanced search: Lets you use simple Boolean operators in your search term and craft the query to get the results you want.

  Box 2: Dataverse search

  Dataverse search helps you quickly find what you're looking for. It delivers fast and comprehensive results across multiple tables in a single list, sorted by relevance.

• Question 315:

  A company creates a canvas app.

  The app requires users to enter their social security number. The app should only display the last four digits when the user tabs to a different column.

  You need to configure the app.

  Which option should you use?

  A. Business rule
  B. Business process flow
  C. Power BI DAX
  D. Power Fx
  D. Power Fx

  ---

  Explanation

  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.

  Power Fx is being made available as open-source software. It is currently integrated into canvas apps, and Microsoft is in the process of extracting it from Power Apps for use in other Microsoft Power Platform products and as open source.

  Incorrect:

  Business rules

  By combining conditions and actions, you can do any of the following with business rules:

  Set column values

  Clear column values

  Set column requirement levels

  Show or hide columns

  Enable or disable columns Validate data and show error messages Create business recommendations based on business intelligence

  References:

  https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule

• Question 316:

  HOTSPOT

  You are using power Automate to create a list of customers from a Microsoft Excel file,

  The list must contain customers who meet one of the following criteria:

  1. Sales of less than $500,000.

  2. Customers who are on credit hold.

  3. You need to create a condition to filter the list Of customers.

  How should you complete the filter condition? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point

  

  

  ---

  Box 1: or

  Or: Takes two arguments and returns true if either argument is true.

  Box 2: equals(item()?['credithold'],'true')

  Equals: Returns true if two values are equal.

  For example, if parameter1 is someValue, this expression returns true:

  equals(parameters('parameter1'), 'someValue')

• Question 317:

  You manage the Dynamics 365 Customer Service environment for an organization.

  Microsoft SharePoint will not be deployed in the environment for a year.

  You need to integrate Microsoft Office 365 solutions with the Dynamics 365 instance to help the sales team with internal collaboration efforts.

  Which three solutions can you currently implement? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Microsoft Skype for Business
  B. Microsoft Exchange Online
  C. Microsoft OneNote
  D. Microsoft Yammer
  E. Microsoft OneDrive for Business
  A. Microsoft Skype for Business
  B. Microsoft Exchange Online
  D. Microsoft Yammer

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-platform/admin/add-office-365-online-services

• Question 318:

  You need to create adoption duties for the administrative staff.

  What should you create?

  A. business rule
  B. business unit
  C. business process flow
  C. business process flow

  ---

  Explanation

  The requirement describes a series of steps that must be completed in a specific order (Commitment Pre-pickup Pickup), which aligns with a Business Process Flow (BPF).

  BPFs guide users through staged processes, enforce order, and can include required steps and validations, making them ideal for managing structured procedures like adoption duties.

  Business rules handle simple logic/validation, and business units are for security structure, not process guidance.

• Question 319:

  HOTSPOT

  You plan to create a canvas app.

  The app must meet the following requirements:

  1. Send an email after a record is saved.

  2. Display the expiration column on a form if the creation date of the record is older than 90 days.

  You need to configure the app.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Power Automate flow

  Send an email after a record is saved.

  Box 2: Formula

  Display the expiration column on a form if the creation date of the record is older than 90 days.

• Question 320:

  A company uses Power Apps with Microsoft Dataverse.

  The company enables auditing on the Dataverse database. The company tenant reaches the maximum storage capacity.

  You need to delete some auditing data.

  Which three deletion options should you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. by record
  B. between two specified dates
  C. by table
  D. older than a specified date
  E. by column
  A. by record
  C. by table
  D. older than a specified date

  ---

  Explanation

  In Microsoft Dataverse, audit logs can grow quickly and consume storage. To manage audit data and free up space, you can delete audit logs using supported deletion criteria.

  Valid deletion options include:

  Option

  A. by record Delete audit history for specific records Option

  C. by table Delete audit logs for a specific table Option

  D. older than a specified date Bulk delete audit data based on age (most common approach)

  Incorrect options:

  Option

  B. between two specified dates Not a supported direct option in audit log deletion Option

  E. by column Column-level deletion is not supported for audit logs

  Therefore, the correct options are A, C, and D.