PL-900 Practice Test 41 — 15 Questions

Question 1

You are developing a canvas app that uses a SQL Server database as a data source. The app needs to display a list of orders and allow users to filter by date range. The SQL table has millions of rows. To ensure optimal performance, which approach should you use? A) Use the 'Filter' function in Power Apps to filter the data on the client side. B) Use a SQL view that filters data server-side and call it via the SQL connector. C) Use Power Automate to retrieve data and pass it to the app. D) Use the 'Search' function on the gallery.

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

Accepted Answer

Use a SQL view that filters data server-side and call it via the SQL connector.. Using a SQL view that filters data server-side minimizes data transfer over the network, improving performance with large datasets. Option A: Using Power Automate adds unnecessary latency and complexity. Option B: The Filter function in Power Apps retrieves all rows from the SQL table and then filters client-side, which is inefficient for millions of rows. Option D: The Search function also operates on client-side data, leading to performance degradation.

Answer

Use Power Automate to retrieve data and pass it to the app.

Answer

Use the 'Filter' function in Power Apps to filter the data on the client side.

Answer

Use the 'Search' function on the gallery.

Question 2

You need to create a flow that runs on the first day of every month and sends a summary email of all new SharePoint list items added in the previous month. The email should be sent to the sales team. Which type of flow should you create?

Accepted Answer

Scheduled cloud flow. A scheduled cloud flow can run on a recurring schedule (e.g., first day of month) and includes actions to query SharePoint and send email. Automated flows trigger on events, not schedules. Desktop flows are for desktop automation. Business process flows guide users through stages.

Answer

Business process flow

Answer

Desktop flow

Answer

Automated cloud flow

Question 3

Contoso Ltd. is a global consulting firm that wants to build a Power Pages site for their external clients. The site must allow clients to: 1) View their project status and deliverables. 2) Submit timesheets and expense reports. 3) Communicate with their project manager via a built-in messaging feature. The company has a Dataverse environment with existing tables for Projects, Tasks, Timesheets, Expenses, and Users. They have a Microsoft Entra ID tenant for employee authentication but want clients to use their own social accounts (e.g., Google, Facebook) or email-based local authentication. Contoso has a strict security policy: all data must be encrypted at rest and in transit. The site must support multiple languages (English, Spanish, French). The marketing team needs to be able to update the site's content (text and images) without developer assistance. The development team wants to use a pre-built template to accelerate the initial setup. Which approach should Contoso take?

Accepted Answer

Create a Power Pages site using the 'Customer self-service' template. Configure multiple identity providers (Google, Facebook, local) in the Power Pages admin center. Use the design studio to manage content. Enable multilingual support in site settings.. The Power Pages 'Customer self-service' template includes pre-built pages for managing projects, timesheets, expenses, and messaging, which can be customized to fit Contoso's needs. The Power Pages admin center allows configuring multiple identity providers (Google, Facebook, local) for client authentication. The design studio enables marketing team to update content without developer assistance. Multilingual support is built-in and can be enabled in site settings. Dataverse provides encryption at rest and in transit. Option A is incorrect because SharePoint Online lacks the complex data relationships and custom authentication options required. Option C is incorrect because building a custom site from scratch would be time-consuming and does not leverage the pre-built template. Option D is incorrect because Power Apps portals (legacy) are being replaced by Power Pages and do not offer the same modern capabilities and templates.

Answer

Create a SharePoint Online site and use Power Automate to connect to Dataverse for data. Use SharePoint's built-in authentication for external users.

Answer

Build a custom Power Pages site from scratch using Visual Studio Code and deploy it via Azure DevOps. Use custom authentication providers for social logins.

Answer

Create a Power Apps portal (legacy) using the 'Customer portal' template and configure social identity providers in the portal settings. Use the portal's content editor for marketing updates.

Question 4

A sales team wants to track customer interactions and automate follow-up emails without custom development. What Microsoft Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it enables the sales team to create automated workflows that trigger follow-up emails based on customer interactions, such as when a new contact is added or a meeting ends. It integrates with common data sources like Dynamics 365, SharePoint, or Outlook, and uses prebuilt connectors to send emails without any custom code.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 5

A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they support offline capability by leveraging the Power Apps offline sync feature, which allows data to be cached locally on the device and synchronized with the data source (e.g., Dataverse or SharePoint) when connectivity is restored. This makes them ideal for mobile scenarios like store managers approving discount requests in areas with intermittent connectivity.

Answer

Portal

Answer

Model-driven app

Answer

Power Automate

Question 6

A Power Platform administrator needs to ensure that only users from specific Microsoft Entra ID security groups can access a production environment. The solution must automatically update membership when the Entra ID group is modified. Which approach should the administrator use?

Accepted Answer

In Power Platform Admin Center, add the Entra ID group as a security group for the environment. The Power Platform Admin Center allows an administrator to link a Microsoft Entra ID security group directly to a production environment. When the group is added as a security group for the environment, membership is automatically synchronized with the Entra ID group, so any changes to the group (additions or removals) are reflected in the environment without manual intervention.

Answer

Use PowerShell cmdlets to assign the Entra ID group as an environment user

Answer

Add users individually to the environment's role assignments

Answer

Share the environment with the Entra ID group using the 'Share' button

Question 7

A Power Platform administrator needs to monitor usage and performance of environments. Which TWO actions should the administrator take? (Choose two.)

Accepted Answer

Enable audit logging in Microsoft Purview compliance portal. Enabling audit logging in the Microsoft Purview compliance portal captures user and admin activities across Power Platform environments, which is essential for monitoring usage and performance. Audit logs provide a detailed record of events such as environment creation, solution imports, and data access, enabling administrators to track changes and diagnose performance issues. This aligns with the requirement to monitor usage and performance, as audit data can be analyzed to identify patterns and anomalies.

Answer

Enable capacity alerts for storage

Answer

Set up Microsoft Defender XDR for Power Platform

Answer

Configure DLP policies to block high-risk connectors

Question 8

Fabrikam, Inc. uses Power Apps to create a canvas app for expense reporting. The app is connected to a SharePoint list named Expenses. The app allows users to submit expenses, attach receipts, and view their history. The manager wants to add a feature where users can scan a receipt using the mobile app camera and automatically extract the amount and date using AI Builder. The extracted data should be populated into the form fields. The development team needs to implement this feature. Which steps should they take?

Accepted Answer

Use AI Builder's receipt processing model in Power Apps. AI Builder provides a prebuilt receipt processing model that can be directly integrated into a Power Apps canvas app. This model allows users to scan a receipt using the camera, automatically extract the amount and date, and populate those values into form fields. Option B is incorrect because while a Power Automate flow could also process the image, it is an unnecessary extra step when AI Builder can be used directly within Power Apps. Option C is incorrect because the Camera control alone cannot extract text from an image; it requires additional processing like AI Builder. Option D is incorrect because Microsoft Copilot Studio is designed for building chatbots, not for receipt scanning and data extraction.

Answer

Create a Power Automate flow that processes the image and returns the data

Answer

Use the Camera control to capture the image and use a custom formula to extract text

Answer

Integrate Microsoft Copilot Studio to handle the receipt scanning

Question 9

Which THREE are common uses of connectors in Power Automate? (Choose three.)

Accepted Answer

Create a record in Dataverse. Connectors in Power Automate provide pre-built actions and triggers to interact with external services. The Dataverse connector includes a 'Create a new record' action, enabling automated creation of rows in Dataverse tables without custom code, directly from a flow.

Answer

Build a custom user interface

Answer

Create a real-time dashboard

Question 10

Which THREE are benefits of using Dataverse as the data platform for Power Platform solutions?

Accepted Answer

Built-in role-based security and auditing. Dataverse provides built-in role-based security that allows administrators to control access at the row, field, and table levels using security roles, and it includes automatic auditing to track data changes. This is a core benefit for enterprise compliance and data governance within Power Platform solutions.

Answer

Full relational database capabilities with T-SQL support

Answer

Free unlimited storage for all data types

Question 11

Which TWO settings can you configure in a Power Platform environment to control data loss prevention?

Accepted Answer

Default action for connectors. The 'Default action for connectors' setting in a Power Platform environment allows administrators to define the default behavior (e.g., Block, Allow, or Audit) for connectors that are not explicitly covered by a DLP policy. This setting directly controls data loss prevention by preventing data from being shared with unmanaged or risky connectors. Option E is correct because environment-specific DLP policies enable granular control over which connectors can be used together, preventing data from flowing between business and non-business connectors within that environment.

Answer

Connector sharing settings

Answer

Environment security roles

Answer

Audit logging configuration

Question 12

Which THREE of the following are features available in Power BI Premium per capacity? (Select three.)

Accepted Answer

XMLA endpoints for read-write access to datasets. Power BI Premium per capacity exposes XMLA endpoints that support both read and write operations on datasets. This allows tools like SQL Server Management Studio (SSMS) and third-party applications to manage, update, and refresh datasets programmatically using the XML for Analysis (XMLA) protocol, which is essential for enterprise-level dataset management and integration with custom solutions.

Answer

Built-in AI visuals like Q&A and Key Influencers

Answer

Free users can create and share reports

Question 13

A company has configured the copilot as shown in the exhibit. Users report that the copilot is not answering questions about HR policies that were updated in the SharePoint site today. What is the most likely cause?

Accepted Answer

The knowledge source refresh interval is set to weekly. The copilot's knowledge source refresh interval is set to weekly, meaning it only re-indexes the SharePoint site every seven days. Since the HR policies were updated today, the copilot is still using the stale, pre-update content and cannot answer questions about the new policies until the next scheduled refresh occurs.

Answer

The public website refresh is set to daily

Answer

Authentication is not properly configured

Answer

Generative AI is disabled

Question 14

A Power Automate flow uses an approval action. The approver can choose 'Approve', 'Reject', or 'Reassign'. The flow needs to send a different email based on the approver's choice. Which action should be used after the approval?

Accepted Answer

Condition. The Condition action in Power Automate evaluates the output of the approval action (e.g., the 'outcome' field) and routes the flow down different branches based on whether the approver selected 'Approve', 'Reject', or 'Reassign'. This is the correct choice because it directly maps the three possible approval outcomes to distinct email actions using conditional logic.

Answer

Apply to each

Answer

Parallel branch

Answer

Do until

Question 15

A company has a Power BI dataset that refreshes daily. Users report that the report shows stale data from two days ago. What is the most likely cause?

Accepted Answer

The scheduled refresh has failed for the past two days. The most likely cause is that the scheduled refresh has failed for the past two days. Power BI datasets that rely on scheduled refresh must complete successfully to update the data; if the refresh fails, the dataset retains the last successful refresh’s data, which in this case is from two days ago. Users seeing stale data from two days ago directly indicates that the refresh has not succeeded since then.

Answer

The dataset uses DirectQuery mode

Answer

Incremental refresh is configured incorrectly

Answer

The on-premises data gateway is offline