Practice Free Microsoft PL-100 Exam Questions Online, PL-100 Free Demo

Question 91 Selectable Answer

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 are developing a model-driven app that uses a Common Data Service database. App users will have a variety of different security roles.
Development and testing must be performed using production data. Multiple testers must be used at each testing stage.
You need to provision and configure new environments for development and testing.
Solution:
✑ Provision sandbox environments named S1 and S2.
✑ Copy the production environment to both S1 and S2.
✑ Use S1 for development and S2 for testing.
Does the solution meet the goal?

A. Yes
B. No

Answer:
Explanation:
A sandbox environment is any non-production environment of Microsoft Dataverse. Isolated from production, a sandbox environment is the place to safely develop and test application changes with low risk.
Reference: https://docs.microsoft.com/en-us/power-platform/admin/environments-overview

Question 92 Written Answer

DRAG DROP
You have the following Common Data Service entities: BusinessContracts and BusinessAccounts.
You need to configure an N:N relationship between the two entities.
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.

Answer:

Explanation:
Step 1: Open the relationship tab of the BusinessContracts entity.
View entity relationships
From the Power Apps portal, select either Model-driven or Canvas design mode.
Select Data > Entities and select the entity that has the relationships you want to view.
With the Relationships tab selected, you can select the following views:
Step 2: Select Add relationship.
Create relationships
While viewing entity relationships, in the command bar, select Add relationship and choose Many-to-many.
Step 3: Select the Business Accounts entity as the related entity.

Question 93 Written Answer

DRAG DROP
A company has the following divisions: wholesale and retail.
The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.
You need to ensure that each user sees data only for the team to which the user is assigned.
How should you secure the report? To answer, drag the appropriate options to the correct action. Each option 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.

Answer:

Explanation:
Graphical user interface, application
Description automatically generated
Box 1: Power BI Desktop
You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.
To define security roles, follow these steps.
✑ Import data into your Power BI Desktop report, or configure a DirectQuery connection.
✑ From the Modeling tab, select Manage Roles.
✑ From the Manage roles window, select Create.
✑ Etc.
Box 2: Power BI Service
After you save your report in Power BI Report Server, you manage security and add or remove members on the server.

Question 94 Written Answer

DRAG DROP
A company uses data from a publicly available web service. You plan to create a tabular report by using Power 81 Desktop to visualize data from the web service.
The data returned in one column is numeric and must be converted to a corresponding text value. The most up-to-date version of the data must always be used.
You need to create the report and make it available only to co workers.
Which four 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select

Answer:

Question 95 Selectable Answer

You need to configure functionality for submitting status reports.
What should you do?

A. Determine whether the application is offline when a user selects submit button and call the Sec () function.
B. Determine whether the application is offline when the app loads. Use the SaveDaca () function in the OnSelect property.
C. Determine whether the application is offline when a user selects the submit button and call the SaveDaca () function.
D. Determine whether the application is offline when the app loads. Use the LoadDaca () function in the Submit button.

Answer:
Explanation:
Scenario: The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report.
When data is submitted offline, the data must be stored in the app until the app is back online.
Mobile users often need to be productive even when they have limited or no connectivity. LoadData and SaveData combine to form a simple mechanism to store small amounts of data on a local device. By using these functions, you can add simple offline capabilities to your app.
The SaveData function stores a collection for later use under a name.
The LoadData function reloads a collection by name that was previously saved with SaveData. You can't use this function to load a collection from another source.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-savedata-loaddata

Question 96 Selectable Answer

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.
A company has locations in multiple countries and regions across four continents.
The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table.
You need to create a visualization that displays the total amount of orders by country/region in USD.
Proposed solution:
Create a custom calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart.
Does the solution meet the goal?

A. Yes
B. No

Answer:
Explanation:
Instead use a calculated field.
Need to calculate the exchange rate in USD.
Calculated columns are calculated in real-time when they are retrieved.
Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes

Question 97 Selectable Answer

1. Topic 1, Wide World Importers

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.

Background
Current environment
Sales representatives submit weekly status reports to regional managers. There is no standardized format for these status reports. The process for managing status reports is challenging.

Wide World Importers has decided to use Microsoft 365, Microsoft Azure, and Power Platform for future app development. Both Wide World Importers and Tailwind Traders have identical Microsoft SharePoint and Azure configurations. Both companies use separate tenants.

Requirements
Application
You must create a mobile app to streamline the creation of status reports by sales representatives. You must make the same app available to Tailwind Traders.
The mobile app must meet the following requirements:
- Minimize the use of code.
- Use formulas and expressions when necessary.
- Support a variety of visual layouts.
- Use a SharePoint list to store information about regional managers and sales representatives.
- Use Azure SQL Database to store other data.

Status reports
- Sales representatives must provide a weekly status report for all work processes each Monday.
- Representatives must enter the following information for each process:

- If a sales representative submits a status report and assigns the At Risk status to a process, the app must prompt the sales representative to enter a detailed description for the risk. This information must be emailed to the regional manager. If the category is Work/life balance, the information must be carbon copied to the human resources department.
- If a sales representative does not submit a weekly status report by an agreed upon deadline, the system must send an email to remind the sales representative.
- The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report.
- You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.
- When data is submitted offline, the data must be stored in the app until the app is back online.

Technical
Regardless of the UI layouts, the data recorded must be standardized in the Azure DB tables. You must use global variables in the app.

Deployment
- Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and performance guidelines.
- The completed app and all supporting components must be provided to Tailwind Traders.
- Tailwind Traders must not be able to make changes to any of the components.
- You must use the following version control numbering scheme:
Major: The last two digits of the year the app is packaged
Minor: Two digits that represent the month when the app is packaged
Build: A number that is incremented to represent significant changes to the app
Revision: The incremented revision for a package
- New versions of the application must completely replace previous versions of the app.
- When identifying versions of the app solution, all dependencies, entities, and user interfaces components must be identified to avoid any unintentional issues caused by reverting individual components to a previous version.
- Previous versions of the mobile app must be available for roll back purposes.
- All versions of software that have been used in production must be retained for five years.

Issues
The mobile app has been live for several months. Eight versions of the app have been released since the initial version of the app was deployed to sales representatives. You must revert the app to an earlier version and redesign some features.

User1 often works in a warehouse that does not have internet connectivity. User1 needs to edit an existing status report and submit a new status report.

Several sales representatives have accessibility restrictions. User2 is visually impaired and cannot see images. User3 is unable to use a mouse.

You need to provide the app to Tailwind Traders.
What should you do?

A. Within Managed Properties, set the value of the Allow customizations option to true. Export the app as a managed solution.
B. Use the Share App feature.
C. Within Managed Properties, set the value of the Allow customizations option to false. Export the app as a managed solution.
D. Within Managed Properties, set the value of the Allow customizations option to false. Export the app as an unmanaged solution.

Answer:
Explanation:
Scenario: The completed app and all supporting components must be provided to Tailwind Traders. Tailwind Traders must not be able to make changes to any of the components.
Managed Solution: A managed solution is a finalized solution that can be distributed and installed. They are created by exporting an unmanaged solution by setting restrictions to prevent any further customizations. The whole point of Managed is locking down the Component states so they cannot be edited. Deleting the Managed Solution will remove all its customisations as well as data contained. Managed Solutions become read only once deployed so they cannot be manipulated.
Reference: https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Managed-vs-Unmanaged/td-p/495685

Question 98 Selectable Answer

You need to create the mobile app.
Which type of app should you create?

A. model-driven app
B. portal app
C. Microsoft 365 web app
D. canvas app

Answer:
Explanation:
An accessible canvas app will allow users with vision, hearing, and other impairments to successfully use the app. In addition to being a requirement for many governments and organizations, following the below guidelines increases usability for all users, regardless of their abilities.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/accessible-apps

Question 99 Selectable Answer

You have a Power Apps solution that includes three model-driven apps, a business process flow, and a scheduled flow. The solution is deployed to a datacentre in the United States.
You plan to deploy the solution to Canada.
You need to identify applicable government regulations for all components of the solution.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. View results in the Service Trust portal.
B. Check the results of the Solution checker.
C. Identify regulations for the region where the tenant resides.
D. Identify all regulations for the region where the Common Data Service database resides.
E. Configure data loss prevention (DLP) policies in the Power Platform Admin center.

Answer:
Explanation:
A: The Microsoft Service Trust Portal provides a variety of content, tools, and other resources about Microsoft security, privacy, and compliance practices.
D: The Service Trust Portal contains details about Microsoft's implementation of controls and processes that protect our cloud services and the customer data therein.
Reference: https://docs.microsoft.com/en-us/microsoft-365/compliance/get-started-with-service-trust-portal

Question 100 Written Answer

HOTSPOT
You need to create a model-driven app without using code.
Which tools should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:
Graphical user interface, application
Description automatically generated
Box 1: App designer
As an app maker, you can create and edit public views by using Power Apps.
Box 2: Site Map designer
Site maps define the navigation for your app. Create a site map for your app with ease by using the tile-based site map designer.

Question 101 Written Answer

HOTSPOT
A company is creating new app for use by technicians.
Previous versions of the app do not render properly on tablets and phones.
You need to ensure that the new app renders properly on all devices.
Which design element should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:
Graphical user interface, text, application
Description automatically generated
Box 1: Tablet form factor
Box 2: Aspect version
Customize a canvas app by changing its screen size.
✑ Sign in to Power Apps.
✑ Open the app to edit.
✑ Select Settings.
✑ Select Display.
✑ (Tablet apps only) Under Aspect ratio, perform either of these steps:
✑ Select the ratio that matches the target device for this app.
✑ Select Custom to set your own size, and then specify a width between 50 - 3840 and a height between 50 - 2160.

Question 102 Selectable Answer

You use a Microsoft SharePoint list to record information about customers.
You must perform a series of actions only when a new item is added to a SharePoint list.
You need to configure a Power Automate flow.
Which trigger should you use?

A. When an item is created
B. When an item is created or modified
C. When a file is created (properties only)
D. For a selected item

Answer:
Explanation:
Trigger - When an item is created
Triggers when an item is created.
MS Flow will trigger when an item is created in the list. It will return all list item properties which can be used in the Flow.
Reference: https://www.c-sharpcorner.com/article/sharepoint-based-triggers-in-ms-flow-part-2/

Question 103 Written Answer

HOTSPOT
You need to configure the app to meet the requirements.
Which object properties should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:
Box 1: Fill
Scenario: You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.
Fill C The background color of a control.

Question 104 Written Answer

HOTSPOT
Rangers in national parks report wildlife they encounter during patrols. The rangers record observations in a notebook when they are on patrol. The rangers manually enter observation data when they are in the office. You are designing an app that allows rangers to record their observations while they are on patrol.
The wildlife is modeled as a custom table named Wildlife. The model has relationships to the annotation entity and to a custom entity named Wildlife Details. In the Wildlife Details entity, rangers capture more information as they observe an animal’s habitat. When observing wildlife, rangers must indicate whether an animal requires medical attention. The app must synchronize and save data to Common Data Service when connectivity is available.
You need to design the app.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:
Box 1: Enable the Wildlife entity and the annotation entity for mobile offline
Note: As part of the 2020 Wave 2 release, we made generally available offline capabilities for model driven apps for users of Power Apps. Makers and administrators can now configure apps to be available offline on a user’s device, and users can continue to complete their tasks against the local cache on their phone even with intermittent or no network connectivity. When the network is re-established, the users’ changes are seamlessly synchronized back to the cloud.
Box 2: Enable attachments on the Wildlife Details entity and enable Wildlife Details entity for mobile offline.
Box 3: Create a business process.
Business process flows. Ensure that people enter data consistently and follow the same steps every time they work in an app by creating a business process flow.
Note: Power Automate includes several types of processes, each designed for a different purpose:
✑ Automated flows. Create a flow that performs one or more tasks automatically after it's triggered by an event.
✑ Button flows.
✑ Scheduled flows. Create a flow that performs one or more tasks on a schedule such as once a day, on a specific date, or after a certain time.
✑ Business process flows. Ensure that people enter data consistently and follow the same steps every time they work in an app by creating a business process flow.
✑ Workflows and actions. Dynamics 365 customizers may be familiar with the classic Microsoft Dataverse processes, which are workflows and actions.

Question 105 Written Answer

HOTSPOT
Inspectors for a city building department use a Microsoft Teams channel, inspectors use SharePoint to view construction bylaws, rules, and regulations.
The city clerk email inspectors links to new bylaw proposal, inspectors vote on the proposals and provide additional feedback.
You need to demonstrate to the city clerk how they can automate the process
Which option should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Test Online Free Microsoft PL-100 Exam Questions and Answers