Pl-900

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. A) Actions B) Credentials C) Postman collection D) Triggers

A) Actions D) 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. 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.

What is a benefit to using Power Virtual Agents? A) Improve customer satisfaction B) Requires more time than regular customer chat C) Doesn't use AI to understand user's intent

A) Improve customer satisfaction Correct. Power Virtual Agents can improve customer satisfaction by allowing customers to self-help and resolve issues quickly, 24/7 using rich personalized chatbot conversations.

Power BI helps with which of the following business processes? A) Notifying users when a SharePoint list item has changed. B) Generating an approval. C) Analyzing and displaying data.

C) Analyzing and displaying data. Correct. By analyzing and displaying your data, Power BI empowers business users to make beneficial decisions

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. A) Filter array B) Join C) Parse JSON D) Select

D) Select

What are the three modalities of Power BI designed to let people create, share, and consume business insights in the way that serves them, or their role, most effectively? A) Desktop, service, and Mobile apps. B) Tiles, visualizations, and dashboards. C) Reports, dashboards, and tiles.

A) Desktop, service, and Mobile apps. Correct. Power BI consists of a Microsoft Windows desktop application called Power BI Desktop, an online SaaS (Software as a Service) service called the Power BI service, and mobile Power BI apps that are available on phones and tablets.

You want to build a mobile app that allows you complete control over the user experience and design. What type of Power Apps app should you build? A) A Model-driven app B) A Portal app C) A Canvas app

C) A Canvas app

Someone has added an item in SharePoint which prompts a workflow to run in Power Automate. What type of operation have you used to start your workflow? A) Trigger B) Action C) Function-based

A) Trigger

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. A) Allow users outside your company to use the chatbot. B) Allow users inside your company to modify the chatbot without additional licensing. C) Create a chatbot using a template. D) Use the chatbot on your website

A) Allow users outside your company to use the chatbot. D) 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. You can create a chatbot from a template in Power Virtual Agents in Microsoft Teams. Templates are not available for the Power Virtual Agents web app.

A company uses Microsoft Power Platform. You need to recommend whether to use Microsoft Dataverse or Microsoft Dataverse for Teams to store data for a new Power Apps app. Which two features are unique to Microsoft Dataverse? Each correct answer presents a complete solution. A) Auditing B) Multiple business units C) file data type D) integration with Power Automate

A) Auditing B) Multiple business units Auditing is not available in Microsoft Dataverse for Teams. There is only one business unit in Microsoft Dataverse for Teams. In Microsoft Dataverse, many business units can be configured. Both Microsoft Dataverse and Microsoft Dataverse for Teams support the file data type and the integration with Power Automate cloud flows.

If you wanted to create a standard procedure or process for handling service requests, what type of logic would be best to implement? A) Business process flow B) Business rule C) Workflow

A) Business process flow Correct. Business process flows can be used to define a set of steps for people to follow to take them to a desired outcome.

You plan to create a Power Apps app. You need to enable users to read and write data from SharePoint and OneDrive for Business. Which type of app should you use? Select only one answer. A) Canvas app B) Model-driven app C) Power Apps portal D) Business process flow

A) Canvas app A canvas app connects to multiple data sources including SharePoint and Excel files stored in OneDrive for Business by using out-of-the-box connectors. Model-driven apps can use only Microsoft Dataverse as the underlying data store. Power Apps portals allow external customers and partners to access data in Microsoft Dataverse. Business process flows are used to standardize business processes, providing a streamlined UI for users to complete a process. Model-driven apps, Power Apps portals, and Business process flows cannot be used to read and write data from SharePoint and OneDrive.

Your social media engagement officer has requested your help in boosting followers and retweets on Twitter. How could you help her get more information to better understand and subsequently increase engagement? A) Configure a Power BI report to capture and analyze data from Twitter, allowing you to better understand why certain posts elicit more responses. B) Power Apps using portals can create a new customer site for our followers. C) Power Automate can handle our content approvals for us, reducing the time it takes to produce new content and ensure our quality procedure is followed.

A) Configure a Power BI report to capture and analyze data from Twitter, allowing you to better understand why certain posts elicit more responses.

A company uses Microsoft Exchange Online. The company receives email messages from its 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 actions should you perform? Each correct answer presents a complete solution. A) Connect to Azure Cognitive Service for Language and use the Sentiment action. B) Connect to LUIS and use the Get prediction action. C) Connect to Microsoft Exchange Server by using an on-premises data gateway. D) Connect to AI Builder and use the prebuilt sentiment analysis model.

A) Connect to Azure Cognitive Service for Language and use the Sentiment action. D) Connect to AI Builder and use the prebuilt sentiment analysis model. Using the Azure Cognitive Service for Language connector 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. Azure Cognitive Services Language Understanding Intelligent Service (LUIS) provides the ability to analyze natural language according to a trained model, but it does not allow the evaluation of sentiment. This scenario uses Microsoft Exchange Online so there is no need to connect to a Microsoft Exchange Server hosted on-premises.

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? A) Connector B) AI Builder C) Power Virtual Agents D) Power BI

A) Connector 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.

Someone asks you to describe a connector. How would you respond? A) Connectors connect your data source to your app, workflow, or dashboard. B) Connectors hold a series of functions available for developers. C) Connectors are a cloud-based service that makes it practical and simple for line-of-business users to build workflows that automate time-consuming business tasks and processes across applications and services.

A) Connectors connect your data source to your app, workflow, or dashboard.

Your sales team is in desperate need of a mobile application that can display rows living in a SharePoint list. When displaying the records, multiple pieces of information about each record need to be visible to the user. Which of the following Power Apps tools would you use when designing your app to achieve this functionality? A) Create a gallery to display the sales rows. B) Create a form to display the sales rows. C) Create an input control to display the sales rows.

A) Create a gallery to display the sales rows. Correct. Galleries are used to display tables of data from your data source. They are highly customizable, so you can show whatever information about a particular row that is necessary. You could then use a Form to edit individual records, if desired.

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. A) Create a new form for the Microsoft Dataverse table. B) Create a business process flow. C) Select the form in the app designer. D) Create a new view.

A) Create a new form for the Microsoft Dataverse table. C) Select the form in the app designer. 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 need to prevent external leakage of corporate data. What should you do? A) Create data policies. B) Configure conditional access. C) Implement the Microsoft Power Platform Center of Excellence (CoE) Starter Kit. D) Enable auditing in Microsoft Dataverse.

A) Create 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.

What is one method for creating a visual? A) Drag a field from the Fields list onto the Report view canvas. B) Drag a field from the Fields list onto the Visualizations pane. C) Drag a field from the Fields list onto the Model view canvas.

A) Drag a field from the Fields list onto the Report view canvas. Correct. Dragging any field from the Fields list onto the open white space of the canvas (in Report view) will automatically create a default visual for that data type.

A company uses Microsoft Power Platform. You need to recommend whether to use Microsoft Dataverse or Microsoft Dataverse for Teams to store data for a new Power Apps app. Which two features are unique to Microsoft Dataverse? Each correct answer presents a complete solution. You have a Power Automate flow that triggers whenever a comment is posted on a blog site. You need to configure the flow to meet the following requirements: Require users to fill in their subscriber ID when posting comments. Save the subscriber ID in uppercase from the Power Automate flow. Which function should you use? Select only one answer. A) Expression B) Condition C) Trigger D) Template

A) Expression

Your organization has started using lots of Approval flows, and users are complaining that they have too many approvals to keep track of. They don't know what is approved and what is still pending their approval. What is the easiest way for them to check? A) Have the users navigate to the Approval Center in Power Automate. B) Have the users set up Outlook rules to catch approvals so they are more visible. C) Send the users to the SharePoint list, which holds the records being approved to review which ones are approved and which ones are not.

A) Have the users navigate to the Approval Center in Power Automate. Correct. In the Approval Center, users will be able to view their outstanding approvals as well as their approval history in a much easier-to-read platform. All of the approvals that require that user's interaction will be available through the Approval Center.

A client likes the idea of implementing a Microsoft Power Platform solution, but is concerned about the ability to interact with a custom API. How should you respond? A) Microsoft Power Platform offers the ability to create custom connectors for this purpose which allow you to connect to Power Apps and Power Automate. B) Microsoft Power Platform has over 600 connectors to use in these situations. C) Microsoft Power Platform uses connectors that hold a series of functions available for developers.

A) Microsoft Power Platform offers the ability to create custom connectors for this purpose which allow you to connect to Power Apps and Power Automate.

What is a dashboard? A) One-page collection of visualizations that is created from within the Power BI service (online). B) Data which is ready to be used for building visuals. C) An application for PCs that lets you gather, transform, and visualize your data.

A) One-page collection of visualizations that is created from within the Power BI service (online). Correct. A dashboard is a great way to display information and visualizations

Your team has become frustrated with the number of times they have to perform basic data entry on project startup. There are many divisions who need the information and sometimes human error results in mistakes, making it more difficult to make sense of your information. Which program would be the most help in this situation? A) Power Automate B) Power Apps C) Power BI

A) Power Automate

One of your colleagues would like to set up a flow to write an item to a SharePoint list when they receive an email from their boss. Which of the following would get them started? A) See if any templates are available for this scenario. If one exists, use that, otherwise create a blank flow with a "When an email is received" trigger. B) Create an instant cloud flow and set the trigger to be "When an email is received", then add an action for creating the SharePoint item. C) Create an automated cloud flow with only one action: create an item in SharePoint.

A) See if any templates are available for this scenario. If one exists, use that, otherwise create a blank flow with a "When an email is received" trigger. Correct. Don't discount the template store in Power Automate; more often than not, someone has already solved this problem before. However, if they haven't, you can just create a new flow and use the appropriate Trigger to achieve your goal.

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. Select all answers that apply. A) Share the app with the sales manager. B) Make the sales manager a co-owner of the app. C) Grant the sales manager read-only access to the data stored in the SQL Server database. D) Publish the app to Microsoft AppSource.

A) Share the app with the sales manager. C) Grant the sales manager read-only access to the data stored in the SQL Server database. The canvas app must be shared with a user to ensure the user can access the Power Apps app itself. Even if a user has access to a Power Apps app, the user must also have access to any data source used in the app. Making the sales manager a co-owner on the app would grant the sales manager permission to edit the app, which the requirements do not permit. Publishing the app to Microsoft AppSource makes it available for others to find and use the app.

How can business rules be used in both canvas and model-driven apps? A) To validate data and show error messages. B) Show or hide fields. C) Manage solution development and data storage.

A) To validate data and show error messages.

Your project requirements call for the ability to take a picture of a part and identify which model it is. You aren't a data scientist or developer, how can you add this to your app? A) Train and use an Object Detection model in your app with AI Builder. B) This is not possible. C) Add a camera control to your app.

A) Train and use an Object Detection model in your app with AI Builder. Correct. Power Apps makes available to you the ability to use artificial intelligence without writing code. This allows you to do Form Processing, Object Detection, Prediction, and Text Classification all powered by Azure services.

Which statement is true regarding adding comments to a dashboard? A) You can use the "@" symbol to mention a colleague in a comment. B) Comments can be added to an entire dashboard but not to individual visualizations on that dashboard. C) Before a comment is published, it must be approved by the dashboard designer.

A) You can use the "@" symbol to mention a colleague in a comment. Correct. Comments can be added to an entire dashboard or to individual visualizations on a dashboard. Add a general comment or a comment targeted at specific colleagues. Also, comments can be added to a dashboard using Power BI or Power BI Mobile apps.

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. A) form B) iframe C) list D) text

A) form C) list 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.

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? A) Do until B) Apply to each C) Switch D) Condition

B) Apply to each The Apply to each action allows to loop through items in a collection. In this case, this action can be used to loop through each of the rows in the spreadsheet. Do until allows you to loop through items until a specified condition is met. In this scenario, there is no condition, and every item must be looped through. Switch allows taking an input parameter and performing different steps based on the input's value. In this case, there are no separate actions to take, but the same action to perform on every single row in the spreadsheet. The condition action allows setting up a conditional statement and then perform an action based on whether the condition is true or false. In this scenario, there is no condition to evaluate since every row must be handled the same way.

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. A) Desktop flow B) Business process flow C) Cloud flow D) Flow template

B) Business process flow C) 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. Desktop flows are used for robotic process automation (RPA). Flow templates are templates, not real flows

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? A) Choices B) Choice C) Yes/No D) Autonumber

B) Choice 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.

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. A) Shape map B) Donut chart C) KPI visualization D) Column combo chart

B) Donut chart D) 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. 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.

You need to install and configure prebuilt Power BI dashboards and reports. Which two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply. A) Create an app and publish it to the Power BI Apps marketplace. B) Find a Power BI template app in the Power BI Apps marketplace and install it. C) Connect the app to the data. D) Build a data model and save it in a .pbix file.

B) Find a Power BI template app in the Power BI Apps marketplace and install it. C) Connect the app to the data. Power BI template apps contain prebuilt reports and dashboards that can be obtained from the Power BI marketplace. After installing a Power BI template app, you must connect the app to the data including connection information. Creating a new app requires significant effort and is not the same as installing a prebuilt app. Creating a data model and saving it in a Power BI Desktop file does not actually connect your template app to the data.

Your department would like to set up an approval system for items that are being written to a SharePoint list. You have been assigned the task of creating the system. Using flow, what's the best approach? A) Create an automated cloud flow from blank and add a trigger for "When a new item is created" in SharePoint, and actions for the approvals. B) Generate an approval flow from the built-in SharePoint Approvals functionality on your SharePoint list. C) Set up a blank flow to send approval emails to the department manager when a new item is created in the SharePoint List.

B) Generate an approval flow from the built-in SharePoint Approvals functionality on your SharePoint list. Correct. Why reinvent the wheel? SharePoint's built-in Approvals flows are great, and using the information in this module you can set them up quickly and easily.

You have been tasked with creating a Power App that can scan barcodes that will display the scanned item's information on the screen. Out of the following control options, which one would the barcode scanner fall under? A) Galleries B) Media C) Forms

B) Media Correct. The barcode scanner control is a part of the Media category of controls. This control can be used to scan barcodes of various types and pass information about the barcode to the Power App. Then, additional Functions can use that barcode information to perform additional tasks.

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? A) Power BI B) Power Automate C) Power Apps D) Power Virtual Agents

B) Power Automate 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 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? A) Power Apps B) Power Automate C) Power BI D) Power Virtual Agents

B) Power Automate 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.

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. A) Power Automate Desktop B) Power Automate portal C) Power Automate mobile app D) Power Apps Studio E) Power Virtual Agents .

B) Power Automate portal C) Power Automate mobile app D) Power Apps Studio

A company uses Microsoft Dataverse. You need to define views to display data in model-driven apps. Which three items can you configure in the view designer? Each correct answer presents part of the solution. Select all answers that apply. A) The apps in which the view is available. B) The columns included in the view. C) The filter for rows shown in the view. D) The sort order of rows in the view. E) Whether the user can filter the contents of the view in the app.

B) The columns included in the view. C) The filter for rows shown in the view. D) The sort order of rows in the view. The view designer allows you to select the columns from the table to be shown and define the filter criteria for the rows to be shown in the view. The view designer also allows you to specify the sorting behavior of the rows in the view. The app designer determines which view is included in the app, not the view designer. All views can be filtered by the user in a model-driven app.

What defines how a chatbot conversation plays out? A) Publishing B) Topics C) Entities

B) Topics Correct. In Power Virtual Agents, topics have trigger phrases and conversation nodes to define how a chatbot should respond and what it should do.

One of your co-workers has set up a Model-driven application using Dataverse. The app captures information about computer hardware assets, including their price. Your co-worker is concerned that users of the application are going to forget to populate the cost center if the part is expendable. How could this be prevented? A) Use Power Automate to validate that the cost center column value is populated. B) Use a Business Rule to make the cost center field required if the expendable field is true. C) Use a Canvas App instead of a Model-driven app.

B) Use a Business Rule to make the cost center field required if the expendable field is true.

Your manager has built a solution using the Microsoft Dataverse using a few of the standard tables included out of the box. He wants to capture the date that new records are added to the Entity, but he isn't sure how. He notices that a "Date" field is already inside his Entity, but he wants the field to have a custom name of "Date Confirmed". What would you recommend he do? A) Create a new table with the name "Date Confirmed". B) Use the built-in Date column within the table to store the date values, but rename the column to "Date Confirmed". C) a new Environment with the name "Date Confirmed".

B) Use the built-in Date column within the table to store the date values, but rename the column to "Date Confirmed".

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. A) automating business processes B) building sites by using low-code tools C) creating documents from templates D) exposing data in Dataverse to customers E) extracting data from documents

B) building sites by using low-code tools D) exposing data in Dataverse to customers This item tests the candidate's knowledge of the use cases for Power Pages and its capabilities. 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. Power Pages cannot automate business processes or create documents, but it can be integrated with the rest of Microsoft Power Platform. Power Automate is used to automate business processes. AI Builder is used for extracting data from documents.

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? A) Power BI B) Dataverse C) AI Builder D) Power Apps

C) 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. 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.

Which is a way that Power BI can help you effectively leverage your data? A) Analyze sales data to better allocate resources and place orders, optimizing operations. B) Analyze customer data to better target and promote specific items to specific customers. C) All of the above.

C) All of the above. Correct. Power BI can analyze all types of data you may have to assist in your business efficiency and decision making efficacy.

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? A) Pie B) Funnel C) Bar D) Cards

C) Bar 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 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? Select only one answer. A) Model-driven app B) Power Apps portal C) Canvas app D) Microsoft Dataverse

C) Canvas app Canvas apps can access Excel workbooks. Model-driven apps and Portal Apps do not work with Excel workbooks. Microsoft Dataverse is a data platform.

You have a gallery control in your app for displaying all customer orders. Your manager says she would like to see orders from the last 90 days in addition. How would you reduce the amount of data she sees? A) You would modify the data source to purge out all orders older than 90 days. B) Use the data filtering wizard. C) Create a formula for your gallery that uses the Filter function.

C) Create a formula for your gallery that uses the Filter function. Correct. The Filter function allows you to apply logic tests to one or more columns in your data source. For this scenario you could filter out data where the Order Date is less than 90 days ago.

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? A) Data loss prevention (DLP) policy B) Microsoft 365 security group C) Dataverse security role D) Business process flow

C) Dataverse security role 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 BI dashboard for Power BI mobile apps. What should you do? Select only one answer. A) Create a new page and edit the mobile layout. B) Use Power BI Desktop. C) Edit the phone view. D) Use the Power BI mobile app to create the dashboard.

C) 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.

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. A) Power Automate Desktop B) Power Automate mobile app C) Email inbox D) Power Automate portal E) Microsoft Teams

C) Email inbox D) Power Automate portal E) 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. Power Automate Desktop does not support approvals. Power Automate Mobile app does not show the file attached inside the approvals.

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? A) Alternate key B) Customer C) Lookup D) Primary key

C) Lookup When a one-to-many relationship is created between two tables, a lookup column is created on the related table on the many sides of the relationship. This column links the parent record with the child record. A lookup column is also known as the foreign key. Alternate keys are created for integrations with other systems. Customer is a special lookup column that represents an account or a contact. You cannot create a customer column by creating a one-to-many relationship. In Microsoft Dataverse, every table has a primary key that uniquely identifies each row in the table. The primary key column is created when the table is created.

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. Select all answers that apply. A) Pie chart B) KPI C) Map D) Line chart

C) Map D) Line chart A map is meant to associate quantity information to locations. A line chart can be used to display a series over time. A pie chart is meant to show the relationship of parts to a whole. A KPI is meant to show the progress towards a goal.

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? Select only one answer. A) Canvas app B) Model-driven app C) Portal app D) Cloud flow

C) Portal app A portal app, using the Partner portal template, allows users to register themselves for your portal app web site. The knowledge management feature in the app can be used to allow suppliers to read documentation from the company. Canvas apps in general are built from scratch and would take much more time to build than a portal app that uses the partner portal template with the knowledge base feature. Additionally, canvas app requires the app to be shared explicitly with each external user and cannot be published in a way that allows users to sign themselves up for access. Model-driven apps do not allow for self-service registration to gain access to the app. A cloud flow can be used within a larger solution, but a flow does not have any user interface that users can interact with, so it does not meet the requirements of allowing users to log in and view information in a web-based solution.

How can data sources be used with Power Apps Canvas apps? A) Power Apps can only use its internal data sources. B) Power Apps uses only external data sources and doesn't have an internal data source. C) Power Apps can use multiple internal and external data sources in the same app.

C) Power Apps can use multiple internal and external data sources in the same app. Correct. Power Apps allows you complete control of which data sources you use in your app. There are over 600 data connectors available, and the ability to build a custom connector if one doesn't exist.

To secure and administer Power Automate you can use what resources? A) Download the Power Automate administrator application. B) Power Automate is only administered via the web portal. C) Power Automate can be administered on the web, via PowerShell, or even by building flows.

C) Power Automate can be administered on the web, via PowerShell, or even by building flows. Correct. Power Automate provides https://admin.powerplatform.microsoft.com, PowerShell cmdlets, and flow actions for managing Power Automate. This gives you complete flexibility for your Microsoft Power Platform administration.

How can data sources be used with Power Automate? A) Power Automate can only connect to Microsoft data sources such as Office 365 and Azure. B) Power Automate requires you to build custom connectors to access external data. C) Power Automate can connect to data sources using one of the 600+ prebuilt connectors or by building your own custom connector.

C) Power Automate can connect to data sources using one of the 600+ prebuilt connectors or by building your own custom connector. Correct. Power Automate allows you to automate business processes where your data lives.

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. A) Power Automate B) Power Apps C) Power BI D) Power Virtual Agents E) Microsoft Dataverse

C) Power BI D) 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.

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. A) Blank page B) Dynamics 365 C) Scenario-based D) Site design

C) Scenario-based D) Site design When you create a Power Pages website, you must select a template. 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. The blank page template creates a site consisting of a single home page to which you must then add pages and other content. Dynamics 365 templates require the corresponding Dynamics 365 app to be installed in the environment

1. When you build a model-driven app, which designer is used to define the navigation of your app? A) App designer B) View designer C) Site map designer

C) Site map designer Correct. The site map designer is used to define the navigation of your app. You can drag components onto the design canvas, preview your work, and instantly publish the site map. Administrators and any user with the required privileges can quickly create site maps for apps.

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? Select only one answer. A) Group B) Area C) Subarea D) Command bar

C) Subarea Subarea in sitemap can be used to show tables/ dashboards/custom pages. You can add multiple subareas to a group. A group in Sitemap cannot be linked to show a table. Area can have multiple groups and each group can have multiple subareas. An area cannot be used to show a table. Command bar in a model-driven app displays context-specific menu items on a grid, form, or subgrid. They are not part of Sitemap navigation.

3. When you want to share a model-driven app, which of the following statements is true? A) Users just need to be added to a predefined security role B) Model-driven apps do not need to be shared, they are accessible to anyone with the app link. C) Users need to be added to a predefined or custom security role and one or more security roles need to be associated with the app.

C) Users need to be added to a predefined or custom security role and one or more security roles need to be associated with the app. Correct. Users must have a security role that grants them the right to access the app for you to successfully share the app.

One of your colleagues would like to post information about SharePoint items that have been approved to Twitter. Is this possible? If so, how would he do it? A) No, it's not possible. SharePoint lists don't connect to Twitter directly, so there's no way to Tweet about approved items. B) Yes, it's possible. He can create a flow to monitor his SharePoint list for approved items, then notify him so he can Tweet the details manually. C) Yes, it's possible. He can create a flow to monitor his SharePoint list for approved items, then Tweet the details.

C) Yes, it's possible. He can create a flow to monitor his SharePoint list for approved items, then Tweet the details. Correct. This was covered in this module, so you can refer back to earlier in the module to see how he could achieve it.

Where can you NOT publish a chatbot? A) Microsoft Teams B) Facebook C) YouTube

C) YouTube Correct. You can publish chatbots to engage with your customers on Microsoft Teams, Facebook, and Mobile Apps.

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? A) connector B) cloud flow C) desktop flow D) business process flow

C) 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. 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.

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? A) User Topics B) Service Channel C) Power Automate Action D) Custom Entities

D) Custom Entities 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 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? Select only one answer. A) Build a sample from the Power BI Developer Samples GitHub repository. B) Use Performance Analyzer in Power BI Desktop. C) Create a deployment pipeline in Power BI. D) Install a template app in the Power BI service.

D) Install a template app in the Power BI service. There is a template app available in the Power BI Apps marketplace for GitHub that contains prebuilt visualizations on repository usage including commits and pull requests. GitHub repositories contain source code for building applications. The Power BI Developer Samples repository contains example solutions for creating embedded Power BI solutions, not for creating Power BI reports that show GitHub usage. Performance Analyzer captures the time taken when interacting with visualizations on a report. It does not examine GitHub repo usage. Deployment pipelines are used to manage the lifecycle of Power BI content from development to test to production.

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? A) Scheduled B) Automated C) Business process D) Instant

D) Instant Instant flows can be triggered by a button in the Power Automate mobile app. A scheduled flow runs at a particular day and time with a specific frequency. In this case, the flow can happen whenever a person decides to run the flow, without any particular schedule. An automated flow runs after a particular event happens in another system. In this case, there is not another application or system that fires the event. Instead, a human is deciding to start the flow. Business process flows are used for guiding users through steps in a business process. However, business process flows are not initiated by pressing a button in the Power Automate mobile app.

You need to build a low-code application that includes online forms for collecting and displaying information from users. What should you use? A) Power Automate B) Power BI C) Power Virtual Agents D) Power Apps

D) Power Apps Power Apps provides a way of quickly creating online forms and applications that are low-code solutions. Power Automate provides the ability to build workflows using a visual interface, but not Power Apps. Power BI provides the ability to create and view dashboards and reports that use charts and graphs to visually represent data, not Power Apps. Power Virtual Agents allow you to create chatbots that users can interact with using natural language.

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? A) Instant cloud flow B) Automated cloud flow C) Business process flow D) Scheduled cloud flow

D) Scheduled cloud flow 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 A) Filter array B) Join C) Parse JSON D) Select

D) Select 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 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. A) Add the column to the view. B) Add the column on the form. C) Publish customizations. D) Add a page.

B) Add the column on the form. C) Publish customizations. 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 Power Platform. The company needs to read text from uploaded images. You need to determine which connector to use. Which connector should you use? A) Azure Blob storage B) Azure Cognitive Services C) Microsoft Dataverse D) Microsoft Teams

B) Azure Cognitive Services 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 has a public-facing portal for its partners. You need to fetch data from the portal in a flow. Which solution should you use? A) AI Builder connector B) Custom connector C) Microsoft Dataverse connector D) Dataflow

B) Custom connector 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.

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? A) Microsoft Dataverse B) Data Operation C) Control D) SharePoint

B) Data Operation 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.

Where do you find flow templates? A) You have to build and save templates yourself; there are no pre-built templates. B) Directly from the Power Automate builder website. C) You need to download the template pack from the Microsoft Learn website.

B) Directly from the Power Automate builder website. Correct. When you create a flow, you can choose to start from a template. There you can browse for templates or use search to find just the right template to begin your project

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. Select all answers that apply. A) Button B) Form C) Gallery D) Screen

B) Form C) Gallery 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.

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. A) Power Apps B) Power Automate C) Power BI D) Power Virtual Agents E) Connectors

B) Power Automate E) Connectors A Power Automate cloud flow should be created with an automatic trigger using the SharePoint Online connector. Connectors must be used to connect the flow trigger and actions to SharePoint Online and Exchange Online. Power Apps are used to create graphical forms. In this solution, no form or user interface is required. Power BI provides the ability to generate visual graphics to users representing underlying data. This solution does not require the display or manipulation of data. Power Virtual Agents are used for allowing users to interact with underlying data using natural language and chatbots. There is no user interaction in this scenario that requires a chatbot or Power Virtual Agents.

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? A) Dynamics 365 Customer Insights B) Power Virtual Agents C) Power Automate D) Dynamics 365 Remote Assist

B) Power Virtual Agents 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 and publish a canvas app. Users report issues with the latest version of the app. You need to revert the app to an earlier working version. Which two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply. A) Edit the app, undo all the changes, and publish the app. B) Select an earlier version of the app and click on Restore. C) Publish the restored version of the app. D) Export the previous version of the app and import it.

B) Select an earlier version of the app and click on Restore. C) Publish the restored version of the app. To restore canvas apps to an earlier version, the Restore option must be used. Once an earlier version of the canvas app is restored, a new version is created. The restored version needs to be published. To restore to an earlier version of the app, the app does not need to be edited and changes do not need to be undone. The Restore option can be used. The app is exported with the latest changes whenever you export a canvas app. The earlier version of the app cannot be exported.

A company receives written letters. You need to allow users to record and track the letters. Which solution should you use? A) Power Automate B) Power Virtual Agents C) Power Apps D) Power BI

C) Power Apps Power Apps provides a rapid low code development environment for building custom apps for business needs. Power Automate is used to create workflows between applications and services. Power Virtual Agents allows chatbots to be created. Power BI is a business analytics service.

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. A) Create a new table. B) Create a new model-driven app. C) Create a new personal view. D) Create a new public view.

D) Create a new public view. 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.

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? Select only one answer. A) User topics B) Service channel C) Power Automate action D) Custom entities

D) Custom entities