Microsoft Learn: Practice Assessment Flashcards

Question 1

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

c. Power BI

Question 32

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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

Q

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

A

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.

Answer 65

A

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.

Answer 66

A

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.

Answer 67

A

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.

Answer 68

A

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.

Answer 69

A

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.

Answer 70

A

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.

Answer 71

A

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.

Answer 72

A

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.

Answer 73

A

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.

Answer 74

A

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.

Answer 75

A

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.

Answer 76

A

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.

Answer 77

A

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.

Answer 78

A

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.

Answer 79

A

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.

Answer 80

A

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.

Answer 81

A

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.

Answer 82

A

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

Answer 83

A

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.

Answer 84

A

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.

Answer 85

A

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.

Answer 86

A

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.

Answer 87

A

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.

Answer 88

A

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.

Answer 89

A

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.

Answer 90

A

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.

Answer 91

A

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.

Answer 92

A

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.

Answer 93

A

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.

Answer 94

A

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.

Answer 95

A

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.

Answer 96

A

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.

Answer 97

A

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.

Answer 98

A

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.

Answer 99

A

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

Answer 100

A

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.

Answer 101

A

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.

Answer 102

A

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.

Answer 103

A

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.

Answer 104

A

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.

Answer 105

A

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.

Brainscape's Knowledge GenomeTM

Microsoft Learn: Practice Assessment Flashcards

Brainscape's Knowledge Genome^TM