Microsoft Microsoft Certifications PL-200 Questions & Answers
Question 241:
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
Name
Company
Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create an alternate key for the columns.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: A
Explanation:
Alternate keys are useful for integration projects, when you need to bring into Dynamics data from an existing database into your Dataverse (Dynamics 365, Dynamics CRM, Common Data Service).
A Dataverse column will be set as carrying a unique value for each record.
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
Name
Company
Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create a Microsoft Power Fx formula for the columns.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
Explanation:
Correct Solution: Create an alternate key for the columns.
Alternate keys are useful for integration projects, when you need to bring into Dynamics data from an existing database into your Dataverse (Dynamics 365, Dynamics CRM, Common Data Service).
A Dataverse column will be set as carrying a unique value for each record.
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
Name
Company
Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create a duplicate detection rule for the columns.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
Explanation:
Correct Solution: Create an alternate key for the columns.
Alternate keys are useful for integration projects, when you need to bring into Dynamics data from an existing database into your Dataverse (Dynamics 365, Dynamics CRM, Common Data Service).
A Dataverse column will be set as carrying a unique value for each record.
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.
Correct Answer: B
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.
You are a system administrator for a company with locations in Mexico, United States, and France. The company has both fulltime employees and contractors in all regions. Fulltime employees use a mobile app. The company has two
security groups: fulltime employees and contractors.
The company requests a chatbot in Microsoft Teams to answer employee benefit questions. The chatbot must meet the following requirements:
1.
It must be in the local language.
2.
Only fulltime employees may access the chatbot.
You need to configure the chatbot.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Create one chatbot that managed all three languages.
You can set up a multilingual bot in Power Virtual Agents for contact center.
You can configure routing rules to route voice calls to appropriate agents based on the language that your customer has selected. A multilingual contact center helps you serve global customers who want to interact with your contact center in
the language of their choice. You can also set up bots as the first contact who can handle such requests.
Use Bot Framework Composer in Power Virtual Agents to set up a bot for a multilingual contact center.
The process for setting up the multilingual bot in Power Virtual Agents is as follows:
1.
Create a bot in Power Virtual Agents.
2.
Create a topic in Bot Framework Composer.
3.
Configure the greeting topic in Power Virtual Agents.
4.
Configure the transfer to agent node by using the escalate topic.
5.
Configure workstreams and queues.
6.
Verify the multilingual bot.
Box 2:
Configure the transfer to agent node by using the escalate topic
1.
In Power Virtual Agents, open the Escalate topic in the authoring canvas, and delete all the default messages except the trigger phrases.
2.
Select Add node (+), select End the conversation, and then select Transfer to agent.
3.
Optionally, in Private message to agent, enter the following to fetch the preferred language of the customer.
4.
Customer preferred language is {x} bot.va_CustomerLocale
5.
Save the topic.
6.
In the site map under Manage, select Channels, and then select Microsoft Teams on the Channels page.
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.
Which features should you use? To answer, select the appropriate options in the answer area.
Hot Area:
Correct Answer:
Box 1: Entity
Recognize when a caller states Tennis or any variation of the word.
Prebuilt entities
Out of the box, Power Virtual Agents comes with a set of prebuilt entities, which represent the most commonly used stereotype information in real-world dialogs, such as age, colors, numbers, and names.
Custom entities
The prebuilt entities cover commonly used information types, but on some occasions, such as when building a bot that serves a specific purpose, you'll need to teach the bot's language understanding model some domain-specific knowledge.
For instance, let's say you want to build a bot for an outdoor store. In this case, you'll need to teach the bot to acknowledge the "outdoor gears product" category in a dialog.
Box 2: Topic
Provide options when a caller states the name of a sport.
A topic has trigger phrases and conversation nodes. Trigger phrases are phrases, keywords, and questions that a user is likely to type that are related to a specific issue. Conversation nodes define how a bot should respond to a trigger
phrase and what it should do.
The AI uses natural language understanding (NLU) to parse what a customer types and find the most appropriate trigger phrase or node.
For example, a user might type "Open hours" into your bot. The AI matches that to the Store hours topic, begins a conversation that asks which store the customer is interested in, and then displays the hours the store is open.
Incorrect:
* Variable
Power Virtual Agents uses entities to identify a specific type of information from a user's responses. A variable type is associated with the identified information when it's saved. The variable type is analogous with the entity.
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.
Hot Area:
Correct Answer:
Question 249:
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 BI workspaces.
2.
Schedule the dataflow to update every day at 11:00 AM.
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.
Hot Area:
Correct Answer:
Box 1: Export the JSON file.
Be able to create a copy of the dataflow to separate Power BI workspaces.
You can just click on the menu options for the dataflow and then click on “Export .json” option. This will export the dataflow in a json file format.
The next step is to click New->Dataflow in the workspace where you would like to copy your dataflow to and then use the Import Model option. Then you will need to find and select the json file on your machine and click ok. A copy of your
original dataflow will be created.
Box 2: Configure the Power BI service.
Schedule the dataflow to update every day at 11:00 AM.
SETUP SCHEDULED REFRESH
In the workspace containing the dataflow, there is no Next Refresh on the dataflow. Therefore the dataflow will not refresh automatically.
Click on the three dots on the dataflow row, they appear when your mouse hovers over the row. Select Settings from the options.
1.
Expand Scheduled refresh.
2.
Click on the toggle to turn on scheduled refresh.
3.
Select refresh frequency, daily means every day, weekly means you can select which day of the week.
4.
Select your time zone.
5.
If you have selected weekly, select days.
6.
Click on Add another time and enter the hour, minutes and am or pm for every time you want the refresh to happen.
7.
Leave the tick so you you will be notified if the dataflow refresh fails.
You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query.
The dataflow has the following requirements:
1.
A table of aggregated data must be created in dataflow storage.
2.
A unique identifier must be created for the table.
You need to configure the dataflow.
Which solutions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Computed entity
A table of aggregated data must be created in dataflow storage.
Creating computed entities in dataflows.
You can perform in-storage computations when using dataflows with a Power BI Premium subscription. This lets you do calculations on your existing dataflows, and return results that enable you to focus on report creation and analytics.
To perform in-storage computations, you first must create the dataflow and bring data into that Power BI dataflow storage. After you have a dataflow that contains data, you can create computed entities, which are entities that do in-storage
computations.
Box 2: Alternate key
A unique identifier must be created for the table.
Work with alternate keys
All Microsoft Dataverse table rows have unique identifiers defined as GUIDs. These are the primary key for each table. When you need to integrate with an external data store, you might be able to add a column to the external database tables
to contain a reference to the unique identifier in Dataverse. This allows you to have a local reference to link to the Dataverse row. However, sometimes you can't modify the external database. With alternate keys you can now define a column
in a Dataverse table to correspond to a unique identifier (or unique combination of columns) used by the external data store. This alternate key can be used to uniquely identify a row in Dataverse in place of the primary key. You must be able
to define which columns represent a unique identity for your rows. Once you identify the columns that are unique to the table, you can declare them as alternate keys through the customization user interface (UI) or in the code. This topic
provides information about defining alternate keys in the data model.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Microsoft exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your PL-200 exam preparations and Microsoft certification application, do not hesitate to visit our Vcedump.com to find your solutions here.
