ExamGecko
Search Search Login
Home Home / Microsoft / PL-200
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You configure and test a user interface (UI) flow. You plan to run the flow as a scheduled flow. The UI flow must run on a Windows 10 device. As part of process automation, the UI flow must sign into the Windows 10 device with the credentials for a user account named User1. You need to ensure that the flow runs during non-peak hours and requires no physical user intervention. What should you do?
You must create a new entity to support a new feature for an app. Records for the entity must be associated with a business unit and specify security roles for the business unit. You need to configure entity ownership. Which entity ownership type should you use?
A company uses a canvas app. Supervisors must approve transactions when a user from the sales department enters a revenue amount that is over $1 million. You need to configure an approval process without using code. What should you create?
A company uses model-driven apps. Users in the sales department enter the first name, last name, and phone number of customers in the app. The users request a single screen in the app to enter the customer data. You need to configure the app. What should you do?
HOTSPOT You configure an alert in Power BI. You need to alert users when the value of a tile exceeds a threshold. To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are building a Power Pages site for a supermarket chain. The company plans to have the managers of individual stores use the site. Managers will authenticate on the site each week by using their corporate identity to update stock information for their store. Managers must be able to add and update stock information for their store only. You need to configure the site security. Solution: Configure table permissions. Does the solution meet the goal?
You create a Power Apps app for Microsoft Teams using Microsoft Dataverse for Teams. Users report that they are unable to view the app in Teams. You need to ensure that users can access the app. What should you do?
A company uses a model-driven app. The app uses a Power Virtual Agents chatbot. The company has two locations in different countries/regions with separate environments for each location. Each location has a development environment, a testing environment, and a production environment. The company uses the Application Lifecycle Management (ALM) process for the environments. You need to create the different Power Virtual Agents bot environments. How many Power Virtual Agents bot environments are required?
A company uses Power Apps. The company plans to create a canvas app that uses a responsive design. You need to configure the app. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
HOTSPOT You create a Power Platform help Desk solution. You need to create a dashboard that displays information on help desk cases that are handled each week. Which dashboard components should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 201 - PL-200 discussion

Report
Export

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.


Question 201
Correct answer: Question 201

Explanation:

Box 1: Power Query

To filter data in a dataflow, you should use Power Query. Power Query is a data connection tool that is part of the Microsoft Power Platform, which allows you to connect to various data sources, transform, and load data into other applications such as Power BI, Excel, and Dataverse. It is a functional, case-sensitive, and data-transformation language that enables you to discover, connect, combine, and refine data sources to meet your business intelligence needs.Power Query allows you to filter data by using its built-in functions and operators. You can filter data by using the filter, sort, and group by functions, as well as by using custom formulas and conditions.You can also use the advanced editor to write complex queries using M code, which is the underlying language used by Power Query.Reference: https://docs.microsoft.com/en-us/power-query/ https://docs.microsoft.com/en- us/power-query/transform/filter-rows-by-condition2nd


Box 2: Power Fx

To filter data in a canvas app, you should use Power Fx. Power Fx is a no-code, low-code, and code- based platform that enables you to build custom business logic and automate workflows in your Power Platform apps. It allows you to create custom formulas and expressions in the app using a functional language, which allows you to filter data in the app.Power Fx can be used to create custom formulas and expressions in the app which can filter data in the app by using its built-in functions and operators. You can filter data by using the filter, sort, and group by functions, as well as by using custom formulas and conditions. You can also use the advanced editor to write complex queries using Power Fx code.Reference: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/power-fx-formulas


Show Answer
asked 05/10/2024
Ali Diaz
31 questions
PreviousPreviousNextNext
User
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms