Q1.For each of the following statements, select “Yes” if the statement is correct, or “No” if it is not.
*Each item is worth one point.
| Statement | Yes | No | |
|---|---|---|---|
| Power BI Desktop can connect to external resources, but the Power BI service cannot connect to external resources. | |||
| You can create and edit Power BI reports using either Power BI Desktop or the Power BI service. | |||
| The only way to distribute a report created in Power BI Desktop is to send the PBIX file to other users. |
Show answer
Both Power BI Desktop and the Power BI service can connect to external resources such as databases and Excel.
Therefore, the first statement is “No”.
Reports can be created and edited in either the Desktop version or the service version, so the second statement is “Yes”.
Distributing a report created in Desktop is not limited to sending the PBIX file; if you publish to the Power BI service, other users can view it online.
Therefore, the third statement is “No”.
What is Power BI? (Comparing Power BI Desktop and the Power BI service)
Q2.You have developed a canvas app in Power Apps.
A colleague on your team needs to be able to actually run the app.
What should you do?
Show answer
The key point of this question is “making it ready to run“.
Simply publishing the app does not guarantee that the colleague can reach it, so you need to share the app with the intended colleague.
You can share by adding the recipient’s email address from the [Share] button in Power Apps, and the colleague receives an email containing a link for access.
They can then sign in with a Microsoft account or organizational account to use the app.
Therefore, A is correct.
Share a canvas app
Q3.A resort hotel wants to set up a checklist that housekeeping staff use when they finish cleaning a guest room.
From a mobile device, staff need to be able to check off each completed task and take a photo of the made bed.
The check results for each room must be saved to a SharePoint list.
You need to choose the Microsoft Power Platform component that meets these requirements.
Which component should you choose?
Show answer
One difference between canvas apps and model-driven apps is the data stores they can use.
A canvas app can treat Excel or SharePoint as a virtual data source, whereas a model-driven app is built on Dataverse.
Because this question requires that the results be saved to a SharePoint list, the canvas app in E is correct.
Power Pages is a tool for building websites (formerly Power Apps portals), and Power Virtual Agents is now part of Microsoft Copilot Studio.
Create a canvas app from a SharePoint list
Microsoft Copilot Studio
Q4.A company uses Power BI to track sales.
Each region has quarterly and annual sales targets.
You need to build a Power BI dashboard that addresses various reporting requirements.
Which chart type should you use?
To answer, drag the appropriate chart type to the correct requirement.
Each chart type may be used once, more than once, or not at all.
*Each item is worth one point.
Drag each option to the matching requirement’s drop zone, or tap to place it. Click a filled zone to send it back. (The same option may be used more than once.)
KPI
Line chart
Matrix
Show answer
A KPI is a visual that makes it easy to judge progress toward a target (whether you are ahead or behind), so the first item is “KPI”.
A line chart is excellent for showing how a series of values changes over time, so the second item is “Line chart”.
The third item requires showing each region’s share of the total sales, and a doughnut chart is well suited to expressing the relationship of parts to a whole, so “Doughnut” is correct.
A matrix is good at aggregation by category and filtered display.
Visualization types in Power BI
Q5.A company uses a cloud app that its IT department built in-house.
This app provides a public API for managing employee availability.
You are creating an automated flow in Power Automate that sends an email to an employee’s manager when the employee is recorded as being on sick leave in the app.
You need to choose the appropriate connector type for the flow.
Select the answer that correctly completes the statement.
Show answer
In Power Automate, you choose the connector type based on the destination you are connecting to.
The standard connectors provided by Microsoft (such as Office 365) and premium connectors are used for destinations that are available by default.
This question requires calling the public API of a cloud app that the IT department developed independently.
When integrating with a proprietary API that has no built-in connector, you create a custom connector and define the API specification to connect, so “Custom” is correct.
Overview of custom connectors
Q6.A company stores customer warranty information in Microsoft Dataverse.
Authenticated and authorized customers need to be able to view their own warranty information without having a Microsoft Power Platform license assigned to them.
You must share the warranty information with these customers.
What should you use?
Show answer
The key to this question is “without requiring a Power Platform license“.
Power BI, model-driven apps, and canvas apps all require the user side to have a Power Platform license.
Power Pages, on the other hand, is a tool for building websites; it can display Dataverse data on the web, and authenticated external customers can access it without a per-user license.
Therefore, C is correct.
What is Power Pages
Q7.A company wants to use Power Automate to send an email alert to a specific employee every time the company is mentioned in a Twitter post.
You need to create a flow to do this.
Select two tools that can create the required flow.
Each correct answer presents a complete solution.
*Each item is worth one point.
Show answer
The intent of this question is “from which device (app) can you create a Power Automate flow“.
Because the trigger is a Twitter post, a desktop flow does not apply, so C is incorrect.
The two basic methods are creating from Power Automate in a browser and creating from the Power Automate mobile app, so A and D are correct.
You can also navigate to the creation screen from Dynamics 365, but there is no need to open it specifically, so it is incorrect.
Overview of the Power Automate mobile app
Q8.You are building a canvas app that lets users record expenses.
The app also supports screen readers for users with visual impairments.
You have the following requirements.
– Use a tool that identifies potential issues.
– Use a tool that offers suggestions for changing the app.
You need a tool that meets these requirements.
Which tool should you use?
Show answer
Running the Accessibility checker in Power Apps detects potential accessibility issues.
Furthermore, it explains why each issue is a barrier for users with a particular disability and even offers suggestions for fixing it.
Because this question calls for a tool that both identifies issues and offers improvement suggestions, C is correct.
The admin center, Trust Center, and flow checker do not apply to this purpose.
Check the accessibility of a canvas app in Power Apps
Q9.You are testing a business process flow in a sandbox environment.
After testing is complete, you need to copy that business process flow to the production environment.
In doing so, you must not carry over any data or other changes.
What should you do to meet this requirement?
Show answer
When releasing from a sandbox environment to a production environment, you follow these steps.
(1) Include the feature to be released in a solution and export it, and (2) import that solution into the production environment.
Therefore, C is correct.
The default solution includes all features in the environment, which violates the requirement not to carry over extra changes, so D is wrong.
Note that because a business process flow stores information in the BPF table, the first time you must include the entity in the solution.
Invalid export – business process entity not found
Q10.You are creating a Power BI dashboard.
Match each option to the correct requirement.
To answer, drag the appropriate option from the left column to the correct requirement on the right.
Each option may be used once, more than once, or not at all.
*Each item is worth one point.
Drag each option to the matching requirement’s drop zone, or tap to place it. Click a filled zone to send it back. (The same option may be used more than once.)
Embed
Get data
Pin
Show answer
The easiest way to let other users access your report or dashboard is “Share”, so the first item is “Share”.
To display Excel data, you first need to connect to the Excel workbook file and get the data, so the second item is “Get data”.
Pinning is an operation you perform after getting data, so it is incorrect in this position.
The operation of adding a report tile to a dashboard is called “Pin”, so the third item is “Pin”.
Share Power BI reports and dashboards with colleagues and others
Get data from Excel workbook files
Pin a tile