New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > Microsoft > Microsoft Certified Power Platform Fundamentals > PL-900

PL-900 Microsoft Power Platform Fundamentals Question and Answers

Question # 4

You are new to working with Microsoft Flow. You create a flow that extracts birth dates for users and then

sends a birthday greeting email to users on their birthday.

The flow does not properly extract birth dates.

Where should you make changes?

A.

Connectors

B.

Expression

C.

Templates

Full Access
Question # 5

A company uses Microsoft 365, SharePoint Online, and Dynamics 365 Sales.

You need to recommend tools to build a solution that meets the following requirements:

* Synchronize data from an external Microsoft SQL Server instance.

* Send out of the box report automatically to specific company executives.

* Ensure that opportunities over a specified amount are approved by a sales manager.

Which two tools or components should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

Microsoft Excel

B.

Microsoft Word

C.

Power Automate

D.

Microsoft DataService

E.

Power BI

Full Access
Question # 6

A company plans to create a workflow that periodically runs a Dynamics 365 action based on data in third-party cloud-based solutions.

Which features should you use to create the workflow? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 7

You plan to use Power Automate to perform data-management tasks when users interact with sales

opportunities in Dynamics 365.

You need to identify the three types of events that can generate a trigger for the tasks.

Which three types of events should you identify? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

when a record is displayed in a view

B.

when a record is deleted

C.

when a record is created

D.

when a record is updated

E.

when a record is read

Full Access
Question # 8

A company uses Dynamics 365 Customer Service. The company uses a manual process to manage call

escalations.

You must use Power Automate to automate the process for routing escalated calls.

You need to create the flow.

Which type of connector should you use?

A.

Microsoft Excel

B.

Common Data Service

C.

Office 365 Users

Full Access
Question # 9

A business plans to including 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.

Full Access
Question # 10

You plan to use Microsoft Flow to monitor what people are saying about your company's products. You store the feedback for research and development purposes.

You need to recommend Flow components to use for the solution.

To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Full Access
Question # 11

You are building a Power Automate flow to manage sales.

The sales team saves quotes as PDF files to a Microsoft OneDrive folder. You create a Microsoft SharePoint list to help the sales team manage follow ups to quotes. You need to copy the customer name, phone number, and the amount of the potential sale from the sales quote and insert the data into the SharePoint list. Which Al Builder model should you use?

A.

key phrase extraction

B.

sentiment analysis OC.

C.

text recognition

D.

language detection

Full Access
Question # 12

STION NO: 88 DRAG DROP

A company provides on-site architectural consulting services to residential and business customers. The company wants to implement a simple alert system where a consultant can press a button on their mobile device to send the user’s location to the company as a text notification.

You need to build a button flow that sends the notification.

In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Full Access
Question # 13

A company has a website. The website includes a form that allows the company to collect information about leads.

You need to set up an automated workflow to create leads in Dynamics 365 Sales when leads are created on the company’s custom website.

What should you create?

A.

Task Flow

B.

Power Automate flow

C.

Dynamics 365 workflow

D.

Business Process Flow

Full Access
Question # 14

A company uses Microsoft Flow.

Each time a work order is created, a service manager must review and approve the work order before a

worker is dispatched.

You need to create a flow to enforce the process.

What should you create?

A.

plug-in

B.

approval flow

C.

business rule

D.

team flow

E.

instant flow

Full Access
Question # 15

Users within a company use Flow for personal productivity.

Users often overwrite their working flows by editing the definitions and are unable to undo changes after saving a flow.

You need to ensure that users can revert a flow to the current state.

Which two options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Export

B.

Rename

C.

Save As

D.

Share

Full Access
Question # 16

You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device.

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 17

You create a Power Apps canvas app.

You need to ensure that your coworkers can run the app.

What should you do?

A.

Share the app.

B.

Send the URL for the app to coworkers.

C.

Add a license for the app.

D.

Create a Flow for the app.

Full Access
Question # 18

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

Full Access
Question # 19

A company uses Microsoft 365, Power Platform, and Dynamics 365. You do not assign permissions to any licensed users.

Users are able to create and edit Power Apps canvas apps.

In which environment are users creating and editing the apps?

A.

Production

B.

Default

C.

Sandbox

Full Access
Question # 20

This question requires that you evaluate the BOLD text to determine if it is correct.

A company requires that service representatives schedule customer visits every six months. Each service representative is required to enter a scheduled task for the next checkup as they are leaving a client site. A service representative wants to automate task entry by creating a business process flow that can be initiated from the service call screen on a phone.

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.

a scheduled

C.

an instant

D.

an action

Full Access
Question # 21

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.

Full Access
Question # 22

NO:32 HOTSPOT

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 would you recommend using in Power Apps? To answer, select the appropriate control in the dialog box in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 23

A company plans to build new apps for the business to allow employees to work more efficiently.

You need to recommend the appropriate types of Power Apps to meet the company’s requirements.

To answer, drag the appropriate app types to the correct requirements. Each app type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Full Access
Question # 24

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.

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

B.

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

C.

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

D.

Block users who are identified as minors.

Full Access
Question # 25

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.

Full Access
Question # 26

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 27

A company is building a Power Apps Portals.

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.

Full Access
Question # 28

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.

Full Access
Question # 29

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.

Full Access
Question # 30

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.

Full Access
Question # 31

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

A.

0

B.

1

C.

2

D.

3

Full Access
Question # 32

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.

Full Access
Question # 33

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.

Full Access
Question # 34

A company has a Power Apps app that is used by most employees. The company is expanding to other

countries/regions.

You need to recommend a solution to translate text generated within the Power Apps in near real-time.

What should you recommend?

A.

Microsoft Azure Synapse Analytics

B.

Microsoft Azure Cognitive Services

C.

Common Data Service connector

D.

Power BI

Full Access
Question # 35

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.

Full Access
Question # 36

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.

Full Access
Question # 37

A company uses Dynamics 365 Sales. The company uses a browser-based app named Sales Hub.

You need 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

Full Access
Question # 38

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.

Full Access
Question # 39

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

Full Access
Question # 40

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.

Full Access
Question # 41

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.

Microsoft Flow

D.

Azure Machine Learning

E.

Microsoft Power BI

Full Access
Question # 42

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

Full Access
Question # 43

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.

Full Access
Question # 44

A rapidly growing 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.

Full Access
Question # 45

This question requires that you evaluate the BOLD 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

Full Access
Question # 46

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.

NOTE: Each correct selection is worth one point.

Full Access
Question # 47

You need to explain the major components of the Common Data Model (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.

Full Access
Question # 48

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 Microsoft Flow to connect to the database.

D.

Open a ticket with Microsoft and request a new connector.

E.

Use Microsoft Azure Service Bus.

Full Access
Question # 49

A tutoring company has developed and deployed a model-driven app for the administration staff and a canvas app for teachers. Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: tach correct selection is worth one point.

Full Access
Question # 50

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

Full Access
Question # 51

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.

Full Access
Question # 52

You are creating a Power Virtual Agents chatbot to help users search for available meeting rooms within a building.

The chatbot must meet the following requirements:

Allow users to initiate the chatbot by typing the phrase Help me Meeting Guru.

Provide meeting room capacity options of 1-4 people and 5-10 people.

End the chatbot session if the user attempts to schedule a meeting room for more than 10 people.

You need to identify the actions to use.

Which actions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 53

NO: 14 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.

Full Access
Question # 54

You create a Power Virtual Agents chatbot for a company.

The management wants to learn about the effectiveness of the chatbot.

You need to identity the percentage of customers who stop responding to prompts from the chatbot.

Which report should you view?

A.

Customer satisfaction

B.

Engagement over time

C.

Escalation rate drivers

D.

Session outcomes overtime

Full Access
Question # 55

You ate creating a model-driven app.

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.

Full Access
Question # 56

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.

Full Access
Question # 57

You create a Power Virtual Agents chatbot for use with Microsoft Teams. You are testing the chatbot.

Testers report the following issues:

Changes that you make to the chatbot are not seen by testers.

When users enter the word refund the chatbot must ask the user the product for which they would like a refund. The chatbot does not ask the user for product information.

You need to determine what needs to be done to fix the issues.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 58

A company plans to use Microsoft Power Platform connectors to automate an existing business process that includes Power Automate cloud flows and canvas 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.

Full Access
Question # 59

A company has built a Power Apps to take pictures of and store business card data during a seminar.

The company wants to select a tool that can extract data from the pictures.

You need to identify the tool.

A.

Copilot studio

B.

AI Builder

C.

Azure Machine Learning

D.

Microsoft Dataverse

Full Access
Question # 60

A company uses Power Automate.

Which three items can trigger flows? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Lifecycle Services

B.

Microsoft 365 Admin center

C.

Common Data Service

D.

Microsoft Outlook 365

E.

Microsoft Windows Desktop

Full Access
Question # 61

You are building a Power Virtual Agents chatbot for a company.

You are working with an existing topic and would like to call an action.

Which technology is available to perform the action?

A.

Power Virtual Agent Entity

B.

Power Apps

C.

Power Automate

D.

Power Bl

Full Access
Question # 62

You are planning to allow members of your team to test your chatbot. You must ensure this is done in a secure way.

A team member named User1 must test the chatbot.

You need to ensure that User1 can complete testing.

What should you do?

A.

Sign in to the authoring environment as the chatbot author.

B.

Sign in to Microsoft Azure DevOps as the chatbot author.

C.

Sign in to Microsoft Azure DevOps as User1.

D.

Sign in to the authoring environment as User1.

Full Access
Question # 63

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 Microsoft Azure Storage Blobs

B.

separate connectors

C.

separate tenants

D.

separate environments

Full Access
Question # 64

You are authoring a Power Virtual Agents chatbot for a company.

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 65

A company is building an interactive chatbot to answer questions about product and product warranties.

You need to create conversation paths for questions about product warranties.

Which tool should you use?

A.

Authoring canvas

B.

Azure Bot Framework

C.

Power Platform admin center

D.

Power Virtual Agents portal

E.

Conversation node

Full Access
Question # 66

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

Full Access
Question # 67

You are developing a Power Virtual Agents chatbot for a company.

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 68

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.

Full Access
Question # 69

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

Full Access
Question # 70

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 must unify all the mobile devices to one vendor.

Full Access
Question # 71

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.

Full Access
Question # 72

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

Full Access
Question # 73

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.

Full Access
Question # 74

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.

Full Access
Question # 75

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.

Full Access
Question # 76

You are creating a Power Virtual Agents chatbot for a company.

Which component types should you use for each scenario? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 77

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.

Full Access
Question # 78

A manufacturing company is evaluating Al Builder.

You need to select Al 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.

Full Access
Question # 79

You create a Power Virtual Agents chatbot for a company. The chatbot will use common channels and services by which the company communicates with customers.

You need to determine which services the chatbot can be used with or added to.

Which two services can the chatbot be used with? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Facebook

B.

Power Bl

C.

Microsoft Azure Event Grid

D.

Microsoft Azure Service Bus

E.

Microsoft Azure Bot Framework

Full Access
Question # 80

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.

Full Access
Question # 81

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

D.

Use the Common Data Model.

Full Access
Question # 82

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.

Gateway

D.

Flow

Full Access
Question # 83

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.

Microsoft Flow

C.

AI Builder

D.

Canvas app

E.

Power BI

Full Access
Question # 84

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.

Full Access
Question # 85

This question requires that you evaluate the BOLD text to determine if it is correct.

You have a Power BI report with a page named RevReceived. The page shows revenue received by your

company. You want to create an almost identical page that shows net revenue instead of gross revenue. To accomplish this task, you modify the RevReceived page.

Review the underlined text. If it makes the statement correct, “No change is needed”. If the statement is

incorrect, select the answer choice that makes the statement correct.

A.

No change is needed.

B.

duplicate the RevReceived page.

C.

import the RevReceived page.

D.

copy the visuals from RevReceived to a new page.

Full Access
Question # 86

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 Bl service

B.

Power Bl reports

C.

Power Bl desktop

D.

Power Bl dashboards

Full Access
Question # 87

You need to display sales orders greater than a specific threshold in a Power Bl report. What should you use?

A.

Common Data Service

B.

connector

C.

Power Query

D.

filter

Full Access
Question # 88

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.

Full Access
Question # 89

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.

Full Access
Question # 90

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.18912E1457D5D1DDCBD40AB3BF70D5D

C.

Export data to Microsoft Excel.

D.

Create a view.

Full Access
Question # 91

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

Full Access
Question # 92

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

Full Access
Question # 93

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

Full Access
Question # 94

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

Full Access
Question # 95

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.

Full Access
Question # 96

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.

Full Access