Microsoft PL-100 Practice Test - Questions Answers, Page 26

A company receives its marketing campaign performance report as a Microsoft Excel file. The company stores the file in Microsoft SharePoint.

A user updates the Excel file daily with updated data.

The company needs a solution that automatically displays the latest analytics.

You need to create a basic report that contains pie charts that display the most profitable channels.

You need to propose the right solution.

Solution: Model-driven application using native charts.

Does the solution meet the goal?

A company receives its marketing campaign performance report as a Microsoft Excel file. The company stores the file in Microsoft SharePoint.

A user updates the Excel file daily with updated data.

The company needs a solution that automatically displays the latest analytics.

You need to create a basic report that contains pie charts that display the most profitable channels.

You need to propose the right solution.

Solution: Microsoft Power Apps canvas app having an Excel file imported into the app and Pie chart control.

Does the solution meet the goal?

A company is using Microsoft Power Platform and Microsoft Teams to approve work contracts.

A manager must view all approved contracts in the past year that the company sent or received. The manager must approve any pending contracts. The solution must minimize effort.

You need to recommend a solution for the company.

What should you recommend?

DRAG DROP

A company plans to use Microsoft Power Platform to modernize their business.

Sales commissions are given only to the representatives who sell items from a designated category of products. The company wants to minimize the effort needed to manage data security.

You need to describe how to store real-world objects to the business stakeholders.

What should you use? To answer, drag the appropriate tables to the correct objects. Each table 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.

DRAG DROP

You are designing a data model for a new app. The app will be supported by two tables. TableA will contain data that is unique to your industry. TableB will provide access to readonly data from an Azure SQL database.

You need to configure the tables.

Which table type should you use? To answer, drag the appropriate table types to the correct tables. Each table 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.

HOTSPOT

A company is using Power Automate to send an email with all active projects that are at risk.

Projects that are stored in a table in Microsoft Dataverse are deemed at risk if the column for a risk score is greater than 70 or has a zero value.

The flow will loop over all the records in the Dataverse Projects table and update the risk status field based on the risk score.

You need to create a single evaluation expression to update the risk status field.

Which expression component should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DRAG DROP

A company uses a canvas app.

The finance team and sales team require access to the canvas app. You must perform the following actions:

* Add members of the sales team to the app as users.

* Add members of the finance team to the app as co-owners.

The app must be shareable with current and future team members.

You need to request creation of group types for team members. This must enable sharing of the app with the least amount of effort.

Which group types should you request? To answer, drag the appropriate group types to the correct activities. Each group 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.

HOTSPOT

You create a canvas app for a finance team.

The finance team members require access to the app. The finance manager must be able to make updates to the app when necessary.

You need to set permissions for the team and the finance manager by using the principle of least privilege.

Which actions should you perform for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You create a canvas app. The current version of the app is 16.

You identify a mistake in version 16 of the app. You restore a previous version of the canvas app. You need to inform others which version of the canvas app they should use for development. Which version should they use?