Microsoft Microsoft Certifications PL-200 Questions & Answers
Question 71:
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:
Correct Answer:
Box 1: Add existing
When you add existing tables to your solution don't include them with all the subcomponents (it's a checkbox in the add wizard). This might otherwise create problems with dependencies later.
Box 2: Add required components
A Solution is basically just a container that bundles a list of components. When a component is added to a solution a pointer to the component will be created. This means that when a component that is included in several solutions is changed
it is changed in all of them.
The following picture tries to explain this. When you have two solutions (Solution A and Solution B), both contain the contact table with a certain column. When this columns requirement level will be changed to “Business Required” this
configuration is changed in both solutions.
Incorrect:
* Add subcomponent
When you add existing tables to your solution don't include them with all the subcomponents (it's a checkbox in the add wizard). This might otherwise create problems with dependencies later.
For example, if an ISV adds some field to an OOB table and you include this table to your solution with all subcomponents you might get problems installing a new version of the ISV solution where the mentioned field will be deleted. Reference: https://benediktbergmann.eu/2022/01/18/dataverse-solutions-explained/
Question 72:
DRAG DROP
A company uses a model-driven app with Microsoft Dataverse in a single environment.
The company requires a canvas app that includes the same data as the model-driven app.
You need to create the canvas app.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Step 1: Sign into the Power Apps Maker portal
Power Apps can't be used to create a connected data source, or modify its structure; the data source must already exist in a service somewhere.
Create an app
Sign in to Power Apps and, if necessary, switch environments.
Under Start from, select Dataverse.
Step 2: Select the Dataverse option
If this is your first time, you're prompted to create a connection to Dataverse. Select Create this connection.
Under Choose a table, select your table (such as Accounts for this example), and then select Connect.
If the Welcome to Power Apps Studio dialog box appears, select Skip.
Etc.
Step 3: Select the data source and tables…
Save the app.
You'll probably want to make more changes before you use this app or share it with others. As a best practice, save your work so far before you proceed.
Select Settings.
Set the app name to AppGen, change the background color to deep red, and change the icon to a checkmark.
Set the app name to AppGen, and select Save.
Close the settings dialog.
Near the left edge, select Save as and then, in the lower-right corner, select Save.
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:
Correct Answer:
Box 1: Power Query
The Power Query activity allows you to build and execute Power Query mash-ups to execute data wrangling at scale in a Data Factory pipeline.
To achieve scale with your Power Query activity, Azure Data Factory translates your M script into a data flow script so that you can execute your Power Query at scale using the Azure Data Factory data flow Spark environment.
Box 2: T-SQL
The Microsoft Dataverse business layer provides a Tabular Data Stream (TDS) endpoint that emulates a SQL data connection. The SQL connection provides read-only access to the table data of the target Dataverse environment thereby
allowing you to execute SQL queries against the Dataverse data tables. No custom views of the data have been provided. The Dataverse endpoint SQL connection uses the Dataverse security model for data access. Data can be obtained for
all Dataverse tables to which a user has access to.
Dataverse SQL is a subset of Transact-SQL.
Incorrect:
*
Azure Data Explorer a.k.a Kusto is a log analytics cloud platform optimized for ad-hoc big data queries.
*
Microsoft Power Fx is the new name for the formula language for canvas apps in Power Apps.
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.
A company uses a model-driven app for customer support.
The company has the following requirements for the app:
1.
Send an email in real-time to customers when they enter their email address.
2.
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.
You need to configure the model-driven app.
Select and Place:
Correct Answer:
Box 1: Classic Flow
Send an email in real-time to customers when they enter their email address.
Use Classic Flow We with ‘Send Email’.
Box 2: Power Automate flow
Send an email to customers at the same time every day for cases that are open for more than 24 hours.
Run flows on a schedule
Create a cloud flow that performs one or more tasks (such as sending a report in email).
Once a day, an hour, or a minute.
On a date that you specify.
After a number days, hours, or minutes that you specify.
Create a recurring flow
Sign in to Power Automate.
Select My flows > New flow > Scheduled cloud flow.
Etc.
Incorrect:
*
JavaScript
Would need customization.
*
Power Apps component framework (PCF) control
Power Apps component framework empowers professional developers and app makers to create code components for model-driven and canvas apps. These code components can be used to enhance the user experience for users working
with data on forms, views, dashboards, and canvas app screens.
A company plans to automate the following manual processes by using Power Automate.
You need to identify UI flow types for the two business processes.
Which desktop flow type should you use? To answer, drag the appropriate desktop flow types to the correct business processes. Each desktop flow 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:
Correct Answer:
Box 1: Attended Attended mode To run an attended desktop flow, you need to have an active Windows user session that matches the name of the user configured for your connection. The session must not be locked.
When an attended desktop flow starts on the target machine, we recommend that you avoid interacting with your device until the run completes.
Box 2: Unattended Unattended mode To run unattended desktop flows, the target machine needs to be available with all users signed out.
Prevent users from saving a record if validation from a custom action fails.
Query and update a list of records.
You need to configure processes for the app without using code.
Which processes should you use? To answer, drag the appropriate processes to the correct requirements. Each process 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:
Correct Answer:
Box 1: Business process flow
Prevent users from saving a record if validation from a custom action fails.
Business process flows provide a guide for people to get work done. They provide a streamlined user experience that leads people through the processes their organization has defined for interactions that need to be advanced to a conclusion
of some kind. This user experience can be tailored so that people with different security roles can have an experience that best suits the work they do.
Use business process flows to define a set of steps for people to follow to take them to a desired outcome. These steps provide a visual indicator that tells people where they are in the business process. Business process flows reduce the
need for training because new users don't have to focus on which table they should be using. They can let the process guide them.
Box 2: Cloud flow
Query and update a list of records.
Power Automate has significant advantages over the classic background workflow model; you should consider using Power Automate to automate your processes instead of classic workflow.
Create flows instead of classic Microsoft Dataverse workflows to build new automation processes. Additionally, you should review your existing classic background workflow processes and consider replacing them with flows.
You create a custom table and configure a child table relationship with the contact table. You need to configure the cascading rules for each action.
Which behavior should you use? To answer, drag the appropriate behaviors to the correct actions. Each behavior 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:
Correct Answer:
Box 1: Cascade All Cascade All Perform the action on all referencing table records associated with the referenced table record.
Box 2: Restrict Restrict Prevent the Referenced table record from being deleted when referencing tables exist.
A company uses a Microsoft Power Platform environment.
The company plans to implement a Power Apps app. The application must meet the following requirements:
Audit all user activity and only retain the audit logs for one year.
Annually remove products that were created over a year ago.
You need to configure the automated processes.
What should you configure? To answer, drag the appropriate configurations to the correct requirements. Each configuration 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:
Correct Answer:
Box 1: Environment auditing
Configure auditing for an environment
There are three levels where auditing can be configured: an environment, table, and column. For table auditing to take place, auditing must be enabled at the environment level. For column auditing to take place, auditing must be enabled at
the environment level and the table level.
To enable user access auditing (Log access) or activity logging (Read logs), auditing must be enabled at the environment level.
Box 2: Bulk deletion job
Remove a large amount of specific, targeted data with bulk deletion
The bulk deletion feature helps you to maintain data quality and manage the consumption of system storage by deleting data that you no longer need.
For example, you can delete the following data in bulk:
Stale data.
Data that is irrelevant to the business.
Unneeded test or sample data.
Data that is incorrectly imported from other systems.
With bulk deletion you can perform the following operations:
Delete data across multiple tables.
Delete records for a specified table.
Receive email notifications when a bulk deletion finishes.
Delete data periodically.
Schedule the start time of a recurring bulk delete.
Retrieve the information about the failures that occurred during a bulk deletion.
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.
Select and Place:
Correct Answer:
Box 1: Column
Users need to add an alternate phone number when entering their account information.
Add an extra column for the alternate phone number.
Box 2: View
The users also require a list that displays the customers that do not have an alternate phone number.
Use a view to find the required information.
Question 80:
DRAG DROP
A company plans to add another language to a Microsoft Dataverse environment.
Several components were added or modified in the environment.
You need to ensure that these components get translated.
Which method should you use? To answer, drag the appropriate methods to the correct component types. Each method 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:
Correct Answer:
Box 1: Export and re-import translated text
Microsoft Dataverse supports multiple languages. If you want your solution to be installed for organizations that include different base languages or that have multiple languages provisioned, take this into account when planning your solution.
The following table lists tactics to use along with solution components to include in a solution that supports multiple languages.
* Export and import translations Solution component type: Attributes Charts Dashboards Entity Entity Relationships Forms Messages Option Sets Views
Note:
The standard tables include default text for labels that are available in many different languages. However, when you customize a form, such as adding or changing columns, or create custom tables, you may need the labels for those
components to appear in different languages. You can import translated label text for customized tables for your apps so that the label text displays in languages other than the base language.
High-level process
Export the translations from the solution that contains the tables that you want to translate label text. Then, open the translations XML file and add the translated text.
Import the translations.
Box 2: Create a separate version for each language
*
Separate component for each language Solution component type: Article Templates Email Templates Mail Merge Templates Reports Dialogs
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.
