Etienne revision cards

Question 1

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?

Answer 1

Canvas App

Question 2

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?

Answer 2

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

Question 3

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?

Answer 3

Edit Form

Question 4

You configure a canvas app to track and order office stationery. The app allows users to order multiple stationery items.
The items selected by the user must be reset each time a user reopens the app.
You need to store user selections.
Which function should you use?

Answer 4

Collection

Question 5

You use a Microsoft Dataverse table to store products. You create a canvas app to list the products in the app.
You need to enable users to view the product code, description, and image of each product.
Which control should you use?

Answer 5

Gallery

Question 6

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.

Answer 6

The columns included in the view.
The filter for rows shown in the view.
The sort order of rows in the view.

Question 7

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?

Answer 7

Create the app in a Microsoft Dataverse for Teams environment.

Question 8

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

Answer 8

They adjust the layout of the UI automatically in response to changes in a device’s orientation or screen resolution.
They connect to multiple data sources.
They embed Power BI dashboards.

Question 9

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?

Answer 9

A Connector

Question 10

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

Answer 10

Azure Cognitive Services

Question 11

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

Answer 11

Data loss prevention (DLP) policy

Question 12

A company uses Microsoft Power Platform.
You need to prevent external leakage of corporate data.
What should you do?

Answer 12

Create data policies.

Question 13

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?

Answer 13

developer

Question 14

A company uses Power Automate to integrate applications.
You have a legacy application that does not have an application programming interface (API).
You need to determine which type of flow you should use to access the data in the legacy application.
What should you use?

Answer 14

Desktop flow

Question 15

You create a flow by using Power Automate. The flow must notify a user every time a new item is added to a SharePoint list.
You need to ensure an email notification is added to the flow.
What should you use?

Answer 15

action

Question 16

You create a Power Automate flow.
A connector in the flow returns an array of objects.
You need to filter the array.
Which connector should you use?

Answer 16

Data Operation

Question 17

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

Answer 17

Run after

Question 18

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

Answer 18

desktop flow

Question 19

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

Answer 19

Power Automate

Question 20

A company uses Power Virtual Agents to display information to authenticated users.
You need to retrieve data from a Microsoft Dataverse table.
What should you use?

Answer 20

Actions

Question 21

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?

Answer 21

Custom entities

Question 22

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?

Answer 22

Capturing data from customers.

Question 23

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?

Answer 23

form
list

Question 24

A company has a customer self-service portal. Customers log complaints through the portal.
You need to extract the city and product name from the complaints before routing them to a specific customer service center.
Which Microsoft Power Platform feature should you use?

Answer 24

AI Builder

Question 25

The manager of a retail store wants to provide a self-service solution for customers who want to track their orders.
You need to recommend a solution based on Microsoft Power Platform.
Which solution should you recommend?

Answer 25

website portal using Power Pages

Question 26

You need to create a Power BI dashboard for Power BI mobile apps.
What should you do?

Answer 26

Edit the phone view.

Question 27

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?

Answer 27

Pin a visualization.
Use the Q&A question box.

Question 28

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?

Answer 28

Canvas app

Question 29

A company wants to streamline the new employee onboarding process.
You need to allow new employees to manage their active certifications and work history by using an Excel workbook.
Which Power Apps solution should you use?

Answer 29

Canvas app

Question 30

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

Answer 30

Subarea

Question 31

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.

Answer 31

Add the column on the form.
Publish customizations.

Question 32

A company announces its new product launch on a social platform.
The company wants to analyze customers’ reviews on the platform to understand how they feel about its product.
You need to identify the Microsoft Power Platform service the company should use for the analysis.
What should you select?

Answer 32

AI Builder

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?

Answer 33

Multiple currency support

Mobile offline

Question 34

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?

Answer 34

Share the connector.

Question 35

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

Which two flow types should you use

Answer 35

Business process flow
Cloud flow

Question 36

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?

Answer 36

Create a new form for the Microsoft Dataverse table.
Select the form in the app designer.

Question 37

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?

Answer 37

Prebuilt entities

Question 38

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

Answer 38

Power Apps

Question 39

A company uses Microsoft Power Platform.
You need to recommend a use case for formulas in canvas apps.
Which two actions should you recommend?

Answer 39

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

Question 40

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?

Answer 40

Compose

Question 41

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?

Answer 41

Premium HTTP connector
Custom connector

Question 42

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?

Answer 42

Custom connector

Question 43

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

Answer 43

Use Performance Analyzer in Power BI Desktop

Question 44

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?

Answer 44

Power Apps maker portal
SharePoint list

Question 45

You edit a Power BI report.
You need to add a calculated column.
Which two actions should you perform?

Answer 45

Open the report using Power BI Desktop.
Select the Data tab and then select New column.

Question 46

You create a Power BI report.
You need to share the report with internal users.
Which two actions should you perform?

Answer 46

Embed the report in a secure portal.
Use the Power BI mobile app.