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

HOTSPOT
-
A company plans to use Power BI to visualize data.
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.
 

HOTSPOT -
A tutoring company has developed and deployed a model-driven app for the administration staff and a canvas app for teachers.
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.
Hot Area:
 

You create a Power Virtual Agents chatbot for a company.
The management wants to learn about the effectiveness of the chatbot.
You need to identify the percentage of customers who stop responding to prompts from the chatbot.
Which report should you view?

A. Customer satisfaction

B. Engagement over time

C. Escalation rate drivers

D. Session outcomes over time

A company's customer-facing applications must comply with Global Data Protection Regulations (GDPR) regulations.
You need to recommend actions to help ensure GDPR compliance.
Which two features should the company use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Force a user to update security questions after a specific amount of time.

B. Prompt a user for consent to use their personal data and record the date consented.

C. Block users who are identified as minors.

D. Automatically deactivate a user who has not used the portal in six months.

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.
NOTE: Each correct selection is worth one point.
Hot Area:
 

HOTSPOT -
An organization plans to create Power Platform solutions and is evaluating Microsoft Dataverse.
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.
Hot Area:
 

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.
Hot Area:
 

DRAG DROP -
A team of five people plans to create Power Platform solutions for a company. Team members plan to initially use Power Platform trial instances to create solutions.
Team members have questions about how many Power Platform instances and Common Data Service databases they need.
You need to respond to the team.
How should you respond? To answer, drag the appropriate responses to the correct questions. Each response 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.
Select and Place:
 

DRAG DROP
-
You are planning to deploy Power Pages websites.
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.
 

A company plans to move an on-premises customer service data management system to a cloud-managed solution.
The customer service application must be replaced by a model-driven application. The company uses Microsoft SQL Server Integration Services (SSIS) packages to move data from the on-premises database system to a third-party enterprise resource planning (ERP) system.
You need to replace the SSIS packages for data transfer.
What should the company use in place of the packages to move the data?

A. Power Platform connector

B. Microsoft Azure Data Lake

C. Power Virtual Agents

D. Data Migration Framework

HOTSPOT
-
You save and publish the following view in the view designer:
 
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
 

DRAG DROP -
You are implementing a solution for an animal hospital.
The animal hospital must contact owners regarding their pets.
You need to model the owner and pet object information by using Microsoft Dataverse. The solution must minimize the amount of customization required:
✑ owner first name
✑ owner last name
✑ owner email address
✑ owner date of birth
✑ pet name
pet breed
 
✑ pet owner
Which component should you use? To answer, drag the appropriate components to the correct data. 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.
Select and Place:
 

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:
✑ Things are going well.
✑ 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.
Select and Place:
 

HOTSPOT -
You have a Power BI report.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
 

HOTSPOT -
You create a Power Virtual Agents chatbot for use with Microsoft Teams. You are testing the chatbot.
Testers report the following issues:
✑ Changes that you make to the chatbot are not seen by testers.
✑ When users enter the word refund the chatbot must ask the user the product for which they would like a refund. The chatbot does not ask the user for product information.
You need to determine what needs to be done to fix the issues.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
 

You test a business process flow in a sandbox environment.
When you complete testing, you must copy the business process flow to a production environment without bringing any data or other modifications with it.
You must meet the requirements.
What should you do?

A. Export the default solution.

B. Create a view and export the view.

C. Add the business process flow to a separate solution. Export the solution.

D. Export the form that contains the business process flow to a separate solution.

DRAG DROP
-
A company uses Microsoft Power Apps and Microsoft Azure to modernize its mobile workforce.
The company needs to identify solutions for three use cases:
•	An app to audit retail store displays with a tablet-specific layout for its unique screen dimensions
•	An app to create sales orders that uses business process flows
•	An app to display product information that uses data from a Microsoft Dataverse instance, Microsoft Excel, and Microsoft SharePoint
You need to identify the correct app types to use.
Which apps should you use? To answer, drag the appropriate app types to the correct apps. 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.
 

A recent update has been made to a canvas app.
The update causes usability issues.
You need to roll back the app to a previous version.
What should you do?

A. Restore the previous version of the app.

B. Uninstall the app for all users and reinstall by using the package from a previous version.

C. Deactivate the live app, import the previous version of the app, and then activate the app.

D. Delete the app and create a new app based on the previous version.

A company plans to create a canvas app that connects to three databases with different proprietary database formats.
What is the minimum number of connectors required?

A. 0

B. 1

C. 2

D. 3

DRAG DROP -
A company has locations in multiple regions. The company develops solutions based on Power Apps and Power Automate.
You need to recommend features to support the implementation.
Which Power Platform features should you recommend? To answer, drag the appropriate features to the correct requirements. Each feature 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.
Select and Place:
 

You are using Dynamics 365 Sales.
You need to create a Power BI report that includes customer office locations. The City and State columns must be combined to form one column on the report.
What should you do?

A. Use Power Query Editor to merge columns.

B. Import the data.

C. Export data to Microsoft Excel.

D. Create a view.

HOTSPOT -
A business is evaluating AI Builder.
Which actions can you perform?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
 

DRAG DROP
-
You are managing a custom model through its lifecycle in AI Builder.
You need to determine the earliest status the model should be in to perform actions.
What is the earliest status required for each action? To answer, drag the appropriate statuses to the correct actions. Each status 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.
 

A company has a website. The website includes a form that allows the company to collect information about leads.
You need to set up an automated workflow to create leads in Dynamics 365 Sales when leads are created on the company's custom website.
What should you create?

A. Task Flow

B. Power Automate flow

C. Dynamics 365 workflow

D. Business Process Flow

HOTSPOT
-
Your company has created a Power Virtual Agents chatbot to assist employees with common questions such as checking their vacation balances, office opening hours, and travel expense policies.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
 

DRAG DROP -
A company is building a Power Apps portal.
You need to select out-of-the-box portal types to meet the company's requirements.
Which portal types should you use? To answer, drag the appropriate portal types to the correct requirements. Each portal 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.
Select and Place:
 

DRAG DROP -
You are creating a model-driven app to track requests for quotes.
The app must use the following navigation structure:
Sales -
✑ Sales Log
✑ Request for Quotes
✑ Projects
✑ Settings
✑ Customers
✑ Product Lines
✑ Sales Territories
Administration -
✑ User Admin
✑ Users
✑ Roles
You need to create the app navigation.
Which sitemap component types should you use? To answer, drag the appropriate component types to the correct navigation elements. Each component 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.
Select and Place:
 

A company uses Power Automate.
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. scheduled flow

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

You are building a Power Virtual Agents chatbot for a company.
You are working with an existing topic and would like to call an action.
Which technology is available to perform the action?

A. Power Virtual Agent Entity

B. Power BI

C. Power Apps

D. Power Automate

A company uses Power Automate.
Which three items can trigger flows? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Lifecycle Services

B. Microsoft 365 Admin center

C. Common Data Service

D. Microsoft Outlook 365

E. Microsoft Windows Desktop

HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
 

DRAG DROP
-
A company uses Power Automate.
The company wants to automate a user's data entry into an older Windows application on the user's local computer.
You need to configure the automation to meet the following requirements:
•	Automatically capture the user's data entry actions.
•	Enable the user to specify the values to be entered when the automation is run on the computer.
Which three actions should you manually 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.
 

HOTSPOT -
You are creating a Power Virtual Agents chatbot for a company.
Which component types should you use for each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
 

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

A company uses Microsoft 365 and Dynamics 365 Sales. The company does not have any developers on its staff.
You need to explain to the executives the benefits of using Power Platform apps.
What are two benefits? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Users can send emails from Dynamics 365 Sales to their personal email addresses.

B. Users can create Power Apps to create apps for different departments.

C. Users can use Power Automate to share information between Microsoft 365 and Dynamics 365 Sales.

D. The company can unify all the mobile devices to one vendor.

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 BI workspace and grant coworkers permissions.

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 Automate flow to export the data into a SQL Server database.

You are building a canvas app to allow users to record their expenses. The app also will support screen readers for users with visual impairments.
You have the following requirements:
•	Use a tool that identifies potential issues.
•	Use a tool that provides suggestions for modifying the app.
You need a tool that meets the requirements.
Which tool should you use?

A. Flow Checker

B. Microsoft Trust Center

C. Microsoft Power Platform admin center

D. Accessibility Checker

HOTSPOT
-
A company uses Microsoft Power Platform to connect to multiple data sources and manage business data.
The low-code components in Microsoft Power Platform must be able to create and update data in these data sources.
You need to access the required data by using Microsoft Power Platform components.
Which component should you use for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

DRAG DROP
-
A company uses a model-driven app to manage customer data.
The company requires updates to the account table main form. The updates must be made within the app.
You need to make the required updates.
Which changes should you make to meet each requirement? To answer, drag the appropriate changes to the correct requirements. Each change 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.
 

HOTSPOT -
A company plans to implement Power Platform apps. The company does not plan to use any development tools or plug-ins.
Which actions can you perform?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
 

You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business.
You need to create a canvas app that allows team members to update the status of their tasks.
What should you use?

A. the Generate an app from data feature

B. a custom action in Common Data Service

C. Power Apps Checker

D. the Open entity data in Excel feature

HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
 

A coworker is creating an app in Power Apps and needs to automatically synchronize data from an external source. The coworker is unable to locate a suitable
Microsoft approved connector template in AppSource.
You need to recommend a solution for the coworker.
What should you recommend?

A. Create a custom connector.

B. Ask the outside source to send you the data once a week.

C. Use Power Automate to connect to the database.

D. Open a ticket with Microsoft and request a new connector.

E. Use Microsoft Azure Service Bus.

A company uses Microsoft Power Platform to monitor social media.
You create a Power Automate cloud flow to process social media messages that positively mention the company and its products.
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 a complete solution.
NOTE: Each correct selection is worth one point.

A. Azure Communication Services Chat

B. Language – Question Answering

C. AI Builder

D. Azure Application Insights

E. Azure Cognitive Service for Language

HOTSPOT -
You are creating a Power Automate approval flow.
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.
Hot Area:
 

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

B. Rename

C. Save As

D. Share

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

You have a Power Automate flow that saves attachments from emails into OneDrive for Business.
You need to determine why the flow is not working.
What are three possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Navigate to the Power Automate admin center and view the projects.

B. Navigate to the Action Items section of the Power Automate portal.

C. Enable Repair Tips for the flow.

D. Navigate to the flow and view the run history.

E. Navigate to the Power Automate web portal and click view notifications.