PL-900 Practice Test 3 — 10 Questions

Question 1

Your organization uses Power Automate to integrate with Microsoft 365 services. You need to create a flow that automatically creates a contact in Outlook when a new lead is added to Dynamics 365. The flow should run immediately when the lead is created. Which connector should you use as the trigger?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Dynamics 365 connector. The Dynamics 365 connector provides a 'When a record is created' trigger. SharePoint, Outlook, and Teams connectors do not trigger on Dynamics 365 leads.

Answer

SharePoint connector

Answer

Outlook connector

Answer

Microsoft Teams connector

Question 2

A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?

Accepted Answer

Publish the report from Power BI Desktop and schedule a daily data refresh in Power BI service. It separates the report creation (in Power BI Desktop) from the data refresh schedule (in the Power BI service). By publishing the report once and configuring a daily scheduled refresh, the dashboard automatically reflects the latest data from the Excel file without manual intervention, which is the most efficient approach for weekly updates.

Answer

Use Power BI Desktop to connect to the Excel file and publish a new report weekly

Answer

Use Power Query to merge data from the Excel file and create a composite model

Answer

Upload the Excel file to the Power BI service each week

Question 3

Which THREE capabilities does Microsoft Power Platform include to help organizations achieve digital transformation?

Accepted Answer

Low-code application development. Power Platform delivers low-code application development through Power Apps (option B), which lets makers build canvas and model-driven apps with connectors and formulas instead of full custom code, directly supporting digital transformation. Workflow automation is provided by Power Automate (option D), enabling automated flows, approvals, and integration across hundreds of connectors to digitize business processes. Data analytics and visualization come from Power BI (option E), which turns data into interactive dashboards and reports for data-driven decisions. Option A is incorrect because Power Platform consumes prebuilt AI models via AI Builder rather than training custom models from scratch, and option C is incorrect because Power Platform augments rather than replaces custom coding, still allowing pro-code extensibility.

Answer

Custom AI model training from scratch

Answer

Replacement of all custom coding

Question 4

A non-profit organization wants to create a simple app for volunteers to log their hours and submit expenses. The app should be easy to build and require minimal coding. Which Power Platform tool should they use?

Accepted Answer

Power Apps canvas app. Power Apps canvas app is the correct choice because it allows non-developers to quickly build a custom, low-code app for data entry tasks like logging volunteer hours and submitting expenses. Canvas apps start from a blank canvas or a template, enabling drag-and-drop design with minimal coding, and can connect directly to data sources like SharePoint or Dataverse for storing records.

Answer

Power Pages

Answer

Power BI

Answer

Power Automate

Question 5

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

Accepted Answer

The users lack write permissions on the SharePoint list.. The 'Access denied' error when submitting new items in a canvas app connected to a SharePoint list indicates that the user lacks write permissions on the underlying data source. Even though the app is shared with the user, the SharePoint list itself enforces its own permission model. Without Contribute or Edit permissions on the list, the user cannot create new items, resulting in the generic access denied error.

Answer

The connection reference is not shared with the users.

Answer

The SharePoint list has exceeded its item limit.

Answer

The app is shared with 'Can edit' permission but not 'Can view'.

Question 6

A company wants to integrate Power Automate with Microsoft Teams so that when a new task is assigned in Planner, a message is posted in a Teams channel. Which connector should be used?

Accepted Answer

Microsoft Teams. Microsoft Teams. The Microsoft Teams connector allows posting messages to Teams channels, which is exactly what the scenario requires. Option A (Outlook.com) is for personal email, not Teams. Option B (SharePoint) is for document management, not Teams messaging. Option C (Office 365 Outlook) is for email and calendar, not for posting to Teams channels.

Answer

Outlook.com

Answer

SharePoint

Answer

Office 365 Outlook

Question 7

A multinational corporation uses Power Platform extensively. They have multiple environments: DEV, TEST, UAT, STAGING, and PROD. A developer accidentally published a Power App that connects to a SQL Server database using an unapproved connector in the PROD environment. The organization has strict data governance policies that require all connections to use approved connectors only. The admin needs to block this connector in PROD while still allowing it in other environments. What should the admin do?

Accepted Answer

Create an environment-level DLP policy for PROD that blocks the connector.. Environment-level DLP policies in Power Platform apply only to a specific environment, so creating one for PROD that blocks the unapproved connector restricts it there while leaving DEV, TEST, UAT, and STAGING unaffected. This precisely meets the requirement to block the connector only in PROD. Tenant-level policies would affect all environments, which is too broad.

Answer

Create a tenant-level DLP policy that blocks the connector for all environments.

Answer

Remove the developer's permissions to the PROD environment.

Answer

Delete the Power App from PROD.

Question 8

A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?

Accepted Answer

Create a canvas app from the Excel file. A canvas app can be created directly from an Excel file stored in OneDrive using the Power Apps 'Start from data' option. This generates a three-screen app (browse, detail, edit) that connects to the Excel table via the OneDrive for Business connector, making it ideal for simple personal expense tracking without requiring Dataverse or custom development.

Answer

Use Power Pages to display the Excel file

Answer

Create a model-driven app using Dataverse

Answer

Use Power Automate to create a mobile app

Question 9

A sales manager wants to create a Power BI report that shows monthly sales trends and allows drilling down from year to quarter to month. Which feature should they use?

Accepted Answer

Hierarchy. A hierarchy in Power BI allows users to create a parent-child relationship between fields (e.g., Year → Quarter → Month) that enables automatic drill-down and drill-up actions in visuals. This directly supports the sales manager's requirement to view monthly trends and drill from year to quarter to month without manual configuration.

Answer

Drill-through

Answer

Bookmarks

Answer

Slicers

Question 10

Match each Power Automate trigger type to its description.

Accepted Answer

Manual: A flow that runs when a user clicks a button or selects an action.. Correct matches: Manual triggers are user-initiated, scheduled triggers run on a time schedule, and automated triggers react to events. Common confusions arise between event-driven (automated) and time-based (scheduled) triggers, as well as between manual and other types.

Answer

Manual: A flow that runs on a recurring schedule.

Answer

Scheduled: A flow that starts automatically when a new file is created.