ExamGecko
Home Home / Microsoft / PL-200

Microsoft PL-200 Practice Test - Questions Answers, Page 21

Question list
Search
Search

List of questions

Search

Related questions











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


DRAG DROP

A company has a model-driven app that uses Microsoft Dataverse.

Users need to add an alternate phone number when entering their account information. The users also require a list that displays the customers that do not have an alternate phone number. You need to enable the required features.

Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature 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 202
Correct answer: Question 202

HOTSPOT

A company plans to implement a voice-enabled Power Virtual Agents bot. The company has the following requirements for the bot:

• Recognize when a caller states Tennis or any variation of the word.

• Provide options when a caller states the name of a sport.

You need to configure the bot.


Question 203
Correct answer: Question 203

DRAG DROP

A company uses a model-driven app for customer support. The company has the following requirements for the app:

• Send an email in real-time to customers when they enter their email address.

• Send an email to customers at the same time every day for cases that are open for more than 24 hours. The solution should require the least amount of customization.


Question 204
Correct answer: Question 204

HOTSPOT

You use Power Virtual Agents to create a bot that will answer and transfer help desk calls. You create topics that contain nodes and functions. The company has the following requirements for the bot:

• When a caller states the word issue, help, or problem, the bot must respond with the question.

"How can we help you today?"

• When the bot responds with the question, "How can we help you today?", the bot must provide the caller with the choices of hardware, software or other

• When the caller asks a question, the bot must save the response so that it can perform an action on the response. You need to configure the bot.

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


Question 205
Correct answer: Question 205

HOTSPOT

A company plans to implement chatbots by using Power Virtual Agents.

The company has the following requirements for the bots:

• Users in the accounting department must be able to create a bot for frequently asked questions.

• The support desk users must be able to use the bot.

The users must not be able to change environment parameters in the Microsoft Power Platform environment. You need to configure the permissions for the bots.

Which actions should you implement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Question 206
Correct answer: Question 206

DRAG DROP

A company plans to create a Power Virtual Agents chatbot.

The bot has the following requirements:

• Prompt for a location of the customer and the call must be routed to a support agent for the location.

• Transfer support calls at each location to a support bot that uses the Bot Framework.

You need to configure the bot.

Which components should you use? To answer, drag the appropriate components to the correct requirements. Each component 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 select is worth one point.


Question 207
Correct answer: Question 207

HOTSPOT

You plan to create a Power Bi dataflow.

The Power BI dataflow has the following requirements:

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

• 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 208
Correct answer: Question 208

HOTSPOT

You create a canvas app.

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

• Create a new collection variable.

• 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.


Question 209
Correct answer: Question 209

HOTSPOT

You create a model-driven app for an automobile parts help desk.

A help desk agent uses a form to gather information about customers' automobiles in two custom tables. The names of the tables are Client and Automobile, The form must prepopulate the following information about the customer from the client table:

• First name

• Last name

The agent must be able to type the following information about the automobile:

• Automobile make

• Automobile model

You need to implement the form. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Question 210
Correct answer: Question 210
Total 285 questions
Go to page: of 29