Exam Prep

Question 1

A company hosts conferences.

You need to enable customers to view upcoming conferences hosted by your company.

Which power apps components should you use?

Answer 1

Power Apps Portal

Question 2

You create an app.

You need to ensure that the app displays data from an Azure SQL Database.

What should you use?

Answer 2

Canvas App

Question 3

You plan to create a web-based knowledge base.

You need to allow suppliers to register themselves to gain access to information stored in the knowledge base.

What should you create?

Answer 3

Portal app

Question 4

A company wants to streamline the new employee onboarding process.

You need to allow new employees to manage their active certifications and work history by using an Excel workbook.

Which Power Apps solution should you use?

Answer 4

Canvas App

Question 5

You build a canvas also. The canvas app is tied to a Microsoft SQL Server database table.

You need to add a control that allows users to modify the values for each column of a row in a table.

Which control should you use?

Answer 5

Edit form

Question 6

You create a canvas app that is connected to a Microsoft Dataverse table.

You need to share the app.

Which two actions should you perform?

Each correct answer presents part of the solution.

Answer 6

Publish the app.
Assign a security role.

Question 7

You configure a canvas app to track and order office stationery. The app allows users to order multiple stationery items.

The items selected by the user must be reset each time a user reopens the app.

You need to store user selections.

Which function should you use?

Answer 7

Collection

Question 8

A company uses SharePoint and Microsoft Power Platform.

You need to create a canvas app from an existing SharePoint list that can view and edit items in the list.

In which two locations can you create this app? Each correct answer presents a complete solution.

Answer 8

Power apps maker portal

SharePoint list

Question 9

You use a Microsoft Dataverse table to store products. You create a canvas app to list the products in the app.

You need to enable users to view the product code, description, and image of each product.

Which control should you use?

Answer 9

Gallery

Question 10

You are configuring site map for model driven app. You need to add a table to the navigation pane on the app. Where should you add the table?

Answer 10

Subarea

Question 11

A company plans to use Microsoft power platform and dataverse to transform its business. The company requires a central backend solution connected to a Dataverse that managers and other employees can use to manage the day-to-day activities related to their business.

The solution must include process guidance to ensure that everyone follows the same procedures. You need to identify the solution that meets the requirements.

What should you select?

Answer 11

Model-driven application

Question 12

A company uses Microsoft power platform. You need to enable users to ask questions with natural language phrases. Which to Microsoft power platform component should you use? Each correct answer presents a complete solution.

Answer 12

Power BI & Power Virtual Agent

The Q&A feature in Power BI dashboard allow users to ask questions of their data using natural language and creates new visualization based on the question and data.

Power virtual agent chat bots can understand the phrases supplied by users in natural language, and can determine the topic and conversation to be used to respond to the user.

Question 13

You need to create an approval process for sales quotes. Which Microsoft power platform component should you use?

Answer 13

Power automate can create approval processes

Question 14

A company has a PowerApps portal that has a list of their retail stores. You need to add retail store hours to the portal.

Which two Microsoft power platform component should you use? Each correct answer represents a complete solution.

Answer 14

A Power BI report or dashboard can be embedded inside a Power Apps portal.

A Power virtual agent chat bot can be integrated into Power Apps portal.

Question 15

You build a canvas app for users to request a new project. You need to build a solution that meets the following requirements:
information about the request must be stored in the SharePoint online list.
When a new item is added to the list, a new team must be created for that project.

Which two actions should you perform? Each correct answer presents part of the solution.

Answer 15

A connection to Microsoft teams must be created to create a new team in teams. An automated flow that is triggered when a new item is added to the SharePoint list where project information is stored, must be created.

Question 16

A company uses Microsoft power platform. The company needs to read text from uploaded images. You need to determine which connector to use. Which connector should you use?

Answer 16

Azure cognitive services can analyze images and extract printed and handwritten text from the image. Azure cognitive services has multiple connectors for Microsoft power platform.

Question 17

A company uses a Microsoft Dynamics 365 customer service. You implement a portal app that allows customers to raise support tickets. You need to enable interactive support functionality in the portal. Which solution should you use?

Answer 17

Power virtual agents can be used to create chat bots, which can be used in portals to support customers with their queries, and without the need to reach a live agent.

Question 18

A company uses Microsoft exchange online. The company receives email messages from his customers. The company wants to determine whether customers are happy satisfied or upset. Email messages must be routed to the proper representative based on sentiment. You need to create a flow in Power Automate that can read and route the messages. Which two action should you perform? Each correctAnswer presents a complete solution.

Answer 18

Using the Azure cognitive service for language, connect her with the sentiment action can be used to analyze sentiment. Connecting to AI builder and using the analyze positive or negative sentiment action can be used to analyze sentiment.

Question 19

You cnfigure security and compliance features in Microsoft power platform. You need to restrict access to all social media connectors. What should you configure?

Answer 19

Data loss prevention policies can be used to control the use of connectors to data and services. DLP policies allow classifying connectors as business and non-business and blocked.

Question 20

A company has three branch offices in New York, Paris, and Madrid. you need to create the Microsoft dataverse in environments, and the Microsoft data verse instances. What should you do?

Answer 20

Create 3 environments, each with one instance.

An environment has only one Microsoft data verse instance. An environment is required to host a Microsoft data verse instance.

Question 21

A company plans to use Microsoft Power Platform to transform its business.

The company wants to digitize its invoice approval process to remove all manual steps.

You need to recommend the appropriate Microsoft Power Platform product.

Which product should you recommend?

Answer 21

Power Automate.

Power Automate is used to build automated workflow solutions, including automated processes and robotic process automations

Question 22

A company uses Power Virtual Agents.

You need to perform actions in Microsoft Dataverse by using a chatbot.

What should you use?

Answer 22

Power Automate.

Power Automate cloud flows can be called from a Power Virtual Agents chatbot. The cloud flow can connect to Microsoft Dataverse to perform actions.

Question 23

A company uses Power Virtual Agents to display information to authenticated users.

You need to retrieve data from a Microsoft Dataverse table.

What should you use?

Answer 23

Actions.

Actions are used to call Power Automate flows that can retrieve information from a Microsoft Dataverse table.

Question 24

A company uses Microsoft 365. All users in the company have a Microsoft 365 license assigned to them.

You plan to create a chatbot using Power Virtual Agents in Microsoft Teams.

You need to identify two features that are unique to the Power Virtual Agents web app.

Which two features should you identify? Each correct answer presents a complete solution.

Answer 24

Allow users outside your company to use the chatbot.

Use the chatbot on your website.

A chatbot created with Power Virtual Agents in Microsoft Teams can only be access by users within your organization. If you need to have a chatbot accessible by external users, you need to create the chatbot using the Power Virtual Agents web app. A chatbot created with Power Virtual Agents in Microsoft Teams can only be deployed to a Microsoft Teams channel. It cannot be embedded in a website. If you need to have a chatbot embedded in your website, you need to create the chatbot using the Power Virtual Agents web app. Chatbots created with Power Virtual Agents in Microsoft Teams can only be used by users with a Microsoft 365 subscription. Chatbots created with the Power Virtual Agents web app require additional licenses to make changes to the bot.

Question 25

A company is considering using Power Pages for its website.

You need to identify the capabilities of Power Pages.

What are two capabilities of Power Pages? Each correct answer presents a complete solution.

Answer 25

Building sites by using low-code tools.

Exposing data in Dataverse to customers.

Power Pages enables low-code makers to build and deploy websites without needing to write code. Power Pages has tools to manage content, including the capability to expose data in Dataverse tables to external users such as customers.

Question 26

You plan to create Power Pages websites on a new Microsoft Power Platform environment.

You need to accelerate the creation of the websites.

Which two types of templates can you use to meet the requirement? Each answer presents a complete solution.

Answer 26

Scenario-Based.

Site design.

Scenario-based templates are complete sites that meet common needs such as registering for afterschool classes, applying for permits, and booking meetings. Site design templates create websites with a set of premade pages with different layouts, images, and colors

Question 27

A company announces its new product launch on a social platform.

The company wants to analyze customers’ reviews on the platform to understand how they feel about its product.

You need to identify the Microsoft Power Platform service the company should use for the analysis.

What should you select?

Answer 27

AI Builder.

Microsoft Power Platform has prebuilt AI Builder models such as the sentiment analysis model that detects positive and negative sentiment in text data. Using this model, you can analyze comments from a social media platform.

Question 28

A company has a customer self-service portal. Customers log complaints through the portal.

You need to extract the city and product name from the complaints before routing them to a specific customer service center.

Which Microsoft Power Platform feature should you use?

Answer 28

AI Builder.

You can use the AI Builder entity extraction model to extract entity information such as city, color, phone number, and location from text. The model can be used in a Power Apps app or in a Power Automate flow.

Question 29

The manager of a retail store wants to provide a self-service solution for customers who want to track their orders.

You need to recommend a solution based on Microsoft Power Platform.

Which solution should you recommend?

Answer 29

Website portal using Power Pages.

Power Pages are intended for external-facing users and allow you to provide customers with a platform where they can track their orders.

Question 30

You need to create a Power Automate flow to allow managers to approve or deny vacation requests.

Which two flow types should you use? Each correct answer presents a complete solution.

Answer 30

Business process flow.

Cloud flow.

Business process flows can be used to allow managers to approve or deny vacation requests. Cloud flows can be used to allow managers to approve or deny vacation requests.

Question 31

A company has an approval process that contains an attachment.

You need to ensure users can access the attachment in the approval notification.

Which three solutions should you use? Each correct answer presents a complete solution.

Answer 31

Email inbox.

Power Automate Portal.

Microsoft Teams.

Emails sent by approvals contain the file attached. Approvals listed inside the Power Automate portal shows the file attached. The Approvals app inside Microsoft Teams shows the file attached.

Question 32

You create a flow by using Power Automate. The flow must notify a user every time a new item is added to a SharePoint list.

You need to ensure an email notification is added to the flow.

What should you use?

Answer 32

Action.

An action does something in a flow. In this case, you will use an action to send an email.

Question 33

You create a Power Automate flow.

A connector in the flow returns an array of objects.

You need to filter the array.

Which connector should you use?

Answer 33

Data Operation.

The Data Operation connector has actions to transform and shape arrays including the Filter Array action.

Question 34

You have a Power Automate flow. You have a JSON array that has contacts information.

You need to combine the First Name and Last Name properties of the array in a new property called Full Name.

Which data operation should you use?

Answer 34

Select.

Select operation allows you to add a new property.

Question 35

A company uses Power Virtual Agents to manage routine customer requests. You use Power Automate to pass these requests to your back-end systems.

You need to mimic the onscreen actions that customer service agents perform manually by using robotic process automation (RPA).

What should you use?

Answer 35

Desktop flow.

Desktop flows perform actions on older applications that do not have an API and for which the only interface is the keyboard, mouse, and screen. Desktop flow actions mimic the onscreen actions that the user performs.

Question 36

A sales company plans to use Microsoft Power Platform and Dataverse to build solutions to help manage its day-to-day operations.

The company requires a solution that at the end of each workday automatically identifies and cancels appointments from the previous workday that are not marked as complete.

You need to create a Power Automate cloud flow that meets the requirement.

Which type of cloud flow should you create?

Answer 36

Schedule flow that runs daily at a specific time.

Scheduled flows run on predefined schedules. When run, they can easily include actions that identify and update multiple records at a time.

Question 37

A company plans to use Power Automate to help digitize its operations.

The company requires a solution that creates invoices in an application that does not include modern APIs.

You need to select the Power Automate flow that meets the requirement.

Which type of Power Automate flow should you select?

Answer 37

Desktop flow.

Desktop flows can be used to record and play back steps that include steps performed in applications where modern APIs are not available.

Question 38

A company uses Microsoft Dataverse to create a data model for a retail organization. The company uses the standard contact table to store customer information.

A customer can order one or more products.

You need to create a relationship between customer and product.

Which type of relationship should you use?

Answer 38

Many-to-Many.

Many-to-many relationships between customer and product will allow multiple products to be associated with multiple orders.

Question 39

You build a solution by using Microsoft Power Platform and Microsoft Dataverse.

You must use the default Currency table that comes with your Microsoft Dataverse subscription.

You need to determine the table type for the Currency table.

Which table type should you identify?

Answer 39

Standard.

Several standard tables, also known as out-of-the-box tables, are included with a Microsoft Dataverse environment. The Currency table is one of those tables.

Question 40

A company is evaluating Microsoft Dataverse and Microsoft Dataverse for Teams.

You need to determine which features are only available in Microsoft Dataverse.

Which two features should you identify? Each correct answer presents a complete solution.

Answer 40

Multiple currency support.

Mobile offline.

Microsoft Dataverse for Teams does not support multiple currencies or Mobile offline. These are unique to Microsoft Dataverse. Microsoft Dataverse and Microsoft Dataverse for Teams both have file and image support. Microsoft Dataverse for Teams also supports relational storage.

Question 41

You plan to create a data model by using Microsoft Dataverse.

You have a column that allows users to select one of two options: Approve or Reject.

You need to allow for adding more options to the column or changing the label of the options in the future.

Which type of column should you create?

Answer 41

Choice.

The Choice field allows user to select a single value from a list of available values. User also have the option not to choose any value from the options. In that case the data for the column will be saved as null in data store.

Question 42

A company has a custom API. The API downloads Microsoft Excel and Microsoft Word files from an internal server.

You need to fetch data inside Power Automate.

Which two connectors can you use? Each correct answer presents a complete solution.

Answer 42

Premium HTTP connector.

Customer connector.

The Premium HTTP connector and a custom connector can fetch data from a custom API.

Question 43

You plan to use the Microsoft Teams connector in a Power Automate cloud flow.

Which two components are defined by the connector? Each correct answer presents a complete solution.

Answer 43

Actions & triggers.

A connector defines the actions that can be performed in the service using the connector. A connector defines how events in the service can trigger a Power Automate cloud flow. The connector defines the operations that can be performed on the service the connector is defined for.

Question 44

A company uses Power BI.

You need to collaborate with others to build visualizations.

What should you use?

Answer 44

Workspace.

Workspaces are used to collaborate on building content for Power BI including datasets, reports, and dashboards.

Question 45

A company manufactures car parts. Some parts are defective.

You create a Power BI report to visually represent defect information.

You need to add a single visualization to the report to show the percentage of defects per part.

Which two visualizations should you use? Each answer presents a complete solution.

Answer 45

Donut chart.

Column combo chart.

Each product can have a slice of the donut chart, with each slice showing the percentage of defects that product has in relation to other products. A combo chart shows two different values in a single chart. In this case, using a combo bar chart, each product can have a bar. Each bar can stand for a single product, with different colors representing the percentage of parts made with and without defects.

Question 46

You create a Power BI report to display information about product sales using Power BI Desktop. You have two Excel spreadsheets named Data1.xlsx and Data2.xlsx.

Data1.xlsx has a table called Table 1. Table 1 has two columns of information:

Product name

Units sold

Data2.xlsx has a table called Table 2. Table 2 has two columns of information:

Toy name

Number sold

You need to combine the data into a single dataset that can be used in the report by using Power Query Editor. The data set must contain the headers Product name and Units sold.

Which two actions should you take? Each correct answer presents part of the solution.

Answer 46

Rename the columns in Table 2 to Product name and Units sold.

Append the data from Table 1 to the data in Table 2.

You must rename the columns from Table 2 for the appended column data to appear in the same columns as the first set of data from Table 1. Otherwise, your combined data would have four columns (Product name, Units Sold, Toy name, and Number sold) instead of 2 (Product name and Units sold). Appending the data from one table to the other will create a single dataset that can be used in the report.

Question 47

You have a table in a Power BI dataset. You add a clustered column chart visual to the report page.

You need to show the count of rows in the table as columns for each category in the table.

Which field well should you add to the row count measure?

Answer 47

Y-Axis.

The field that shows the numeric values, the height of the columns, should be added to the Y-axis in a column chart visual. The field that shows the colors for categories should be added to the legend well.

Question 48

You need to create a Power BI dashboard for Power BI mobile apps.

What should you do?

Answer 48

Edit the phone view.

Phone view is the one that is rendered on Power BI mobile apps. Only reports can have multiple pages. It is not possible to create dashboards using Power BI Desktop or Power BI mobile apps.

Question 49

You need to use Power BI to build a report for a sales manager.

The report must meet the following requirements:

A single-entry point to view data.

A way to drill down into data from a single table, named Sales, in your company’s SQL Server database.

One page that shows sales by date and another page that shows sales by region. Each page should allow users to view the raw data from the Sales table as well as view a bar graph representing the information.

Which two actions should you perform? Each correct answer presents part of the solution.

Answer 49

Create a Power BI report tied to the Sales table.

Create one report with two pages for sales by data and sales by region.

A report can be tied to a single data set and have multiple pages. A Power BI report tied to the Sales table must be created. The requirements state that two pages must be created. Dashboards consist of a single page, but a report can contain more than one page, so one report must be created with multiple pages.

Question 50

A company uses Microsoft Power Platform.

You need to enable users to ask questions with natural language phrases.

Which two Microsoft Power Platform components should you use? Each correct answer presents a complete solution.

Answer 50

Power BI

Power Virtual Agents

The Q&A feature in Power BI dashboards allows users to ask questions of their data using natural language and creates new visualizations based on the question and data.