Preview real exam questions, verified answers and available explanations before choosing a study plan.
Question 1
Single choice
A company uses Dynamics 365 Sales. The company uses a browser-based app named Sales Hub.
You need to ensure that users can access data from mobile devices.
Which app should users install?
A
Dynamics 365 Remote Assist
B
Dynamics 365 Finance
C
Dynamics 365 Business Central
D
Dynamics 365 for Phones
Reveal answer detailsClose answer details
Correct answerD
Explanation
Use the Dynamics 365 for phones and Dynamics 365 for tablets apps for your sales, customer service, field service, and other tasks when you're on the go. With one download from your app store, you'll automatically have access to all the apps you need for your role. You will see apps with the new Unified Interface on your mobile device.
Each time a work order is created, a service manager must review and approve the work order before a worker is dispatched.
You need to create a flow to enforce the process.
What should you create?
A
plug-in
B
approval flow
C
business rule
D
team flow
E
instant flow
F
scheduled flow
Reveal answer detailsClose answer details
Correct answerB
Explanation
With Power Automate, you can manage the approval of documents or processes across several services, including SharePoint, Dynamics 365, Salesforce, OneDrive for Business, Zendesk, or WordPress.
You need to display sales orders greater than a specific threshold in a Power BI report.
What should you use?
A
filter
B
Power Query
C
Common Data Service
D
connector
Reveal answer detailsClose answer details
Correct answerA
Question 4
Multiple choice
You are creating a dashboard in the Power Bl service.
You need to identify where you can find visuals to pin to your dashboard.
From which two components can you pin visuals? Each correct answer presents a complete solution. Choose two.
NOTE: Each correct selection is worth one point.
A
Semantic model
B
Report
C
Power Automate
D
Dataverse
E
Q&A
Reveal answer detailsClose answer details
Correct answersB, E
Question 5
Drag & drop
DRAG DROP
You plan to use Microsoft Flow to monitor what people are saying about your company's products. You store the feedback for research and development purposes. You need to recommend Flow components to use for the solution.
To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
Box 1: Trigger A trigger is something that triggers or starts the workflow. It could be a new file uploaded to a document library, a new item created in the list or an email sent to your Inbox - something that will start (kick-off the workflow).
There are two types of triggers: 1. Automatic trigger is pre-programmed into the workflow based on a certain rule (i.e. new document or item created, email sent, etc.) 2. Manual Trigger is a trigger initiated by a user. Unlike with automatic trigger above, the workflow will only start when initiated manually by the end user (for example, from the Document Library for a selected file). Manual trigger is only supported for certain types of workflows (i.e. Get feedback from your manager for the selected file)
Box 2: action An action is something that occurs as a result of the workflow.
Box 3: expression Sometimes users just need to do basic operations like getting the current time, adding numbers together, or replacing a part of a string of text. That's possible inline in any flow action. Microsoft Flow leverages the same Workflow Definition Language used by Azure Logic apps. For new users who are unfamiliar with the expression language, there is an inline help experience that shows how to use each expression as they build out their flow.
Box 4: flow type There are four different Flow types that you can choose from when starting out. You can create a scheduled flow, automated flow, instant flow, or a business process flow.
A company uses Microsoft Excel workbooks to store consolidated sales data. Workbooks are stored on OneDrive for Business.
Match each Power BI feature to its requirement. To answer, drag the appropriate features from the column on the left to its requirement on the right. Each option may be used once, more than once, or not at all.
You are creating a canvas app to enable users to order tickets. You create an input field for users to input the number of tickets to order.
Users must order a maximum of four tickets and a minimum of two tickets. If a user enters a number except 2, 3, or 4, the input field must display in red. If a user enters the numbers 2, 3, or 4, the input field must display in green.
You need to color the input field based on the user input.
What should you use?
A
formula
B
calculated column
C
gallery
D
connector
Reveal answer detailsClose answer details
Correct answerA
Explanation
For example, we can use the PowerFX IsNumeric to validate field value as Numeric or not. In the text property of the label provide the below formula.
You manage the support team at a rapidly growing company.
Customers and support technicians need a better experience when logging and responding to support requests. You need more visibility into what the support technicians are doing every week.
You need to recommend tools to help the company's needs.
Which tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Question 9
Hotspot
HOTSPOT
A company plans to implement Power Bl.
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Question 10
Single choice
Your company uses a SharePoint list to track customer order information, including manufacturing status.
Employees find the list difficult to read and update when using their mobile devices. You have a requirement to improve the usability of interacting with order data while on mobile devices.
You need to determine which Microsoft Power Platform capability will meet the requirements.
Which capability should you choose?
A
Canvas app
B
Power Automate cloud flow
C
Power Bl report
Reveal answer detailsClose answer details
Correct answerA
Question 11
Hotspot
HOTSPOT
A company enhances its data by using an Al Builder prebuilt model.
The company determines that the model does not provide good results for the company is unique data.
You need to increase the accuracy of the predictions made by the model.
Select the answer that correctly completes the sentence.
Reveal answer detailsClose answer details
Question 12
Single choice
Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app.
You need to establish a secure connection between the database and the app.
What should you use?
A
Data source
B
App
C
Data gateway
D
Power Automate
Reveal answer detailsClose answer details
Correct answerC
Explanation
For an on-premises database, identify a data gateway that was shared with you (or create one).
Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.
You need to select a Power Automate control action for each function in the flow. Which control action should you use? To answer, drag the appropriate control actions to the correct functions. Each control action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
Box 1: Do until The Do Until control in Power Automate is a loop that repeatedly forces an action until a certain condition becomes true.
Box 2: Switch In Power Automate, a Switch case action is a control function that allows for expression or variable to change the flow behavior. Where switch case has multiple cases which include different action or block of statement.
You plan to implement a model-driven app for a company. Employees will use the app to manage appointments with customers. The app must meet the following requirements:
1. Allow employees to create lists of appointments that occur in the next two weeks 2. Display a pie chart of customer types and a bar chart of completed appointments by employee from the sitemap. 3. Allow employees to access notes, emails, and other activities for a particular customer 4. Automatically hide the appointment address columns if an appointment is marked as online.
You need to identify the required components for the model-driven app.
Reveal answer detailsClose answer details
Question 17
Multiple choice
A company using Power Platform is implementing Power BI. The company plans to connect to several data sources and create reports and dashboards.
You need to identify the data sources they can connect to.
Which two data sources should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A
Microsoft Excel
B
Microsoft Dataverse
C
Microsoft OneNote
D
Microsoft Word
Reveal answer detailsClose answer details
Correct answersA, B
Question 18
Hotspot
HOTSPOT
You are authoring a Copilot Studio copilot for a company.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Question 19
Multiple choice
You overwrite a Power Automate flow by editing the definition and saving the changes.
You need to be able to revert a flow to the current state.
Which two options can you use?
Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A
Save As
B
Rename
C
Export
D
Share
Reveal answer detailsClose answer details
Correct answersA, C
Question 20
Multiple choice
You create a Power BI dashboard that displays Common Data Model data.
You need to share the Power BI dashboard with coworkers and allow the coworkers to collaborate.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A
Create a Power Automate flow to export the data into a SQL Server database.
B
Publish the dashboard as an app to your coworkers.
C
Export the data to Microsoft Excel. Make required changes and then re-import the data.
D
Create a Power Bl workspace and grant coworkers permissions.
Reveal answer detailsClose answer details
Correct answersB, D
Explanation
Create a Power BI workspace and grant coworkers permissions: You can create a new Power BI workspace, add your dashboard to the workspace, and then invite your coworkers to the workspace. You can then grant them permissions to access and collaborate on the dashboard.
Publish the dashboard as an app to your coworkers: You can publish the dashboard as an app, and then share the app with your coworkers. They can then install the app and access the dashboard.
You are new to working with Microsoft Flow. You create a flow that extracts birth dates for users and then sends a birthday greeting email to users on their birthday.
The flow does not properly extract birth dates.
Where should you make changes?
A
Connectors
B
Expression
C
Templates
Reveal answer detailsClose answer details
Correct answerB
Explanation
Expressions are a way to manipulate data, for example, combine two strings, or a mathematical operation.While Connectors are pre-built APIs that allow you to connect to different services, like SharePoint, Dynamics, or OneDrive, and perform actions such as retrieving data or creating new items.
The front desk of a hotel uses a model-driven app to check in guests.
The hotel wants to create a canvas app for the housekeeping staff to manage cleaning supplies. The canvas app will connect to a new instance of Microsoft Dataverse.
You need to create a new environment for the housekeeping staff.
What should you use?
A
Microsoft Azure portal
B
Power Apps maker portal
C
Microsoft 365 admin center
D
Microsoft Power Platform admin center
Reveal answer detailsClose answer details
Correct answerD
Question 24
Multiple choice
You are creating Power BI reports.
You need to choose which filters you can use for reports.
Which three types of filters can you use? Each correct answer presents a complete solution.
A company plans to build new apps for the business to allow employees to work more efficiently.
You need to recommend the appropriate types of Power Apps to meet the company's requirements.
To answer, drag the appropriate app types to the correct requirements. Each app type may be used once,
more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
Canvas is recommended for building mobile apps that use cameras and location data because it allows for the creation of custom mobile apps that can access device-specific features such as the camera and GPS. It also provides a flexible and intuitive drag-and-drop interface that allows for the creation of custom user interfaces.
AI Builder is recommended for building a feature that detects objects in images because it allows for the creation of custom AI models using a simple, no-code interface. This can be used to build image recognition capabilities that can detect and identify objects within images, which is useful for the feature you want to build.
A manufacturing company receives daily shipments that arrive at any time during the day.
A mailroom manager signs for the shipment, and then sends an email from Microsoft Outlook to the receptionist when the shipment is available. The receptionist sends a text message to each driver to let them know that items within the shipment are ready for delivery.
The company builds a Microsoft Power Automate flow that sends the text messages automatically to all drivers as soon as the receptionist receives the email.
You need to identify the component that allows the Power Automate flow to start without the intervention of the receptionist.
Which component should you select?
A
Copilot
B
Power BI
C
Al Builder
D
Connector
Reveal answer detailsClose answer details
Correct answerD
Question 28
Multiple choice
You are creating a canvas app.
You need to configure the app.
Which two objects are provided by the connector? Each correct answer presents a complete solution.
The company wants to implement some specific features that Power BI does not include.
You need to recommend solutions for the company.
What should you recommend? To answer, drag the appropriate solutions to the correct requirement. Each solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
1. "Evaluate solutions" - so you are looking for an app that's already developed for Power BI - the answer would be AppSource:
What's the difference between Microsoft AppSource and Azure Marketplace?
"AppSource includes business and industry solutions, such as apps that integrate into Microsoft 365, Dynamics 365, and POWER PLATFORM services. Azure Marketplace includes IT and developer solutions that are built on Azure or used within Azure subscriptions themselves."
2. An app doesn't exist yet for this one, so the only possible answer is LCS. Instead, you are looking at multiple companies for someone that can build a "proof of concept" solution:
Microsoft Dynamics Lifecycle Services is a collaborative workspace that customers and their partners use to manage finance and operations apps projects from pre-sales to the implementation phase and finally to the production environment.
A company uses Microsoft Power Platform to monitor social media.
You create a Power Automate cloud flow to process social message that positively mention the company and its product.
You need to choose a connector to perform sentiment analysis on the social media messages.
Which two connectors can you use in the flow? Each correct answer presents solution.
NOTE: Each correct selection is worth one point.
A
Azure Communication Services Chat
B
Language-Question Answering
C
Azure Cognitive Service for Language
D
Al Builder
E
Azure Application Insights
Reveal answer detailsClose answer details
Correct answersC, D
Explanation
AI Builder en lugar de "Microsoft Sentiment Analysis connector"
Question 31
Multiple choice
You are creating a self-service solution to handle incoming sales support calls.
The solution must detect the caller's location and translate any information the caller provides from the caller's native language to English.
Which two components should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A
Power Virtual Agents
B
Microsoft Azure Cognitive Services
C
AI Builder Language Detection Model
D
Microsoft Dynamics 365 Remote Assist for mobile
Reveal answer detailsClose answer details
Correct answersB, C
Question 32
Drag & drop
DRAG DROP
A company is using the Power Platform.
The company would like to create a project health check solution. For each active project, team members will use the tool to select one of the following options:
1. Things are going well. 2. I need help.
If things are going will, an email is sent to the manager letting them know that no intervention is needed. If the team member needs help, a mobile notification is sent to the manager letting them know the team needs assistance.
You need to create the solution.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Reveal answer detailsClose answer details
Question 33
Drag & drop
DRAG DROP
A company plans to implement Power Apps in a Power Platform environment.
You need to implement other required components.
Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, more than once, or not at all.
A company uses a custom-built system to record financial data that runs on a manager's machine.
The system does not have an API. New customer details must be manually entered into the system by the manager from a central spreadsheet. The user interface of the system contains the complex business logic that is needed for the manual customer data entry process.
You need to ensure that new customer details can be entered into the system automatically by using Power Automate.
Which type of flow should you create?
A
automated cloud
B
business process
C
desktop
D
instant cloud
Reveal answer detailsClose answer details
Correct answerC
Explanation
Since the custom-built system runs on a manager's machine and does not have an API, the most appropriate type of flow to use is a Desktop flow. Desktop flows are designed to automate tasks on a local machine, interacting with desktop applications and performing actions similar to a user.
In this case, the desktop flow can be configured to automate the process of entering new customer details into the custom-built system by interacting with the user interface and performing the necessary steps for data entry from the central spreadsheet. https://learn.microsoft.com/en-us/power-automate/desktop-flows/introduction
Question 35
Hotspot
HOTSPOT
You are authoring a Power Virtual Agents bot for a company that sells flowers and shrubs.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
Box 1: Yes Chatbots built with Power Virtual Agents will understand and display content that's locally relevant to the user. Localized handling and formatting are based on the user's browser locale setting, and include the following elements within a chat conversation: Date and time Numbers ZIP or postal code Currency Speed
Box 2: Yes Custom entities: The prebuilt entities cover commonly used information types, but on some occasions, such as when building a bot that serves a specific purpose, you'll need to teach the bot's language understanding model some domain-specific knowledge.
For instance, let's say you want to build a bot for an outdoor store. In this case, you'll need to teach the bot to acknowledge the "outdoor gears product" category in a dialog.
You need to choose the appropriate type of template for each requirement for the websites.
Which types of templates should you use? To answer, drag the appropriate templates to the correct requirements. Each template may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
1. Site Design https://learn.microsoft.com/en-us/training/modules/power-pages-templates/introduction
4. Blank page template create a completely custom website using our blank page template. This template includes a home page with a header, footer, and a single section.
A company creates canvas apps that us a data source from its sales team.
To meet company device policies, you must determine the available app formats the sales team can select when the sales team creates the canvas.
You need to determine the available app formats.
Which two app formats should you select? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.
A
Mobile
B
iOS
C
Desktop
D
Tablet
E
Android
Reveal answer detailsClose answer details
Correct answersA, D
Question 42
Hotspot
HOTSPOT
A company plans to use Power Apps to connect to a series of custom services. There are no connectors available for the custom services.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
Box 1: Yes Only if you would like to share your connector with all users of Logic Apps, Microsoft Flow, and PowerApps, you can submit your connector for Microsoft certification. Microsoft will review your connector.
Box 2: Yes Connectors created in Microsoft Flow are available in PowerApps. Likewise, connectors created in PowerApps are available in Microsoft Flow.
Box 3: No If you would like to share your connector with all users of Logic Apps, Microsoft Flow, and PowerApps, you can submit your connector for Microsoft certification. Microsoft will review your connector.
A company is assessing the capabilities of Dataverse.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Question 44
Drag & drop
DRAG DROP
A company is evaluating the use of Microsoft Power Automate to eliminate manual, repetitive tasks.
You need to recommend the appropriate type of Power Automate flow for each scenario.
Which type of Power Automate flow should you recommend? To answer, move the appropriate Power Automate flow types to the correct scenarios.
You may use each scenario once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Question 45
Single choice
A company has a Power Apps app that is used by most employees. The company is expanding to other countries/regions.
You need to recommend a solution to translate text generated within the Power Apps in near real-time.
What should you recommend?
A
Microsoft Azure Synapse Analytics
B
Microsoft Azure Cognitive Services
C
Common Data Service connector
D
Power BI
Reveal answer detailsClose answer details
Correct answerB
Explanation
Specifically, the Translator Text API can be integrated into the Power Apps app to provide near real-time translation of generated text. Azure Cognitive Services is a collection of pre-built APIs for natural language processing, computer vision, and speech recognition, among others.
Question 46
Drag & drop
DRAG DROP
You create a Power Bl dashboard.
Match each option to its requirement. To answer, drag the appropriate option from the column on the left to the correct requirement on the right. Each option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Reveal answer detailsClose answer details
Question 47
Multiple choice
You create a model-driven app for a department.
You need to make the model-driven app available to other department members.
Which two methods should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A
Publish the app to AppSource.
B
Send the application's Web URL to other team members by email.
C
Deploy the application to other user's instances through PowerShell.
D
Use the Share feature in the Power Apps designer.
Reveal answer detailsClose answer details
Correct answersB, D
Question 48
Drag & drop
DRAG DROP
A company needs to create a series of mobile applications to empower their field engineers to accomplish several tasks with varying degrees of complexity.
Match each app type to its definition. To answer, drag the appropriate app type from the column on the left to its definition on the right. Each app type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Reveal answer detailsClose answer details
Explanation
Box 1: canvas Both model-driven and canvas apps allow you to easily build business apps. They both share access to the Common Data Service providing standard and custom entities. Canvas apps start with your user experience, crafting a highly tailored interface with the power of a blank canvas and connecting it to 200 data sources. Canvas apps can be built for web, mobile, and tablet applications. Model-driven apps start with your data model - building up from the shape of your core business data and processes in the Common Data Service to model forms, views, and other components. Model-driven apps automatically generate great UI that is responsive across devices.
An administrator creates a new data loss prevention (DIP) policy.
You need to identify the Microsoft Power Platform components that must be updated to comply with the policy.
Which two types of components should you identify? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A
Power Automate cloud flows
B
Canvas apps
C
Power B1 reports
D
Model-driven apps
E
Power Pages websites
Reveal answer detailsClose answer details
Correct answersA, B
Question 51
Hotspot
HOTSPOT
You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue.
What should you do? To answer, select the appropriate option in the answer area.
You receive a copy of a Power Automate cloud flow from a colleague.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Question 53
Single choice
You are developing a Microsoft Power Platform solution. The solution uses data stored in Microsoft Excel, a Microsoft Dataverse database, and an Azure SQL database.
You must create several visuals to enable the data to display on a screen without moving the data out of its source location.
You need to create the visuals.
Which tool should you use?
A
Power Automate
B
Power Platform Center of Excellence Starter Kit
C
Power Virtual Agents
D
Power BI
Reveal answer detailsClose answer details
Correct answerD
Explanation
Power BI is a business intelligence and data visualization tool that allows you to connect to various data sources, including Microsoft Excel, Microsoft Dataverse, and Azure SQL databases. It allows you to create interactive, visually appealing reports and dashboards without having to move the data out of its source location. Power Automate, Power Platform Center of Excellence Starter Kit, and Power Virtual Agents are all different tools that are not specifically designed for creating data visuals in the way that Power BI is.
Question 54
Hotspot
HOTSPOT
You are building Power BI visualizations for a team.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device.
For each of the following statements, select Yes it the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Reveal answer detailsClose answer details
Explanation
Box 1: No
Box 2: Yes
Box 3: Yes When you create an app, or someone shares an app with you, you can run that app on Windows, iOS, Android, or in a web browser.
A company uses Dynamics 365 Sales. The company uses a browser-based app named Sales Hub.
You need to ensure that users can access data from mobile devices.
Which app should users install?
A.
Dynamics 365 Remote Assist
B.
Dynamics 365 Finance
C.
Dynamics 365 Business Central
D.
Dynamics 365 for Phones
Correct Answer: D
Explanation
Explanation/Reference:
Use the Dynamics 365 for phones and Dynamics 365 for tablets apps for your sales, customer service, field service, and other tasks when you're on the go. With one download from your app store, you'll automatically have access to all the apps you need for your role. You will see apps with the new Unified Interface on your mobile device.
Each time a work order is created, a service manager must review and approve the work order before a worker is dispatched.
You need to create a flow to enforce the process.
What should you create?
A.
plug-in
B.
approval flow
C.
business rule
D.
team flow
E.
instant flow
F.
scheduled flow
Correct Answer: B
Explanation
Explanation/Reference:
With Power Automate, you can manage the approval of documents or processes across several services, including SharePoint, Dynamics 365, Salesforce, OneDrive for Business, Zendesk, or WordPress.
You need to display sales orders greater than a specific threshold in a Power BI report.
What should you use?
A.
filter
B.
Power Query
C.
Common Data Service
D.
connector
Correct Answer: A
QUESTION 4
You are creating a dashboard in the Power Bl service.
You need to identify where you can find visuals to pin to your dashboard.
From which two components can you pin visuals? Each correct answer presents a complete solution. Choose two.
NOTE: Each correct selection is worth one point.
A.
Semantic model
B.
Report
C.
Power Automate
D.
Dataverse
E.
Q&A
Correct Answer: BE
QUESTION 5
DRAG DROP
You plan to use Microsoft Flow to monitor what people are saying about your company's products. You store the feedback for research and development purposes. You need to recommend Flow components to use for the solution.
To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Box 1: Trigger A trigger is something that triggers or starts the workflow. It could be a new file uploaded to a document library, a new item created in the list or an email sent to your Inbox - something that will start (kick-off the workflow).
There are two types of triggers: 1. Automatic trigger is pre-programmed into the workflow based on a certain rule (i.e. new document or item created, email sent, etc.) 2. Manual Trigger is a trigger initiated by a user. Unlike with automatic trigger above, the workflow will only start when initiated manually by the end user (for example, from the Document Library for a selected file). Manual trigger is only supported for certain types of workflows (i.e. Get feedback from your manager for the selected file)
Box 2: action An action is something that occurs as a result of the workflow.
Box 3: expression Sometimes users just need to do basic operations like getting the current time, adding numbers together, or replacing a part of a string of text. That's possible inline in any flow action. Microsoft Flow leverages the same Workflow Definition Language used by Azure Logic apps. For new users who are unfamiliar with the expression language, there is an inline help experience that shows how to use each expression as they build out their flow.
Box 4: flow type There are four different Flow types that you can choose from when starting out. You can create a scheduled flow, automated flow, instant flow, or a business process flow.
A company uses Microsoft Excel workbooks to store consolidated sales data. Workbooks are stored on OneDrive for Business.
Match each Power BI feature to its requirement. To answer, drag the appropriate features from the column on the left to its requirement on the right. Each option may be used once, more than once, or not at all.
You are creating a canvas app to enable users to order tickets. You create an input field for users to input the number of tickets to order.
Users must order a maximum of four tickets and a minimum of two tickets. If a user enters a number except 2, 3, or 4, the input field must display in red. If a user enters the numbers 2, 3, or 4, the input field must display in green.
You need to color the input field based on the user input.
What should you use?
A.
formula
B.
calculated column
C.
gallery
D.
connector
Correct Answer: A
Explanation
Explanation/Reference:
For example, we can use the PowerFX IsNumeric to validate field value as Numeric or not. In the text property of the label provide the below formula.
You manage the support team at a rapidly growing company.
Customers and support technicians need a better experience when logging and responding to support requests. You need more visibility into what the support technicians are doing every week.
You need to recommend tools to help the company's needs.
Which tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION 9
HOTSPOT
A company plans to implement Power Bl.
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION 10
Your company uses a SharePoint list to track customer order information, including manufacturing status.
Employees find the list difficult to read and update when using their mobile devices. You have a requirement to improve the usability of interacting with order data while on mobile devices.
You need to determine which Microsoft Power Platform capability will meet the requirements.
Which capability should you choose?
A.
Canvas app
B.
Power Automate cloud flow
C.
Power Bl report
Correct Answer: A
QUESTION 11
HOTSPOT
A company enhances its data by using an Al Builder prebuilt model.
The company determines that the model does not provide good results for the company is unique data.
You need to increase the accuracy of the predictions made by the model.
Select the answer that correctly completes the sentence.
Correct Answer:
QUESTION 12
Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app.
You need to establish a secure connection between the database and the app.
What should you use?
A.
Data source
B.
App
C.
Data gateway
D.
Power Automate
Correct Answer: C
Explanation
Explanation/Reference:
For an on-premises database, identify a data gateway that was shared with you (or create one).
Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.
You need to select a Power Automate control action for each function in the flow. Which control action should you use? To answer, drag the appropriate control actions to the correct functions. Each control action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Box 1: Do until The Do Until control in Power Automate is a loop that repeatedly forces an action until a certain condition becomes true.
Box 2: Switch In Power Automate, a Switch case action is a control function that allows for expression or variable to change the flow behavior. Where switch case has multiple cases which include different action or block of statement.
You plan to implement a model-driven app for a company. Employees will use the app to manage appointments with customers. The app must meet the following requirements:
1. Allow employees to create lists of appointments that occur in the next two weeks 2. Display a pie chart of customer types and a bar chart of completed appointments by employee from the sitemap. 3. Allow employees to access notes, emails, and other activities for a particular customer 4. Automatically hide the appointment address columns if an appointment is marked as online.
You need to identify the required components for the model-driven app.
Correct Answer:
QUESTION 17
A company using Power Platform is implementing Power BI. The company plans to connect to several data sources and create reports and dashboards.
You need to identify the data sources they can connect to.
Which two data sources should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A.
Microsoft Excel
B.
Microsoft Dataverse
C.
Microsoft OneNote
D.
Microsoft Word
Correct Answer: AB
QUESTION 18
HOTSPOT
You are authoring a Copilot Studio copilot for a company.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION 19
You overwrite a Power Automate flow by editing the definition and saving the changes.
You need to be able to revert a flow to the current state.
Which two options can you use?
Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A.
Save As
B.
Rename
C.
Export
D.
Share
Correct Answer: AC
QUESTION 20
You create a Power BI dashboard that displays Common Data Model data.
You need to share the Power BI dashboard with coworkers and allow the coworkers to collaborate.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A.
Create a Power Automate flow to export the data into a SQL Server database.
B.
Publish the dashboard as an app to your coworkers.
C.
Export the data to Microsoft Excel. Make required changes and then re-import the data.
D.
Create a Power Bl workspace and grant coworkers permissions.
Correct Answer: BD
Explanation
Explanation/Reference:
Create a Power BI workspace and grant coworkers permissions: You can create a new Power BI workspace, add your dashboard to the workspace, and then invite your coworkers to the workspace. You can then grant them permissions to access and collaborate on the dashboard.
Publish the dashboard as an app to your coworkers: You can publish the dashboard as an app, and then share the app with your coworkers. They can then install the app and access the dashboard.
You are new to working with Microsoft Flow. You create a flow that extracts birth dates for users and then sends a birthday greeting email to users on their birthday.
The flow does not properly extract birth dates.
Where should you make changes?
A.
Connectors
B.
Expression
C.
Templates
Correct Answer: B
Explanation
Explanation/Reference:
Expressions are a way to manipulate data, for example, combine two strings, or a mathematical operation.While Connectors are pre-built APIs that allow you to connect to different services, like SharePoint, Dynamics, or OneDrive, and perform actions such as retrieving data or creating new items.
The front desk of a hotel uses a model-driven app to check in guests.
The hotel wants to create a canvas app for the housekeeping staff to manage cleaning supplies. The canvas app will connect to a new instance of Microsoft Dataverse.
You need to create a new environment for the housekeeping staff.
What should you use?
A.
Microsoft Azure portal
B.
Power Apps maker portal
C.
Microsoft 365 admin center
D.
Microsoft Power Platform admin center
Correct Answer: D
QUESTION 24
You are creating Power BI reports.
You need to choose which filters you can use for reports.
Which three types of filters can you use? Each correct answer presents a complete solution.
A company plans to build new apps for the business to allow employees to work more efficiently.
You need to recommend the appropriate types of Power Apps to meet the company's requirements.
To answer, drag the appropriate app types to the correct requirements. Each app type may be used once,
more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Canvas is recommended for building mobile apps that use cameras and location data because it allows for the creation of custom mobile apps that can access device-specific features such as the camera and GPS. It also provides a flexible and intuitive drag-and-drop interface that allows for the creation of custom user interfaces.
AI Builder is recommended for building a feature that detects objects in images because it allows for the creation of custom AI models using a simple, no-code interface. This can be used to build image recognition capabilities that can detect and identify objects within images, which is useful for the feature you want to build.
A manufacturing company receives daily shipments that arrive at any time during the day.
A mailroom manager signs for the shipment, and then sends an email from Microsoft Outlook to the receptionist when the shipment is available. The receptionist sends a text message to each driver to let them know that items within the shipment are ready for delivery.
The company builds a Microsoft Power Automate flow that sends the text messages automatically to all drivers as soon as the receptionist receives the email.
You need to identify the component that allows the Power Automate flow to start without the intervention of the receptionist.
Which component should you select?
A.
Copilot
B.
Power BI
C.
Al Builder
D.
Connector
Correct Answer: D
QUESTION 28
You are creating a canvas app.
You need to configure the app.
Which two objects are provided by the connector? Each correct answer presents a complete solution.
The company wants to implement some specific features that Power BI does not include.
You need to recommend solutions for the company.
What should you recommend? To answer, drag the appropriate solutions to the correct requirement. Each solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
1. "Evaluate solutions" - so you are looking for an app that's already developed for Power BI - the answer would be AppSource:
What's the difference between Microsoft AppSource and Azure Marketplace?
"AppSource includes business and industry solutions, such as apps that integrate into Microsoft 365, Dynamics 365, and POWER PLATFORM services. Azure Marketplace includes IT and developer solutions that are built on Azure or used within Azure subscriptions themselves."
2. An app doesn't exist yet for this one, so the only possible answer is LCS. Instead, you are looking at multiple companies for someone that can build a "proof of concept" solution:
Microsoft Dynamics Lifecycle Services is a collaborative workspace that customers and their partners use to manage finance and operations apps projects from pre-sales to the implementation phase and finally to the production environment.
A company uses Microsoft Power Platform to monitor social media.
You create a Power Automate cloud flow to process social message that positively mention the company and its product.
You need to choose a connector to perform sentiment analysis on the social media messages.
Which two connectors can you use in the flow? Each correct answer presents solution.
NOTE: Each correct selection is worth one point.
A.
Azure Communication Services Chat
B.
Language-Question Answering
C.
Azure Cognitive Service for Language
D.
Al Builder
E.
Azure Application Insights
Correct Answer: CD
Explanation
Explanation/Reference:
AI Builder en lugar de "Microsoft Sentiment Analysis connector"
QUESTION 31
You are creating a self-service solution to handle incoming sales support calls.
The solution must detect the caller's location and translate any information the caller provides from the caller's native language to English.
Which two components should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A.
Power Virtual Agents
B.
Microsoft Azure Cognitive Services
C.
AI Builder Language Detection Model
D.
Microsoft Dynamics 365 Remote Assist for mobile
Correct Answer: BC
QUESTION 32
DRAG DROP
A company is using the Power Platform.
The company would like to create a project health check solution. For each active project, team members will use the tool to select one of the following options:
1. Things are going well. 2. I need help.
If things are going will, an email is sent to the manager letting them know that no intervention is needed. If the team member needs help, a mobile notification is sent to the manager letting them know the team needs assistance.
You need to create the solution.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
QUESTION 33
DRAG DROP
A company plans to implement Power Apps in a Power Platform environment.
You need to implement other required components.
Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, more than once, or not at all.
A company uses a custom-built system to record financial data that runs on a manager's machine.
The system does not have an API. New customer details must be manually entered into the system by the manager from a central spreadsheet. The user interface of the system contains the complex business logic that is needed for the manual customer data entry process.
You need to ensure that new customer details can be entered into the system automatically by using Power Automate.
Which type of flow should you create?
A.
automated cloud
B.
business process
C.
desktop
D.
instant cloud
Correct Answer: C
Explanation
Explanation/Reference:
Since the custom-built system runs on a manager's machine and does not have an API, the most appropriate type of flow to use is a Desktop flow. Desktop flows are designed to automate tasks on a local machine, interacting with desktop applications and performing actions similar to a user.
In this case, the desktop flow can be configured to automate the process of entering new customer details into the custom-built system by interacting with the user interface and performing the necessary steps for data entry from the central spreadsheet. https://learn.microsoft.com/en-us/power-automate/desktop-flows/introduction
QUESTION 35
HOTSPOT
You are authoring a Power Virtual Agents bot for a company that sells flowers and shrubs.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Box 1: Yes Chatbots built with Power Virtual Agents will understand and display content that's locally relevant to the user. Localized handling and formatting are based on the user's browser locale setting, and include the following elements within a chat conversation: Date and time Numbers ZIP or postal code Currency Speed
Box 2: Yes Custom entities: The prebuilt entities cover commonly used information types, but on some occasions, such as when building a bot that serves a specific purpose, you'll need to teach the bot's language understanding model some domain-specific knowledge.
For instance, let's say you want to build a bot for an outdoor store. In this case, you'll need to teach the bot to acknowledge the "outdoor gears product" category in a dialog.
You need to choose the appropriate type of template for each requirement for the websites.
Which types of templates should you use? To answer, drag the appropriate templates to the correct requirements. Each template may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
1. Site Design https://learn.microsoft.com/en-us/training/modules/power-pages-templates/introduction
4. Blank page template create a completely custom website using our blank page template. This template includes a home page with a header, footer, and a single section.
A company creates canvas apps that us a data source from its sales team.
To meet company device policies, you must determine the available app formats the sales team can select when the sales team creates the canvas.
You need to determine the available app formats.
Which two app formats should you select? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.
A.
Mobile
B.
iOS
C.
Desktop
D.
Tablet
E.
Android
Correct Answer: AD
QUESTION 42
HOTSPOT
A company plans to use Power Apps to connect to a series of custom services. There are no connectors available for the custom services.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Box 1: Yes Only if you would like to share your connector with all users of Logic Apps, Microsoft Flow, and PowerApps, you can submit your connector for Microsoft certification. Microsoft will review your connector.
Box 2: Yes Connectors created in Microsoft Flow are available in PowerApps. Likewise, connectors created in PowerApps are available in Microsoft Flow.
Box 3: No If you would like to share your connector with all users of Logic Apps, Microsoft Flow, and PowerApps, you can submit your connector for Microsoft certification. Microsoft will review your connector.
A company is assessing the capabilities of Dataverse.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION 44
DRAG DROP
A company is evaluating the use of Microsoft Power Automate to eliminate manual, repetitive tasks.
You need to recommend the appropriate type of Power Automate flow for each scenario.
Which type of Power Automate flow should you recommend? To answer, move the appropriate Power Automate flow types to the correct scenarios.
You may use each scenario once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION 45
A company has a Power Apps app that is used by most employees. The company is expanding to other countries/regions.
You need to recommend a solution to translate text generated within the Power Apps in near real-time.
What should you recommend?
A.
Microsoft Azure Synapse Analytics
B.
Microsoft Azure Cognitive Services
C.
Common Data Service connector
D.
Power BI
Correct Answer: B
Explanation
Explanation/Reference:
Specifically, the Translator Text API can be integrated into the Power Apps app to provide near real-time translation of generated text. Azure Cognitive Services is a collection of pre-built APIs for natural language processing, computer vision, and speech recognition, among others.
QUESTION 46
DRAG DROP
You create a Power Bl dashboard.
Match each option to its requirement. To answer, drag the appropriate option from the column on the left to the correct requirement on the right. Each option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
QUESTION 47
You create a model-driven app for a department.
You need to make the model-driven app available to other department members.
Which two methods should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A.
Publish the app to AppSource.
B.
Send the application's Web URL to other team members by email.
C.
Deploy the application to other user's instances through PowerShell.
D.
Use the Share feature in the Power Apps designer.
Correct Answer: BD
QUESTION 48
DRAG DROP
A company needs to create a series of mobile applications to empower their field engineers to accomplish several tasks with varying degrees of complexity.
Match each app type to its definition. To answer, drag the appropriate app type from the column on the left to its definition on the right. Each app type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Box 1: canvas Both model-driven and canvas apps allow you to easily build business apps. They both share access to the Common Data Service providing standard and custom entities. Canvas apps start with your user experience, crafting a highly tailored interface with the power of a blank canvas and connecting it to 200 data sources. Canvas apps can be built for web, mobile, and tablet applications. Model-driven apps start with your data model - building up from the shape of your core business data and processes in the Common Data Service to model forms, views, and other components. Model-driven apps automatically generate great UI that is responsive across devices.
An administrator creates a new data loss prevention (DIP) policy.
You need to identify the Microsoft Power Platform components that must be updated to comply with the policy.
Which two types of components should you identify? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A.
Power Automate cloud flows
B.
Canvas apps
C.
Power B1 reports
D.
Model-driven apps
E.
Power Pages websites
Correct Answer: AB
QUESTION 51
HOTSPOT
You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue.
What should you do? To answer, select the appropriate option in the answer area.
You receive a copy of a Power Automate cloud flow from a colleague.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION 53
You are developing a Microsoft Power Platform solution. The solution uses data stored in Microsoft Excel, a Microsoft Dataverse database, and an Azure SQL database.
You must create several visuals to enable the data to display on a screen without moving the data out of its source location.
You need to create the visuals.
Which tool should you use?
A.
Power Automate
B.
Power Platform Center of Excellence Starter Kit
C.
Power Virtual Agents
D.
Power BI
Correct Answer: D
Explanation
Explanation/Reference:
Power BI is a business intelligence and data visualization tool that allows you to connect to various data sources, including Microsoft Excel, Microsoft Dataverse, and Azure SQL databases. It allows you to create interactive, visually appealing reports and dashboards without having to move the data out of its source location. Power Automate, Power Platform Center of Excellence Starter Kit, and Power Virtual Agents are all different tools that are not specifically designed for creating data visuals in the way that Power BI is.
QUESTION 54
HOTSPOT
You are building Power BI visualizations for a team.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device.
For each of the following statements, select Yes it the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Explanation/Reference:
Box 1: No
Box 2: Yes
Box 3: Yes When you create an app, or someone shares an app with you, you can run that app on Windows, iOS, Android, or in a web browser.