Examtopics Test Dumps Flashcards

1
Q

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

c. three

Restore a canvas app to a previous version in PowerApps.
1. Open powerapps.com, and then click or tap Apps in the left navigation bar.
2. Near the right edge, click or tap the info icon for the app that you want to restore.
3. Click or tap the Versions tab, and then click or tap Restore for the version that you want to restore

Three versions
1. Old version
2. New version
3. Restored version

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

D. Dynamics 365 for Phones

Use the Dynamics 365 for phones and Dynamics 365 for tablets apps for your sales, customer service, field service, and other tasks when you’re on the go. With one download from your app store, you’ll automatically have access to all the apps you need for your role. You will see apps with the new Unified Interface on your mobile device.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

D. Common Data Service

“Portals bring the power of no-code solutions to building externally facing websites. Through the Power Apps interface, you can build an anonymous or authenticated website that allows users to interact with data held in Dataverse.”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

Statement 1: You can change the entity ownership from User to Organization-owned

Statement 2: You can create a business rule for a custom entity that can be used in a Flow

A

Statement 1 is incorrect

After custom entity creation, the ownership cannot be changed. If you want other ownership type, you need to create a new entity and delete the old one

Statement 2 is correct

You can create business rules on custom entities. Microsoft flow is able to use Custom entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You need to explain the major components of the Common Data Model (CDM) and their functions.
Match each term to its definition.

Tools
1. Entities
2. Data connectors
3. Common Data Service
3. Common Data Model
5. Workflow

Purpose 1: Helps jumpstart application development by leveraging business logic, security, and integrations

Purpose 2: A set of records used to store data.

A

Purpose 1: Common Data Service

Purpose 2: Entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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.

A

A. Check AppSource for a tax add-on.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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.

Tools
1. Power Apps portal
2. Power Automate
3. Power BI
4. Common Data Service

Requirement 1: Customers must be able to submit support requests by using a website
Requirement 2: Support requests must be created and stored
Requirement 3: Support technicians must be notified when a new support request is entered
Requirement 4: Support technicians must be able to enter a status report for work completed during the previous week by using a mobile app.

A

Requirement 1: Power Apps portal
Requirement 2: Common Data Service
Requirement 3: Power Automate
Requirement 4: Power Apps portal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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.

Statement 1: Dynamics 365 Sales and Microsoft 365 must be in the same tenant to allow Single Sign-On (SSO)

Statement 2: You must download a product from AppSource to ensure that SSO works with Dynamics 365 Sales and Microsoft 365

A

Statement 1 is Incorrect

When you offer your application for use by other companies through a purchase or subscription, you make your application available to customers within their own Azure tenants. This is known as creating a multi-tenant application.

Statement 2 is incorrect

Single sign-on (SSO) between Dynamics 365 and Microsoft 365 is not dependent on downloading a product from AppSource. As long as both services are within the same tenant, SSO should work seamlessly without additional downloads.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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. Power Apps
b. Azure Active Directory
c. Power Automate
d. Azure Machine Learning
e. Power BI

A

a. Power Apps
c. Power Automate
e. Power BI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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.

Statement 1: You can synchronize account information from Dynamics 365 Sales with a third-party database

Statement 2: You can create invoices from order and send the invoices to the customer by using a Power Automate flow.

A

Statement 1 is correct
You can synchronize account information from Dynamics 365 Sales with a third-party database using Power Automate.

Statement 2 is correct
You can create invoices from orders and then send the invoices to customers using a Power Automate flow.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

c. Power Platform Analytics

The Power Platform Analytics Usage report is the default reports seen by the logged in environment admin. It provides total app launches and daily active users across all apps in the environment. Admins can filter the view with attributes like device platform, player version, country, state, and city.

Reference:
https://docs.microsoft.com/en-us/power-platform/admin/analytics-powerapps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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.

Admin Centers
1. Azure Active Directory
2. Dynamics 365 Admin center
3. Power Apps Admin Center
4. Power BI Admin portal

Requirement 1: Create user accounts for Power Apps

Requirement 2: Assign the Environment maker role to a user

A

Requirement 1: Azure Active Directory

Requirement 2: Power Apps admin center

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.

Scenario 1: Build automatic workflows that access multiple data sources
a. AI Builder
b. Power Apps
c. Power Automate
d. Azure Functions
e. Power BI

Scenario 2: Create custom apps that address specific business needs
a. AI Builder
b. Power Apps
c. Power Automate
d. Azure Functions
e. Power BI

Scenario 3: Design insightful data visualizations
a. AI Builder
b. Power Apps
c. Power Automate
d. Azure Functions
e. Power BI

A

Scenario 1: Power Automate
Scenario 2: Power Apps
Scenario 3: Power BI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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.

Scenario 1: Field technicians need a mobile app to capture the location and the image of defective products
a. Canvas app
b. Power Apps Portals
c. Common Data Service

Scenario 2: Sales representatives need to see different views and dashboards in the sales app
a. Canvas app
b. Model-driven app
c. Power Apps Portals

A

Scenario 1: Canvas app
Scenario 2: Model-driven app

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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.

Tools
a. Business rule
b. Business process flow
c. Power Automate
d. Power BI

Requirement 1: If a customer is travelling with a person under the age of 18, a field must display to collect the date of birth for the under 18 traveler only

Requirement 2: Ensure that all travel agents use the same process with all customers

Requirement 3: Send a confirmation email to customers after reservations are complete

A

Requirement 1: Business rule
Requirement 2: Business process flow
Requirement 3: Power Automate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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.

Features
a. Environment
b. Security group
c. SharePoint library

Requirement 1: Ensure fastest response times for each company location
Requirement 2: Create test and production copies of the data and apps

A

Requirement 1: Environment
Requirement 2; Environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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:

You will ____ versions of the app
a. 1
b. 2
c. 3
d. 4

A

c. 3

Test dump says 2 because the customer “Has not yet restored the version”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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.

Statement 1: You can create a canvas app that scans and parses documents using Azure Cognitive Services and then adds the appropriate information to Dynamics 365 Sales.

Statement 2: You can create a canvas app that uses Azure Cognitive Services to read incident records and identify tickets that need to be escalated based on sentiment score.

A

Statement 1 is correct
Statement 2 is correct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

C. environment-level policies
D. tenant-level policies

  1. Restricting the permissions of Dataverse users is done on Environment Level.
  2. Preventing users to connect to data sources is done by creating DLP policies, which also uses Tenant Level Security.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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.

Statement 1: Virtual table data is stored in Microsoft Dataverse

Statement 2: Columns are used in forms and views

A

Statement 1 is incorrect

A virtual table is a definition of a table in the Dataverse platform without the associated physical tables for table instances created in the Dataverse database.
Instead during runtime, when a table instance is required, its state is dynamically retrieved from the associated external system.

Statement 2 is correct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

Statement 1: Managed solutions can be used to group multiple Power Platform components together during solution development

Statement 2: Managed solutions must be used to distribute a Power Platform application on AppSource

Statement 3: Managed solutions always protect Power Platform components from editing when components are exported to another environment

A

Statement 1: Yes
Managed solutions are used to deploy to any environment that isn’t a development environment for that solution.
Statement 2: No
Unmanaged solutions can be exported either as unmanaged or managed.
Statement 3: Yes
You can’t edit components directly within a managed solution. To edit managed components, first add them to an unmanaged solution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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.

Responses
a. One per user
b. One per tenant
c. One per environment
d. One per Power Platform app

Question 1: How many trial instances must the team create
Question 2: How many Common Data Service databases must the team create

A

Question 1: One per environment
Question 2: One per environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

A company is creating a canvas app to track and analyze customer visits to their retail stores. Data about customer visits is stored on-premises at each retail store location.
The app must display data about customer visits when users launch the app.
You need to ensure that the data is available for consumption by the app.
Which tool should you use?
A. Connector
B. Microsoft Dataverse
C. Data source
D. Power Automate
E. Data gateway

A

e. Data gateway

A data gateway is a tool that allows you to connect to on-premises data sources, such as the customer visit data stored at each retail store location in this scenario. The data gateway acts as a bridge between the on-premises data and the cloud-based Power Platform, allowing the canvas app to access and display the customer visit data in real-time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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.

Statement 1: Security roles are modified in Microsoft Azure Directory

Statement 2: Security roles are assigned to each table

A

Statement 1: No

It should be in the Power Platform Admin Center. This is Yes in the test dumps.

Statement 2:
Security roles are assigned to users and to groups, not to tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

A company currently does not separate testing, development and production as per standard Application Lifecycle Management (ALM) protocol. The company uses Power Apps for accounting and sales processes.
The company needs to use only one login account per user. The company also must prevent development and testing from impacting production.
You need to implement a solution to meet the requirements.
Which method should you select?

A. separate environments
B. separate tenants
C. separate Microsoft Azure Storage Blobs
D. separate connectors

A

a. separate environments

To follow application lifecycle management (ALM) principles, you’ll need separate environments for app development and production. Although you can perform basic ALM with only separate development and production environments, we recommend that you also maintain at least one test environment that’s separate from your development and production environments.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

A company creates the following Microsoft Power Platform environments to manage a custom model-driven app:
✑ Development
✑ Production
You have been granted the System Administrator security role to the development environment and a custom security role named Project Team Member to the production environment.
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You will not be able to access the app until the System Administrator security role is assigned to the app in the development environment

Statement 2: You can delete records in the development environment

Statement 3: You will not be able to access the app until the Project Team Member security role is assigned to the app in the production environment

A

Statement 1 is No
You already have this access as a System Administrator.
Users who have the Environment Maker, System Administrator, or System Customizer security role can access and edit all model-driven apps within the environment. This is because these security roles have create, read, and write privileges on the Model-driven App table.

Statement 2 is Yes
If you are the System Administrator role in your CDS (Common Data Service), you would have full permission to customize or administer the environment, including creating, modifying, and assigning security roles.
Currently, within PowerApps, there is no way to prevent CDS System Administrator role from deleting a record in an Entity.

Statement 3 is No
Other security options are available.
Also, there is no information on what the custom Project Team Member role entails.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

A company uses Dynamics 365 Sales.
You have the following requirements:
* View analytics on accounts.
* The model-driven app must automatically send an approval form to a manager when the purchase price is greater than $10,000.
* Create a chatbot for the webpage to interact with customer questions.
You must use Microsoft Power Platform to extend the capabilities of Dynamics 365 Sales.
You need to select an application for each requirement.
Which application should you use?

Applications
a. Power BI
b. Power Automate
c. Power Virtual Agents
d. Power Portals

Requirement 1: View Analytics on accounts
Requirement 2: Automatically send approval
Requirement 3: Create chatbot for webpages

A

Requirement 1: Power BI
Requirement 2: Power Automate
Requirement 3: Power Virtual Agents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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.

Statement 1: You can display data aggregates and raw data in a Power BI report

Statement 2: You can display related data from multiple sources in the same Power BI report

A

Statement 1 is Yes
The following list provides advantages to using aggregations:
Query performance over big data - as users interact with visuals on Power BI reports, DAX queries are submitted to the dataset. Boost query speeds by caching data at the aggregated level, using a fraction of the resources required at the detail level. Unlock big data in a way that would otherwise be impossible.

Statement 2 is Yes
With Power BI Desktop, you can connect to many different types of data sources, then shape the data to meet your needs, enabling you to create visual reports to share with others. Shaping data means transforming the data: renaming columns or tables, changing text to numbers, removing rows, setting the first row as headers, and so on. Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

A company is evaluating ways that they can implement AI Builder.
For which two scenarios can you use AI Builder? Each correct answer 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 based on the image.
E. Detect patterns in data and predict outcomes.

A

d. Interpret images and perform an action based on the image
e. detect patterns in data and predict outcomes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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.

Statement 1: Custom connector cannot be used if a standard connector for the service is available

Statement 2: Custom connectors connectors are supported in instant flows only

Statement 3: Standard and custom connectors cannot be mixed within the same flow or app

A

Statement 1 is No
Statement 2 is No
Statement 3 is No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

A company is evaluating Power Platform and has questions about the role that Microsoft Dataverse 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.

Statement 1: Model-driven apps require a Microsoft Dataverse database

Statement 2: A flow instance can only access one Microsoft Dataverse

Statement 3: Canvas apps require a Microsoft Dataverse database

A

Statement 1 is Yes
Statement 2 is Yes
Statement 3 is No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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.

Statement 1: You can create a Common Data Service environment in the Power Platform Admin center

Statement 2: You must enable data encryption after you create a Common Data Service environment

Statement 3: You can control security roles and privileges in a Common Data Service environment from the Power Apps Admin center

A

Statement 1 is Yes

Statement 2 is No

Statement 3 is Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

b. prediction
c. object detection
e. text classification

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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.

Scenario 1: Create no-code workflows that uses different systems
a. Azure Logic Apps
b. Power Apps
c. Power Automate
Scenario 2: Build no-code mobile application
a. Azure Logic Apps
b. Power Apps
c. Power Automate
Scenario 3: Build a mobile application by using Microsoft Dataverse
a. Azure Logic Apps
b. Power Apps
c. Power Automate

A

Scenario 1: Power Automate
Scenario 2: Power Apps
Scenario 3: Power Apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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. Microsoft Dataverse

A

D. Microsoft Dataverse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

You are creating a Power Apps app. You want to ensure that the app can be used by individuals who have a vision impairment.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: Power Apps can use a screen reader without the need for a connector

Statement 2: You can use an accessibility checker for Power Apps to check for accessibility violations and provide user interface tips

A

Statement 1: Yes

The following software combinations are the supported recommendations for consuming PowerApps with a screen reader:
✑ Windows: Microsoft Edge / Narrator
✑ macOS: Safari / VoiceOver
✑ Android: PowerApps app / Talkback
✑ iOS: PowerApps app / VoiceOver

Statement 2: Yes

Users who have vision, hearing, or other impairments can use your canvas app more easily and successfully if you consider accessibility as you design how the app looks and behaves. If you’re not sure how to make your app more accessible, you can run the Accessibility checker in PowerApps Studio.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

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.

Actions
1. Train the model
2. Use the model in PowerApps or Power Automate
3. Export data into AI Builder
4. Publish the model
5. Import data into Common Data Service

A

Step 1: 5. Import data into Common Data Service
AI Builder requires the use of Common Data Service, which is the data platform for PowerApps and allows you to store and manage business data. Common Data

Step 2: 1. Train the model

Step 3: 4. Publish the model

Step 4: 2. Use the model in PowerApps or Power Automate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

A company plans to implement solutions that use Microsoft Dataverse.
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.

Features
a. business rules
b. business process flows
c. common data model

Requirement 1: Validate data across multiple fields and entities regardless of the app used to create data

Requirement 2: Create visual guides to ensure that users enter data and perform in a consistent mannner

Requirement 3: Accelerate development by using a standard set of entities for the most common scenarios

A

Requirement 1: business rules
You can create business rules and recommendations to apply logic and validations without writing code or creating plug-ins. Business rules provide a simple interface to implement and maintain fast-changing and commonly used rules.

Requirement 2: business process flows
Business process flows ensure that people enter data consistently and follow the same steps every time they work in an app by creating a business process flow.

Requirement 3: common data model
Model-driven app design is a component-focused approach to app development. Model-driven app design doesn’t require code and the apps you make can be simple or very complex. Unlike canvas app development where the designer has complete control over app layout, with model-driven apps much of the layout is determined for you and largely designated by the components you add to the app.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

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.

Model types
a. prediction
b. form processing
c. object detection

Requirement 1: identify products without labels or serial numbers

Requirement 2: Identify customers who might not pay their invoices on time

A

Requirement 1: object detection
Requirement 2: prediction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

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.

Tools
a. Power Apps
b. Power Automate
c. Power BI
d. Microsoft Dataverse

Requirement 1: Support technicians must be able to submit support requests by using an app

Requirement 2: Customer data must be stored any synchronized with Dynamics 365 Finance

Requirement 3: Support technicians must be notified when a new support request is entered

A

Requirement 1: Power Apps
Requirement 2: Microsoft Dataverse
Requirement 3: Power Automate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

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.

Statement 1: You can use a text classification model in AI Builder to retrieve text and perform sentiment analysist for ServiceNow incidents.

Statement 2: You can tag Instagram post that mention your new product

Statement 3: You can send results about the number of mentions of your new product in Instagram to Power BI for inclusion on a dashboard

A

Statement 1 is Yes
Statement 2 is Yes
Statement 3 is Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

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.

Tools
a. Power BI
b. Power Automate
c. Power Apps

Task 1: Automate workflows
Task 2: Trigger an action from an event
Task 3: Create a custom mobile data entry screen

A

Task 1: Power Automate
Task 2: Power Automate
Task 3: Power Apps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

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.

Action 1: Implement the Power Apps app
a. Canvas
b. Model-driven
c. Portal

Action 2: Use drag and drop to add a video to the app
a. View
b. Connector
c. Control

Action 3: Apply consistent company colors to the app
a. Unified interface
b. Control
c. Theme
d. Template

A

Action 1: Model-driven
Action 2: Control
Action 3: Theme

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

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.

Navigate to the Power Apps portal and create
a. a canvas app
b. a model-driven app
c. a portal app
d. an app by using a template

A

b. a model-driven app

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

Question #47Topic 1
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

A

a. Actions
d. Triggers

test dump’s answer is A and C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

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. Microsoft Dataverse
B. business process flow
C. entity metadata
D. business rule

A

a. Microsoft Dataverse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

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

A

a. demo website

You should use the demo website only to try out the bot and share it with your teammates or other stakeholders who want to try out the bot. It’s not intended for production uses, for example, you shouldn’t use it directly with customers.

50
Q

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.

Statement 1: The Business Card Reader model can be used with both Power Automate and Power Apps

Statement 2: The Sentiment Analysis model can be used in Power Automate only.

A

Statement 1 is Yes

Statement 2 is No
You can use sentiment analysis with both Power Automate and Power Apps.

51
Q

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.

Requirement 1: Automatically import data from a Microsoft Excel spreadsheet once a day
a. Custom Connector
b. Azure Data Lake
c. Power Automate
d. Power BI

Requirement 2: Provide a chatbot that can assist customers who need support

A

Requirement 1: Power Automate
Requirement 2: Power Virtual Agent

52
Q

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.

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.

A

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.

Test dump also considers Choice D

53
Q

You are learning about Power Apps and how to use triggers.
Which objects should you use? To answer, select the appropriate options in the answer area.

Statement 1: When a condition is met, Power Apps can trigger a
a. connector
b. Power Automate flow
c. gateway
d. solution

Statement 2: Actions and triggers are properties of a
a. connector
b. gateway
c. solution

A

Statement 1: Power Automate flow
Statement 2: connector

54
Q

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

A. Create a custom connector.

55
Q

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.

A

B. Implement the Virtual Agent.
C. Build a Power Automate flow.

Test dump gave A and C

56
Q

HOTSPOT -
A company is evaluating AI Builder.
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.

Statement 1: Prebuilt AI Builder models are pretrained and are ready to interpret business data immediately

Statement 2: Prebuilt AI Builder models exist for both Power Automate and Power Apps

A

Statement 1 is Yes
Statement 2 is Yes

57
Q

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.

Components
a. Standard Dataverse table
b. Custom Dataverse table
c. Column
d. Relationship

Data
1. The owner object
2. The pet object
3. The owner’s email address
4. Reference a pet record as belonging to an owner record

A
  1. Standard Dataverse table
  2. Custom Dataverse table
  3. Column
  4. Relationship
58
Q

A company plans to build canvas apps that will be used within Microsoft Teams.
You need to identify the platform based on the design considerations.
To answer, drag the appropriate platforms to the correct design considerations. Each platform may be used once, more than once, or not at all

Platforms
a. Dataverse
b. Dataverse for Teams

Design 1: Limit the number of rows to less than one million that can exist for an application in Teams

Design 2: Ensure that professional developers have as many features as possible, such as API access, plug-ins, and more, when developing applications for use within Teams

A

Design 1: Dataverse for Teams -
Over time, the data stored in the Dataverse for Teams environment will grow and eventually reach the capacity limit that these environments have (2 GB). At this point, existing apps will continue to operate but new applications won’t be allowed to be created or installed. Customers will be directed to contact a tenant admin to upgrade the Dataverse for Teams environments to Dataverse and obtain more capacity.

Design 2: Dataverse
APIs and plugins aren’t supported by Dataverse for Teams, instead it’s more of a limited/targeted set of features specifically for Teams. So when it says “as many features as possible”, you can rule out Dataverse for Teams.

59
Q

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

A

a. filter

60
Q

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.

A

A. Pin the report to a dashboard.
D. Share the dashboard.

C is incorrect because you can only publish in Power BI Desktop while Power BI Desktop does not have a dashboard. You can only say publish a report in Power BI Desktop or share a dashboard in Power BI Service.

61
Q

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.

Statement 1: The Power BI published app is stored within the Team site so that others can install it

Statement 2: One of the other project managers installs and modifies a dashboard within the Power BI published app. The changes are automatically made into the original publish app

A

Statement 1 is Yes

Statement 2 is No
Changes made by the project manager need to be published : “The workspace is your staging area, so your changes aren’t live in the app until you publish again. This lets you make changes without affecting the published apps.” It means that changes aren’t AUTOMATICALLY applied to the app.

62
Q

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.

Component types
a. Dashboard
b. Report

Requirement 1: Display data from a Microsoft Excel workbook that has multiple worksheets into one chart

Requirement 2: Display the top departmental goal metrics and alert users when specific threshold targets are met

Requirement 3: Display Sales charts that can be filtered by region

A

Requirement 1: Report
Reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc.

Requirement 2: Dashboard
Dashboards are a business key performance indicator view where it displays key values that can change business profits and can be glanced at one screen.

Requirement 3: Report
Power BI dashboards cannot slice and dice, but reports have many ways to filter and slice.

63
Q

You have a Power BI report.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You can export data from a visualization in a Power BI report
Statement 2: You can show the data behind a visual report on your screen without exporting the data
Statement 3: You can export data to view supporting data for a KPI

A

Statement 1 is Yes
You can export data from a visualization in a Power BI report

Statement 2 is Yes
You can show the data behind a visual report on your screen without exporting the data

Statement 3 is Yes
You can export data to view supporting data for a KPI

64
Q

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.

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.

A

A. Create a Power BI workspace and grant coworkers permissions.

Basic Sharing for Dashboards and Reports through a workspace is the most common way of sharing the Power BI content. Basic Sharing is very simple and easy to use method. You can simply click on the Share button in the dashboard or report, and then share it with other users.

B. Publish the dashboard as an app to your coworkers.

Apps are great sharing method for multiple environment, and best way of sharing for users in production environment.
Power BI App is the solution for multiple environment approach. With Power BI App, your development environment (workspace), and user environment (App) are isolated from each other.

E. Embed reports in your company’s internal web portal.

Sometimes, you don’t need a secure way of sharing, you may search for an easy and free way of sharing, and your content is not confidential or sensitive.

65
Q

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

c. Data gateway

66
Q

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

A. Restore the previous version of the app.

67
Q

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.

A

D. Navigate to the report used by the dashboard.

Analyze in Excel is a feature on Power BI datasets and reports published to the service. You can find it right in front of every report’s name as an action

68
Q

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.

Reporting types
a. Power BI Service only
b. Power BI Desktop only
c. Power BI Desktop or Power BI Service

Requirement 1: Create Power BI dashboards that contain a single store’s sales information

Requirement 2: Share that dashboard with your retail managers

A

Requirement 1 is Power BI Service only
Requirement 2 is Power BI Service only

69
Q

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.

Features
a. Query & Aggregate
b. Mobile apps
c. Export to Excel
d. Get data from files

Requirement 1: Enable user-friendly reporting on phones
Requirement 2: Use natural language to query and aggregate data

A

Requirement 1: Mobile Apps
Requirement 2: Q&A

70
Q

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.

Componnets
a. Tile
b. Template app
c. Treemap
d. Page
e. Theme
f. Alert
g. DirectQuery
h. Workspace

Requirement 1: Display a chart with incoming calls versus wait time and pin the chart to a dashboard

Requirement 2: Send a specific user a notification when the number of customer support calls waiting is over 20

Requirement 3: Display metrics from different datasets that have related data.

A

Requirement 1: Tile
Requirement 2: Alert
Requirement 3: DirectQuery

71
Q

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.

A

A. Create a Power BI workspace and grant coworkers permissions.
B. Publish the dashboard as an app to your coworkers.

72
Q

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.

A

a. Use Power Query Editor to merge columns.

73
Q

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.

App types
a. model-driven
b. dashboard
c. dataset
d. canvas

Definition 1: Quickly create app for very complex processes from data in Common Data Service with little or no code

Definition 2: Create simple apps with a highly customizable user interface layouts

A

Definition 1: model-driven
Both model-driven and canvas apps allow you to easily build business apps. They both share access to the Common Data Service providing standard and custom entities. Model-driven apps start with your data model building up from the shape of your core business data and processes in the Common Data

Definition 2: canvas
Canvas apps start with your user experience, crafting a highly tailored interface with the power of a blank canvas and connecting it to 200 data sources. Canvas apps can be built for web, mobile, and tablet applications.

74
Q

A user is starting to learn about Power Apps.
Which objects should you use? To answer, select the appropriate options in the answer area.

A Power Apps can call a
a. connector
b. flow
c. gateway
d. solution

Actions and triggers are properties of a
a. connector
b. flow
c. gateway
d. solution

A

Statement 1: Flow
Statement 2: Connector

75
Q

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

C. You can use Power BI to display data that comes from both environments.

76
Q

A company runs a call center to handle customer support inquiries.
The company tracks metrics including the number of incoming calls and call resolution rates. 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

A

D. Power BI

77
Q

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.

Requirement 1: Send an email to the sales associate on a predetermined schedule
a. Subscribe
b. Export
c. Favorites
d. Publisher

Requirement 2: Quantify the adoption usage from the sales associates
a. Explore
b. Favorites
c. Usage metrics
d. Performance inspector

A

Requirement 1: Subscribe
Requirement 2: Usage metrics

78
Q

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

A

a. drill-down
Allows you to explore hierarchical data in more detail by focusing on a specific data point.

b. automatic
Automatic filters are filters that are applied automatically based on certain conditions or criteria. For example, you can automatically filter data by date, by a specific category, or by a certain value.

d. manual
Manual filters allow you to manually select the data you want to include in your report, giving you full control over what data is displayed.

79
Q

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.

Statement 1: Power BI can only retrieve data from up to two different sources from each dashboard

Statement 2: Power BI visualizations can be used in canvas apps and model-driven apps

Statement 3: Power BI can display charts and list boxes on dashboards

A

Statement 1 is No
Power BI can retrieve data from multiple sources for each dashboard. It has a wide range of connectors that allow it to access various data sources like databases, cloud services, and flat files.

Statement 2 is Yes
Power BI visualizations can be used in both canvas apps and model-driven apps. In canvas apps, you can use the Power BI tile control to display a Power BI report, and in model-driven apps, you can embed Power BI visuals within dashboards or forms.

Statement 3 is Yes
Power BI can display various types of visualizations on dashboards, including charts and list boxes. It offers a range of chart types such as bar, column, line, pie, and more, as well as list boxes to display data in a more structured format.

80
Q

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

A

B. Streaming dataset

A Streaming dataset in Power BI allows you to stream data in real-time and view it in a dashboard. It’s a suitable option for monitoring IoT devices that generate a large amount of data in near real-time. Streaming dataset supports multiple data sources and it’s possible to push data to it using REST APIs or SDKs.

A. Scheduled refresh dataset is useful for when you need to refresh a dataset at specific intervals, but it’s not suitable for near real-time monitoring.
C. Content Pack dataset is a predefined dataset that is shared by a publisher, it’s not suitable for custom data sources like IoT devices.
D. Power BI dataflows allow you to transform, enrich, and manage data from multiple sources, but it’s not suitable for real-time data.
E. Quick Insights is a feature that allows you to quickly discover hidden insights in your data, but it’s not suitable for real-time data.

81
Q

You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue.
What should you do? To answer, select the appropriate option in the answer area.

You should
a. modify the RevReceived page
b duplicate the RecReceived page and update the duplicate copy
c. import the RevReceived page
d. copy the visuals from RevReceived to a new page

A

b duplicate the RecReceived page and update the duplicate copy

82
Q

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.

Power BI components
a. reports
b. workspace
c. dashboards
d. dataset

Requirement 1: Allow users to set and receive alert when data changes beyond specified limits

Requirement 2: View and filter data to Microsoft Excel for further manipulation and analysis

A

Requirement 1: dashboards
Requirement 2: reports

83
Q

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.

Requirement 1: Make decisions by analyzing high-level KPIs
a. Power BI service
b. Power BI Desktop
c. Power BI dashboards

Requirement 2: Drill down into the details of a visual
a. Power BI reports
b. Power BI Desktop
c. Power BI dashboards

A

Requirement 1: Power BI Dashboards
PowerBI dashboards are a collection of visuals that provide a high-level overview of key performance indicators (KPIs) for a particular area of focus. These dashboards allow users to quickly see important trends and patterns in the data, which can be used to make decisions.

Requirement 2: Power BI reports

84
Q

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

A

d. Power Platform admin center

Test dump answer is E

85
Q

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.

Requirement 1: Improve performance by reducing table size
a. Aggregations
b. Formulas
c. Modeling view

Requirement 2: Cache data locally on a user’s device
a. Import
b. Dual

A

Requirement 1: Aggregations
Automatic aggregations are both self-training and self-optimizing. They enable dataset owners of any skill level to improve query performance, providing faster report visualizations for even the largest datasets.

Requirement 2: Import

86
Q

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

A

b. a published application

The test dump’s popular answer is D as well

87
Q

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

B. Power BI reports

D. Power BI dashboards

Power BI reports and Power BI dashboards are the two objects where you can add your charts to display them to others at your company. Power BI reports allow you to create and publish a collection of visualizations and data, and Power BI dashboards allow you to create a single view of important metrics and data using visualizations such as area charts, pie charts, and donut charts.

88
Q

A company is implementing Power BI to track sales.
Each of the company’s regions has specific quarterly and yearly sales goals.
You need to build a Power BI dashboard for various reporting requirements.
Which chart types should you use? To answer, drag the appropriate chart types to the correct requirements.

Chart types
a. Donut
b. KPIs
c. Line Chart
d. Matrix

Requirement 1: Show the quarterly sales total to date in relation to the sales goal

Requirement 2: View the sales trend by month of the sales year to date for all region

Requirement 3: View the year-to-date sales as a percentage by region

A

Requirement 1: KPIs
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.

Requirement 2: Line chart
Line charts emphasize the overall shape of an entire series of values, usually over time.

Requirement 3: Donut
Doughnut charts are similar to pie charts. They show the relationship of parts to a whole. The only difference is that the center is blank and allows space for a label or icon.

89
Q

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.

Products
a. Share
b. Embed
c. Get Data
d. Pin

Requirement 1: ensure that coworkers can see the dashboard
Requirement 2: Display data from Microsoft Excel in the dashboard
Requirement 3: Add a report tile to the dashboard

A

Requirement 1: Share
Requirement 2: Get Data
Requirement 3: Pin

90
Q

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.

A. Use Power Query to merge columns.
B. Import the data.
C. Export data to Microsoft Excel.
D. Create a view.

A

A. Use Power Query to merge columns.

91
Q

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. Microsoft Dataverse
B. Power Automate
C. AI Builder
D. Canvas app
E. Power BI

A

d. Canvas app

92
Q

A company using Power Platform is implementing Power BI. The company plans to connect to several data sources and create reports and dashboards.
You need to identify the data sources they can connect to.
Which two data sources should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Microsoft Excel
B. Microsoft Dataverse
C. Microsoft OneNote
D. Microsoft Word

A

A. Microsoft Excel
B. Microsoft Dataverse

93
Q

You create a multi-page Power BI report for an organization.
You must enable salespeople in the organization to use the report to view data relevant to their sales region only.
You need to enable security for the report.
What should you use?

A. sensitivity labels
B. Microsoft Azure Active Directory
C. Microsoft Trust Center
D. data loss prevention policies
E. row-level security

A

E. row-level security

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn’t restrict this data access.
You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server. For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop.

94
Q

You are building a Power Apps portal by using the Customer Self-Service template.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: The Customer Self-Service portal supports Azure AD authentication

Statement 2: The Customer Self-Service portal has multi-language support

Statement 3: The Customer Self-Service portal supports web forms

A

Statement 1: No
Employee self-service portal does support Azure AD authentication, both Customer self-service portal and Partner portal both does not support this

Statement 2: Yes
Customer self-service portal has multi-language support.

Statement 3: Yes
Customer self-service portal support advanced forms.

95
Q

User1 creates several Power BI dashboards for a company. User1 shares a dashboard with User2 who works for another company. User2 reports that she is able to view the dashboard. User2 forwards the email containing the dashboard sharing link that she received to User3.
User3 reports that he receives an error message when he selects the link to view the dashboard. User3 can view a dashboard that he has created.
You need to determine why User3 receives an error.
What is the issue?

A. User3 is running an out-of-date version of Power BI and must upgrade to a newer version.
B. User2 is signed in to the dashboard and must sign out before User3 can sign in.
C. Forwarding the email does not share the dashboard with User3.
D. User1 is signed in using the wrong organizational account for Power BI.

A

C. Forwarding the email does not share the dashboard with User3.

96
Q

A company plans to implement Power BI.
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: Power BI Report Builder is the only tool used to create reports to be published to the Power BI service

Statement 2: Power BI service can include calculated columns

Statement 3: Power BI Desktop can include calculated columns

A

Statement 1 is No
Power BI Report Builder is not the only tool used to create reports to be published to the Power BI service. Power BI Desktop is also a powerful tool that can be used to create reports and publish them to the Power BI service.

Statement 2 is No
Power BI service does not include calculated columns. However, you can create calculated columns and measures in Power BI Desktop and then publish them to the Power BI service.

Statement 3 is Yes
Power BI Desktop can include calculated columns. You can use the “New Column” feature to create a new column, and then use DAX (Data Analysis Expressions) to create a calculated column.

97
Q

You are developing reports for a company.
You must create visualizations that include the following data:
✑ Invoices due from a third-party enterprise resource planning (ERP) system
✑ Number of calls made to the client from Microsoft Dataverse
✑ Microsoft Excel file data
The reports must be displayed in a single page.
You need to create the visualizations.
What should you use?
A. deployment pipelines
B. tables
C. columns
D. dashboards

A

d. dashboards
A Power BI dashboard is a single page, often called a canvas, that tells a story through visualizations.

98
Q

You are using the Power BI service to view a visual on a report that has been shared with you.
You need to add the visual to a dashboard as a tile.
Which action should you perform?
A. Export data
B. Pin
C. Copy
D. Spotlight

A

B. Pin
An entire report page can be pinned to a dashboard, which is called pinning a live tile. It’s called a live tile because you can interact with the tile on the dashboard.
Unlike with individual visualization tiles, changes made in the report are automatically synced with the dashboard.

99
Q

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

A

A. Query Editor

Power BI Desktop comes with Query Editor, where you can connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.

100
Q

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 is enough 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.

Tools
a. Power BI Service only
b. Power BI Desktop only
c. Power BI Desktop or Power BI Service

Requirement 1: Create dashboards
Requirement 2: Create reports
Requirement 3: Create calculated columns
Requirement 4: Configure security
Requirement 5: Configure sharing

A

Requirement 1: Power BI Service
Requirement 2: Power BI Desktop or Power BI Service
Requirement 3: Power BI Desktop
Requirement 4: Power BI Desktop or Power BI Service
Requirement 5: Power BI Service Only

The following are capabilities which can be done in both Power BI Desktop and Service
1. Reports
2. Visualizations
3. Security
4. Filters
5. Bookmarks
6. R Visuals

101
Q

A company creates a Power BI report for vendors to view purchase orders.
Vendors must view the report by using their own tenant environment.
You need to use a Power BI technology to allow vendors to view the report.
What should you use?
A. dashboard
B. mobile app
C. template app
D. workspace

A

C. Template app

To allow vendors to view a Power BI report using their own tenant environment, a Template app should be used. A Template app is a pre-built solution that contains a collection of dashboards, reports, and datasets that can be customized and shared with specific users or groups of users.

102
Q

You create and share two Power BI dashboards with an accountant. You configure the dashboards to update daily.
DashboardA shows a lock when the accountant tries to view the dashboard. DashboardB displays outdated data.
You need to identify the issues for the dashboards.
What are the issues? To answer, drag the appropriate issues to the correct dashboards. Each issue may be used once, more than once, or not at all.

Issues
a. Permissions on dataset
b. Refresh has not run
c. Incorrect datasets imported

DashboardA
DashboardB

A

DashboardA: Permissions on dataset
DashboardB: Refresh has not run

103
Q

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You can connect to external resources with Power BI Desktop but not with Power BI Service

Statement 2: You can build and edit Power BI reports by using Power BI Desktop or the Power BI service

Statement 3: The only way to distribute a Power BI Desktop report is by sending the PBIX file to others

A

Statement 1 is No
Power BI Desktop and the Power BI service both allow you to connect to external resources such as databases, web services, and Excel files. So it is not true that you can connect to external resources with Power BI Desktop but not with the Power BI service.

Statement 2 is Yes
Power BI Desktop and the Power BI service both allow you to build and edit Power BI reports. This statement is true.

Statement 3 is No
You can distribute a Power BI Desktop report by publishing it to the Power BI service, which allows others to access the report online. You can also share the report by sending the PBIX file to others or by embedding the report on a website. So it is not true that the only way to distribute a Power BI Desktop report is by sending the PBIX file to others.

104
Q

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.

A

C. Enable diagnostic tools in Lifecycle Services.

Enabling diagnostic tools in Lifecycle Services can provide detailed logs and insights into the error that is occurring and help to determine the root cause of the issue.

105
Q

A company plans to build Power Apps portals.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You must use standard templates for building portals
Statement 2: You can test portals in non-production environments and migrate the portals into production environments
Statement 3: When transitioning to the new version of a portal, you can display a customizable maintenance page until the new portal is ready to be used

A

Statement 1 is Yes
Statement 2 is Yes
Statement 3 is Yes

106
Q

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.

Portal types
a. partner portal
b. community portal
c. portal from blank
d. customer self-service portal

Requirement 1: Collaboratively onboard new suppliers and distributors

Requirement 2: Publish a blog post announcing new suppliers

A

Requirement 1: partner portal
A partner portal allows every organization with resellers, distributors, suppliers, or partners to have real-time access to every stage of shared activities.

Requirement 2: community portal
A community portal leverages peer-to-peer interactions between customers and experts to organically grow the catalog of available knowledge from knowledge base articles, forums, and blogs as well as providing feedback through comments and ratings.

✑ Portal from blank: Create a website to share data with external and internal users. This template comes with sample pages to get you quickly started.
✑ Customer self-service portal: A customer self-service portal enables customers to access self-service knowledge, support resources, view the progress of their cases, and provide feedback.
Reference:

107
Q

A user is trying to understand the differences between the various ways apps can be built by using Power Apps.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You can embed canvas apps in model-driven apps
Statement 2: A Power Apps portal can use only one data source
Statement 3: You must use Power BI to create reports in model-driven apps

A

Statement 1 is Yes
You can create a canvas app and then embed that within a model driven app.

Statement 2 is No

Statement 3 is No
Model drivel also provides charts, view, dashboard, ability to integrate with SSRS and Excel to create report for data analysis.

108
Q

A user is creating their first canvas app in Power Apps.
The user does not know what types of controls they can include.
You need to recommend solutions for the user.
Which types of controls should you recommend using in Power Apps?

Scenario 1: View the date, time, and location of upcoming internal meetings
a. Meeting-screen template
b. Gallery
c. List box

Scenario 2: Create a meeting request from within the app
a. Meeting-screen template
b. Gallery
c. List box

Scenario 3: Drill down into customer contact records in Dynamics 365 sales to view a photo of a customer you are meeting
a. Image
b. People-screen template
c. Add picture

A

Scenario 1: Gallery
A Gallery control can show multiple records from a data source, and each record can contain multiple types of data. For example, a Gallery control can show multiple contacts with each item showing contact information that includes a name, an address, and a phone number for each contact.

Scenario 2: Meeting-screen template
In a canvas app, add a meeting screen that lets users create and send meeting requests from their Office 365 Outlook accounts. Users can search for attendees in their org and add external email addresses. If your tenant has meeting rooms built into Outlook, users can select a location as well.

Scenario 3: image
If you add one or more Image controls to your app, you can show individual images that aren’t part of a data set, or you can incorporate images from records in data sources.
Incorrect Answers:

109
Q

You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device.
For each of the following statements, select Yes it the statement is true. Otherwise, select No.

Statement 1: You should build a model-driven app in Power Apps
Statement 2: You should build a canvas app in Power Apps
Statement 3: Users must download and run the Power Apps mobile application to use the solution.

A

Statement 1 is No
Statement 2 is Yes
Statement 3 is Yes

110
Q

A company uses Dynamics 365 Supply Chain Management.
The company wants to build customer user interfaces that add additional functionality.
You need to recommend a solution for the company.
What should you recommend?
A. Power BI
B. Power Apps canvas apps
C. AI Builder
D. Microsoft Flow

A

b. Power Apps canvas app

Microsoft Power Apps provides a consistent experience for building apps and extending Office 365 and Dynamics 365. Investments include enhancements on
Unified Interface, support for embedding canvas apps in model-driven apps and native support of the Common Data Service for Apps.

111
Q

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.

A

B. Prompt a user for consent to use their personal data and record the date consented.
C. Block users who are identified as minors.

112
Q

You need to create a mobile application which will allow sales associates to enter customer sales leads.
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.

Actions
a. Go to the Office 365 admin center
b. Add components to the app
c. Create a new Power Apps app
d. Publish the app
e. Save the app
f. Add flows to the app

A

c. Create a new Power Apps app
b. Add components to the app
e. Save the app
d. Pulish the app

113
Q

A company uses Power Apps canvas apps.
When a user opens Power Apps Studio in a browser and selects Apps I can edit, they do not see an app that they need to modify.
You need to determine why the user cannot see the app.
What are three possible reasons? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. The user selected an incorrect Power Apps environment.
B. The user has not been granted the System Customizer role.
C. The user has not been set as the app co-owner.
D. The app has not been shared with the user.
E. The environment does not have a Microsoft Dataverse database.

A

A. The user selected an incorrect Power Apps environment.
C. The user has not been set as the app co-owner.
D. The app has not been shared with the user.

114
Q

You create a model-driven app.
The app is ready to be shared.
You need to complete the process required to set the app up to be shared.
How should you complete the process for setting up the app to be shared? To answer, drag the appropriate setting to the correct drop targets. Each source may be used once, more than once, or not at all.

Processes
1. Select an app from the Power Apps list
2. Select the app and select a security role
3. Select a user and choose a security role
4. Select Share

A
  1. Select an app from the Power Apps list
  2. Select Share
  3. Select the app and select a security role
  4. Select a user and choose a security role
115
Q

You are creating a model-driven app.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: To add entities to an app, entities are dragged onto the app canvas from the components area.

Statement 2: View definition is created in the component area of the app designer

Statement 3: You must save, validate, and publish your app for others to see the changes

A

Statement 1 is No
Statement 2 is Yes
Statement 3 is Yes

116
Q

You create a canvas app that allows contractors to submit time they work against a project.
Contractors must be able to use the canvas app to enter time. Contractors must not be able to perform any other actions in the app.
You need to configure permissions for the contractors.
Which type of permissions should you use?
A. application-level
B. task-level
C. record-level
D. field-level

A

d. field level

Field-level security feature to allow more granular control of security at the field level.

117
Q

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.

Component types
a. Area
b. Group
c. Subarea

Navigation Statement
a. Administration
b. Sales Log
c. Customers

A

Administration - Group
Sales log - Subarea
Customers - Subarea

118
Q

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

A

A. the Generate an app from data feature

The “Generate an app from data” feature in Power Apps allows you to create a canvas app automatically from an existing data source, such as an Excel workbook stored in OneDrive for Business. This app can then be used by team members to update the status of their tasks in the Excel workbook.

119
Q

You create a canvas app by using the Generate from data feature. The app connects to a Microsoft SharePoint list.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: A screen is generated that contains a browsable list of SharePoint list items

Statement 2: A screen is generated that allows users to update SharePoint list items

A

Statement 1 is Yes
Statement 2 is Yes

120
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No

Statement 1: Power Apps apps can run only mobile devices

Statement 2: Power Apps can run only with Dynamics 365 products

Statement 3: If a user runs a Power Apps app that accesses information to which the user does not access, the app grants the user permissions.

A

Statement 1 is No
You can run apps in a browser or on mobile devices.

Statement 2 is No
On-premises versions of Microsoft Office can also be used

Statement 3 is No
You must ensure that the users you share the app with have the appropriate permissions.