Microsoft PL-200 Online Practice Questions and Exam Preparation

Microsoft PL-200 Online Questions & Answers

• Question 291:

  DRAG DROP

  You create a canvas app that uses data from a Microsoft SQL Server database.

  You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app.

  You need to filter data in the dataflow and in the canvas app.

  Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool 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: Power Query

  Power Query is used in dataflows for data transformation and filtering before loading data into Microsoft Dataverse

  Box 2: Power Fx

  Power Fx is used in canvas apps to filter and manipulate data at the app level (e.g., Filter(), Sort()).

  Incorrect options:

  T-SQL Used directly in SQL Server, not in dataflows or canvas apps Kusto Used for Azure Data Explorer, not applicable here

• Question 292:

  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.

  You administer the Microsoft 365 and Power Platform environments for Contoso, Ltd. The company has a model-driven app that is used to track customer interactions with employees. The app uses standard table types for customers. A user named Elisabeth Rice signs in to the app by using the following sign in name: [email protected].

  After marriage, Elisabeth changes her legal name to Elisabeth Mueller.

  You need to update the sign in name for the user without losing any application history.

  Solution: Ask the Microsoft 365 administrator to sign in to the admin portal and change the username.

  Does the solution meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  In Microsoft Dataverse and model-driven apps, user records are tied to the underlying Azure AD (Microsoft Entra ID) identity, not just the display name or username string.

  When the username (User Principal Name) is updated in Microsoft 365:

  The user's identity remains the same (same object ID) All historical data (records, ownership, audit history) is preserved

  The change is reflected automatically in Dataverse

  Therefore, updating the username through the Microsoft 365 admin portal does not cause any loss of application history.

  The solution meets the goal.

• Question 293:

  You have a canvas app with an embedded Power Bl tile.

  You share the canvas app. Users report that they are unable to access the Power Bl content.

  You need to determine why users are unable to access the content

  What is the cause of the user s problems?

  A. The Power Bl dashboard is not shared.
  B. The Power Bl interactions property on the Power Bl tiles is set to Off.
  C. The Power Bl connection is not shared.
  D. The Power Bl Display mode property on the Power Bl tiles is set to Disabled
  A. The Power Bl dashboard is not shared.

  ---

  Explanation

  When embedding a Power BI tile in a canvas app, several factors must be considered to ensure that users have access to the content. One of the most important is sharing the Power BI dashboard that contains the tile. If the dashboard is not shared with users, they will not be able to view the content in the tile.

  To share a Power BI dashboard, you must have Edit permission on the dashboard. Once you have this permission, you can share the dashboard with other users by following these steps:

  Open the Power BI service and navigate to the dashboard that you want to share. Click the Share button in the top-right corner of the dashboard. In the Share pane that appears, enter the email addresses of the users that you want to share the dashboard with.

  Select the level of access that you want to grant to the users. You can choose to give them View access, which allows them to view the dashboard but not make changes, or Edit access, which allows them to view and make changes to the dashboard.

  Click the Share button to share the dashboard with the users.

  Additionally, there are other factors that could cause user issues:

  Option B. The Power BI Interactions property on the Power BI tile is set to Off. In that case, users will not be able to interact with the visuals.

  Option C. The Power BI connection is not shared. In that case, users will not have access to the data source.

  Option D. The Power BI Display mode property on the Power BI tile is set to Disabled. In that case, users will not see the tile.

  It is important to check all of these factors and ensure that they are properly configured to guarantee that users can access the content.

  References:

  https://docs.microsoft.com/en-us/power-bi/service-admin-share-dashboardhttps://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/embed-power-bihttps://docs.microsoft.com/en-us/power-bi/service-embed-content/embed-in-powerapps

• Question 294:

  HOTSPOT

  You plan to create classic workflows for process automation on the Account table.

  The process automation has the following requirements:

  1. If the Account Name column changes, a custom column named Previous Name must be updated with the original value.

  2. If the Credit Limit column changes, an email must be sent to the record owner with the new value.

  3. Asynchronous processes must be used whenever possible.

  You need to implement the process automation.

  What is the minimum number of workflows you should use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: 2

  Background

  There are two types of workflows: Real-time workflows Background workflows.

  Real-time workflows run immediately (synchronously) and background workflows run asynchronously.

  Note: Actions that background workflow processes can perform Background workflow processes can perform the actions listed in the following table.

  * Update row

  You can update the row that the background workflow is running on, any of the rows linked to that row in an N:1 relationships, or any rows created by earlier steps.

  * Send Email

  Sends an email. You can choose to create a new email message or use an email template configured for the table of the row that the background workflow is running on or any tables that have an N:1 relationship with the table, or the table for any rows created by earlier steps.

  * Etc.

  Best practices for background workflow processes

  Use child workflows

  If you apply the same logic in different workflows or in conditional branches, define that logic as a child workflow so you don't have to replicate that logic manually in each background workflow or conditional branch. This helps make your workflows easier to maintain. Instead of examining many workflows that might apply the same logic, you can just update one workflow.

  Box 2: 0

  Real-time

  Real-time workflows run immediately (synchronously) and background workflows run asynchronously.

• Question 295:

  You create a canvas app for a sales team. The app has an embedded Power BI tile that shows year-to-date sales. Sales users do not have access to the data source that the tile uses.

  Sales team users must be able to see data in the Power BI tile. You must minimize the level of permissions that you grant and minimize administrative overhead.

  You need to share another Power BI component to make the data visible.

  What should you share?

  A. The Power BI dataset the tile uses as a data source.
  B. The Power BI dataset the tile uses as a data source.
  C. The Power BI dashboard that includes the tile.
  C. The Power BI dashboard that includes the tile.

  ---

  Explanation

  In Microsoft Power Apps, when embedding a Power BI tile from Microsoft Power BI into a canvas app, users must have access to the Power BI artifact that contains the tile.

  To meet the requirements:

  Users do not have access to the underlying dataset You must minimize permissions and administrative overhead

  Sharing the Power BI dashboard:

  Grants access to all tiles within the dashboard Avoids giving direct access to the dataset Is the least-privileged and simplest approach

  Option analysis:

  A Sharing the dataset grants broader access than required

  B Duplicate of A (invalid option)

  C Correct (share the dashboard that contains the tile)

  Therefore, you should share the Power BI dashboard that includes the tile.

• Question 296:

  HOTSPOT

  A company uses a canvas app to manage production resources in a specific region. Employees must be at company locations to use the app.

  Due to a sudden requirement for employees to work remotely, employees no longer commute to a specific location to conduct their work and cannot access the canvas app.

  You must reconfigure the app to ensure that employees only access the app from a limited number of locations.

  You need to restrict access to the app.

  Which components should you configure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  References:

  https://docs.microsoft.com/en-us/power-platform/admin/restrict-access-online-trusted-ip-rules

• Question 297:

  You use Power Bl Desktop to configure Power Bl reports and dashboards.

  You need to create a canvas app that displays account information and include the app in a Power Bl report.

  Which three actions should you perform? Each correct answer presents part of the solution.

  NOTE Each correct selection is worth one point.

  A. Publish the report to the Power Bl service.
  B. Connect to Common Data Service from Power Bl Desktop.
  C. Connect Common Data Service from Power Bl Desktop. Selected required fields from the Accounts table.
  D. From the Power Apps Insert menu, add a Power Bl
  E. From the Power Bl Desktop menu, insert a Power Apps visual and include the required fields in the Power Apps data.
  A. Publish the report to the Power Bl service.
  B. Connect to Common Data Service from Power Bl Desktop.
  E. From the Power Bl Desktop menu, insert a Power Apps visual and include the required fields in the Power Apps data.

  ---

  Explanation

  Step 1 (B): Here's how we embed PowerApps into a Power BI report:

  1. Download and login to the Power BI desktop application 2. Click on (...) and select "Import from the marketplace."

  Step 2: Open Power BI desktop and use "Get data" to connect with the Common Data Service data source.

  Step 3: Publish the report to Power BI service.

  References:

  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

• Question 298:

  You are creating a business rule to implement new business logic.

  You must apply the business logic to a canvas app that has a single screen named Screen1.

  You need to configure the scope for the business rule.

  Which scope should you use?

  A. Screen1
  B. Entity
  C. All Forms
  D. Global
  B. Entity

  ---

  Explanation

  Note: Some terminology has changed. Entity is now Table. If you're building a Canvas app, you must use table (entity) as the scope.

  References:

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

• Question 299:

  DRAG DROP

  A company that manufactures medical devices uses Power Apps to manage their sales and device maintenance.

  A table named Devices in Microsoft Dataverse has a column named Status. The Status column must have a new status value of Review added to the existing Choice values of Active and Inactive.

  The table must be added to a solution to be promoted once the change is made.

  Only this change must be promoted to the test environment. The changes must not be able to be changed once promoted.

  You need to add the change to a solution for promotion.

  Select and Place:

  

  

  ---

  In Microsoft Power Apps solutions:

  Add existing is used to include an existing table (Devices) into the solution

  Add subcomponent allows you to include only specific parts of that table (e.g., the Status column changes) instead of the entire table

  This ensures:

  Only the required change (new Choice value "Review") is promoted

  The solution remains minimal and controlled

  Other options are incorrect:

  Add column used to create new columns

  Add required components includes unnecessary dependencies

  Therefore, the correct configuration is:

  Add existing (table)

  Add subcomponent (specific column change)

• Question 300:

  A company uses Power BI dashboards.

  A manager wants to understand the raw data in one of the charts.

  You need to present the data.

  What should you do?

  A. Export the dashboard to Microsoft PowerPoint.
  B. Export the dashboard to Microsoft Excel.
  C. Change to focus mode.
  D. Drill down in the dashboard controls.
  D. Drill down in the dashboard controls.