PL-900

7 Drag/Drop 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? Tools: -Power Apps Portal -Power Automate -Power BI -CDS/Dataverse Customers submit support requests via website Support requests created/stored Techs notified when new support request entered Techs enter status report for work completed using mobile app

- Power Apps Portal - Dataverse - Power Automate - Power BI "With the Power BI mobile app, you can monitor progress on your metrics, make check-ins to update progress, and add notes."

58 DRAG DROP -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. You may need to drag the split bar between panes or scroll to view content. Platforms: dataverse dataverse for teams Limit the number of rows to less than one millions that can exist for an application in Teams Ensure that devs have as many features as possible when developing apps for teams

1. Dataverse for Teams. Easy keyword here is the one million limit. Obviously, the main Dataverse doesn't do that (its limit is upwards of 2 billion or more). 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.

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

3

54 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 suitableMicrosoft 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

66 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

72 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

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

A B Must deactivate

25 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 : Separate environments

55 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) - Canvas App - For using AI Builder C) - Power Automate - To monitor flow and table necessary action for text classification

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

92 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. Microsoft Excel B. Microsoft Dataverse Power BI allows you to connect to a wide variety of data sources to create reports and dashboards. Two popular data sources that can be used are: A. Microsoft Excel: You can connect Power BI to Excel files and use the data in your reports and dashboards. This is a great option if the company already has data stored in Excel and they want to use that data in their Power BI reports. B. Microsoft Dataverse: Dataverse is a data platform that is part of the Power Platform. It allows you to create and manage data in a centralized location and make that data available to other applications like Power BI. This is a great option if the company wants to use Power Platform to manage their data and then use that data in their Power BI reports.

99 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. Query Editor In Power BI, you can use the Query Editor to join the table containing store names and numbers with the table containing sales transaction data. By joining the two tables on the store number, you will be able to show the store name in all Power BI reports that use the transaction data.

37 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. Use Common Data Services to connect to application data.

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. C. Export data to Microsoft Excel. D. Create a view.

A. Use Power Query to merge columns.

49 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. demo website

78 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. drill-down B. automatic D. manual

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

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

AB

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

ABE (Don't export from Power BI to Power BI) The "Publish as app" option is worded badly, but is still kind of correct. What they mean is create a app workspace to upload your dashboard into and other team members can then access this.

9 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

ACE

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

AD

47 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

Actions Triggers

85 HOTSPOT - A company is using Power BI. The company plans to analyze a large number of datasets. The company is concerned that this may negatively impact performance. You need to identify and implement features to mitigate any performance issues. Features: -Aggregations -Formulas -Modeling View -Import -Dual Improve performance by reducing table size Cache data locally on a user's device

Aggregations Import

12 DRAG DROP -A company uses Power Apps.You need to perform administrative tasks for the company.Which admin centers should you use? To answer, drag the appropriate admin centers to the correct requirements. Each admin center may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Admin centers: Azure AD Dynamics 365 Admin center Power Platform Admin Center Power BI admin portal Create user accounts for power apps Assign the environment maker role to a user

Azure AD Power Platform Admin Center

98 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

B. Pin

80 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

B. Streaming dataset 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. Wrongs: A. Scheduled refresh dataset is useful term-241for 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.

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

BC

33 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

BCE

87 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

BD

26 HOTSPOT -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. You will not be able to access app until security admin security role is assigned to app in dev environment You can delete records in dev environment You will not be able to access app until project team member security roles is assigned to the app in prod environment

Box 1: 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. Box 2: 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. Box 3: No -Other security options are available.Also, there is no information on what the custom Project Team Member role entails.Note: Apps can be viewed by valid users with appropriate privileges who sign into Power Apps, the Power Apps mobile app, or Dynamics 365 home page. For a user to view and access apps in an environment, the following privileges, security role, or team membership are required:A user who has the write or create privilege on the Model-driven App table makes the user a maker persona. That user can view and access all apps in the environment.A user who has only the read privilege on the Model-driven App table, must also have the associated security role(s) that are assigned to the app (or equivalent)

15 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: Business rule Business process flow Power automate Power BI Customer traveling with person under 18 - field needs to display to collect DOB Ensure all travel agents use same process with all customers Send confirmation email to customers after reservation complete

Business rule Business process flow Power automate

11 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

C

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

C

65 Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a newPower 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

C- Data Gateway for importing data from On-Premise to Cloud

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

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

1 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

C. three

19 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

CD

45 HOTSPOT - You are a retail director for a large clothing company. Each week you use the corporate YouTube channel to create a video that highlights new initiatives, and goals for retail operations. You need to design a Power Apps app that streams the videos to internal users. Which objects should you use? Objects: -View -Connector -Control -Model-driven -Theme -Power Pages Portal -Canvas -Unified Interface -Template Implement the power apps app Use drag/drop to add video to app Apply consistent company colors to app

Canvas Control Theme

76 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

D

91 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

D. Canvas app

3 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

D. Common Data Service

2 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

D. Dynamics 365 for Phones

36 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

D. Microsoft Dataverse

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

D. Navigate to the report used by the dashboard. From REPORT, Export - Analyze in Excel. Option not available in dashboard

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

D. Run a Power BI report.

86 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

D. a Power BI workspace

97 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

D. dashboards

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

DE

82 DRAG DROP - A company plans to implement Power BI to analyze retail operations data. You need to recommend solutions for the company. Which Power BI components should the company use? Components: reports workspaces dashboards reports Allow users to set and receive alerts when data changes beyond specified limits View and filter data and export data to MS excel for further manipulation or analysis

Dashboard Report

83 HOTSPOT -You are creating Power BI visualizations.You need to display the visuals where a user can perform each function. Components: Power BI service Power BI desktop Power BI dashboards Power BI reports Make decisions by analyzing high level KPIs Drill down into the details of a visual

Dashboard Report

5 DRAG DROP -You need to explain the major components of the Common Data Model (CDM) and their functions.Match each term to its definition. Tools: Entities Data connectors Dataverse Common data model Workflows Purpose: By using _____________, you can jump-start app development by leveraging business logic, security, and integration already built- in. An ________________ is a set of records used to store data

Dataverse Entities

23 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

E. Data gateway

84 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

E. Power BI Desktop

93 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

E. row-level security

16 DRAG DROP -A company has locations in multiple regions. The company develops solutions based on Power Apps and Power Automate.You need to recommend features to support the implementation.Which Power Platform features should you recommend? To answer, drag the appropriate features to the correct requirements Ensure fastest response times for each company location Create test and production copies of the data and apps

Environment for both

74 HOTSPOT -A user is starting to learn about Power Apps.Which objects should you use? Power apps app can call a: Actions and triggers are properties of a:

Flow Connector

39 DRAG DROP -A bank uses Power Platform apps and flows to support business processes. The company would like to use historical client data to predict whether a client's loan application is likely to be approved or rejected. You need to use AI Builder to implement the solution. Which four actions should you perform in sequence? Train Model Use the model in powerapps or power automate Export data into ai builder Publish the model Import data into common data service

Import data into common data service Train Model Publish the model Use the model in powerapps or power automate ITPU: IMPORT TRAIN PUBLISH USE

88 DRAG DROP -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? Chart: Donut KPIs Line Chart Matrix Show quarterly sales total to date in relation to goal View sales trend my month of sales YTD for all regions View YTD sales as % by region

KPI (keyword goal) Line chart (over time) Donut (or Pie - percentage) Box 1: KPI. A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Line chart -Line charts emphasize the overall shape of an entire series of values, usually over time. Box 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.

69 DRAG DROP - A company uses Microsoft Excel workbooks to store consolidated sales data. Workbooks are stored on OneDrive for Business. Match each Power BI feature to its requirement. Features: Q&A Export to excel Get data from files Mobile apps Enable user friendly reporting on phones Use natural language to query and aggregate data

Mobile apps Q&A (Q&A = Query and Aggregate)

8 HOTSPOT -You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365.For each of the following statements, select Yes if the statement is true. Otherwise, select No. Dynamics 365 and MS 365 must be in same tenant for SSO You must download product from AppSource to ensure that SSO works with Dynamics 365 and MS 365

N N

4 HOTSPOT -You create a user-owned custom entity by using Common Data Service. You change the entity ownership from user to organization owned Y/N You can create a business rule for a custom entity that can be used in a flow Y/N

N Y

94 HOTSPOT -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. Customer self-service portal supports azure ad authentication Customer self-service portal has multi language support Customer self-service portal supports web forms

N (keyword customer, employee does support AD auth) Y Y

96 HOTSPOT -A company plans to implement Power BI.Instructions: For each of the following statements, select Yes if the statement is true Power BI report builder is only tool used to create reports to be published to power bi service Power BI service can include calculated columns Power BI desktop can include calculated columns

N (many ways to create reports) N Y (this is advanced data modeling - therefore only desktop supports)

10 HOTSPOT -A company plans to implement Power Platform apps. The company does not plan to use any development tools or plug-ins.Which actions can you perform?For each of the following statements, select Yes if the statement is true. Otherwise, select No. You can sync account info from Dynamics 365 Sales with a 3rd party database You can create invoices from orders and then send the invoices to the customer using a power automate flow

No Yes

30 HOTSPOT -A company plans to create Power Platform apps that consume industry-standard and proprietary data sources.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Custom connector cannot be used if a standard connector for the service is available Customer connectors are supported in instant flows only Standard and custom connectors can't be mixed within same flow or app

No No No

79 HOTSPOT -You are building Power BI visualizations for a team.For each of the following statements, select Yes if the statement is true. Power BI can only retreive data from up to 2 different sources from each dashboard Power BI visualizations can be used in canvas apps and model driven apps Power BI can display charts and list boxes on dashboards

No Yes Yes

24 HOTSPOT -For each of the following statements, select Yes if the statement is true. Power Platform security roles are modified in MS Azure AD Security roles are assigned to each table

No (modified in power platform admin center) No (Security roles are assigned to users and to groups, not to tables.) Assuming question 1 is regarding "Power Platform" security roles, then No - You modify those in the Power Platform Admin Center. Login to the Power Platform Admin Center - click Environments on the left and select yours, then you'll see "Security Roles" on the right where you can add/modify/delete. I missed this question initially because taken at face-value, of course "security roles" are modified in Azure AD. But this is PL-900, so I guess they're only referring to Power Platform.

20 HOTSPOT -An organization plans to create Power Platform solutions and is evaluating Microsoft Dataverse. For each of the following statements, select Yes if the statement is true. Virtual table data is stored in MS Dataverse Columns are used in forms and views

No - A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an EXTERNAL data source Yes

21 HOTSPOT -Instructions: For each of the following statements, select Yes if the statement is true. Managed solutions can be used to groups multiple power platform components together during solution development Managed solutions must be used to distribute a power platform app on AppSource Managed solutions always protect power platform components from editing when components are exported to another environment

No - unmanaged used during keyword:development Yes Yes

22 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. Options: One per user One per tenant One per environment One per power platform app How many trial instances must team create? How many common data services databases must team create?

One per environment One per environment

13 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. Build automatic workflows that access multiple data sources Create custom apps that address specific business needs Design insightful data visulizations

Power Automate Power Apps Power BI

27 DRAG DROP -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. Applications: Power BI Power automate Power virtual agents Power portals View analytics on accounts Automatically send approval Create chatbot for webpages

Power BI Power automate Power virtual agents

68 DRAG DROP -You are a district manager for a large retail company. You want to provide sales managers with deeper sales insights to ensure that they can make more informed decisions for their stores.Store managers must be able to view data in near real-time.You need to create and share a Power BI dashboard that can be used by the store managers.Which tools can you use? Tools: Power BI service only Power BI desktop only Both Create power bi dashboards that contain a single store's sales info Share that dashboard with your retail managers

Power BI service only for both Sharing and dashboards are service only

35 HOTSPOT -A company needs to create several workflows and applications to help streamline their sales operations.You need to determine which applications are appropriate for given scenarios.Which applications should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Apps: Azure logic apps Power apps Power automate Create no-code workflows that use different systems Build no-code mobile apps Build a moble app by using MS dataverse

Power automate Power apps Power apps

51 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? Automatically import data from excel once a day Provide chatbot that can assist customers

Power automate Power virtual agent

53 HOTSPOT -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.NOTE: Each correct selection is worth one point. When condition is met, power apps can trigger a: Actions and triggers are properties of a:

Power automate flow Connector

62 DRAG DROP -A company plans to create an information portal that managers can use to view critical information about their teams.You need to recommend the type of Power BI components that the company should use.What should you recommend? Types: Report Dashboard Display data from excel workbook that has multiple worksheets in one chart Display the top departmental goal metrics and alert users when specific thresholds targets are met Display sales charts that can be filtered by region

Report (report has charts) Dashboard (keyword alert) Report (can't filter dashboard) The first one is tricky because, yes, dashboards are a single page view of data (that require an underlying report). So you *could* generate a dashboard from the report of the multiple worksheets chart. However, taking multiple excel worksheets and making a chart is the textbook definition of a report. So the best answer here would be a Report (in my humble and accurate opinion of course).

100 DRAG DROP -A company is using Power BI to build visualizations.The company's IT support team needs to know when to install Power BI Desktop on users' computers and where the Power BI Service is enough to perform tasks.You need to recommend solutions for the company.What should you recommend? Tools Power bi service only Power bi desktop only Both Create dashboards Create reports Create calculated columns Configure security configure Sharing

Service only Both Desktop only Both Service only

77 HOTSPOT - You are a regional sales manager for a large internet retailer. You create a series of Power BI reports and dashboards to help sales associates be more productive and increase sales. Sales are not increasing as expected. You need to determine if the new reports are being used and send emails to sales associates to provide guidance on how to use the reports and dashboards. Which features should you use? Features: -Publisher -Favorites -Export -Subscribe -Explore -Usage Metrics -Performance Inspector Send email to sales associate on predetermined schedule: Quantify the adoption usage from the sales associates:

Subscribe Usage metrics

70 DRAG DROP -A company plans to display support call metrics on a screen that is visible to all call center staff.You need to recommend solutions to meet the company's requirements.What should you recommend? Components: Tile Theme Template app Alert Treemap DirectQuery Page Workspace Display a chart with incoming calls versus wait time and pin the chart to a dashboard Send a specific user a notification when number of calls waiting is over 20 Display metrics from different datasets that have related data

Tile Alert Workspace (keyword different datasets) Page/Treemap are reports which can only handle one dataset

61 HOTSPOT -You create reports within Power BI to report on the status of a project. A manager asks you to share the reports with other team members. You decide to create a published app and set permissions to allow other team members to view the reports.For each of the following statements, select Yes if the statement is true The power bi published app is stored within the team site so others can install it One of the other PMs installs and modifies a dashboard within the published app. The changes are automatically made into the original

Y N

32 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. You can create a common data service environment in the power platform admin center You must enable data encryption after you create a common data service environment You can control security roles and privileges in a common data service environment from the power apps admin center

Y N Y

18 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. You can create canvas apps that scans and parses docs using azure cognitive services and then adds the appropriate info to dynamics 365 sales You can create canvas apps that use azure cognitive services to read incident records and identify tickets that need to be escalated based on sentiment score

Y Y

28 HOTSPOT -A company plans to use Power BI to visualize data from business systems.For each of the following statements, select Yes if the statement is true. Otherwise, select No. You can display data aggregates and raw data in a power bi report You can display related data from multiples sources in the same power bi report

Y Y

56 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. Prebuilt AI builder models are pretrained and are ready to interpret business data immediately Prebuit AI builder models exist for both power automate and power apps

Y Y

63 HOTSPOT -You have a Power BI report.For each of the following statements, select Yes if the statement is true. Otherwise, select No. You can export data from a visualization in a power bi report You can show the data behind a visual report on your screen w/o exporting data You can export data to view supporting data for a KPI

Y Y Y

43 HOTSPOT -A business is evaluating AI Builder.Which actions can you perform? You can use text classification model in AI builder to retrieve text and perform sentiment analysis for incidents You can tag instagrame posts that mention your new product You can send results about the number of mentions of your new product in IG to Power BI for dashboard

Y (text classification model is basically a category including all the AI builder prebuilt models) Y Y

50 HOTSPOT -You are planning to use the Business Card Reader and Sentiment Analysis prebuilt AI models to build solutions.For each of the following statements, select Yes if the statement is true. Business card reader model can be used with both power automate and power apps The sentiment analysis can be used with power automate only

YES NO

31 HOTSPOT -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. Model-driven apps require MS dataverse database A flow instance can only access one MS dataverse database Canvas apps require a MS dataverse database

Yes No No

38 HOTSPOT -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.NOTE: Each correct selection is worth one point. Power apps can use screen reader without the need for a connector You can use accessibility checker for power apps to check for violations and provide user interface tips

Yes Yes

40 DRAG DROP -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? Features: business rules business process flows common data model Validate data across multiple fields and entities regardless of the app used to create data Create visual guides to ensure that users enter data and perform tasks in a consistent manner Accelerate development by using a standard set of entities for the most common scenarios

business rules (Not CDM since it's just a model and doesn't validate anything) business process flows common data model

81 HOTSPOT -You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue.What should you do? Modify page duplicate page/update duplicate copy import page copy visuals from page to new page

duplicate

46 HOTSPOT - You want to create a Power Apps app that allows you to define a custom Sitemap. What should you do? To answer, select the appropriate options in the answer area. Navigate to power apps portal and create: canvas app power pages app model-driven app template app

model-driven app Site maps define the manner by which users move between tables in a model-driven app. This is called navigation. App navigation is a fundamental aspect of the user experience when performing tasks within the app.

41 DRAG DROP -A manufacturing company is evaluating AI Builder.You need to select AI Builder models to address specified requirements.Which model types should you use? Model: prediction form processing object detection Identify products w/o labels or serial numbers Identify customers who might not pay invoice on time

object detection prediction

42 DRAG DROP -You manage the support team at a rapidly growing company.Support technicians need a better experience when logging and responding to support requests.You need to recommend tools to help the company's needs.Which tools should you recommend? Tools: power apps power automate power bi dataverse Support techs submit request using app Customer data stored/sync'd with Dynamics 365 Finance Techs must be notified when new request entered

power apps dataverse power automate

44 DRAG DROP -Match each tool to its task. To answer, drag the appropriate tool from the column on the left to its task on the right. Each tool may be used once, more than once, or not at all. Tools: Power bi power automate power apps Automate workflows Trigger an action from an event Create a custom mobile data entry screen

power automate power automate power apps

89 DRAG DROP -You create a Power BI dashboard.Match each option to its function. Products: share embed get data pin Ensure coworkers can see dashboard Display data from MS excel in dashboard Add report tile to dashboard

share get data pin

57 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? Components: standard dataverse table custom dataverse table column relationship Owner object Pet object Owner email address Reference pet record as belonging to owner

standard dataverse table custom dataverse table column relationship