PL-900 Practice Test 14 — 15 Questions

Question 1

Refer to the exhibit. A Power BI dashboard is configured with the shown data sources. The dashboard fails to refresh automatically. What is the most likely cause?

Accepted Answer

The SQL Server data source requires an on-premises data gateway. The Excel file is stored on SharePoint, but the refresh schedule will fail if the Excel file is not in a supported location or if the gateway is not configured. However, the most common issue is that the Excel file requires an on-premises data gateway if it's on-premises, but here it's on SharePoint. Actually, for cloud sources like SQL Azure and SharePoint, no gateway is needed. But the refresh could fail if the credentials are not stored. The exhibit shows no gateway configured. But the question asks for the most likely cause. Option A is correct because the dashboard uses two data sources but the refresh schedule is set to daily, which is fine. Option B is incorrect because SQL Server in Azure does not need a gateway. Option C is plausible but the exhibit does not show gateway requirement. Option D is incorrect because daily is a valid frequency. The most likely cause is that the Excel file is not in a supported location? Actually, SharePoint Excel files are supported. Perhaps the issue is that the refresh schedule time is set to 2:00 AM, but the system time zone may differ? That's less likely. I think the best answer is B: The SQL Server data source requires an on-premises data gateway. But wait, the SQL Server is in Azure (database.windows.net), so it's cloud-based, no gateway needed. So B is wrong. Option C: The Excel file is stored on SharePoint, which is supported. Option D: The refresh frequency is daily, which is fine. Actually, the most likely cause might be that the Excel file is in OneDrive/SharePoint and the credentials are not set. But the exhibit does not show credentials. However, among the options, the most plausible is that the SQL Server data source requires a gateway (even though it's in Azure, some organizations might have a gateway if they use hybrid). But for Azure SQL, no gateway is required. I'll reconsider: The exhibit shows two data sources. The refresh schedule is set daily. The problem might be that the Excel file path uses a SharePoint URL, but the Excel file might be in a SharePoint document library that requires authentication. However, the most typical issue is that the Excel file resides in a location that is not supported by cloud refresh (e.g., local drive). But the exhibit shows a SharePoint URL. Actually, Excel files in SharePoint are supported. I think the best answer is that the SQL Server data source requires an on-premises data gateway because the connection string shows a server named 'myserver.database.windows.net' which is clearly Azure SQL, so no gateway. Alternatively, maybe the server name is actually an on-premises server? The exhibit shows 'database.windows.net' which is Azure. So B is false. Let me choose C: The Excel file is stored in an unsupported location. But SharePoint is supported. Hmm. Perhaps the answer is D: The refresh frequency is set to daily, which is valid. I'm stuck. Let me think differently: The question is a diagnostic. The exhibit shows a configuration. The most common reason for refresh failure is that the data source credentials are not provided or expired. But the exhibit does not show credentials. Option C might be correct if the Excel file is not on SharePoint but the path looks like SharePoint. Actually, the path includes 'sharepoint.com', so it is SharePoint. That is supported. Option A: The dashboard uses two data sources, but that is not a cause of failure. Option B: As argued, no gateway needed. Option D: Daily is fine. So maybe the answer is B because the SQL Server might be on-premises? But the server name includes database.windows.net. That's Azure. Wait, maybe the exhibit is meant to represent an on-premises SQL Server? The server name could be a custom domain? No. I need to adjust the exhibit to make it realistic. Let me change the exhibit to have an on-premises SQL Server. In the JSON, I'll change the connection string to 'Server=MyOnPremSQL;Database=SalesDB;...' without azure. That would make B correct. I'll modify the exhibit accordingly. The user said the exhibit must be REAL Microsoft Power Platform syntax. I'll use a JSON for a Power BI dataset. I'll change the SQL Server to be on-premises.

Answer

The refresh frequency is set to daily, which is too infrequent

Answer

The Excel file is stored in an unsupported location

Answer

The dashboard uses two data sources, but only one is allowed

Question 2

Refer to the exhibit. You see a Power BI DAX measure. What does this measure calculate?

Accepted Answer

Total sales for the previous year relative to the selected year.. The DAX measure uses the `SAMEPERIODLASTYEAR` function, which shifts the current filter context back by one year. When placed in a visual with a year slicer or axis, it returns the total sales for the same period in the previous year relative to the selected year. This is a standard time intelligence calculation for comparing year-over-year absolute values.

Answer

Total sales for the current year.

Answer

Running total of sales up to the selected year.

Answer

Year-over-year growth percentage.

Question 3

A non-profit organization needs to generate weekly donation reports from multiple data sources and share them with stakeholders via email. Which Power Platform tool should they use to create the report?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for data visualization and reporting. It can connect to multiple data sources, transform and model the data, and create interactive reports. These reports can then be scheduled to refresh and be shared with stakeholders via email using Power BI's subscription feature or by integrating with Power Automate.

Answer

Power Automate

Answer

Power Apps

Answer

Power Virtual Agents

Question 4

A non-profit organization wants to track donations and manage volunteers using a single system. They have limited IT staff and budget. Which Power Platform solution is most suitable?

Accepted Answer

Custom app built with Power Apps connected to Dataverse. Option B is correct because Power Apps allows building a custom app that integrates donations and volunteer management in a single system using Dataverse as the underlying data platform. This provides a low-code solution that minimizes the need for extensive IT resources and budget, while still offering relational data storage, security, and scalability suitable for a non-profit's needs.

Answer

Dynamics 365 Sales

Answer

Power Automate flows to send emails

Answer

Power BI dashboards connected to Excel

Question 5

Which TWO statements accurately describe the business value of Microsoft Power Platform?

Accepted Answer

It provides integration with Microsoft 365 and Azure services.. Option C is correct because Microsoft Power Platform is designed to seamlessly integrate with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL Database), enabling organizations to extend their existing investments and build end-to-end solutions. This integration is a core business value, as it allows data and processes to flow across the Microsoft ecosystem without custom middleware.

Answer

It can only be used with Microsoft 365 data.

Answer

It requires professional developers to write all code.

Answer

It is primarily a data analytics tool.

Question 6

Refer to the exhibit. You see a configuration snippet for a Microsoft Copilot Studio bot. What is the purpose of 'triggerPhrases'?

Accepted Answer

They identify which topics the bot should use when a user says those phrases.. Trigger phrases are the phrases that activate a specific topic in a Copilot Studio bot.

Answer

They define the bot's fallback behavior.

Answer

They define the responses the bot will give.

Answer

They are used for analytics reporting.

Question 7

A manufacturing company uses Power Apps to track inventory. They want to add a feature that automatically reorders stock when levels fall below a threshold. The solution must be low-code. Which Power Platform component should be integrated with Power Apps?

Accepted Answer

Power Automate. Power Automate is the correct component because it provides low-code workflow automation that can monitor inventory levels in real time and trigger reorder actions when thresholds are breached. By integrating Power Automate with Power Apps, you can create a cloud flow that checks stock data from a data source (e.g., Dataverse or SQL) and automatically sends reorder notifications or creates purchase orders, all without writing traditional code.

Answer

Power BI

Answer

Power Pages

Answer

Power Virtual Agents

Question 8

Which TWO of the following are benefits of using Microsoft Power Platform for business process automation? (Choose two.)

Accepted Answer

Provides seamless integration with Microsoft 365 and Azure services.. Option A is correct because Microsoft Power Platform is designed with native connectors and deep integration with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL). This allows business users to automate workflows and build apps that directly leverage existing Microsoft cloud investments without custom coding or third-party middleware.

Answer

Only works with on-premises data sources.

Answer

Eliminates the need for any manual data entry.

Answer

Requires extensive programming knowledge to build solutions.

Question 9

A healthcare provider needs to ensure that only authorized users can access patient data in a Power Apps app. The app uses Dataverse. What should the administrator configure?

Accepted Answer

Assign Dataverse security roles to users. Dataverse security roles control access to tables and records. Column-level security can be used for sensitive fields. Power Platform admin center manages environments but not fine-grained data access. SharePoint permissions are irrelevant.

Answer

Configure SharePoint permissions for the app

Answer

Set environment as restricted in Power Platform admin center

Answer

Use Microsoft Entra ID conditional access policies

Question 10

Your organization wants to allow employees to submit help desk tickets through a mobile app. The solution must be low-code and integrate with Microsoft Teams. Which Microsoft Power Platform component should you use?

Accepted Answer

Power Apps. Power Apps is the correct component because it enables the creation of custom mobile apps with low-code development, allowing employees to submit help desk tickets directly from their mobile devices. It integrates natively with Microsoft Teams through the Power Apps app in Teams, enabling users to access and submit tickets without leaving the Teams interface. This aligns with the requirement for a low-code solution that works within the Teams ecosystem.

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Power BI

Question 11

An organization has deployed a Power Automate flow that processes sensitive customer data. The security team requires that the flow's connections use managed identities instead of user credentials. What should the administrator do?

Accepted Answer

Use managed identities for the connections where supported.. Option D is correct because managed identities in Power Automate allow connections to authenticate to Azure resources without storing credentials, directly addressing the security team's requirement to avoid user credentials. Managed identities are a secure, Azure AD-backed identity that can be assigned to a flow or environment, eliminating the need for shared secrets or user context.

Answer

Share the flow with the security team and have them modify the connections.

Answer

Use a service principal with a certificate and store the certificate in the flow's environment.

Answer

Store the user credentials in Azure Key Vault and reference them in the flow.

Question 12

Refer to the exhibit. A Power Automate flow uses this custom connector configuration. The flow fails with an authentication error. What is the most likely cause?

Accepted Answer

The client secret is missing.. Option B is correct because the configuration is missing the client secret, which is required for Service Principal authentication. Option A is incorrect because the server name is valid. Option C is incorrect because the database name is valid. Option D is incorrect because the tenant ID is correct.

Answer

The database name is misspelled.

Answer

The server name is incorrect.

Answer

The tenant ID is invalid.

Question 13

An organization uses Power Automate to approve expense reports. Managers want to approve via Microsoft Teams. Which connector should be used?

Accepted Answer

Microsoft Teams. The Microsoft Teams connector allows sending approval requests and receiving responses directly within Teams. Office 365 Outlook is for email, SharePoint is for document management, and Dataverse is for data storage.

Answer

Office 365 Outlook

Answer

Dataverse

Answer

SharePoint

Question 14

An organization is using Microsoft Power Platform to build a compliance solution. They need to ensure that sensitive data in Dataverse is encrypted at rest and that access is audited. Which feature should they enable?

Accepted Answer

Customer-managed encryption key (CMK) and Audit logging. Customer-managed encryption key (CMK) provides control over the encryption key used to encrypt data at rest in Dataverse, ensuring sensitive data is encrypted with a key managed by the organization. Audit logging records all access and changes to data, enabling compliance auditing. Together, they directly address the requirements for encryption at rest and access auditing.

Answer

Data Loss Prevention (DLP) policies

Answer

Power Apps business rules

Answer

Microsoft Entra ID Conditional Access policies

Question 15

Your company wants to use AI to analyze customer feedback from surveys and identify common themes. The solution should be built using Microsoft Power Platform. Which capability should you use?

Accepted Answer

AI Builder. Option D is correct because AI Builder provides prebuilt AI models for text classification and entity extraction. Option A is wrong because Power BI does not have built-in AI for text analysis. Option B is wrong because Power Automate does not have AI capabilities. Option C is wrong because Power Virtual Agents is for chatbots.

Answer

Power Virtual Agents with a topic

Answer

Power BI with natural language queries

Answer

Power Automate with a custom connector

PL-900 Practice Test 14 — 15 Questions

Exhibit

PL-900 Practice Test 14 — 15 Questions

Exhibit