Power Platform PL-900 Study Assessment

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.

* Actions Credentials Postman collection * Triggers This item tests the candidate's knowledge of using connectors to access services and data. 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. When you add a connector to a flow, you supply the credentials required for the service. A Postman collection can be used to create a custom connector, but it does not define the components for an out-of-the-box connector such as the Microsoft Teams connector.

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 a 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. Select all answers that apply. Add a connection to Microsoft Teams. Create an instant cloud flow. Create an automated cloud flow. Add a connection to Microsoft Project.

* Add a connection to Microsoft Teams. Create an instant cloud flow. * Create an automated cloud flow. Add a connection to Microsoft Project. This item tests the candidate's knowledge of how to build a solution using Microsoft Power Platform that connects various applications in Microsoft 365, including SharePoint and Microsoft Teams. 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. An instant flow has a manual trigger. The requirements state that a new team must be created automatically. Microsoft Project is not required for this solution.

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.

* Allow users outside your company to use the chatbot. Allow users inside your company to modify the chatbot without additional licensing. Create a chatbot using a template. * 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

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?

* Collection Dataverse SharePoint Variable The item tests the candidate's knowledge of where to temporarily store a collection of records in an app. Collection in a canvas app can be used to store data temporarily within the app. The collection is lost when a user reopens the app. The Clear function can also be used to clear a collection on demand. Items selected by the user are specific to the session and should not be saved in Microsoft Dataverse or SharePoint. Variables are used to store a single value or an object. They cannot be used to store multiple items.

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? Select only one answer. Collection Dataverse SharePoint Variable

* Collection Dataverse SharePoint Variable The item tests the candidate's knowledge of where to temporarily store a collection of records in an app. Collection in a canvas app can be used to store data temporarily within the app. The collection is lost when a user reopens the app. The Clear function can also be used to clear a collection on demand. Items selected by the user are specific to the session and should not be saved in Microsoft Dataverse or SharePoint. Variables are used to store a single value or an object. They cannot be used to store multiple items.

A company uses a third-party customer service solution. The solution is on-premises and uses Microsoft SQL Server as the data store. You need to show the customer service data in a canvas app. What should you use? Connector AI Builder Power Virtual Agents Power BI

* Connector AI Builder Power Virtual Agents Power BI The item tests the candidate's knowledge of how to consume data from third-party apps. Identifying the right component to fetch data from an external source is a fundamental skill to understand the business value of Microsoft Power Platform. The SQL server connector can be used to connect to Microsoft SQL Server databases and perform CRUD operations. AI Builder is a tool for creating models and classification that can add intelligence to apps and flows. Power Virtual Agents allows creating chatbots for support scenarios. Power BI is used for analytics and creating visualizations. AI Builder, Power Virtual Agents, and Power BI cannot be used to fetch data from an external Microsoft SQL Server database.

A company uses a third-party customer service solution. The solution is on-premises and uses Microsoft SQL Server as the data store. You need to show the customer service data in a canvas app. What should you use?

* Connector AI Builder Power Virtual Agents Power BI The item tests the candidate's knowledge of how to consume data from third-party apps. Identifying the right component to fetch data from an external source is a fundamental skill to understand the business value of Microsoft Power Platform. The SQL server connector can be used to connect to Microsoft SQL Server databases and perform CRUD operations. AI Builder is a tool for creating models and classification that can add intelligence to apps and flows. Power Virtual Agents allows creating chatbots for support scenarios. Power BI is used for analytics and creating visualizations. AI Builder, Power Virtual Agents, and Power BI cannot be used to fetch data from an external Microsoft SQL Server

A company uses Microsoft Power Platform. You model the data in Microsoft Dataverse and create a model-driven app. You need to create a new model-driven app for a different group of users. The model-driven app must restrict the columns in a table that users can change the values. Which two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply. Create a new form for the Microsoft Dataverse table. Create a business process flow. Select the form in the app designer. Create a new view. Create a new form for the Microsoft Dataverse table. Create a business process flow. Select the form in the app designer. Create a new view.

* Create a new form for the Microsoft Dataverse table. Create a business process flow. * Select the form in the app designer. Create a new view. This item tests the candidate's knowledge of modifying forms in model-driven apps. Model-driven app forms are linked to a Microsoft Dataverse table. A form displays a subset of the columns for that table. To enable a different group of users to edit different fields, a new form should be created. A Microsoft Dataverse table can have multiple forms containing different columns from the table and different layouts. The app designer can select which of the forms is available in the app. Business process flows are associated with a Microsoft Dataverse table not the forms for the table. A view displays columns from the table but as a list. A form is required to edit the data.

A company uses Microsoft Power Platform. You model the data in Microsoft Dataverse and create a model-driven app. You need to create a new model-driven app for a different group of users. The model-driven app must restrict the columns in a table that users can change the values. Which two actions should you perform? Each correct answer presents part of the solution.

* Create a new form for the Microsoft Dataverse table. Create a business process flow. * Select the form in the app designer. Create a new view. This item tests the candidate's knowledge of modifying forms in model-driven apps. Model-driven app forms are linked to a Microsoft Dataverse table. A form displays a subset of the columns for that table. To enable a different group of users to edit different fields, a new form should be created. A Microsoft Dataverse table can have multiple forms containing different columns from the table and different layouts. The app designer can select which of the forms is available in the app. Business process flows are associated with a Microsoft Dataverse table not the forms for the table. A view displays columns from the table but as a list. A form is required to edit the data.

You need to identify the capabilities of the Power BI service compared to Power BI Desktop. Which two features are only available in the Power BI service? Each correct answer presents a complete solution.

* Dashboards Measures Reports * Workspaces

ou create Power BI reports by using Power BI Desktop. You need to recommend how to create a relationship between the two tables in Power BI Desktop. Which two sections should you recommend? Each correct answer presents a complete solution. Select all answers that apply. Data Report Model Filters

* Data Report * Model Filters This item tests the candidate's knowledge of familiarity with Power BI Desktop to build a basic dashboard. From the data section, you can use the manage relationships option to create a relationship between two tables. From the model section in Power BI Desktop, a relationship can be created by using the Manage relationship option. The report section allows creating visualizations from the data source. The filters section allows users to filter visuals based on data fields. The report and filters sections cannot be used to create relationships between tables in designer.

You build a canvas app. 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 the table. Which control should you use?

* Edit form Data table Gallery Vertical container

A company has a Power Apps portal. You need to send a notification each week by using a third-party service. The notification must contain a summary of the records created inside the Power Apps portal. Which Microsoft Power Platform component should you use?

* Power Automate Power BI Power Virtual Agents Microsoft Dataverse

You create a chatbot in Microsoft Teams by using Power Virtual Agents. You need to configure the chatbot to identify when an email address is included in a user's response to the chatbot. What should you use? Select only one answer. Prebuilt entities Custom entities Variables Topics

* Prebuilt entities Custom entities Variables Topics The item tests the candidate's knowledge of entities in Power Virtual Agents. Entities in Power Virtual Agents represent a certain type of real-world subjects, like a phone number, zip code, city, or even a person's name. Power Virtual Agents has prebuilt entities to capture common information like name, age, phone number, etc. including email addresses. Custom entities are not required since there are prebuilt entities which capture email addresses. Variables in Power Virtual Agents store customer responses that can be later used in the conversation. Topics in Power Virtual Agents are used to configure trigger phases that decide the flow of conversation. They cannot be used to capture a user's response.

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. Select all answers that apply. Premium HTTP connector Custom connector Word Online (Business) connector Excel Online (Business) connector

* Premium HTTP connector * Custom connector Word Online (Business) connector Excel Online (Business) connector

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.

* Premium HTTP connector * Custom connector Word Online (Business) connector Excel Online (Business) connector

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. Select all answers that apply. Rename the columns in Table 2 to Product name and Units sold. Pivot the Units sold column. Transpose Table 2. Remove the columns Toy name and Number sold from Table 2. Append the data from Table 1 to the data in Table 2.

* Rename the columns in Table 2 to Product name and Units sold. Pivot the Units sold column. Transpose Table 2. Remove the columns Toy name and Number sold from Table 2. * Append the data from Table 1 to the data in Table 2. This item tests the candidate's knowledge of the kinds of actions that can be taken in Power Query Editor to clean and transform data, as well as how to combine data from multiple data sources. 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. Pivoting the Units Sold column will transform the table in a way that makes the data unmeaningful. Transposing Table 2 will make the rows columns and the columns rows, which does not achieve the goal of combining data into a single dataset. Removing the columns from Table 2

You plan to build a Power Apps app to meet the following requirements: App must be developed and tested in a non-production environment. App makers must be able to share the app with any user in the tenant. App will be updated twice a year. Ability to restore the environment from a backup. You need to determine which type of Microsoft Power Platform environment to use for the app. What should you use? Sandbox Trial Microsoft Dataverse for Teams Default

* Sandbox Trial Microsoft Dataverse for Teams Default This item tests the candidate's knowledge of different environment types. A sandbox environment can be used for development and testing and is separate from a production environment. A Power Apps app in a sandbox environment can be shared with any user in the Azure AD tenant to which the environment is associated. A trial environment is limited to a single user and expires after 30 days. A Microsoft Dataverse for Teams environment is restricted to users who are a member of the associated team. The default environment cannot be backed up.

You create a canvas app. You add a label control to your screen. You need to set the text color to red. What are three possible ways to achieve this goal? Each correct answer presents a complete solution.

* Select the label control. Select the color picker control in the toolbar and choose red from the color menu. Select the label control. Choose the Fill property in the formula bar. Set the formula value to Color.Red. * Select the label control. Choose the Color property in the formula bar. Set the formula value to Color.Red. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Fill property and add Color.Red to the textbox. * Select the label control. Open the Properties pane and choose the Advanced tab. Find the Color property and add Color.Red to the textbox. This item tests the candidate's knowledge of the use case for formulas in Power Apps, as well as both a low-code and no-code way of accomplishing the same task in a canvas app. You can change the color of a label's text by choosing a color from the color picker in the toolbar. You can also use the color enumeration to set the Color property of a label control, which can be done in the formula bar or in the Properties pane. Fill will set the background color of the control, not the text color.

You create a canvas app. You add a label control to your screen. You need to set the text color to red. What are three possible ways to achieve this goal? Each correct answer presents a complete solution. Select all answers that apply. Select the label control. Select the color picker control in the toolbar and choose red from the color menu. Select the label control. Choose the Fill property in the formula bar. Set the formula value to Color.Red. Select the label control. Choose the Color property in the formula bar. Set the formula value to Color.Red. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Fill property and add Color.Red to the textbox. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Color property and add Color.Red to the textbox.

* Select the label control. Select the color picker control in the toolbar and choose red from the color menu. Select the label control. Choose the Fill property in the formula bar. Set the formula value to Color.Red. * Select the label control. Choose the Color property in the formula bar. Set the formula value to Color.Red. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Fill property and add Color.Red to the textbox. * Select the label control. Open the Properties pane and choose the Advanced tab. Find the Color property and add Color.Red to the textbox. This item tests the candidate's knowledge of the use case for formulas in Power Apps, as well as both a low-code and no-code way of accomplishing the same task in a canvas app. You can change the color of a label's text by choosing a color from the color picker in the toolbar. You can also use the color enumeration to set the Color property of a label control, which can be done in the formula bar or in the Properties pane. Fill will set the background color of the control, not the text color.

You create a canvas app that displays sales information from a SQL Server database. You must meet the following requirements: The sales manager can use the canvas app to view sales data in the SQL Server database. The sales manager cannot edit the app. Other users should not be able to search for and find the app. Which two actions should you perform? Each correct answer presents part of the solution.

* Share the app with the sales manager. Make the sales manager a co-owner of the app. * Grant the sales manager read-only access to the data stored in the SQL Server database. Publish the app to Microsoft AppSource.

You plan to create a Power BI report to display a company's sales data. The sales team has prebuilt reports in Power BI that contain sales data. You need to recommend a solution that allows users to reuse the same dataset to build their own reports and dashboards. What should you recommend? Select only one answer. Share the dataset containing sales data. Share the reports in the dashboard. Share the dashboard. Create and share a Power BI app.

* Share the dataset containing sales data. Share the reports in the dashboard. Share the dashboard. Create and share a Power BI app. The item tests the candidate's knowledge of how to use shared datasets. A dataset can be shared and can be used to create new reports and dashboards. Sharing a report only allows a user to interact with the report. Users will not be able to create new reports and dashboards from the dataset of the report. Sharing a dashboard only allows a user to interact with the dashboard. Users will not be able to create new reports and dashboards from the underlying dataset. When an app is shared, reports and dashboards can only be viewed in the app.

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? Select only one answer. Standard Activity Custom Virtual

* Standard Activity Custom Virtual This item tests the candidate's knowledge of the types of Microsoft Dataverse tables. 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. An activity table holds the type of information for which an entry can be made on a calendar. The Currency table is not an activity table. Custom tables are unmanaged tables that were created directly in the Microsoft Dataverse environment. In this scenario, an out-of-the-box table is being used, so it is not custom. A virtual table is a custom table that has columns containing data from an external data source. In this scenario, external data is not being accessed and a virtual table is not required.

A company uses Microsoft Power Platform. You need to identify the features of model-driven apps. What are three features of model-driven apps? Each correct answer presents a complete solution.

* They adjust the layout of the UI automatically in response to changes in a device's orientation or screen resolution. They connect to multiple data sources. They control navigation between forms by using Microsoft Power Fx formulas. * They embed Power BI dashboards. * They guide users by using business process flows.

A company uses Microsoft Power Platform. You need to identify the features of model-driven apps. What are three features of model-driven apps? Each correct answer presents a complete solution. They adjust the layout of the UI automatically in response to changes in a device's orientation or screen resolution. They connect to multiple data sources. They control navigation between forms by using Microsoft Power Fx formulas. They embed Power BI dashboards. They guide users by using business process flows.

* They adjust the layout of the UI automatically in response to changes in a device's orientation or screen resolution. They connect to multiple data sources. They control navigation between forms by using Microsoft Power Fx formulas. * They embed Power BI dashboards. * They guide users by using business process flows. This item tests the candidate's knowledge of the capabilities of model-driven apps. Model-driven apps are based on a single data source, which is Dataverse. Model-driven apps use the data model and relationships in Dataverse to control navigation between records. Model-driven apps have a predefined UI model, and one of the benefits of this UI model is that the components you create are automatically able to respond to different screen resolutions and orientations. Model-driven apps are composed of components, and many components can be easily added to model-driven apps, such as Power BI dashboards and business process flows. Model-driven app components are no-code and do not require Power Fx to change the component's functionality or control navigation.

A coworker creates a custom AI Builder model that classifies text based on historical classification. You are creating a Power Automate cloud flow in which you add the AI Builder action named Classify text into categories with one of your custom models. The coworker's custom AI Builder model is not available in the list for that action. You confirm that the Environment Maker security role is assigned to your profile. You need to ensure that the custom AI Builder model is available in the list. What should you ask the coworker to do?

* Train the model and publish the model. Change the name of the model .Include additional historical data for the model. Assign you the Basic User security role. This item tests the candidate's knowledge of the lifecycle to create an AI Builder model. By training the model and then publishing it, it will become available for Power Automate cloud flows. Changing the model's name will not affect its availability in the list. Adding more training data to the model will have no impact on its availability in the cloud flows. The Basic User security role does not allow the creation of flows using AI Builder custom models. The currently assigned role of Environment Maker is sufficient.

You create a Power Pages site. You need to share Dataverse data with external users. Which two components in Power Pages can you use to display data? Each correct answer presents a complete solution. Select all answers that apply. form iframe list text

* form iframe * list text This item tests the candidate's knowledge of how to share data externally by using Power Pages. Form and list components can be added to a web page in a Power Pages site to expose data from Dataverse to external customers. A form component displays rows from a table and can also be used to create and edit rows in the table. A list component displays a read-only view of the data in a Dataverse table. A text component displays static text and cannot display data from Dataverse. An iframe component is used to embed a web page from another website by using a URL, and it cannot display data from Dataverse.

A company plans to use AI Builder to improve business productivity. You need to determine which prebuilt AI models are available for use. Which three types of models are available? Each correct answer presents a complete solution. Select all answers that apply. sentiment analysis text recognition language detection object detection document processing

* sentiment analysis * text recognition * language detection object detection document processing This item tests the candidate's knowledge of available prebuilt models in AI Builder. AI Builder has prebuilt models you can use directly in Power Apps applications or Power Automate flows. The sentiment analysis, text recognition, and language detection models are prebuilt models that are available in AI Builder. There are also custom AI Builder models such as object detection, category classification, and document processing.

A company uses Microsoft Power Platform. The company builds Power Apps canvas apps, Power BI dashboards, and Power Virtual Agents chatbots. You need to identify the Microsoft Power Platform component that can be used directly with these three components. What should you identify?

AI Builder Model-driven apps * Power Automate Microsoft Dataverse

A company has a public-facing portal for its partners. You need to fetch data from the portal in a flow. Which solution should you use?

AI Builder connector * Custom connector Microsoft Dataverse connector Dataflow The item tests the candidate's knowledge of connectors in Microsoft Power Platform. Custom connectors can be used to connect to custom APIs and pull data, in the absence of a prebuilt connector. AI Builder connector enables adding intelligence to automated processes, predicting outcomes, and helping improve business performance. Microsoft Dataverse connector is used to perform data operations against a Microsoft Dataverse data store. It cannot be used to fetch data from a custom-built portal. Dataflows are used to extract and transform data. They cannot be used to fetch data in a Power Automate flow.

A company uses Microsoft Power Platform. You need to describe the features of Power Apps. What are two features of a canvas app? Each correct answer presents a complete solution.

Access apps anonymously. * Control functionality with Microsoft Power Fx formulas. Embed entire Power BI dashboards. * Include artificial intelligence.

A company uses a model-driven app for customer data management. You create a new column. Users report that they cannot view the column when they edit records. You need to ensure users can view the column. Which two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply. Add the column to the view. Add the column on the form. Publish customizations. Add a page.

Add the column to the view. * Add the column on the form. * Publish customizations. Add a page. This item tests the candidate's knowledge of modifying forms in model-driven apps. In model-driven apps, forms provide the UI that users can use to interact with the underlying Dataverse table data. A form allows a user to view or edit a record. If a new column is added to a Dataverse table, the column is not added to the form. To make the column available to users, the column must be added to the form and then published to ensure the changes are available to users. Views in Dataverse will display the list of records in a table based on filter criteria. Adding the column to a view will not enable users to edit the column value. Tables in model-driven apps can be added through pages. This does not affect column visibility on forms.

A company uses Microsoft Dataverse. You plan to create a one-to-many relationship between two tables named TableA and TableB in Microsoft Dataverse. You need to identify the column data type that is created for the relationship in TableB. What should you identify?

Alternate key Customer * Lookup Primary key

A company uses Power Automate cloud flows to automate data processing. You plan to build a flow. You need to enter identical data that will be referenced in multiple paths in the flow only once. Which action should you add to the flow? Apply to each Compose Condition Switch

Apply to each * Compose Condition Switch This item tests the candidate's knowledge of using flow steps to perform data operations. Compose creates an array that you can reference later in the flow. Apply to each is a loop that processes each record in a set of data in turn. A condition is used for if...then...else logic to control the actions taken in a flow. A switch action is used to perform different actions depending on a value in the flow.

You build a Power Virtual Agents bot. You add a topic to the bot. You need to train the bot to understand how someone might ask for a topic. What should you add to the bot?

Ask a question Call an action Show a message * Trigger phrases

You build a Power Virtual Agents bot. You add a topic to the bot. You need to train the bot to understand how someone might ask for a topic. What should you add to the bot? Ask a question Call an action Show a message Trigger phrases

Ask a question Call an action Show a message * Trigger phrases

You create a Power Automate cloud flow that uses a standard connector. A feature that you plan to add is not included in the list of actions that are available for this connector. On the website from the publisher of the connector, you review the modern API information about the feature. You need to add the feature to the cloud flow. What should you do? Select only one answer. Assign a Power Automate Per Flow license to the cloud flow. Assign a user that has more permissions to the connector. Ask a user who has the System administrator security role to edit the cloud flow. Create a custom connector and use it in the cloud flow.

Assign a Power Automate Per Flow license to the cloud flow. Assign a user that has more permissions to the connector. Ask a user who has the System administrator security role to edit the cloud flow. Create a custom connector and use it in the cloud flow. This item tests the candidate's knowledge of connector components and the differences between standard, premium, and custom connectors. Based on the API documentation, you can create a custom connector that will let you add the new feature. Assigning a Power Automate Per Flow license to the cloud flow will not impact the connector's list of actions. Changing the connection for a different user will only impact the data permissions; it will not add new features to a connector. The security role of the user editing the cloud flow has no impact on the connector's list of actions.

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?

Azure Blob storage Azure Cognitive Services Microsoft Dataverse Microsoft Teams This item tests the candidate's knowledge of consuming Microsoft Azure services including Azure Cognitive Services. 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. Azure Blob storage has a connector, but it is used for storing and accessing files, not analyzing the contents of the files. Microsoft Dataverse can store files but cannot analyze the contents of the files. The Microsoft Teams connector can create channels and post messages but cannot analyze files.

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? Azure Blob storage Azure Cognitive Services Microsoft Dataverse Microsoft Teams

Azure Cognitive Services This item tests the candidate's knowledge of consuming Microsoft Azure services including Azure Cognitive Services. 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. Azure Blob storage has a connector, but it is used for storing and accessing files, not analyzing the contents of the files. Microsoft Dataverse can store files but cannot analyze the contents of the files. The Microsoft Teams connector can create channels and post messages but cannot analyze files.

A company uses GitHub repositories for source code control. The company plans to create visualizations in Power BI to analyze repository usage including commits and pull requests. You need to create reports for repository usage. What should you do?

Build a sample from the Power BI Developer Samples GitHub repository. Use Performance Analyzer in Power BI Desktop. Create a deployment pipeline in Power BI. * Install a template app in the Power BI service.

A company uses Microsoft Power Platform. Which two controls in a canvas app can be connected to a data source? Each correct answer presents a complete solution.

Button * Form * Gallery Screen This item tests the candidate's knowledge of controls to design the user experience. A form is used to view, edit, and create a single row for a data source. To configure a form, you select its data source. A gallery displays a list of rows from a data source. To configure a gallery control you select its data source.Asource. A button has a formula that can change the properties of other controls. A button can cause data to be saved but the button is not linked to a data source. A screen is not linked to a data source. The controls added to the screen can be linked to data sources.

A real estate company plans to use Microsoft Dataverse to track apartments. You need to create a new column to store whether an apartment is available for rent, for sale, or both. Which column type you should use? Select only one answer. Choice Choices Yes/No Customer

Choice Choices Yes/No Customer This item tests the candidate's knowledge of selecting Microsoft Dataverse column types. The Choices column type can select multiple options between multiple values. The Choice column type can select only one option between multiple values. The Yes/No column type can select only one option between two values. Customer references to an Account or a Contact.

You use Microsoft Dataverse to develop a data model for a company. You plan to use a custom table named Problem to store information about problems reported by customers. Problems will be assigned a low, medium, or high severity. You need to capture the problem severity. Which type of column should you use? Choices Choice Yes/No Autonumber

Choices * Choice Yes/No Autonumber The item tests the candidate's knowledge of column types in Microsoft Dataverse. Identifying the appropriate column type for a requirement is a fundamental skill to design data model in Microsoft Dataverse. The Choice column type allows users to select only a single value from the list of values. The Choices column type allows users to select more than one value. The Yes/ No column type allows only two values: Yes and No. It cannot be used to display more than two options. The Yes/ No column type allows only two values: Yes and No. It cannot be used to display more than two options. Autonumber is text column type that allows generating automated unique numbers to uniquely identify each record. It cannot be used to display options to the user.

You build a canvas app. You need to allow users to select one or more values for a field. Which three controls should you use? Each correct answer presents a complete solution. Radio Combo box Dropdown List box Rating

Combo box Dropdown List box This item tests the candidate's knowledge of selecting the correct canvas app control depending on the type of choices. A combo box control, a dropdown control, and a list box control can be used to select multiple values. A radio control is used to show options that are mutually exclusive. A rating control can store only a single value.

You create a Power Automate cloud flow. The cloud flow fails at a step. You need to send an email notification to the flow owner whenever a step fails. What should you configure?

Condition * Run after Retry policy Compose action

A company uses Power Virtual Agents. You need to perform actions in Microsoft Dataverse by using a chatbot. What should you use? Connector Entity Power Automate Topic

Connector Entity * Power Automate Topic This item tests a candidate's knowledge of topics, entities, and actions in Power Virtual Agents. Power Automate cloud flows can be called from a Power Virtual Agents chatbot. The cloud flow can connect to Microsoft Dataverse to perform actions. Connections cannot be added to Power Virtual Agents chatbots. Entities are used in Power Virtual Agents chatbots to assist in natural language understanding. Topics are the conversations handled by a Power Virtual Agents chatbot.

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.

Create a Power BI dashboard tied to the Sales table. * Create a Power BI report tied to the Sales table. Create two reports: one for sales by date and one for sales by region. * Create one report with two pages for sales by date and sales by region.

A company has a model-driven app. You need to enable all users to access data in the app. What should you do? Select only one answer. Create a new table. Create a new model-driven app. Create a new personal view. Create a new public view.

Create a new public view. This item tests the candidate's knowledge of the different types of views. All the users will be able to use this view to access the data. Is not necessary to create a separate table or a new model-driven app. A personal view is not available to other users.

A company uses Microsoft Power Platform. You need to prevent external leakage of corporate data. What should you do? Select only one answer. Create data policies. Configure conditional access. Implement the Microsoft Power Platform Center of Excellence (CoE) Starter Kit. Enable auditing in Microsoft Dataverse.

Create data policies. This item tests the candidate's knowledge of data policies. Data policies prevent an app or a flow from connecting to two different data sources that may allow data to be accessed or copied outside of the organization. For example, a cloud that that connects to both Azure SQL Server and Dropbox could copy the data from Azure SQL Server to an external Dropbox folder. Azure Active Directory (Azure AD) conditional access can control when a user can access a Power Apps app using various signals such as location and device. It will not prevent data from being leaked externally. The Microsoft Power Platform CoE toolkit will enable monitoring of the apps, flows, and connectors used within your organization. It will not prevent data leakage on its own. The CoE toolkit enables the managing of data policies. Auditing in Microsoft Dataverse captures changes to data in Microsoft Dataverse tables. Auditing does not prevent data leakage.

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? Select only one answer. Microsoft Dataverse Data Operation Control SharePoint

Data Operation The item tests the candidate's knowledge on the appropriate flow control to perform data operations. The Data Operation connector has actions to transform and shape arrays including the Filter Array action. Using the Microsoft Dataverse connector allows performing operations in Microsoft Dataverse, which is a data store in Microsoft Power Platform. The control connector contains the condition and loop actions. The SharePoint connector contains all the actions to perform actions with SharePoint. The Microsoft Dataverse, Data Operation, and SharePoint connectors do not have actions to transform the data.

A company uses a set of model-driven apps within a single environment in Microsoft Power Platform. You need to share a new model-driven app with users. What should you assign to users to enable them to access the app?

Data loss prevention (DLP) policy Microsoft 365 security group * Dataverse security role Business process flow This item tests the candidate's knowledge of the Microsoft Power Platform security model. Model-driven apps use role-based security to control access to the app, its features, and its data. A model-driven app is associated with one or more Dataverse security roles. You must associate one of these security roles with users to enable them to access and run the app. When you share a model-driven app with a user, you are prompted to share the security roles with the user as well.

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? Select only one answer.

Dataverse * AI Builder Power BI Power Apps

A company uses a set of model-driven apps within a single environment in Microsoft Power Platform. You need to share a new model-driven app with users. What should you assign to users to enable them to access the app? Data loss prevention (DLP) policy Microsoft 365 security group Dataverse security role Business process flow

Dataverse security role This item tests the candidate's knowledge of the Microsoft Power Platform security model. Model-driven apps use role-based security to control access to the app, its features, and its data. A model-driven app is associated with one or more Dataverse security roles. You must associate one of these security roles with users to enable them to access and run the app. When you share a model-driven app with a user, you are prompted to share the security roles with the user as well.

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. Select all answers that apply. Desktop flow Business process flow Cloud flow Flow template

Desktop flow * Business process flow * Cloud flow Flow template This item tests the candidate's knowledge of selecting the correct Power Automate flow type based on the assigned task. 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. Desktop flows are used for robotic process automation (RPA). Flow templates are templates, not real flows.

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.

Desktop flow * Business process flow * Cloud flow Flow template This item tests the candidate's knowledge of selecting the correct Power Automate flow type based on the assigned task. 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. Desktop flows are used for robotic process automation (RPA). Flow templates are templates, not real flows.

You plan to build a Power Automate flow. The flow needs to loop through all rows in an Excel spreadsheet and update the first column value for all rows with the current date. You need to configure the action for the flow. Which action should you use?

Do until * Apply to each Switch Condition

You plan to build a Power BI report for a sales team. You need to display the sales revenue for the top fifteen product categories. Which chart type should you use?

Dot plot * Bar Combo Gauge The item tests the candidate's knowledge of the report types available in Power BI. Bar charts are used to visualize and compare data across categories. Dot plot charts allow you to compare multiple measures by their magnitudes and represent the data with dots. It allows you to plot the data along the X-axis. Gauge charts are useful to represent a single value that measures progress towards a goal or a KPI. For example, the average gross sales of company. Dot plot charts and gauge charts cannot be used to present data across categories. Combo charts are suitable for the comparison of data between two measures in a single visualization. For example, comparing last year's to current year's sales and gross margin values.

You build a canvas app. 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 the table. Which control should you use? Select only one answer. Edit form Data table Gallery Vertical container

Edit form This item tests the candidate's knowledge of basic controls in a canvas app. An edit form is tied to an underlying data table and is the easiest way to allow users to update values in the underlying data. The data table control can be used for viewing data in a data source but cannot be used for editing that data. The gallery control is used to allow users to view or select items in a list but cannot be used for editing values. A vertical container can be used to position controls on a screen, but it is not used for editing the data in a data source.

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. Select all answers that apply. File and image support Multiple currency support Relational storage Mobile offline

File and image support * Multiple currency support Relational storage * Mobile offline This item tests the candidate's knowledge of limitations regarding Microsoft Dataverse for Teams compared to Microsoft Dataverse. 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.

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? Gallery Form Drop-down Data table

Gallery The item tests the candidate's knowledge of controls to design UI in canvas apps. Identifying the correct control is a fundamental skill required to build a canvas app. The Gallery control displays the multiple records from data source and each record can contain multiple types of data including images Forms displays a single record. It cannot be used to show a list of items. The Drop-down control cannot display image column of Dataverse. The Data table control cannot display image column of Dataverse.

You are configuring Sitemap for a model-driven app. You need to add a table to the navigation pane of the app. Where should you add the table?

Group Area * Subarea Command bar

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?

Microsoft Dataverse * Data Operation Control SharePoint The item tests the candidate's knowledge on the appropriate flow control to perform data operations. The Data Operation connector has actions to transform and shape arrays including the Filter Array action. Using the Microsoft Dataverse connector allows performing operations in Microsoft Dataverse, which is a data store in Microsoft Power Platform. The control connector contains the condition and loop actions. The SharePoint connector contains all the actions to perform actions with SharePoint. The Microsoft Dataverse, Data Operation, and SharePoint connectors do not have actions to transform the data.

A company uses Dynamics 365 Field Service to support their customers. You need to allow external users to create a new support request. Which Microsoft Power Platform component should you use?

Model-driven app Power BI * Power Apps portal Power Automate

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. Select all answers that apply. Notify the users by email. Allow the users to edit the app. Publish the app. Assign a security role.

Notify the users by email. Allow the users to edit the app. * Publish the app. * Assign a security role. This item tests the candidate's knowledge of sharing a canvas app when users need to edit it. A canvas app must be published before it can be shared. When a canvas app is connected to a Microsoft Dataverse table, a security role must be assigned. The email is only a notification. It does not affect sharing capabilities. To share an app, it is not required to allow users to edit it.

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.

Notify the users by email. Allow the users to edit the app. * Publish the app. * Assign a security role. This item tests the candidate's knowledge of sharing a canvas app when users need to edit it. A canvas app must be published before it can be shared. When a canvas app is connected to a Microsoft Dataverse table, a security role must be assigned. The email is only a notification. It does not affect sharing capabilities. To share an app, it is not required to allow users to edit it.

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?

One-to-many * Many-to-many Many-to-one Hierarchical self-referential

You edit a Power BI report. You need to add a calculated column. Which two actions should you perform? Each correct answer presents part of the solution.

Open up Power BI Desktop Add a New Column

You need to create a Power BI visualization that displays month-by-month revenue comparisons for the current and previous years. Which chart type should you use? Select only one answer. Pie Funnel Bar Cards

Pie Funnel * Bar Cards The item tests the candidate's knowledge of the type of visualizations available in Power BI. Identifying the right visualization for a requirement is fundamental to design a Power BI report. Using a bar chart, specific value across different categories can be displayed. Pie charts show the relationship of parts to the whole. Cards whether single row or multiple rows, are used to display data points like total sales over a year, market share over a year or total opportunities. Pie charts and cards cannot be used to display data comparisons on more than one category. Funnels help visualize a process that has stages, and items flow sequentially from one stage to the next.

A company plans to hold a meeting with investors to discuss customers. The company needs to present last year's revenue and customer acquisitions in this meeting. You need to create a Power BI report. Which two visualizations should you use? Each correct answer presents a complete solution.

Pie chart KPI * Map * Line chart

You need to build a workflow that sends an email each time a new item is added to a SharePoint Online list. Which two components should you use? Each correct answer presents part of the solution.

Power Apps * Power Automate Power BI Power Virtual Agents * Connectors

A company plans to create an app by using Microsoft Power Platform. The app should be able to email sales quotes to customers. You need to automate the process of sending sales quotes. What should you use?

Power Apps Power Automate * Power BI Power Virtual Agents The item tests the candidate's knowledge of using Power Automate to automate processes. With Power Automate, email notifications can be sent with attachments. Power Apps allows creating complex user interfaces with cross-browser and cross-device compatibility. Power BI is used for analytics and provides insights with interactive visualizations. Power Virtual Agents allow users to build chatbots for support scenarios. Power Apps, Power BI, and Power Virtual Agents cannot be used to send automated emails.

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. Select all answers that apply. Power Apps Studio Power Apps maker portal SharePoint document library SharePoint list

Power Apps Studio * Power Apps maker portal SharePoint document library * SharePoint list This item tests the candidate's knowledge of creating an app from data. An app can be created from data in the maker portal by selecting the SharePoint list. From the SharePoint list, select Power Apps and then Create an app. The Power Apps Studio allows editing an app not creating an app from data. An app can only be created from a SharePoint list not from a document library.

A company is evaluating Microsoft Power Platform. The company needs to send out a reminder to specific teams to complete their timesheet. The reminder should be sent on Wednesday and Friday every week. You need to determine which Microsoft Power Platform tool to use. What should you use? Select only one answer. Power BI Power Automate Power Apps Power Virtual Agents

Power Automate The item tests the candidate's knowledge of Microsoft Power Platform services and the business scenarios where they can be used. Scheduled cloud flows in Power Automate can be used to send reminders to users every week. Power BI is used to create reports and dashboards. Power Apps is used to create customized user interface support on web browsers and mobile devices. Power Virtual Agents is used to create chatbots for support scenarios.

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. Select all answers that apply. Power Automate Power Apps Power BI Power Virtual Agents Microsoft Dataverse

Power Automate Power Apps * Power BI * Power Virtual Agents Microsoft Dataverse This item tests the candidate's knowledge of the business value of Power BI and 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. Power Virtual Agents chatbots 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. Power Automate and Microsoft Dataverse do not include a user interface that permits users to ask questions.

A company receives written letters. You need to allow users to record and track the letters. Which solution should you use?

Power Automate Power Virtual Agents * Power Apps Power BI

A company has a Power Apps portal. You need to send a notification each week by using a third-party service. The notification must contain a summary of the records created inside the Power Apps portal. Which Microsoft Power Platform component should you use? Select only one answer. Power Automate Power BI Power Virtual Agents Microsoft Dataverse

Power Automate This item tests the candidate's knowledge of which component can be used to integrate with third-party services and Microsoft Power Platform. Power Automate can use the standard connector or custom connectors to connect to third-party services. Power BI is a business analytics service. Power Virtual Agents is used to create chatbots, not to consume third-party services. Microsoft Dataverse is a data platform.

You need to modify a cloud flow. Which three solutions should you use? Each correct answer presents part of the solution. Select all answers that apply. Power Automate Desktop Power Automate portal Power Automate mobile app Power Apps Studio Power Virtual Agents

Power Automate Desktop * Power Automate portal * Power Automate mobile app * Power Apps Studio Power Virtual Agents This item tests the candidate's knowledge of modifying a cloud flow. The Power Automate portal, Power Automate mobile app, and Power Apps Studio can be used to modify cloud flows. Power Automate Desktop and Power Virtual Agents do not allow modifying cloud flows.

You need to modify a cloud flow. Which three solutions should you use? Each correct answer presents part of the solution.

Power Automate Desktop * Power Automate portal * Power Automate mobile app * Power Apps Studio Power Virtual Agents

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.

Power Automate Desktop Power Automate mobile app * Email inbox * Power Automate portal * Microsoft Teams

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?

Power BI Dataverse * AI Builder Power Apps

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? Select only one answer. Power BI Dataverse AI Builder Power Apps

Power BI Dataverse * AI Builder Power Apps This item tests the candidate's knowledge of the capabilities of AI Builder and the scenarios for which AI Builder can be used. 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. Power BI is an analytical platform to create visualizations by using data from various sources. It cannot be used to detect sentiment in text. Dataverse is used to manage and store data. It cannot be used to detect sentiment in text. Power Apps is used to create apps for end users. Using Power Apps, you can create canvas apps, model-driven apps, or a Power Pages site based on your requirements. Power Apps cannot, however, be used to detect sentiment in text.

A company is evaluating Microsoft Power Platform. The company needs to send out a reminder to specific teams to complete their timesheet. The reminder should be sent on Wednesday and Friday every week. You need to determine which Microsoft Power Platform tool to use. What should you use?

Power BI * Power Automate Power Apps Power Virtual Agents

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

Power Virtual Agents Power Automate AI Builder Power BI This item tests the candidate's knowledge of selecting the right Microsoft Power Platform component when a process is involved. Power Automate can create approval processes. Power Virtual Agents is used to create chatbots. AI Builder is used to create and train models to analyze data using AI. Power BI is a business analytics service.

A company uses Microsoft Dynamics 365 Sales to manage its sales process. Sales managers need access to more detailed analytics than what is available in Sales. You need to identify which Microsoft Power Platform application creates the required analytics reports. Which application should you select?

Power Virtual Agents Power Automate * Power BI Power Pages

A company uses 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? Select only one answer. Dynamics 365 Customer Insights Power Virtual Agents Power Automate Dynamics 365 Remote Assist

Power Virtual Agents This item tests the candidate's knowledge of how Microsoft Power Platform solutions can work with Microsoft Dynamics 365 apps. Power Virtual Agents can be used to create chatbots, which can be used in portals to support customers with their queries and without the need to reach a live agent. Dynamics 365 Customer Insights provides a 360 view of customer data by unifying the data from various data sources in silos. Power Automate is used for process and UI automation. Dynamics 365 Remote Assist allows field technicians to work with co-workers remotely by using HoloLens. Dynamics 365 Customer Insights, Power Automate, and Dynamics 365 Remote Assist cannot be used to provide interactive support to portal users.

You create a chatbot in Microsoft Teams by using Power Virtual Agents. You need to configure the chatbot to identify when an email address is included in a user's response to the chatbot. What should you use?

Prebuilt Entities

You create a Power Automate cloud flow. The cloud flow fails at a step. You need to send an email notification to the flow owner whenever a step fails. What should you configure? Select only one answer. Condition Run after Retry policy Compose action

Run after The item tests the candidate's knowledge of how to handle errors when running a Power Automate flow. You can configure the run after option to execute an action if the flow step has failed. If a step fails, the condition after that shall never be reached. The retry policy determines the number of times the flow will attempt a step if it fails. The compose action is used to shape and transform data in a Power Automate flow. Run after, retry policy, and compose action cannot be used to send an email notification after a step has failed.

You plan to create a flow using Power Automate. The flow will allow users to press a button in the Power Automate mobile app, which will send a reminder email notification. You need to determine which type of flow to create. Which type of flow should you create?

Scheduled Automated Business process * Instant

A company has a list of new employees. The company wants to use Yammer to send a daily welcome message to new employees. You need to write a flow that checks the list for new employees without human intervention. Which type of flow should you use? Select only one answer. Instant cloud flow Automated cloud flow Business process flow Scheduled cloud flow

Scheduled cloud flow This item tests the candidate's knowledge of different types of cloud flows. Schedule flows run on an interval. The flow can be set to run once a day. Instant flows are usually triggered with manual action. In this case, the flow must run by itself daily. An automated cloud flow is triggered when a particular event takes place. In this case, the flow should run at a designated time each day, and not when an action is performed. Business process flows are used to guide users through multi-step processes. In this case, the flow is taking place without human intervention.

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? Select only one answer. Filter array Join Parse JSON Select

Select This item tests the candidate's knowledge of Power Automate data operations. Select operation allows you to add a new property. Filter array operation is used to reduce the number of objects. Join operation is used to combine the elements with a separator. Parse JSON operation does not allow you to add a new property.

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. Select all answers that apply. Shape map Donut chart This answer is correct. KPI visualization Column combo chart This answer is correct.

Shape map * Donut chart KPI visualization * Column combo chart This item tests the candidate's knowledge of visualization charts and graphs used in Power BI. 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. Shape maps compare regions on a map using color. In this case, regions are not being evaluated. A KPI visualization communicates the amount of progress made toward a goal. In this case, there is no goal being measured. Additionally, this graph does not present a way of measuring all the products in comparison to each other.

A company uses Power BI. You need to aggregate a text field by adding it to a visual in a Power BI report. Which aggregation should you use? Select only one answer. Sum Median Latest Count

Sum Median Latest * Count This item tests the candidate's knowledge of aggregate functions in Power BI. Power BI aggregates text data as distinct categories and counts the occurrences of each category. Only the numeric fields are aggregated as a sum. Only the numeric fields are aggregated as a median. Only date fields use the latest aggregate.

You create a custom AI Builder model to track the count of products by category. Users report that they are not able to use the model from within the Power Apps app that they use. You need to ensure the model is available to the users. What should you do?

Train the model Publish the model. * Share the model. Test the model.

You create a Power Virtual Agents chatbot. You need to ensure that the chatbot understands natural language phrases. What should you add to the chatbot?

User topics Service channel Power Automate action * Custom entities

You create a Power Virtual Agents chatbot. You need to ensure that the chatbot understands natural language phrases. What should you add to the chatbot? User topics Service channel Power Automate action Custom entities

User topics Service channel Power Automate action * Custom entities This item tests the candidate's knowledge of the various components that can be used when building a chatbot. A Power Virtual Agents entity allows a chatbot to map natural language to a general subject. Topics are used to determine the general category of the conversation. A channel allows a bot to be available to a particular platform, such as Microsoft Teams. However, a channel does not handle natural language processing in a chatbot. While it is possible to call a Power Automate action from a chatbot, this is not intended for handling natural language processing in a chatbot.

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. Select all answers that apply. automating business processes building sites by using low-code tools creating documents from templates exposing data in Dataverse to customers extracting data from documents

automating business processes * building sites by using low-code tools creating documents from templates * exposing data in Dataverse to customers extracting data from documents

A company plans to use Microsoft Power Platform and Dataverse to transform its business. The company requires a central backend solution connected to 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?

canvas application desktop flow Power Pages site * model-driven application

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? connector cloud flow desktop flow business process flow

desktop flow This item tests the candidate's knowledge of actions for Power Automate desktop flows. 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. Business process flows are used within model-driven apps to guide a user through the business stages and steps. Connectors are used in cloud flows to connect to a service or system that has an API. Cloud flows do not mimic a user's actions; instead, they interact with the system or service via API calls.

A company uses Microsoft Dynamics 365 Sales to manage its sales process. Sales managers need access to more detailed analytics than what is available in Sales. You need to identify which Microsoft Power Platform application creates the required analytics reports. Which application should you select? Select only one answer. Power Virtual Agents Power Automate Power BI Power Pages

power BI This item tests the candidate's understanding of what a Microsoft Power Platform application is used for. Power BI is used to create powerful analytics that organizations can use to drive business actions. Analytics created in Power BI can be easily consumed in other applications such as Dynamics 365 Sales. Power Virtual Agents is used to create intelligent chatbots that can be used across a business. Power Automate is used to create automation solutions. Power Pages is used to externally facing websites.

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?

trigger * action condition loop This item tests the candidate's knowledge of Power Automate components such as triggers, actions, conditions, and apply to each loop. An action does something in a flow. In this case, you will use an action to send an email. Triggers are used to start a flow but do not carry out an action such as sending an email. A condition specified if a cloud flow should perform a task or set of tasks if the condition value is set to true or false. In this case, no condition is required. A loop is used to loop through items in a collection. In this case, there is no collection, so no loop is required.