my notes.....

1) Power Apps: provides a rapid low code development environment for building
custom apps for business needs.
2) Power Automate :lets users create automated workflows between applications
and services. It helps automate repetitive business processes such as
communication, data collections, and decision approvals.
3) Power BI (Business Intelligence) : is a business analytics service that delivers
insights for analyzing data. It can share those insights through data visualizations
which make up reports and dashboards to enable fast, informed decisions.
4) Power Virtual Agents : enables anyone to create powerful chatbots using a
guided, no-code graphical interface, without the need for data scientists or
developers.
It minimizes the IT effort required to deploy and maintain a custom solution by
empowering subject matter experts to build and maintain their own conversational
solutions

Data Connectors : connectors as a bridge from your data source to your app or
workflow which allows information to be conveyed back and forth
There are 2 type of Data Sources to whcih they connects:
1) Tabular data - A tabular data source is one that returns data in a structured table
format.Examples include Microsoft Dataverse, SharePoint, and SQL Server.
2) Function-based data - A function-based data source is one that uses functions to
interact with the data source.Examples include Office 365 Users, Project Online,
and Azure Blob Storage.

Connectors :are the bridges from your data source to your app, workflow, or
dashboard.

Triggers and Actions :

Triggers : are only used in Power Automate and prompt a flow to begin. Triggers
can be time based, such as a flow which begins every day at 8:00 am, or they could
be based off of an action like creating a new row in a table or receiving an email.
You will always need a trigger to tell your workflow when to run.

Actions : are used in Power Automate and Power Apps. Actions are prompted by
the user or a trigger and allow interaction with your data source by some function.
For example, an action would be sending an email in your workflow or app or writing
a new line to a data source.

Microsoft Dataverse :is a cloud-based, low-code data service and app platform,
which allows you to leverage the security and connectivity of Microsoft services.
Dataverse connects easily to all aspects of Microsoft Power Platform so that you
can fully control, automate, and strengthen your business. With standard tables and
columns, as well as the ability to easily define relationships between your data,
Dataverse was built for powerful, scalable solutions.
This question requires that you evaluate the underlined text to determine if it is
correct.
You have a Power Apps app. You create a new version of the app and then publish
the new version. A customer goes through the process of restoring the previous
version of the app. In the Version tab for the app, you will see two versions of the
app.
Review the underlined text. If it makes the statement correct, select `No change is
needed.` If the statement is incorrect, select the answer choice that makes the
statement correct.

• A. No change is needed.
• B. one
• C. three
• D. four

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

You are a customer service manager.

You need to implement a Power Apps portal that allows customers to submit cases.
Which type of data source is used?

• A. Dynamics 365 Connector

• B. Microsoft SharePoint
• C. Microsoft Azure Storage
• D. Common Data Service

HOTSPOT -
You create a user-owned custom entity by using Common Data Service.
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:
 Answer:
Box 1: No -
Common Data Service supports two types of record ownership. Organization
owned, and User or Team owned. This is a choice that happens at the time the
entity is created and can‫ג‬€™t be changed.

Box 2: Yes -
By combining conditions and actions, you can do any of the following with business
rules:

Set field values -

Clear field values -

Set field requirement levels -

Show or hide fields -

Enable or disable fields -

Validate data and show error messages
Create business recommendations based on business intelligence.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds
DRAG DROP -
You need to explain the major components of the (CDM) and their functions.
Match each term to its definition.
Instructions: To answer, drag the appropriate term from the column on the left to its
definition on the right. Each term may be used once, more than once, or not at all.
Each correct match is worth one point.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct

Answer:
Box 1: Common Data Service -
Note: Common Data Service has been renamed to Dataverse.
By using Dataverse, you can jump-start app development by using the Common
Data Model with business logic, security, and integration already built- in.

Box 2: Entities -
An entity is a set of records used to store data, similar to how a table stores data
within a database.

A distribution company has multiple warehouses.

Tax rates charged on sales orders need to be calculated based on locality and
region.
You need to recommend a cost-effective solution that can be implemented quickly.
What should you recommend?

• A. Check AppSource for a tax add-on.

• B. Create alerts in Dynamics 365 Finance for tax table changes.
• C. Implement the Common Data Model.
• D. Run a Power BI report.
• E. Write scripts and code tax updates.

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.
Select and Place:
HOTSPOT -
You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365.
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 need to implement Microsoft Business Applications along with the Microsoft Power
platform.
Which three Microsoft products are part of the Power platform? Each correct answer presents
a complete solution.
NOTE: Each correct selection is worth one point.

• A. Microsoft Power Apps

• B. Azure Active Directory
• C. Power Automate
• D. Azure Machine Learning
• E. Microsoft Power BI
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:

A large retail company implements Power Apps, Microsoft Flow, and the Common Data
Service.
The board of directors is asking whether users are finding value in the technology. The
company would like to measure and report usage of the software.
You need to recommend a tool to determine software usage.
What should you recommend?

• A. Microsoft Intune
• B. Azure Stream Analytics
• C. Power Platform Analytics
• D. Dynamics 365 Product Insights

DRAG DROP -
A company uses Power Apps.
You need to perform administrative tasks for the company.
Which admin centers should you use? To answer, drag the appropriate admin centers to the
correct requirements. Each admin center 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:
HOTSPOT -
A rapidly growing company produces Office 365 licenses for all employees. The company
wants to empower users to build apps, automate business processes, and analyze data
without requiring I‫׀‬¢ expertise or development skills and without increasing IT expenses and
dependencies.
You need to recommend tools so that users can accomplish specific tasks.
Which tools should you recommend? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT -
A company plans to use Power Platform to build apps which address specific business
challenges.
You need to recommend the appropriate types of Power Apps to use.
What should you recommend? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

DRAG DROP -
A travel company plans to use the Power Platform to create tools that help travel agents book
customer travel.
You need to recommend solutions for the company.
What 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.
Select and Place:

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:

HOTSPOT -
You have version 1.0.0.0 of a published Power Apps app. You create and publish version
2.0.0.0 of the app. A customer goes through the process of restoring the previous version of
the app.
How many versions of the app are displayed in the Version tab for the app? To answer, select
the appropriate option in the answer area.
Hot Area:

HOTSPOT -
A company is evaluating ways to connect Power Platform apps to external services to perform
complex activities.
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 company uses Power Platform.
You must ensure that users cannot share customer data with other users. You must also
ensure that uses cannot connect to data sources unless you grant the user explicit
permissions to access a data source.
You need to recommend solutions to meet the company's security requirements.
Which two types of policies should you recommend? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.

• A. Office cloud policies

• B. Group Policy Objects
• C. environment-level policies
• D. tenant-level policies
• E. preset security policies

Question #20Topic 1
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 toy company creates a text classification model in AI Builder to monitor customer feedback
for specific key words.
When negative feedback is received for a toy, the company wants to proactively perform
engineering reviews for the toy and schedule additional training sessions for workers who
produce the toy.
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 canvas app.

• B. Implement the Virtual Agent.
• C. Build a Power Automate flow.
• D. Use the Common Data Model.

HOTSPOT -
A company plans to use Power BI to visualize data from business systems.
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 company is evaluating ways that they can implement AI Builder.

For which two scenarios can you use AI Builder? Each correct selection presents a complete
solution.
NOTE: Each correct selection is worth one point.

• A. Send emails to all users who subscribe to a service.

• B. Synchronize data from an external database.
• C. Collect data from several data sources and display a dashboard that shows trending
data.
• D. Interpret images and perform an action on the image.
• E. Detect patterns in data and predict outcomes.

HOTSPOT -
A company plans to create Power Platform apps that consume industry-standard and
proprietary data sources.
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 is evaluating Power Platform and has questions about the role that Common Data
Service plays in using Power Apps and Power Automate.
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 create a Common Data Service environment.
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 company plans to use AI Builder to help improve business performance.
You need to determine which AI Models are available for use.
Which three types of models can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. linear regression
• B. prediction
• C. object detection
• D. anomaly detection
• E. text classification

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.

HOTSPOT -
A company needs to create several workflows and applications to help streamline their sales
operations.
You need to determine which applications are appropriate for given scenarios.
Which applications should you use? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Hot Area:
A company uses Dynamics 365 Supply Chain Management and Dynamics 365 Finance.
User account data must be synchronized between the two systems.
You need to ensure that the synchronized data is stored in one place.
What should you use?

• A. Azure IoT Central

• B. Azure Active Directory
• C. SQL Server
• D. Common Data Service

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

• A. Use Common Data Services to connect to application data.

• B. You only need to set up groups in Microsoft 365 for permissions to all data.
• C. Users can access both Microsoft 365 and Dynamics 365 by using Single Sign-on
(SSO).

HOTSPOT -
You are creating a model-driven Power Apps app. You want to ensure that the app can be used
by individuals who have vision impairments.
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 bank uses Power Platform apps and flows to support business processes.
The company would like to use historical client data to predict whether a client's loan
application is likely to be approved or rejected.
You need to use AI Builder to implement 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:

DRAG DROP -
A company plans to implement solutions that use Common Data Service as a data storage.
You need to recommend features to meet the company's needs.
Which 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:

DRAG DROP -
A manufacturing company is evaluating AI Builder.
You need to select AI Builder models to address specified requirements.
Which model types should you use? To answer, drag the appropriate model types to the correct
requirements. Each model 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 manage the support team at a rapidly growing company.
Support technicians need a better experience when logging and responding to support
requests.
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.
Select and Place:

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 -
Match each tool to its task. To answer, drag the appropriate tool from the column on the left to
its task on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

HOTSPOT -
You are a retail director for a large clothing company. Each week you use the corporate
YouTube channel to create a video that highlights new initiatives, and goals for retail
operations.
You need to design a Power Apps app that streams the videos to internal users.
Which objects should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT -
You want to create a Power Apps app that allows you to define a custom Sitemap.
What should you do? To answer, select the appropriate options in the answer area.
Hot Area:

A company is building apps to support their business operations. The apps will use connectors
to access data from several data sources and respond to a number of events generated by
components.
Which two operations can you use for connectors? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
 • A. Actions
• B. Plug-ins
• C. Gateways
• D. Triggers

You are a sales manager for a large retail organization.

You are creating a Power Apps app that will display customer product purchase information
from your old point-of-sale (POS) system and need to link those sales to the customer
accounts and product sales in Dynamics 365 Commerce.
You need to use the appropriate component.
What should you use?

• A. Common Data Service

• B. business process flow
• C. entity metadata
• D. business rule

You create a Power Virtual Agents chatbot.

You need to share the bot with other team members so that they can try out the bot before you
share the bot with customers.
What should you use?

• A. demo website
• B. live production website
• C. test chat feature

HOTSPOT -
You are planning to use the Business Card Reader and Sentiment Analysis prebuilt AI models
to build solutions.
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 -
Your company wants to create a help desk system and implement Dynamics 365 Customer
Service.
The company has the following requirements:
✑ Provide an application to allow support team staff to chat live with a customer.
✑ Automatically import data from a Microsoft Excel spreadsheet once a day.
✑ Provide a chatbot that can assist customers who need support.
You need to determine which applications to use to meet the requirements.
Which applications should you use? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Hot Area:

You create a business rule on contact entity to enforce the requirement that users must enter
either a telephone number, fax number, or an email when creating a new record.
The company decides to remove fax number from the condition.
You need to update the business rule.
What are two ways of achieving the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. Save a copy of the rule and change the condition. Deactivate and delete the original
rule.
• B. Deactivate the business rule and change the condition.
• C. Take a snapshot of the business rule and change the condition.
• D. Change the condition and activate the change.

DRAG DROP -
You create a Power BI dashboard.
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.
NOTE: Each correct match is worth one point.
Select and Place:
You are using Dynamics 365 Sales.
You need to pull data into a Power BI report for your team. The City and State columns must be
combined to form one column on the report.
Which function would you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. Use Power Query to merge columns.

• B. Import the data.
• C. Export data to Microsoft Excel.
• D. Create a view.

A carpet cleaning company uses Dynamics 365 Sales.

The process for entering customer information during onsite sales calls is very complicated.
The company wants a simplified screen that allows salespeople to capture the customer
name, phone number, and other information while speaking to the customer.
You need to recommend a solution that works on various types of mobile devices.
What should you recommend?

• A. Common Data Service

• B. Power Automate
• C. AI Builder
• D. Canvas app
• E. Power BI

A company manages a chain of retail stores. The company stores a list of retail store names
and numbers in one Power BI table. The company stores sales transaction data including a
transaction ID in another table. The transaction ID includes the store number.
You need to show the store name for all retail transactions in all Power BI reports.
Which tool should you use?

• A. Query Editor
• B. Power BI Service
• C. Microsoft Excel
• D. Data Connector
RAG DROP -
A company is using Power BI to build visualizations.
The company's IT support team needs to know when to install Power BI Desktop on users'
computers and where the Power BI Service will suffice to perform tasks.
You need to recommend solutions for the company.
What should you recommend? 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.
Select and Place:

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

You are a sales representative. You create a Power BI report to visualize data from a Microsoft
Excel workbook.
Users need to be able to view and share the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Pin the report to a dashboard.

• B. Export the data.
• C. Publish the dashboard.
• D. Share the dashboard.

HOTSPOT -
You create reports within Power BI to report on the status of a project. A manager asks you to
share the reports with other team members. You decide to create a published app and set
permissions to allow other team members to view the reports.
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 company plans to create an information portal that managers can use to view critical
information about their teams.
You need to recommend the type of Power BI components that the company should use.
What should you recommend? To answer, drag the appropriate component types to the correct
requirements. 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:

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:
You create a Power BI dashboard that displays data from Dynamics 365 Customer
Engagement.
You need to share the Power BI dashboard with coworkers.
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. Create a Power BI workspace and grant coworkers permissions.

• B. Publish the dashboard as an app to your coworkers.
• C. Export the data into Common Data Service for others to manipulate in Power BI.
• D. Export the data to Microsoft Excel for coworkers to import and view in Power BI.
• E. Embed reports in your company's internal web portal.

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

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.

You are a district manager for a large retail organization. You train each store manager to use
Power BI to track sales and daily sales targets.
A store manager remembers learning about the Analyze in Excel option but cannot find the
option in their Power BI dashboard.
You need to help the user resolve the issue.
How should you advise the user?

• A. Install the Power BI Desktop app.

• B. Select the Spotlight button on the dashboard tile.
• C. Subscribe to the dashboard and follow the email link.
• D. Navigate to the report used by the dashboard.
DRAG DROP -
You are a district manager for a large retail company. You want to provide sales managers
with deeper sales insights to ensure that they can make more informed decisions for their
stores.
Store managers must be able to view data in near real-time.
You need to create and share a Power BI dashboard that can be used by the store managers.
Which tools can you use? To answer, drag the appropriate reporting types to the correct
requirements. Each reporting 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 -
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.
NOTE: Each correct match is worth one point.
Select and Place:

DRAG DROP -
A company plans to display support call metrics on a screen that is visible to all call center
staff.
You need to recommend solutions to meet the company's requirements.
What should you recommend? 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.
Select and Place:
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 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.

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.
Select and Place:
HOTSPOT -
A user is starting to learn about Power Apps.
Which objects should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

• A. You do not need to manually back up data.

• B. Both will use the same time zone.
• C. You can use Power BI to display data that comes from both environments.
• D. You can implement Single Sign-On (SSO).

A company runs a call center to handle customer support inquires.

The company tracks metrics including the number of incoming calls, call resolution rates, and
escalations. The company wants to display the metrics on a shared screen that is visible to all
call center staff.
You need to recommend a visualization solution for the company.
Which Power Platform feature should you recommend?

• A. AI Builder
• B. Power Automate
• C. Power Apps
• D. Power BI

HOTSPOT -
You are a regional sales manager for a large internet retailer. You create a series of Power BI
reports and dashboards to help sales associates be more productive and increase sales.
Sales are not increasing as expected.
You need to determine if the new reports are being used and send emails to sales associates
to provide guidance on how to use the reports and dashboards.
Which features should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

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

• A. drill-down
• B. automatic
• C. database
• D. manual
• E. external

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:
A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature in
different parts of their warehouse.
You need to view near-real time information from the IoT devices in Power BI Service
dashboards.
Which tool should you use?

• A. Scheduled refresh dataset

• B. Streaming dataset
• C. Content Pack dataset
• D. Power BI dataflows
• E. Quick Insights

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.
Hot Area:
DRAG DROP -
A company plans to implement Power BI to analyze retail operations data.
You need to recommend solutions for the company.
Which Power BI components should the company use? To answer, drag the appropriate Power
BI components to the correct requirements. Each Power BI 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:

HOTSPOT -
You are creating Power BI visualizations.
You need to display the visuals where a user can perform each function.
Which solution should you use? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

A company is using Power BI.

The company wants to see which data connectors are available for building dashboards.
You need to evaluate the available connectors.
What should you use to see all the available connectors?

• A. Power BI Workspace
• B. Common Data Service
• C. Power BI Dataflows
• D. Power Platform admin center
 • E. Power BI Desktop

HOTSPOT -
A company is using Power BI.
The company plans to analyze a large number of datasets. The company is concerned that this
may negatively impact performance.
You need to identify and implement features to mitigate any performance issues.
Which features should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

You create a set of dashboards and reports for a project team that combines data from
different sources in Power BI. Some of the data is considered sensitive.
You need to distribute the dashboards and reports securely to the team.
What should you create?

• A. a custom data connector

• B. a published app
• C. a Microsoft flow
• D. a Power BI workspace

You are creating visuals in Power BI.

You create area charts, pie charts, and donut charts that use your company's data.
You need to display the charts to others at the company.
Which two objects can you add the charts to? Each correct answer presents a complete
solution.
NOTE: Each correct selection is worth one point.

• A. Power BI service
• B. Power BI reports
• C. Power BI desktop
• D. Power BI dashboards
A company is creating a canvas app to display data from a legacy SQL Server database that is
located on the company's internal network.
You need to connect to the data.
What should you use?

• A. custom connector
• B. content pack
• C. data gateway
• D. Power BI

You are creating a canvas app that uses one connector.

Which two objects are provided by the connector? Each correct answer presents a complete
solution.
NOTE: Each correct selection is worth one point.

• A. customizations
• B. data sources
• C. actions
• D. tables
• E. triggers

DRAG DROP -
A company is considering implementing PowerApps to help manage business processes.
Users are trying to understand the purposes and benefits of PowerApps components.
Match each benefit to its tool. To answer, drag the appropriate benefit from the column on the
left to its tool on the right. Each benefit may be used once, more than once, or not at all.
NOTE: Each correct selection is worth one point.
Select and Place:

DRAG DROP -
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.
What should you recommend? 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.
Select and Place:

A company is considering implementing Power Platform. The company must minimize

development costs.
For which three scenarios should you consider implementing Power Apps Portals? Each
correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. a customer support website that includes knowledgebase search and support for
document uploads
• B. a public website that supports multilingual communities with forums and blogs
support
• C. a secure website for mobile users that is available only by using a VPN into the
corporate network
• D. a secure website for vendors accessing data stored in Common Data Service
• E. an internal website for employees with limited access to Dynamics 365 Finance data

DRAG DROP -
A company is building a model-driven app.
You need to create and configure the objects needed for the app.
Which component categories should you use? To answer, drag the appropriate component
categories to the correct objects. Each component category 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:
HOTSPOT -
You are creating a canvas app that will be used in several countries/regions.
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 publishes e-books for independent authors.
The company wants to implement a Power Apps portal solution to make announcements about
upcoming books to the general public.
You need to recommend features for the company.
Which features should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
DRAG DROP -
A company is building a Power Apps Portal.
You need to select page components.
Which components should you use? 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.
Select and Place:

HOTSPOT -
A company plans to implement Power Apps.
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 App portal.

When a user signs into the portal the following error displays: User not found
You confirm that the user's sign in information is correct.
You need to determine the cause of the error.
What should you do?

• A. Disable custom error messages.

• B. Create a custom error message.
• C. Enable diagnostic tools in Lifecycle Services.
 • D. Enable Maintenance mode.

HOTSPOT -
A company plans to build Power Apps portals.
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:
Question 1:
Skipped
I have changed my Canvas App and added every contact's telephone number to the
gallery. I have saved it. What happens when I go back to the Canvas App.

•
I can now see the contacts' telephone numbers.

•
I cannot see the contacts' telephone numbers no matter how many times
I refresh the webpage - I need to do something before I can see them.
(Correct)

•
I cannot see the contacts' telephone numbers - I need to refresh the web page.
Explanation
Saving the App is not sufficient to change the published app - I also need to Publish
this new version as well.
Question 2:
Skipped
In Power Virtual Agents, which of the following is NOT ideal as a Trigger Phrase.

•
Give me details of your new desktop computer
(Correct)

•
Store opening hours

•
Make a complaint

•
Return product
Explanation
Trigger phrases should ideally be short phrases - so I would reduce "Give me details
of your new desktop computer" to "Details of desktop computer" or similar.

Power Virtual Agents' Artificial Intelligence should be able to associate the users'
"Give me details of your new desktop computer" to the Trigger Phrase "Details of
desktop computer".

Question 3:
Skipped
In Power Virtual Agents, where would you be able to download the transcript of
previous conversations?

•
 Analytics
(Correct)

•
Publish

•
Topics

•
Entities
Explanation
The transcript of previous conversations is available in Analytics - Sessions.

Topics contains how a conversation will flow, but does not contain previous
conversations.

Entities enables the computer to parse out real world topics or concepts in
conversations.

Publish enables you to make your chatbot available to Channels.

Question 4:
Skipped
I want to classify the Dataverse in the Data Loss Prevention (DLP) policies. Which
classification can I NOT use?

•
Blocked
(Correct)

•
Non-business

•
Business
Explanation
There are certain connectors that cannot be moved into the Blocked classification.
These include Power Platform connectors, the Dataverse, Approval, Notifications,
and Microsoft 365 Enterprise License connectors.

They can however be moved into Business or Non-business.

Question 5:
Skipped
In Power BI, I want to find out how many rows are in my data. Which aggregation do
I use?
 •
Sum

•
Min

•
Max

•
Average

•
Count (Distinct)

•
Count
(Correct)
Explanation
Count will count the number of rows.

Sum totals numbers.

Min and Max gives the first and last value (when sorted).

Average is the Sum divided by the Count.

Count (Distinct) gives the number of unique values in a field.

Question 6:
Skipped
In Power BI, which of the following is true?

•
A Dashboard consists of pinned visualizations, but only from a single report.

•
A Dashboard consists of pinned visualizations, from one or more reports.
(Correct)

•
A Workspace consists of pinned visualizations, but only from a single report.

•
A Workspace consists of pinned visualizations, from one or more reports.
Explanation
A Dashboard consists of "pinned" visualizations, from one or more reports.

Workspaces consist of Dashboards, Reports and Datasets.

Question 7:
Skipped
In Power Automate, please select the TWO statements which are correct.

•
In an Apply to each loop, the flow loops until it has gone through all the rows
of the source data.
(Correct)

•
In an Apply to each loop, the flow does different actions depending on whether
a condition is true or false.

•
In a Do Until loop, the flow loops until it has gone through all the rows of the
source data.

•
In a Do Until loop, the flow loops until a certain condition becomes True.
(Correct)
Explanation
In an Apply to each loop, the flow loops until it has gone through all the rows of the
source data.

In a Do Until loop, the flow loops until a certain condition becomes True.

In a condition, the flow does different actions depending on whether a condition is

true or false.

Question 8:
Skipped
In Power Automate, I want a flow to start when new data arrives. What type of flow
is this?

•
An instant flow

•
A schedule flow

•
An automated flow
(Correct)

•
A button flow
Explanation
An automated flow starts with the arrival of new data.
An instant or button flow starts with the press of a button (or triggered from
elsewhere).

A schedule flow runs (for example) every week.

Question 9:
Skipped
In Power BI, I have two queries, each with 2,000 rows. I want to bring in the rows
from one query into the other query, so I end up with one query with 4,000 rows.
What should I use?

•
Calculated Columns

•
Power Query Editor - Append Queries
(Correct)

•
Power Query Editor - Merge Queries

•
Model tab
Explanation
Append Queries allows you to bring in the rows from one query into another.

Merge Queries allows you to bring in the columns from one query into another.

Calculated Columns allows you to add columns into a query.

Model tab allows you to link queries together, but it cannot combine the rows from
two queries.

Question 10:
Skipped
In Power BI, I want to allow the end user to be able to restrict what data is shown on
the page. What of the follow will allow the end user this interaction?

•
Slicers
(Correct)

•
Get and Transform

•
Model

•
 Filters
Explanation
Slicers allow the end user to filter the information on a page. You can also use other
visualizations, such as tables, so when you click on them, other visualizations are
filtered.

Filters will not allow the end user to filter the information. They allow the report
creator to do this.

You can reduce the dataset in Get and Transform, but again, this is for the report
creator, not the end user.

Model allows queries to be joined together.

Question 11:
Skipped
In Power Apps, I am in my default environment. How many Dataverse databases can
I create in my default environment.

•
1

•
0
(Correct)

•
As many as I want.
Explanation
In my default environment, I cannot create any Dataverse databases. I need to
create a new environment to do this.
Question 12:
Skipped
In Power Automate, I wish to create an Approval process. Which of these is not a
standard Approval Type?

•
Approve/Reject - Everyone must approve

•
Approve/Reject - First to respond

•
Approve/Reject - Two must approve
(Correct)
Explanation
The standard Approval types are:
Approve/Reject - Everyone must approve

Approve/Reject - First to respond

Custom Responses - Wait for all responses

Custom Responses - Wait for one response

Therefore, "Two must approve" is not a standard Approval type.

Question 13:
Skipped
Which of these are not directly used in Power Virtual Agents?

•
Entities

•
Artificial Intelligence

•
Topics

•
Forms
(Correct)

•
Trigger Phrases
Explanation
Forms are used in Power Automate.

Entities are references to real-world objects or concepts.

Topics control how a conversations plays out.

Trigger Phrases are used to decide if a certain topic should start.

Artificial Intelligence is automatically used when interpreting a user's input.

Question 14:
Skipped
I need to create a Custom Connector to connect data to my Power App. Please
select all of the following which is true.

•
I can publicly publish the Custom Connector without needing approval from
Microsoft.
 •
I can share the Custom Connector in my organisation without needing
approval from Microsoft.
(Correct)

•
I can use the Custom Connector without needing approval from Microsoft.
(Correct)
Explanation
You can use it and share it in your organisation without needing approval from
Microsoft.

Publicly publishing it does require approval from Microsoft.

Question 15:
Skipped
In Power Apps, you can insert an Image, camera, barcode scanner, video or audio
components in your canvas Power App by going to which menu?

•
Insert menu - Gallery

•
Insert menu - Input

•
Insert menu - Media
(Correct)

•
Insert menu - Charts
Explanation
They are all in the Insert - Media menu.
Question 16:
Skipped
Which of these tables types require a Dynamics 365 license?

•
Custom

•
Complex
(Correct)

•
Standard

•
 Restricted
(Correct)
Explanation
Complex and Restricted tables require a Dynamics 365 license.

Standard is a set of columns which you can expand.

Custom is a "blank" table.

Question 17:
Skipped
In the AI Builder, I want to create a model which detects spam. What model should
I use?

•
Object detection model

•
Text Category classification model
(Correct)

•
Form processing model

•
Prediction model
Explanation
The Text Category classification model can be used for sentiment analysis,
customer request routing and, as per the question, spam detection.

Form processing model extracts data from forms in JPG, PNG or PDF format.

Prediction model calculates the likelihood of something happening.

Object detection identifies objects on retail shelves, brand logos, or common

objects from uploaded images.

Question 18:
Skipped
In Canvas Apps, what is a gallery?

•
It contains the separate screens that we have used (Browse, Detail and Edit)

•
It contains a series of pictures or photos only.

•
 It contains components which make up all (or part of) a row of data.
(Correct)
Explanation
A gallery contains components (such as labels and buttons) which make up all (or
part of) a row of data.
Question 19:
Skipped
What is the Common Data Model?

•
The old name for the Dataverse.

•
A collection of default tables.
(Correct)

•
How to link two tables together in Power BI.
Explanation
It is a schema for tables and columns, with names and field types.

The old name for the Dataverse is the Common Data Service, not Model.

You can link two tables together in Power BI using the Model tab, not the Common
Data Model.

Question 20:
Skipped
Please select the 3 aggregations in the list below, as used in Power BI.

•
Average
(Correct)

•
Measure

•
Calculated Column

•
Sum
(Correct)

•
Min
(Correct)
 •
Field
Explanation
Aggregations are functions summarising data - so Sum, Min and Average are
aggregations.

Measures do also summarise data, but they use aggregations to tell it how to
summarise it.

Calculated Columns add a field to a query.

Fields are like columns in a table.

Question 21:
Skipped
In Power BI's Power Query Editor, I have a column which some text, which includes
some leading and trailing spaces - such as " HELLO THERE ". What do I use to
easily remove these spaces?

•
Pivot

•
Extract

•
Parse

•
Trim
(Correct)
Explanation
Trim removes leading and extracting spaces.

Pivot allows you to do what a PivotTable does in Excel.

Parse is for interpreting XML and JSON data.

Extract is from taking parts of strings, such as the first few characters. It could be
used, but would not be as easy as Trim.

Question 22:
Skipped
In Power BI, which of these is a possible result of using a visual filter?

•
The end user can go from one page to another page of a report.
 •
All the visualizations on a page change from looking at all the data to a single
year.

•
A visualization is changed from a bar chart to a line chart.

•
A bar chart changes from looking at all the data to looking at one particular
category.
(Correct)
Explanation
A visual filter restricts the data for a single visualization.

You can change the type of visualization by clicking on the visualization then
selecting a new type.

Users can go from one page to another using (among other things) drill-through
reports.

All the visualizations on a page can be affected (among other ways) by use a Page
Filter.

Question 23:
Skipped
I have created a Canvas App, which uses tables from the Dataverse and includes a
column containing the take-home pay for each employee. I accidentally put entered
a value of $10,000,000 for one employee. What is the best way to stop this from
happening again?

•
Alter the Canvas App.

•
Create a relationship to a table with acceptable values.

•
Create a Power Automate flow to correct the mistake.

•
Create a business rule.
(Correct)
Explanation
The best way would be to create a business rule in that table in the Dataverse. If an
unacceptable value is entered, it can reject the change.
While I could put in some complicated code to check the data in the Canvas App,
and while creating a Power Automate flow to correct the mistake is possible, it
would be better to create a business rule in the Dataverse.

Because this column is a numerical field, it is unlikely that you would have a table
with every acceptable values. If there were, it could be better to use a Choice data
type in any event - but creating a business rule would be better.

Question 24:
Skipped
I have Dynamics 365. Which of these Portal templates have I just made up?

•
Payroll portal
(Correct)

•
Community portal

•
Partner portal

•
Customer self-service portal
Explanation
There is no "payroll portal" template - there is a employee self-service portal, plus all
of the others above.
Question 25:
Skipped
In Power BI, I would like a graph which shows time in the horizontal or X-axis, and
sales in the vertical or Y-axis. Which visualization should I NOT use?

•
Stacked column chart

•
Pie chart
(Correct)

•
Line chart

•
Area chart
Explanation
A pie chart doesn't have the X- and Y-axes.

A stacked column chart uses bars, with each category above the previous one.
A line chart uses lines for each category, while an area chart fills in the area below
the lines.

Question 26:
Skipped
In Power BI's Power Query Editor, I want to find out how many or what proportion of
values in the sample data is blank. Which one of these do I NOT use?

•
Column profile.

•
Column distribution
(Correct)

•
Column quality.
Explanation
Column Distribution gives the count of Distinct and Unique values, so it will not give
the number of percentage of Empty values.

Column Quality gives you percentages of Questionable values, such as Error or

Empty values.

Column Profile gives you plenty of statistics, but only for one column.

Question 27:
Skipped
I want to link two queries together, but I do not want to alter the columns contained
in each query. What should I use?

•
Measure

•
Append Queries

•
Model tab
(Correct)

•
Merge Queries
Explanation
The Model tab can be used to link two queries together without altering the
structure.
Both Append Queries and Merge Queries in the Power Query Editor brings in rows
(append) or columns (merge) into a second query. It does alter the structure.

Measure is used to aggregate (summarise) values, often number values.

Question 28:
Skipped
Which of the following can connect to the Dataverse? Please select ALL that apply.

•
Power Apps
(Correct)

•
Power Automate
(Correct)

•
Power BI
(Correct)
Explanation
All of them can connect to the Dataverse. There may be some settings that need to
changed to allow the connection to Power BI, but it can still be connected.
Question 29:
Skipped
In Power BI, I want to create a new report from an Excel data source. What can
I use?

•
Neither Power BI Desktop nor the Power BI Service

•
Power BI Desktop, but not Power BI Service

•
Both Power BI Desktop and the Power BI Service
(Correct)

•
Power BI Service, but not Power BI Desktop
Explanation
Both Power BI Desktop and the Power BI Service can create reports from an Excel
data source.
Question 30:
Skipped
Which role has permission to create new resources (apps, connections, gateways
and flows) but not access the data?
 •
Environment Maker
(Correct)

•
System Customizer

•
System Administrator
Explanation
Environment Maker has those permissions.

System Customizer allows you to customise the environment, but you can also
access data for tables that you create.

System Administrator gives you full permissions, including accessing the data.
DRAG DROP -
You are a district manager for a large retail company. You want to provide sales
managers with deeper sales insights to ensure that they can make more informed
decisions for their stores.
Store managers must be able to view data in near real-time.
You need to create and share a Power BI dashboard that can be used by the store
managers.
Which tools can you use? To answer, drag the appropriate reporting types to the
correct requirements. Each reporting 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 -
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.
NOTE: Each correct match is worth one point.
Select and Place:

DRAG DROP -
A company plans to display support call metrics on a screen that is visible to all call
center staff.
You need to recommend solutions to meet the company's requirements.
What should you recommend? 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.
Select and Place:

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.

Answer : AB

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.

Answer : A
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.
Select and Place:

HOTSPOT -
A user is starting to learn about Power Apps.
Which objects should you use? To answer, select the appropriate options in the
answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

• A. You do not need to manually back up data.

• B. Both will use the same time zone.
• C. You can use Power BI to display data that comes from both environments.
• D. You can implement Single Sign-On (SSO).
Answer : C

A company runs a call center to handle customer support inquires.

The company tracks metrics including the number of incoming calls, call resolution
rates, and escalations. The company wants to display the metrics on a shared screen
that is visible to all call center staff.
You need to recommend a visualization solution for the company.
Which Power Platform feature should you recommend?

• A. AI Builder
• B. Power Automate
• C. Power Apps
• D. Power BI

Answer : D

HOTSPOT -
You are a regional sales manager for a large internet retailer. You create a series of
Power BI reports and dashboards to help sales associates be more productive and
increase sales.
Sales are not increasing as expected.
You need to determine if the new reports are being used and send emails to sales
associates to provide guidance on how to use the reports and dashboards.
Which features should you use? To answer, select the appropriate options in the
answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
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.
NOTE: Each correct selection is worth one point.

• A. drill-down
• B. automatic
• C. database
• D. manual
• E. external

Answer : ABD

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:
A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature
in different parts of their warehouse.
You need to view near-real time information from the IoT devices in Power BI Service
dashboards.
Which tool should you use?

• A. Scheduled refresh dataset

• B. Streaming dataset
• C. Content Pack dataset
• D. Power BI dataflows
• E. Quick Insights

Answer : B

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.
Hot Area:
DRAG DROP -
A company plans to implement Power BI to analyze retail operations data.
You need to recommend solutions for the company.
Which Power BI components should the company use? To answer, drag the
appropriate Power BI components to the correct requirements. Each Power BI
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:
WhizLabs

What are three Power Platforms Key actions on data that help users to drive their
business?

1. Analyze
2. Integrate
3. Automate
4. Build
5. Act
6. Provide a value

What are two types of objects that Power Platforms Connectors provides?

1. Function-based
2. Tables
3. Notifications
4. Power BI
5. Actions
6. Sending Emails

Select all Azure Services that Power Platforms Consumes?

1. Azure Advisor
2. Azure Cognitive Services
3. Azure Monitor
4. Azure API Management
5. Azure Bot Service
6. Azure Security Center

You need to create three Microsoft Dataverse Databases.

Can you create all of them in the Power Platform Development Environment.

a. Yes
b. No

You are trying to explain the benefits of the Dataverse (Common Data Service) business rules
to your manager. He asked you about an application of the business rules to the Power Apps
form. Can a canvas app show or hide form fields based on a business rule?
 A. Yes
B. No

You are trying to explain the benefits of the Dataverse (Common Data Service) connector’s
triggers and actions to your manager. He asked you what type of triggers you can use for your
Power Automate Solution working with Dynamics 365.

Please select all triggers that you can use in your organisations business process flow.

1. When a record is updated

2. When a record is selected
3. When a record is created
4. When a record is displayed
5. When a record is deleted
6. When a record is edited

Please select all the AI models that are NOT included in Power Platform.

1. Image Classification
2. Object Detector
3. Prediction
4. Anomaly Detection
5. Form Processor
6. Text Classification

Describe the business value of Power Platform

You explain the Microsoft Dataverse security model to your manager.

Please select all correct statements Dataverse security model.

A. All Dataverse users are authenticated by Azure AD

B. Users can access all Dataverse data anonymously

C. A newly added user has Environment Maker role by default

D. Dataverse security model is Rule Based Access Control model

E. Users with the Environment Maker role can add new data to Dataverse

F. Each Dataverse environment can have its own security access to the data and apps
Identify the core components of Power Platform

You are adding an action to your Power Automate flow.

Please select an option that you can't add in the Flow Designer as a new card
action.

A. Create a new row

B. Add a new flow step

C. Send an email

D. Delete a record
E. Return value to Power Virtual Agents

Domain: Identify the core components of Power Platform

Please select all correct statements about the use of Common Data Service (Dataverse)

A. Canvas apps use only the Common Data Service (Dataverse) data

B. Common Data Service (Dataverse) is based on the Common Data Model

C. Model-driven apps use only the Common Data Service (Dataverse) data

D. You can use more than one Common Data Service (Dataverse) database in the same
environment for Power Apps apps

E. Power Apps portals use data from any data sources, including Common Data Service
(Dataverse)

Domain: Identify the core components of Power Platform

You create an automated flow that extracts the account number, customer name, transaction
id or invoice number, and transaction or invoice date-time from incoming emails. Flow updates
an Excel spreadsheet with this information. And then forwards email to appropriate
departments based on predefined categories, like orders, invoices, pricing, etc.
What two Al builder models do you use in your flow?

A. Business Card Reader

B. Category Classification v right

C. Key Phrase Extraction

D. Sentiment Analysis

E. Entity Extraction v right

F. Text Recognition

Domain: Demonstrate the capabilities of Power BI

Please select all overlapping tasks between Power Bi Desktop and Power BI Service.

A. Collaborating on a dashboard

B. Editing the reports

C. Using Gateway connections

D. Implementing Visualizations

E. Adding Q&A

F. Transforming the data

Domain: Demonstrate the capabilities of Power BI You create a set of the reports in Power BI
Desktop and want to create a dashboard. You expect that many of your coworkers will use the
dashboard. What will be the best way to distribute your work inside of your organization?

A. Upload reports to a new workspace, create a dashboard and add your colleagues to the
workspace as Members

B. Upload reports to My workspace, create a dashboard and add your colleagues to the
workspace as Contributors
C. Upload reports to My workspace, create a dashboard and publish it as an app to your
organization

D. Upload reports to a new workspace, create a dashboard and add your colleagues to the
workspace as Viewers

E. Upload reports to My workspace, create a dashboard and publish it to the web

Domain: Demonstrate the capabilities of Power BI

You create a new report in the Power BI desktop and ready to add it to the dashboard. You
want to share your work with others in your organization.

What will be the easiest first step to accomplish your goals?

A. Export your report as a pbix file

B. Publish a report to Power BI Service workspace

C. Import your report as a pbix file to the Power BI Service workspace

D. Add a report to the Dashboard

E. Share your Dashboard

Domain: Describe the capabilities of Power Apps

You create a canvas app. Please select all the formula elements that you can use for your app.

A. Functions

B. Setting Power Apps environment

C. Controls and their properties

D. Creating BI reports

E. Named operators

F. Enumerations
Domain: Describe the capabilities of Power Apps

What are the three design phases for model-driven apps?

A. Define data sources

B. Model business data

C. Selecting connectors

D. Define business processes

E. Build the app

Domain: Demonstrate the business value of Power Virtual Agents

You are authoring the topic for Power Virtual Agents bot.

What are you creating?

A. Entities

B. Intents

C. Trigger phrases

D. Publishing a bot

E. Channels

Domain: Describe the business value of Power Platform

You created Power Virtual Agent chatbot.

You need to know what the most popular topics are. Please select the Microsoft 365 service
that can provide this information to PVA?

A. Microsoft Teams

B. Microsoft Users Service

C. Dynamics Sales
D. Microsoft SharePoint

E. Dynamics Customer Service Insights

F. Dynamics Finance

Domain: Identify the core components of Power Platform You create a Power Platform solution
in a development environment.

What type of solution will it be when you import it into a test environment?

A. Standard

B. Unmanaged

C. Test

D. Managed

E. System

Domain: Demonstrate the capabilities of Power BI

You create a new high-quality dataset in the Power BI workspace.

You want to share your work with others in your organization who can use your dataset to
create their reports and dashboards by endorsing the dataset.

What are the two levels of endorsement that you can provide for your dataset?

A. High Quality

B. Promoted V right

C. Safe to use

D. Certified v right

E. Verified

F. Approved
Domain: Describe the capabilities of Power Apps

You create a model-driven app and share it with your team members.

Please select two standard security roles that you can assign to the users for access to your
shared app.

A. Environment Maker

B. System Administrator

C. Knowledge Manager

D. Microsoft Dataverse User

E. System Customizer

Domain: Demonstrate the business value of Power Virtual Agents

You use Power Virtual Agents Analytics to learn about which topics impact a bot's
performance the most.

Please select the names of the three analytics rate charts that should help you.

A. Engagement

B. Escalation

C. Resolution

D. Abandon

E. Total Sessions
Domain: Demonstrate the capabilities of Power Automate How many stages can you create in
a Business process flow?

A. 5

B. 25

C. 20

D. 30

E 35

F. 50

Domain: Demonstrate the capabilities of Power Automate

What are the two main parts of any Power Automate flow?

A.Loop

B. Business process

C.One or more actions

D. Schedule

E.Trigger

F. Expressions

Domain: Demonstrate the business value of Power Virtual Agents

You are trying to explain the benefits of the Power Virtual Agents to your manager.

How can Power Virtual Agents help your organization?

Please select all that apply.

A.Improve customer satisfaction

B. Help to create Power Apps faster

C. Empower your team by creating bots with no coding

D. Deliver dashboards and reports to the end user

E. Reduce costs by automating Q&A

F. Create powerful visuals for model-driven apps

Domain: Demonstrate the business value of Power Virtual Agents

What are two topics groups automatically added when you create a chatbot using Power

Virtual Agents?

A. Greeting

B.User

C. Escalate

D.System

E. Lessons

F. Thank you

Domain: Demonstrate the business value of Power Virtual Agents

You want to add actions to your Power Virtual Agents chatbot by calling Power Automate flow.

Can you achieve your goal if the flow is in another Dataverse (Common Data Service)

environment than your chatbot?

A. Yes

B.No
You are trying to explain the benefits of the Dataverse (Common Data Service) connector's
triggers and

actions to your manager. He asked you what type of triggers you can use for your Power
Automate solution

working with Dynamics 365.

Please select all triggers that you can use in your organization's business process flow.

A. When a record is updated

B. When a record is selected

C. When a record is created

D. When a record is displayed

E. When a record is deleted

F. When a record is edited

Please select all the Al models that are NOT included in Power Platform?

Image classification

Object detector

Prediction

Anomaly detection

Form Processor

Text classification
You are editing a BI report with drill-down visualization. You want to remove all filters and
some new ones,

Please select all filters that you can delete from the report

A. Manual

B. Automatic

c. URL

D. Drilt-down

E. Pass Through

You are creating a Bl report and need to aggregate category (text) fields

Please select all the aggregation options that you can use for this procedure.

A. Count

B. Average

c. last

d. SUM

e. First

f. Maximum

You are creating your first dashboard. You need to use a calculated column in one of your
reports. Your

manager suggested using the Power Bl Service for this report

Will you follow his advice?

A. Yes

b. No

Your manager told you to help the sales department. They want to have a responsive Power
App that would

work on phones and tablets for salespeople on the road

What type of app would you create?

A. Canvas

B. Angular lonic

c. Model-driven

D. React Native

E. Nodejs

You are creating a model-driven app. Select all entity assets that you can use for the building
of your app.

A Forms

B. Dashboards

C. Entities

D. views

E. Business Process Flow

F. Charts
The accountant department asked you to create a Power App for expense reports submission.
This app should scan receipts and create a report. Then the user submits this report to the
manager. After the ‘manager's approval, the report will be forwarded to the department

What Power Automate flow would you create for this app?

A. Instant flow

B. Schedule flow

c Approval flow

D. Organization flow

e. Accountant flow

How many stages can you create in a Business process flow?

A. 5

8. 25

c. 20

D. 30

E. 35

f. 50

What are the two main parts of any Power Automate flow?

Loop

Business process

One or more actions

Schedule

Trigger

Expressions
You are trying to explain the benefits of the Power Virtual Agents to your manager.

How can Power Virtual Agents help your organization?

Please select all that apply.

A. Improve customer satisfaction

B. Help to create Power Apps faster

C. Empower your team by creating bots with no coding

D. Deliver dashboards and reports to the end user

E. Reduce costs by automating Q&A

F. Create powerful visuals for model-driven apps