Microsoft Learn: Practice Assessment

Question 1

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

Answer 1

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.

Choice A is incorrect because 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.

Choice C is incorrect because 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.

Choice D is incorrect because 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.

Question 2

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

Answer 2

a. Expression

The toUpper function in an expression can be used to convert the subscriber ID to uppercase.

Choice B is incorrect because the Condition function in Power Automate can be used to check if a specific business logic is satisfied.

Choice C is incorrect because a trigger is the event that starts a cloud flow.

Choice D is incorrect because a template can be used to create a new workflow based on common built-in business scenarios.

Choice B, C, and D cannot be used for data transformation

Question 3

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?

a. Apply to each
b. Compose
c. Condition
d. Switch

Answer 3

b. Compose

Compose creates an array that you can reference later in the flow.

Choice A is incorrect because apply to each is a loop that processes each record in a set of data in turn.

Choice C is incorrect because a condition is used for if…then…else logic to control the actions taken in a flow.

Choice D is incorrect because a switch action is used to perform different actions depending on a value in the flow.

Question 4

You need to modify a cloud flow.

Which three solutions should you use? Each correct answer presents part of the solution.

a. Power Automate Desktop
b. Power Automate Portal
c. Power Automate Mobile App
d. Power Apps Studio
e. Power Virtual Agents

Answer 4

b. Power Automate Portal
c. Power Automate Mobile App
d. Power Apps Studio

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.

Question 5

A company uses Power Automate approvals.

You need to monitor approval requests.

In which two locations can you monitor approvals for your organization? Each correct answer presents a complete solution.

a. Business process flows
b. Canvas app
c. Maker portal
d. Microsoft Teams
e. Power Automate portal

Answer 5

d. Microsoft Teams
e. Power Automate portal

Microsoft Teams has an Approvals app that displays approvals and their status.

The Power Automate portal displays approvals and their status under the Action Items menu.

Choice A is incorrect because business process flows are used in model-driven apps to guide a user through the stages and steps of a business process. Business process flows do not show approvals.

Choice B is incorrect because a canvas app can start an approval process using the Approvals connector but cannot display approvals or monitor their status.

Choice C is incorrect because the maker portal can build flows but does not contain the capability to display action items to monitor approvals.

Question 6

A company uses Power Automate approvals.

You need to monitor approval requests.

In which two locations can you monitor approvals for your organization? Each correct answer presents a complete solution.

a. Business process flows
b. Canvas app
c. Maker portal
d. Microsoft Teams
e. Power Automate portal

Answer 6

d. Microsoft Teams
e. Power Automate portal

Microsoft Teams has an Approvals app that displays approvals and their status.

The Power Automate portal displays approvals and their status under the Action Items menu.

Choice A is incorrect because business process flows are used in model-driven apps to guide a user through the stages and steps of a business process. Business process flows do not show approvals.

Choice B is incorrect because a canvas app can start an approval process using the Approvals connector but cannot display approvals or monitor their status.

Choice C is incorrect because the maker portal can build flows but does not contain the capability to display action items to monitor approvals.

Question 7

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?

a. Filter array
b. Join
c. Parse JSON
d. Select

Answer 7

d. Select

Select operation allows you to add a new property.

Choice A is incorrect because filter array operation is used to reduce the number of objects

Choice B is incorrect because join operation is used to combine the elements with a separator.

Choice C is incorrect because Parse JSON operation does not allow you to add a new property.

Question 8

A company receives documents as PDF attachments by email.

You need to process these documents automatically without user interaction by using Microsoft Power Platform.

Which two components should you use? Each correct answer presents part of the solution.

a. AI Builder
b. Canvas app
c. Power Automate cloud flow
d. Power BI
e. Power Virtual Agents

Answer 8

a. AI Builder
c. Power Automate cloud flow

AI Builder includes a document processing model that can extract information from a document. The AI Builder model can be called from a Power Automate cloud flow, which is triggered by the receipt of an email. The cloud flow uses AI Builder to extract the information from the document and process it with further cloud actions.

Choice B is incorrect because canvas apps enable users to interact with screens and forms.

Choice D is incorrect because Power BI is used for visualizing data and providing users with reports and dashboards.

Choice E is incorrect because Power Virtual Agents enable users to interact with a chatbot.

Question 9

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

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

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

Which type of Power Automate flow should you select?

a. automated cloud flow
b. business process flow
c. desktop flow
d. scheduled cloud flow

Answer 9

c. desktop flow

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

Choice A is incorrect because an automatically triggered cloud flow is used when you want to automate modern applications that include modern APIs.

Choice B is incorrect because business process flows are used to guide users through an organizational process from start to end.

Choice D is incorrect scheduled cloud flows are used when you want to automate modern applications that include modern APIs.

Question 10

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?

a. Canvas app
b. Model-driven app
c. Power Apps portal
d. Business process flow

Answer 10

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.

Choice B is incorrect because Model-driven apps can use only Microsoft Dataverse as the underlying data store.

Choice C is incorrect because Power Apps portals allow external customers and partners to access data in Microsoft Dataverse.

Choice D is incorrect because 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.

Question 11

A company uses Microsoft Power Platform.

You need to recommend a use case for formulas in canvas apps.

Which two actions should you recommend? Each correct answer presents a complete solution.

a. Control which users can run a canvas app
b. Filter a list of rows
c. Save data when a user selects a button
d. Return XML data from a web page

Answer 11

b. Filter a list of rows
c. Save data when a user selects a button

FILTER is a common formula used in canvas apps to restrict the rows from a data source or collection.

The OnSelect property for a button contains the actions to perform.

Formulas such as SubmitForm and Patch are used to save data to a data source. Formulas are not used to share a canvas app. Formulas can only be used when building a canvas app.

There is no equivalent formula for the WEBSERVICE Excel function that retrieves XML data from an internet URL.

Question 12

You create an app.

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

What should you use?

a. Model-driven app
b. Power Apps portal
c. Canvas app
d. Microsoft Dataverse

Answer 12

c. Canvas app

Canvas apps can use data from different sources including Azure SQL databases.

Model-driven apps and Power Apps portal use data coming from Microsoft Dataverse, not Azure SQL databases. Microsoft Dataverse is a data platform.

Question 13

You create a canvas app.

You need to format currency values in the app to always display two decimal places.

Which code segment should you use?

a. Text(“Currency value”, “$#, ###0.00”)
b. Match(“Currency value” , “#,###0.00”)
c. PlainText(“Currency value”, “#,###0.00”)
d. Value(“Currency value”, “#,###0.00”)

Answer 13

a. Text(“Currency value”, “$#, ###0.00”)

The Text function formats a number or datetime value based on the specified format.

Choice B is incorrect because the Match function is used to extract the first text string that matches a pattern.

Choice C is incorrect because the PlainText function removes HTML and XML tags.

Choice D is incorrect because the Value function converts a string of text that contains number characters to a number value.

The Match, PlainText, and Value functions cannot be used to format numbers.

Question 14

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.

a. Access app anonymously
b. Control functionality with Microsoft Fx Formulas
c. Embed entire Power BI dashboards.
d. Include artificial intelligence

Answer 14

b. Control functionality with Microsoft Fx Formulas
d. Include artificial intelligence

Canvas apps use Power Fx formulas to control the visual elements of the screens and the actions taken such as retrieving and displaying data.

Canvas apps can include AI controls for form processing and object detection.

Choice A is incorrect because canvas apps require that users be authenticated with Azure Active Directory (Azure AD), not anonymously.

Choice C is incorrect because canvas apps can embed individual tiles from Power BI dashboard but not entire dashboards. Model-drivel apps can add a Power BI dashboard.

Question 15

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.

a. Radio
b. Combo box
c. Dropdown
d. List box
e. Rating

Answer 15

b. Combo box
c. Dropdown
d. List box

A combo box control, a dropdown control, and a list box control can be used to select multiple values.

Choice A is incorrect because a radio control is used to show options that are mutually exclusive.

Choice E is incorrect because a rating control can store only a single value.

Question 16

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?

a. Gallery
b. Form
c. Drop-down
d. Data table

Answer 16

a. Gallery

The Gallery control displays the multiple records from data source and each record can contain multiple types of data including images.

Choice B is incorrect because Forms displays a single record. It cannot be used to show a list of items.

Choice C is incorrect because the Drop-down control cannot display image column of Dataverse.

Choice D is incorrect the Data table control cannot display image column of Dataverse.

Question 17

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.

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

Answer 17

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.

Choice B is incorrect because 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.

Choice D is incorrect because publishing the app to Microsoft AppSource makes it available for others to find and use the app.

Question 18

A company has a model-driven app.

You need to enable all users to access data in the app.

What should you do?

a. Create a new table
b. Create a new model-driven app
c. Create a new personal view.
d. Create a new public view

Answer 18

d. Create a new public view

All the users will be able to use this view to access the data.

It is not necessary to create a separate table or a new model-driven app.

A personal view is not available to other users.

Question 19

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?

a. canvas application
b. desktop flow
c. Power Pages site
d. model-driven application

Answer 19

d. model-driven application

Model-driven applications are used to create backend applications connected to Dataverse.

They are typically used by management and other employees and can include business process flows for providing guidance to employees.

Choice A is incorrect because canvas applications are used to create applications targeted at specific scenarios.

Choice B is incorrect because desktop flows are used to create robotic process automations that automate manual tasks typically done by end users.

Choice C is incorrect because Power Pages sites provide external users access to Dataverse data. They use model-driven application forms and views to display information to external users.

Question 20

A company has a sales management model-driven app.

You need to add the contact job titles in the list of contacts that is displayed in the account form.

What should you modify?

a. app sitemap
b. contact form
c. account form
d. contact view
e. account view

Answer 20

d. contact view

The contact view that is displayed in the account form needs to be modified to include the contact’s job title.

Choice A is incorrect because the app sitemap defines the navigation and components that are part of the app; the form and the view are already part of it.

Choice B is incorrect because the contact form is used to display the details of a specific contact, but the request is about the list of contacts

Choice C is incorrect because the account form is used to display the list of contacts (view) but doesn’t define which columns appear in it.

Choice E is incorrect because the account view lists accounts, not the contacts.

Question 21

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

Answer 21

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

Question 22

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

Answer 22

c. Power Apps

Power Apps provides a rapid low code development environment for building custom apps for business needs.

Choice A is incorrect because Power Automate is used to create workflows between applications and services.

Choice B is incorrect because Power Virtual Agents allows chatbots to be created.

Choice D is incorrect because Power BI is a business analytics service.

Question 23

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

Answer 23

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.

Question 24

You need to create an approval process for sales quotes.

Which Microsoft Power Platform component should you use?

a. Power Virtual Agents
b. Power Automate
c. AI Builder
d. Power BI

Answer 24

b. Power Automate

Power Automate can create approval processes.

Choice A is incorrect because Power Virtual Agents is used to create chatbots.

Choice B is incorrect because AI Builder is used to create and train models to analyze data using AI.

Choice D is incorrect because Power BI is a business analytics service.

Question 25

A company has a Power Apps portal that has a list of their retail stores. You need to add retail store hours to the portal. Which two Microsoft Power Platform components should you use? Each correct answer presents a complete solution. a. Power BI b. Power Automate c. Power Virtual Agents d. Canvas App

Answer 25

a. Power BI c. Power Virtual Agents A Power BI report or dashboard can be embedded inside a Power Apps portal. A Power Virtual Agents chatbot can be integrated into a Power Apps portal. Choice B is incorrect because Power Automate is used to create automated workflows between applications and services. Choice D is incorrect because Canvas apps are not meant for external users.

Question 26

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? a. Sandbox b. Trial c. Microsoft Dataverse for Teams d. Default

Answer 26

a. Sandbox 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. Choice B is incorrect because A trial environment is limited to a single user and expires after 30 days. Choice C is incorrect because A Microsoft Dataverse for Teams environment is restricted to users who are a member of the associated team. Choice D is incorrect because the default environment cannot be backed up.

Question 27

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.

Answer 27

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. Choice B is incorrect because 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. Choice C is incorrect because 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. Choice D is incorrect because auditing in Microsoft Dataverse captures changes to data in Microsoft Dataverse tables. Auditing does not prevent data leakage.

Question 28

A company has three branch offices in New York, Paris, and Madrid. You need to create the Microsoft Dataverse environments and the Microsoft Dataverse instances. What should you do? a. Create one environment with three instances b. Create three environments, each with one instance c. Create two environments, the first with one instance and the second with two instances d. Create three instances with no environments

Answer 28

b. Create three environments, each with one instance An environment has only one Microsoft Dataverse instance. An environment is required to host a Microsoft Dataverse instance.

Question 29

A company uses Microsoft Power Platform to manage support activities. Support technicians must be notified by email when a new support request is created. You need to recommend the appropriate tool to meet this requirement. Which tool should you recommend? a. AI Builder b. Power Pages c. Power BI d. Power Automate

Answer 29

d. Power Automate Power Automate is a service that helps create automated workflows between apps and services to synchronize files, get notifications, and collect data. Power Automate has built-in connectors to send emails. For example, the Office 365 Outlook connector can be used to send email notifications by using Outlook. Choice A is incorrect because AI Builder is used to create and train models to analyze data by using AI. Microsoft Power Platform has prebuilt AI Builder models. There is also the option to create custom models. AI Builder cannot be used to configure email automations. Choice B is incorrect because Power Pages is a SaaS platform for creating, hosting, and administering external-facing business websites with data from Dataverse. This platform cannot be used to send automated email notifications. Choice C is incorrect because Power BI is an analytical platform for visualizations that uses data from multiple sources. This platform cannot be used to configure email automations.

Question 30

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

Answer 30

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.

Question 31

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? a. Power Virtual Agents b. Power Automate c. Power BI d. Power Pages

Answer 31

c. Power BI

Question 32

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? a. Standard b. Activity c. Custom d. Virtual

Answer 32

a. Standard Several standard tables, also known as out-of-the-box tables, are included with a Microsoft Dataverse environment. The Currency table is one of those tables. Choice B is incorrect because 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. Choice C is incorrect because 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. Choice D is incorrect because 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.

Question 33

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. a. File and image support b. Multiple currency support c. Relational storage d. Mobile offline

Answer 33

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

Question 34

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? a. Choice b. Choices c. Yes/No d. Customer

Answer 34

b. Choices The Choices column type can select multiple options between multiple values. Choice A is incorrect because the Choice column type can select only one option between multiple values. Choice C is incorrect because the Yes/No column type can select only one option between two values. Choice D is incorrect because Customer references to an Account or a Contact.

Question 35

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. a. Premium HTTP connector b. Custom Connector c. Word Online (Business) connector d. Excel Online (Business) connector

Answer 35

a. Premium HTTP connector b. Custom Connector The Premium HTTP connector and a custom connector can fetch data from a custom API. The Word Online (Business) connector and the Excel Online (Business) connector can only work with Word files in document libraries supported by Microsoft Graph.

Question 36

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

Answer 36

b. Custom connector Custom connectors can be used to connect to custom APIs and pull data, in the absence of a prebuilt connector. Choice A is incorrect because AI Builder connector enables adding intelligence to automated processes, predicting outcomes, and helping improve business performance. Choice C is incorrect because 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. Choice D is incorrect Dataflows are used to extract and transform data. They cannot be used to fetch data in a Power Automate flow.

Question 37

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? a. Assign a Power Automate Flow license to the cloud flow. b. Assign a user that has more permissions to the connector. c. Ask a user who has the System Administrator security role to edit the cloud flow d. Create a custom connector and use it in the cloud flow

Answer 37

d. Create a custom connector and use it in the cloud flow Based on the API documentation, you can create a custom connector that will let you add the new feature. Choice A is incorrect because assigning a Power Automate Per Flow license to the cloud flow will not impact the connector’s list of actions. Choice B is incorrect because changing the connection for a different user will only impact the data permissions; it will not add new features to a connector. Choice C is incorrect because the security role of the user editing the cloud flow has no impact on the connector’s list of actions.

Question 38

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

Answer 38

c. Power Automate Power Automate cloud flows can be called from a Power Virtual Agents chatbot. The cloud flow can connect to Microsoft Dataverse to perform actions. Choice A is incorrect because connections cannot be added to Power Virtual Agents chatbots. Choice B is incorrect because entities are used in Power Virtual Agents chatbots to assist in natural language understanding. Choice D is incorrect because Topics are the conversations handled by a Power Virtual Agents chatbot.

Question 39

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? a. Prebuilt entities b. Custom entities c. Variables d. Topics

Answer 39

a. Prebuilt entities 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. Choice B is incorrect because custom entities are not required since there are prebuilt entities which capture email addresses. Choice C is incorrect because variables in Power Virtual Agents store customer responses that can be later used in the conversation. Choice D is incorrect because 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.

Question 40

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

Answer 40

d. Custom entities A Power Virtual Agents entity allows a chatbot to map natural language to a general subject. Choice A is incorrect because topics are used to determine the general category of the conversation. Choice B is incorrect because 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. Choice C is incorrect because 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.

Question 41

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

Answer 41

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.

Question 42

A company is considering using Power Pages for its website. You need to determine whether the use cases for Power Pages meet the company’s requirements. What is a use case for Power Pages? a. Capturing data from customers b. Carrying out integration between systems c. Chatting between an AI-powered chatbot and customers d. Creating visualizations of data.

Answer 42

a. Capturing data from customers Forms can be included in a Power Pages site. External users can access Dataverse data by using these forms and can create, view, and edit rows in a Dataverse table. Choice B is incorrect because integrations between systems can be performed by using connectors in Power Automate cloud flows. Choice C is incorrect because chatting between AI-powered chatbots and customers is performed by using Power Virtual Agents. Choice D is incorrect because Power BI content can be embedded in a Power Pages site, but Power Pages does not create the visualizations.

Question 43

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? a. Train the model b. Publish the model c. Share the model d. Test the model

Answer 43

c. Share the model The life cycle of creating a custom AI Builder model consists of creating, training, publishing, and testing the model within your apps or flows. When a model is published, the model is available only to the maker unless it is explicitly shared with other users. Training or publishing a model does not make it available for users.

Question 44

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. a. sentiment analysis b. text recognition c. language detection d. object detection e. document processing

Answer 44

a. sentiment analysis b. text recognition c. language detection 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.

Question 45

The manager of a retail store wants to provide a self-service solution for customers who want to track their orders. You need to recommend a solution based on Microsoft Power Platform. Which solution should you recommend? a. model-driven app using Power Apps b. canvas app using Power Apps c. website portal using Power Pages d. dashboard using Power BI

Answer 45

c. website portal using Power Pages Power Pages are intended for external-facing users and allow you to provide customers with a platform where they can track their orders. Choices A and B are incorrect because canvas and model-driven Power Apps are targeted to internal users. Choice D is incorrect because Power BI dashboards are intended for users who consume analytic data, not for transactional interactions.

Question 46

A company uses Power BI. You need to collaborate with others to build visualizations. What should you use? a. Dataset b. My workspace c. Dashboard d. Workspace

Answer 46

d. Workspace Workspaces are used to collaborate on building content for Power BI including datasets, reports, and dashboards. Choice A is incorrect because datasets are created when data is imported. Visualizations are created from datasets. A dataset can be used in many workspaces but to collaborate, a workspace must be used. Choice B is incorrect because my workspace is a personal space for creating reports and dashboards in Power BI. This workspace cannot be used to collaborate. My workspace is a personal space for creating reports and dashboards in Power BI, which cannot be used to collaborate. Choice C is incorrect because dashboards can be created from the visualizations in the reports.

Question 47

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. a. Pie Chart b. KPI c. Map d. Line Chart

Answer 47

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. Choice A is incorrect because a pie chart is meant to show the relationship of parts to a whole. Choice B is incorrect because a KPI is meant to show the progress towards a goal.

Question 48

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

Answer 48

c. Bar Using a bar chart, specific value across different categories can be displayed. Choice A is incorrect because pie charts show the relationship of parts to the whole. Choice B is incorrect because funnels help visualize a process that has stages, and items flow sequentially from one stage to the next. Choice D is incorrect because 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.

Question 49

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

Answer 49

c. Bar Using a bar chart, specific value across different categories can be displayed. Choice A is incorrect because pie charts show the relationship of parts to the whole. Choice B is incorrect because funnels help visualize a process that has stages, and items flow sequentially from one stage to the next. Choice D is incorrect because 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.

Question 50

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? a. Sum b. Median c. Latest d. Count

Answer 50

d. Count Power BI aggregates text data as distinct categories and counts the occurrences of each category. Choice A is incorrect because only the numeric fields are aggregated as a sum. Choice B is incorrect because only the numeric fields are aggregated as a median Choice D is incorrect because only date fields use the latest aggregate.

Question 51

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? a. Dot plot b. Bar c. Combo d. Gauge

Answer 51

b. Bar Bar charts are used to visualize and compare data across categories. Choice A is incorrect because dot plot charts allow you to compare multiple measures by their magnitudes and represent the data with dots. Choice C is incorrect because 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. Choice D is incorrect because 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.

Question 52

A company uses Power BI. You create a Power BI report and publish it to the Power BI service. You need to create a dashboard containing tiles for individual visualizations. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. a. Pin a visualization b. Pin a live report page c. Select a visual from the visualization pane d. Use the Q&A question box

Answer 52

a. Pin a visualization d. Use the Q&A question box A visualization can be selected and then pinned to a new or an existing dashboard. The Q&A feature on the dashboard allows asking a question about the data and this generates visualizations that can be pinned to the dashboard. Choice B is incorrect because pinning a live report page will add the page and all its visualizations to a dashboard Choice C is incorrect because the visualization pane is available for reports not for dashboards. A visual must be added to the report and then pinned to a dashboard.

Question 53

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

Answer 53

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. Choice A is incorrect because Power Automate Desktop does not support approvals Choice B is incorrect because Power Automate Mobile app does not show the file attached inside the approvals.

Question 54

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

Answer 54

b. Data Operation The Data Operation connector has actions to transform and shape arrays including the Filter Array action. Choice A is incorrect because Microsoft Dataverse connector allows performing operations in Microsoft Dataverse, which is a data store in Microsoft Power Platform. Choice C is incorrect because the control connector contains the condition and loop actions. Choice D is incorrect because the SharePoint connector contains all the actions to perform actions with SharePoint.

Question 55

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

Answer 55

d. Scheduled cloud flow Schedule flows run on an interval. The flow can be set to run once a day. Choice A is incorrect because Instant flows are usually triggered with manual action. In this case, the flow must run by itself daily. Choice B is incorrect because 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. Choice C is incorrect because business process flows are used to guide users through multi-step processes. In this case, the flow is taking place without human intervention.

Question 56

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

Answer 56

d. Instant Instant flows can be triggered by a button in the Power Automate mobile app. Choice A is incorrect because 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. Choice B is incorrect because 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. Choice C is incorrect 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.

Question 57

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

Answer 57

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.

Question 58

A sales company plans to use Microsoft Power Platform and Dataverse to build solutions to help manage its day-to-day operations. The company requires a solution that at the end of each workday automatically identifies and cancels appointments from the previous workday that are not marked as complete. You need to create a Power Automate cloud flow that meets the requirement. Which type of cloud flow should you create? a. automatic flow that is triggered when an appointment is updated b. scheduled flow that runs daily at a specific time c. instant flow triggered when someone selects a button d. automatic flow that is triggered when a new appointment is created

Answer 58

b. scheduled flow that runs daily at a specific time Scheduled flows run on predefined schedules. When run, they can easily include actions that identify and update multiple records at a time. Choice A is incorrect because a flow that is automatically triggered when a record is updated is used to update the record that caused the flow to trigger. Choice C is incorrect because a flow associated with a button push will require manual input from a user. Choice D is incorrect because an automatic flow triggered when a new record is created is used to perform actions on the record that caused the flow to trigger.

Question 59

You build a Power BI report by using Power BI Desktop. The data is based on a complex set of data that includes multiple data tables that have many-to-one relationships with each other. You need to visually represent the tables and their relationships so that you can understand the data you are working with before you build the report. What should you do? a. Click on the Report view and add a Table visualization for each table to your report. b. Click on the Report view and add the Matrix visualization to your report. c. Click on the Data view and choose the table you want to examine. d. Click on the Modeling view and examine the diagram of available tables and their relationships with each other. e. Click on the Modeling tab and create a new table.

Answer 59

d. Click on the Modeling view and examine the diagram of available tables and their relationships with each other. The Modeling view allows viewing a diagram of available tables and their relationships with each other. Choices A and B are incorrect because adding a visualization to the report does not help with understanding the data structure in advance of building the report. Choice C is incorrect because the Data view allows viewing the rows and columns of your data, but it does not help with understanding the relationships between tables in your data. Choice E is incorrect because adding a new table to the data model will not help with viewing the existing tables and their relationships.

Question 60

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? a. Share the dataset containing sales data. b. Share the reports in the dashboard. c. Share the dashboard. d. Create and share a Power BI app.

Answer 60

a. Share the dataset containing sales data A dataset can be shared and can be used to create new reports and dashboards. Choice B is incorrect because 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. Choice C is incorrect because 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. Choice D is incorrect because when an app is shared, reports and dashboards can only be viewed in the app.

Question 61

You create a Power BI report. You need to share the report with internal users. Which two actions should you perform? Each correct answer presents a complete solution. a. Add a comment inside the report b. Add the reports to favorites c. Embed the report in a secure portal d. Use the Power BI mobile app

Answer 61

c. Embed the report in a secure portal d. Use the Power BI mobile app Embedding the report in a secure portal is a way to share the report. Reports can be shared using the Power BI mobile app. Adding a comment and adding the report to the favorites will not share the report.

Question 62

You 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. a. Data b. Report c. Model d. Filters

Answer 62

a. Data c. Model 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. Choice B is incorrect because the report section allows creating visualizations from the data source. Choice D is incorrect because 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.

Question 63

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

Answer 63

b. Choice The Choice column type allows users to select only a single value from the list of values. Choice A is incorrect because the Choices column type allows users to select more than one value. Choice C is incorrect because the Yes/ No column type allows only two values: Yes and No. It cannot be used to display more than two options. Choice D is incorrect because 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.

Question 64

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

Answer 64

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. Choice A is incorrect because Power Apps are used to create graphical forms. In this solution, no form or user interface is required. Choice C is incorrect because 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. Choice D is incorrect because 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.

Question 65

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

Answer 65

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

Question 66

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

Answer 66

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.

Question 67

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

Answer 67

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.

Question 68

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? a. Model-driven app b. Power BI c. Power Apps portal d. Power Automate

Answer 68

c. Power Apps portal A Power Apps portal can be configured to create new requests from external users. Choice A is incorrect because External users are not allowed to use model-driven apps. Choice B is incorrect because Power BI is a business analytics service. Choice D is incorrect because Power Automate does not allow external users to trigger a request.

Question 69

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

Answer 69

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. Choice A is incorrect because Dynamics 365 Customer Insights provides a 360 view of customer data by unifying the data from various data sources in silos. Choice C is incorrect because Power Automate is used for process and UI automation. Choice D is incorrect 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.

Question 70

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? a. Power Virtual Agents b. Power Automate c. Power BI d. Power Pages

Answer 70

c. Power BI 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. Choice A is incorrect because Power Virtual Agents is used to create intelligent chatbots that can be used across a business. Choice B is incorrect because Power Automate is used to create automation solutions. Choice C is incorrect because Power Pages is used to externally facing websites.

Question 71

A coworker requires a personal Microsoft Power Platform environment to test preview features of Power Apps. The coworker wants to use this environment for at least two months. You need to recommend which type of environment the coworker should create. Which type of environment should you recommend? a. default b. production c. developer d. trial

Answer 71

c. developer The developer environment type is intended to be used by its owner and is available as long as it is actively used. Choice A is incorrect because the default environment type is automatically provisioned by the system and cannot be created for single users. Choice B is incorrect because the production environment type is intended for permanent work, not for testing preview features. Choice D is incorrect because the trial environment type is intended for short-term testing but expires after 30 days.

Question 72

A tire manufacturer stores manufacturing data in SQL Server and sales data in Microsoft Dataverse tables. An operations manager needs to view a single page of information each day that shows the following: -> The number of defects in the manufacturing process. -> The sales by geographic region from the prior day. You need to configure Power BI. Which action should you perform? Select only one answer. a. Select the proper dataset by using the Power BI service b. Create a Power BI Dashboard by using the Power BI service. c. Create a Power BI report by using Power BI Desktop. Publish the report to the Power BI service. d. Create a Power BI report by using the Power BI service. e. Build a Power BI report by using the Power BI Report Builder. Publish the report to the Power BI service.

Answer 72

b. Create a Power BI Dashboard by using the Power BI service. Dashboards allow the aggregation of data into a single page, and they can only be published in the Power BI service. Connecting to the data does not actually create or publish the visualization of the data. Power BI reports allow users to drill into data, but not aggregate multiple datasets.

Question 73

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

Answer 73

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. Choice A is incorrect because alternate keys are created for integrations with other systems. Choice B is incorrect because 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. Choice D is incorrect because 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.

Question 74

You plan to create a data model by using Microsoft Dataverse. You have a column that allows users to select one of two options: Approve or Reject. You need to allow for adding more options to the column or changing the label of the options in the future. Which type of column should you create? a. Choice b. Choices c. Yes/No d. Text

Answer 74

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

Question 75

A company uses Microsoft Power Platform. You create a custom connector from an OpenAPI file. You need to allow other makers in your organization to use the connector. What should you do? a. Define a policy by using a template a policy template b. Run the paconn command c. Share the connector d. Submit the connector for certification

Answer 75

c. Share the connector The custom connector needs to be shared to allow other makers to use the connector in their apps and flows. Chooice A is incorrect because Policies on custom connectors are used to configure the connector at runtime. Policies do not make the connector available for other makers. Choice B is incorrect because the paconn command line tool can be used for development of custom connectors. Choice D is incorrect because the custom connector can only be submitted if the connector needs to be availably publicly.

Question 76

A company uses Power Virtual Agents to display information to authenticated users. You need to retrieve data from a Microsoft Dataverse table. What should you use? a. Topic b. Prebuilt entities c. Custom entities d. Actions

Answer 76

d. Actions Actions are used to call Power Automate flows that can retrieve information from a Microsoft Dataverse table. Choice A is incorrect because topics are used to direct the bot conversation. Choice B is incorrect because prebuilt entities represent commonly used real-world subjects like phone number, zip code, email, age, etc. Choice C is incorrect because custom entities are used to provide a choice to users for domain-specific custom information.

Question 77

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

Answer 77

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. Choice A is incorrect because the blank page template creates a site consisting of a single home page to which you must then add pages and other content. Choice B is incorrect Dynamics 365 templates require the corresponding Dynamics 365 app to be installed in the environment.

Question 78

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

Answer 78

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. Choice B is incorrect because an iframe component is used to embed a web page from another website by using a URL, and it cannot display data from Dataverse. Choice D is incorrect a text component displays static text and cannot display data from Dataverse.

Question 79

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

Answer 79

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. Choice A is incorrect because Power BI is an analytical platform to create visualizations by using data from various sources. It cannot be used to detect sentiment in text. Choice B is incorrect because Dataverse is used to manage and store data. It cannot be used to detect sentiment in text. Choice D is incorrect because 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.

Question 80

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

Answer 80

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. Choice A is incorrect because Desktop flows are used for robotic process automation (RPA). Choice D is incorrect because Flow templates are templates, not real flows.

Question 81

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

Answer 81

d. Instant Instant flows can be triggered by a button in the Power Automate mobile app. Choice A is incorrect because 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. Choice B is incorrect because 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. Choice C is incorrect because 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.

Question 82

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? a. Edit form b. Data table c. Gallery d. Vertical container

Answer 82

a. Edit form 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. Choice B is incorrect the data table control can be used for viewing data in a data source but cannot be used for editing that data. Choice C is incorrect because the gallery control is used to allow users to view or select items in a list but cannot be used for editing values. Choice D is incorrect because 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

Question 83

A company plans to use Power Automate to help digitize its operations. The company requires a solution that creates invoices in an application that does not include modern APIs. You need to select the Power Automate flow that meets the requirement. Which type of Power Automate flow should you select? a. automatic cloud flow b.

Question 84

You plan to create a canvas app that allows users to view a list of current scores for all local professional sporting events. Each game should display the following: -> Name of the game. -> Amount of time left in the game. -> A link to a map of the game’s location. You need to add controls to your Power Apps app. Which two controls should you use? Each correct answer presents part of the solution. a. Form b. Screen c. List box d. Data table e. Gallery

Answer 84

b. Screen e. Gallery A canvas app must have a minimum of one screen. A screen is a container for other controls. Adding a gallery control tied to game data means that each game can be displayed as an item in the gallery. Additionally, you can add other controls to a gallery item, such as a link to the game location. Choice A is incorrect because a form control displays information from one record in a dataset but does not present the data from multiple rows of data at once Choice C is incorrect because a list box is used for displaying a list of values when a user needs to choose options from an available list Choice D is incorrect because A data table returns information in a tabular format like a spreadsheet. It does not allow rich formatting such as adding hyperlinks to row or column data.

Question 85

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

Answer 85

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. Choice B is incorrect because Business process flows are associated with a Microsoft Dataverse table not the forms for the table. Choice D is incorrect because a view displays columns from the table but as a list. A form is required to edit the data.

Question 86

You create a model-driven app by using Power Apps. The app uses a custom Microsoft Dataverse table that has no privileges assigned. You need to share the app with a user. Which two actions should you perform? Each correct answer presents part of the solution. a. Assign a security role to the custom table. b. Select the user with whom you want to share the app and select a security role for the user. Click the Share button. c. Select the user with whom you want to share the app and select the co-owner checkbox. d. Navigate to the details page and copy the web link to the app. Share the link with the user.

Answer 86

a. Assign a security role to the custom table. b. Select the user with whom you want to share the app and select a security role for the user. Click the Share button. For users to have access to the custom table in the app, a security role must be assigned to it. To share a model-driven app, a security role must be assigned to a user when sharing the app. Choice C is incorrect because when sharing a canvas app, a co-owner can be selected. In this case, a co-owner cannot be set because this is a model-driven app. Choice D is incorrect because navigating to the details page this will give the user the location of the app, but it will not grant any permissions to the user. If the user has not already been granted permission, they will get an error message when they load the Power Apps app.

Question 87

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. a. The app 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

Answer 87

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.

Question 88

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. a. Add the column to the view b. Add the column on the form c. Publish customizations d. Add a page

Answer 88

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.

Question 89

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? a. One-to-many b. Many-to-many c. Many-to-one d. Hierarchical self-referential

Answer 89

b. Many-to-many Many-to-many relationships between customer and product will allow multiple products to be associated with multiple orders. Choice A is incorrect because one-to-many relationships between customer and product will allow a product to be related to only one order and cannot be used in subsequent orders. Choice C is incorrect because many-to-one relationships between customer and product will allow users to select only one product for an order Choice D is incorrect because a hierarchical self-referential can be established only within one table. It cannot be used to establish a relationship between two tables.

Question 90

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. a. Open the report using Power BI service b. Open the report using Power BI Desktop c. Select Transform data and then select Custom Column d. Select the Data tab and then select New Column

Answer 90

b. Open the report using Power BI Desktop d. Select the Data tab and then select New Column You must open the report using Power BI Desktop. Power BI Desktop is used to add a calculated column. Creating a new column inside the model is a way to add a calculated column. Choice A is incorrect because calculated columns cannot be added using Power BI Service. Choice C is incorrect because custom columns are different from calculated columns.

Question 91

You plan to create a Power BI report from Microsoft Dataverse. You need to identify which components are available when you create a report using Power BI Desktop. Which two components should you identify? Each correct answer presents a complete solution. a. Shaping and modeling data b. Calculated columns c. Sharing d. Dashboards

Answer 91

a. Shaping and modeling data b. Calculated columns Using Power BI Desktop, data can be shaped and transformed from a data source. Calculated columns and measures can be calculated in a Power BI report using Power BI Desktop. Reports and dashboards can only be shared using Power BI service. It cannot be done using Power BI Desktop. Dashboards cannot be created in Power BI Desktop. You can create reports using Power BI Desktop which can be pinned to dashboards.

Question 92

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. a. Rename the columns in Table 2 to Product Name and Units sold b. Pivot the Units sold column c. Transpose Table 2 d. Remove the columns Toy name and Numbers sold form Table 2 e. Append the data from Table 1 to the data in Table 2

Answer 92

a. Rename the columns in Table 2 to Product Name and Units sold e. Append the data from Table 1 to the data in Table 2 You must rename the columns from Table 2 for the appended column data to appear in the same columns as the first set of data from Table 1. Otherwise, your combined data would have four columns (Product name, Units Sold, Toy name, and Number sold) instead of 2 (Product name and Units sold). Appending the data from one table to the other will create a single dataset that can be used in the report. Choice B is incorrect because pivoting the Units Sold column will transform the table in a way that makes the data unmeaningful. Choice C is incorrect because 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. Choice D is incorrect because Removing the columns from Table 2 will remove all the data that needs to appear in the merged data set.

Question 93

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? a. Dataverse b. AI Builder c. Power BI d. Power Apps

Answer 93

b. AI Builder You can use the AI Builder entity extraction model to extract entity information such as city, color, phone number, and location from text. The model can be used in a Power Apps app or in a Power Automate flow. Choice A is incorrect because Dataverse is used to store and manage data. It cannot be used to extract information from text. Choice C is incorrect because Power BI is a business intelligence platform that is used to create visualizations. It cannot be used to extract information from text. Choice D is incorrect because The Power Apps framework is used to create a UI and does not have the feature on its own to extract information from text. To enable this feature in a Power Apps app, AI Builder needs to be used.

Question 94

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? a. Train the model and publish the model b. Change the name of the model c. Include additional historical data for the model d. Assign you the Basic User security role

Answer 94

a. Train the model and publish the model By training the model and then publishing it, it will become available for Power Automate cloud flows. Choice B is incorrect because changing the model's name will not affect its availability in the list. Choice C is incorrect because adding more training data to the model will have no impact on its availability in the cloud flows. Choice D is incorrect because 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.

Question 95

You build a canvas app for users to request a new project. You need to build a solution that meets the following requirements: 1. Information about the request must be stored in a SharePoint Online list. 2. 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. a. Add a connection to Microsoft Teams b. Create an instant cloud flow c. Create an automated cloud flow d. Add a connection to Microsoft Project

Answer 95

a. Add a connection to Microsoft Teams c. Create an automated cloud flow 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. Choice B is incorrect because an instant flow has a manual trigger. The requirements state that a new team must be created automatically. Choice D is incorrect because Microsoft Project is not required for this solution.

Question 96

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 Services 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

Answer 96

a. Connect to Azure Cognitive Services 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. Choice B is incorrect because 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. Choice D is incorrect because this scenario uses Microsoft Exchange Online so there is no need to connect to a Microsoft Exchange Server hosted on-premises.

Question 97

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. a. Notify the users by email b. Allow the users to edit the app c. Publish the app d. Assign a security role

Answer 97

c. Publish the app d. Assign a security role 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. Choice A is incorrect because the email is only a notification. It does not affect sharing capabilities. Choice B is incorrect because to share an app, it is not required to allow users to edit it.

Question 98

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. a. Power Apps Studio b. Power Apps maker portal c. SharePoint document library d. SharePoint list

Answer 98

b. Power Apps maker portal d. SharePoint list 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. Choice A is incorrect because the Power Apps Studio allows editing an app not creating an app from data. Choice C is incorrect becayse an app can only be created from a SharePoint list not from a document library.

Question 99

You plan to build a canvas app. You need to ensure the app is automatically available to all members of a Microsoft 365 group. What should you do? a. Create the app in a Microsoft Dataverse for Teams environment b. Create a Microsoft Dataverse sandbox environment and a Microsoft Dataverse production environment. Build the app in the sandbox environment. Export the app and import it into the production environment. c. Create the app in the production environment. Share the app with the Microsoft 365 group owners. d. Create the app in the default environment and share the app with the individual members of the Microsoft 365 group.

Answer 99

a. Create the app in a Microsoft Dataverse for Teams environment Power Apps created in Microsoft Dataverse for Teams are automatically shared with all the members of the Microsoft 365 group to which the Team is associated. This solution requires Microsoft Dataverse for Teams to satisfy the requirements. While multiple environments can be used with Microsoft Dataverse, only one environment can exist when using Microsoft Dataverse for Teams. Additionally, apps created in other environments are not automatically shared with all the users the way they are when created in a Microsoft Dataverse for Teams environment.

Question 100

You have a Power Automate flow that fetches a list of contacts from Microsoft Dataverse. You need to loop through contact collection and perform operations on each record. Which connector should you use? a. Data Operation b. Control c. Content Conversion d. Microsoft Dataverse

Answer 100

b. Control The Control connector has an ‘Apply to each’ action that can be used through collection records. The other connectors cannot be used to loop through collections. Choice A is incorrect because the Data Operation connector contains actions to shape and transform data. Choice C is incorrect because the Content Conversion connector converts HTML to text. Choice D is incorrect because Microsoft Dataverse is a Microsoft Power Platform data source, and it has actions to perform operations on database tables and rows

Question 101

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? a. trigger b. action c. condition d. loop

Answer 101

b. action An action does something in a flow. In this case, you will use an action to send an email. Choice A is incorrect because triggers are used to start a flow but do not carry out an action such as sending an email. Choice C is incorrect because 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. Choice D is incorrect because a loop is used to loop through items in a collection. In this case, there is no collection, so no loop is required.

Question 102

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? a. AI Builder b. Model-driven apps c. Power Automate d. Microsoft Dataverse

Answer 102

c. Power Automate A canvas app can call a Power Automate cloud flow, alerts in Power BI dashboards can trigger a Power Automate cloud flow, and Power Virtual Agents chatbots can call a Power Automate cloud flow to perform actions on behalf of the chatbot. Choice A is incorrect because AI Builder can be used with canvas apps but cannot be used directly by Power BI or Power Virtual Agents. Choice B is incorrect because Model-driven apps can embed Power BI dashboards and canvas apps and but cannot link to Power Virtual Agents chatbots Choice D is incorrect because Canvas apps and Power BI dashboards can connect to data in Microsoft Dataverse but Power Virtual Agents chatbots cannot access Microsoft Dataverse directly and must use Power Automate to access data in Microsoft Dataverse.

Question 103

You configure security and compliance features in Microsoft Power Platform. You need to restrict access to all social media connectors. What should you configure? Select only one answer. a. Microsoft Dataverse security role b. License c. Data loss prevention (DLP) policy d. Office 365 security group

Answer 103

c. Data loss prevention (DLP) policy Data loss prevention policies can be used to control the use of connectors to data and services. DLP policies allow classifying connectors as business, non-business, and blocked. Microsoft Dataverse security roles can be used to provide users access to tables and records. Licenses can be used to allow users to access components of Microsoft Power Platform. Microsoft Dataverse security roles and licenses cannot be used to restrict access to specific social media connectors. Office 365 security groups can be used to control access to environments in Microsoft Power Platform.

Question 104

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

Answer 104

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.

Question 105

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. a. Select the label control. Select the color picker control in the toolbar and choose red from the color menu. b. Select the label control. Choose the Fill property in the formula bar. Set the formula value to Color.Red. c. Select the label control. Choose the Color property in the formula bar. Set the formula value to Color.Red. d. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Fill property and add Color.Red to the textbox. e. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Color property and add Color.Red to the textbox.

Answer 105

a. Select the label control. Select the color picker control in the toolbar and choose red from the color menu. c. Select the label control. Choose the Color property in the formula bar. Set the formula value to Color.Red. e. Select the label control. Open the Properties pane and choose the Advanced tab. Find the Color property and add Color.Red to the textbox. 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.

Question 106

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

Answer 106

b. building sites by using low-code tools d. exposing data in Dataverse to customers Power Pages enables low-code makers to build and deploy websites without needing to write code. Power Pages has tools to manage content, including the capability to expose data in Dataverse tables to external users such as customers. Choice A is incorrect because 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.