CCNA Describe the business value of Microsoft Power Platform Questions — Page 3 of 3

151

MCQmedium

Your company has a Power BI dashboard that displays sales data from a SQL Server database hosted on-premises. The dashboard is used by the sales team to monitor daily performance. Recently, the dashboard has been showing stale data. The data is supposed to refresh every night at 2:00 AM. You have confirmed that the SQL Server database is updated with new data each night. However, the Power BI dataset refresh fails. You need to ensure that the dashboard shows up-to-date data every morning. What should you do?

A.Disable scheduled refresh and manually refresh the dataset every morning.

B.Install and configure an on-premises data gateway and assign it to the dataset.

C.Change the data source to an Excel file stored in SharePoint Online.

D.Republish the Power BI report from Power BI Desktop.

AnswerB

On-premises data gateway enables connectivity for scheduled refresh.

Why this answer

The correct answer is B because an on-premises data gateway is required to bridge the connection between Power BI (a cloud service) and an on-premises SQL Server database. Since the dataset refresh fails despite the database being updated, the gateway is either missing or misconfigured. Installing and configuring the gateway allows the scheduled refresh to access the on-premises data source securely, ensuring the dashboard displays up-to-date data each morning.

Exam trap

The trap here is that candidates may think republishing the report (Option D) will fix the refresh issue, but they overlook that the scheduled refresh relies on a persistent gateway connection, not the report file itself.

How to eliminate wrong answers

Option A is wrong because disabling scheduled refresh and manually refreshing the dataset is not a sustainable solution for daily updates and does not address the root cause of the refresh failure. Option C is wrong because changing the data source to an Excel file in SharePoint Online avoids the on-premises connectivity issue but is a workaround that may not meet the company's data requirements and could introduce new data freshness or security concerns. Option D is wrong because republishing the Power BI report from Power BI Desktop does not fix the underlying connectivity problem; it only re-uploads the report without resolving the gateway or refresh failure.

Practice this question →

152

MCQhard

Refer to the exhibit. You are analyzing a Power Automate flow definition. The flow is intended to create a new user record in Dataverse and send an email notification when manually triggered or daily at 8 AM. However, when the flow runs on its schedule, it fails because the trigger output 'name' is empty. What is the most likely cause?

A.The action 'CreateRecord' has an invalid entity name 'Users'.

B.The schedule trigger does not provide a 'name' field in its outputs, causing the expression to fail.

C.The flow is configured to run only on manual trigger, ignoring the schedule.

D.The flow does not have permission to create records in Dataverse.

AnswerB

The schedule trigger does not generate a 'name' output, so the expression is empty.

Why this answer

Option B is correct because a scheduled trigger in Power Automate does not include a 'name' field in its outputs, whereas a manual trigger (e.g., Power Apps or button) typically does. When the flow runs on its daily 8 AM schedule, the expression referencing trigger outputs 'name' evaluates to empty, causing the subsequent actions to fail. This is a common mismatch between trigger types and expected output schemas.

Exam trap

Cisco often tests the misconception that all triggers provide identical output schemas, leading candidates to overlook that scheduled triggers lack user-provided fields like 'name'.

How to eliminate wrong answers

Option A is wrong because 'Users' is a valid system entity name in Dataverse (the table is named 'User'), and the action would not fail due to an invalid entity name unless the table was custom and misspelled. Option C is wrong because the flow definition explicitly includes both a manual trigger and a scheduled trigger (daily at 8 AM), so the schedule is not ignored; the issue is the missing 'name' field from the schedule trigger. Option D is wrong because the flow failing due to an empty 'name' field occurs before any Dataverse permission check; permission errors would produce a different error (e.g., 'Access denied' or 'Principal does not have privilege').

Practice this question →

153

MCQhard

You are a Power Platform administrator. A user reports that a Power Automate flow that connects to SharePoint Online fails intermittently with a '403 Forbidden' error. The flow uses a service principal with application permissions. What is the most likely cause?

A.The flow is exceeding the SharePoint Online API throttling limits.

B.The service principal has been disabled in Microsoft Entra ID.

C.SharePoint Online is experiencing a service outage.

D.The service principal lacks the necessary SharePoint API permissions or admin consent.

AnswerD

Missing permissions cause 403; intermittency could be due to token expiration or conditional access.

Why this answer

A 403 Forbidden error specifically indicates that the server understood the request but refuses to authorize it. Since the flow uses a service principal with application permissions, the most likely cause is that the service principal lacks the necessary SharePoint API permissions or that admin consent has not been granted for those permissions. Without proper permissions or consent, SharePoint Online rejects the request regardless of authentication validity.

Exam trap

The trap here is that candidates confuse 403 Forbidden (authorization failure) with 401 Unauthorized (authentication failure) or throttling errors, leading them to incorrectly select throttling or service outage options.

How to eliminate wrong answers

Option A is wrong because a 403 Forbidden error is an authorization failure, not a throttling limit; exceeding API throttling limits would return a 429 Too Many Requests error, not 403. Option B is wrong because if the service principal were disabled in Microsoft Entra ID, the authentication would fail with a 401 Unauthorized error, not a 403 Forbidden. Option C is wrong because a SharePoint Online service outage would typically result in 503 Service Unavailable or 500 Internal Server Error responses, not a 403 Forbidden.

Practice this question →

154

Multi-Selecthard

Which TWO of the following scenarios are best suited for Power Automate's cloud flows?

Select 2 answers

A.Automating approval processes in SharePoint.

B.Sending a welcome email when a new user is added to Microsoft Entra ID.

C.Moving files from an on-premises server to a cloud storage.

D.Automating data entry from a legacy desktop application.

AnswersA, B

Cloud flows can trigger approvals from SharePoint.

Why this answer

Option A is correct because Power Automate cloud flows can integrate with SharePoint to automate approval processes using built-in approval actions and triggers like 'When an item is created or modified'. Option B is correct because cloud flows can use the 'When a user is added to a group' trigger for Microsoft Entra ID (formerly Azure AD) to send a welcome email via connectors like Outlook or SendGrid, enabling real-time automation without on-premises infrastructure.

Exam trap

The trap here is that candidates often confuse cloud flows with desktop flows (RPA), assuming cloud flows can handle on-premises file moves or legacy app automation, but the PL-900 exam tests the distinction that cloud flows are API-driven and require connectors, while desktop flows handle UI-based and on-premises tasks.

Practice this question →

155

MCQeasy

Your company wants to analyze sales data from multiple sources and create interactive dashboards. The solution must be cloud-based and require minimal IT support. Which Power Platform component should you use?

A.Power BI

B.Power Apps

C.Power Automate

D.Power Virtual Agents

AnswerA

Power BI is a cloud-based analytics service for creating dashboards.

Why this answer

Power BI is the correct choice because it is a cloud-based business analytics service that enables you to connect to multiple data sources, transform and model the data, and create interactive dashboards and reports. It requires minimal IT support through its self-service capabilities, allowing business analysts to build visualizations without deep technical expertise.

Exam trap

The trap here is that candidates may confuse Power BI with Power Apps because both involve data, but Power Apps is for building apps, not for interactive data analysis and dashboards.

How to eliminate wrong answers

Option B (Power Apps) is wrong because it is a low-code platform for building custom applications, not for analyzing sales data or creating interactive dashboards. Option C (Power Automate) is wrong because it focuses on workflow automation and process orchestration, not on data visualization and analytics. Option D (Power Virtual Agents) is wrong because it is designed for creating conversational AI chatbots, not for data analysis or dashboard creation.

Practice this question →

156

MCQmedium

A company's IT department is overwhelmed with password reset requests. They want to allow employees to reset passwords themselves using a conversational interface. Which Power Platform tool should they use?

A.Power BI

B.Power Apps

C.Power Virtual Agents

D.Power Automate

AnswerC

Power Virtual Agents creates chatbots for conversational self-service.

Why this answer

Power Virtual Agents (C) is the correct tool because it enables the creation of conversational AI chatbots that can handle password reset requests through natural language interactions. It integrates with Azure Active Directory and other identity systems to allow employees to securely reset their own passwords without IT intervention, reducing the helpdesk workload.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to automate password reset workflows with the need for a conversational interface, overlooking that Power Virtual Agents is specifically designed for building the chatbot front-end that users interact with.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and business analytics tool, not designed for building conversational interfaces or automating password resets. Option B is wrong because Power Apps is a low-code application development platform for building custom apps (canvas or model-driven), but it lacks native conversational AI capabilities for handling interactive password reset dialogues. Option D is wrong because Power Automate is a workflow automation tool for orchestrating tasks across services, but it does not provide a conversational interface; it could be used as a backend trigger but not as the front-end chatbot itself.

Practice this question →

157

MCQhard

An organization is deploying Power Apps to external customers for a self-service portal. They need to ensure that customer data is isolated from internal employee data. What is the best approach?

A.Use Data Loss Prevention (DLP) policies in the same environment

B.Add external customers as B2B guests in the same environment

C.Create separate environments for internal and external users

D.Use the same environment with security role-based access

AnswerC

Separate environments physically isolate data and allow different DLP policies.

Why this answer

Option C is correct because creating separate environments for internal and external users provides full tenant-level isolation of customer data from employee data. Each environment in Power Platform has its own databases, security settings, and data storage, ensuring that external customers cannot access internal resources even if security roles are misconfigured.

Exam trap

The trap here is that candidates often confuse security roles and DLP policies with true data isolation, assuming that permissions or data loss prevention rules can achieve the same level of separation as dedicated environments, but only separate environments provide the required physical and logical data boundaries.

How to eliminate wrong answers

Option A is wrong because DLP policies control data movement between connectors and prevent data exfiltration, but they do not isolate data within the same environment; internal and external users would still share the same database. Option B is wrong because adding external customers as B2B guests in the same environment still places them in the same Common Data Service (Dataverse) instance, meaning data is not physically isolated and could be exposed through misconfigured security roles. Option D is wrong because using the same environment with security role-based access relies solely on permissions to separate data, which is insufficient for strict data isolation requirements; it does not provide the physical or logical separation needed for compliance and security best practices.

Practice this question →

158

MCQhard

A global manufacturing company uses Microsoft Power Platform to manage its equipment maintenance processes. The company has over 10,000 maintenance technicians worldwide who use a Power Apps mobile app to report equipment issues and log repairs. The app connects to a common data service (Dataverse) that stores all maintenance records. Recently, the company experienced a data breach where a malicious user exploited a vulnerability in the app to access and delete maintenance records from multiple high-value machines. The security team traced the issue to the app's permissions model: the app was using a single service account with elevated privileges to perform all data operations. The company now wants to redesign the app's security to follow the principle of least privilege while maintaining usability for technicians. The technicians need to view their assigned work orders, create new issue reports, and update the status of their own repairs, but they should not be able to delete records or access records from other regions. Which approach should the company take?

A.Replace the Power Apps app with a Power Automate flow that technicians trigger via email to submit and update records.

B.Configure each technician's individual user account with a basic user role in Dataverse, and remove the service account.

C.Implement row-level security in Dataverse to restrict technicians to their own records and region, assign appropriate role-based access (create, read, update, no delete), and use individual user accounts.

D.Create a separate Power Apps app for each region, each with its own service account that has restricted permissions to that region's data.

AnswerC

Row-level security combined with RBAC allows granular permissions per record, following least privilege while maintaining usability.

Why this answer

Option C is correct because it applies the principle of least privilege by using individual user accounts with Dataverse role-based security and row-level security (RLS). This ensures each technician can only create, read, and update their own assigned records within their region, while explicitly denying delete permissions. This approach eliminates the shared, over-privileged service account and enforces granular data isolation.

Exam trap

The trap here is that candidates may think creating separate apps or using basic roles is sufficient, but they overlook the need for both row-level security and individual user accounts to enforce least privilege and data isolation across regions.

How to eliminate wrong answers

Option A is wrong because replacing the app with a Power Automate flow triggered via email does not address the underlying permission model; it still requires a secure data access method and introduces usability friction without solving the privilege escalation issue. Option B is wrong because assigning only a basic user role without row-level security would allow technicians to view and potentially modify records from other regions, violating the requirement for regional data isolation. Option D is wrong because creating separate apps per region with individual service accounts still relies on shared service accounts, which violates the principle of least privilege and does not prevent a compromised account from accessing all data in that region.

Practice this question →

159

MCQeasy

A small business wants to create a chatbot to answer common customer questions about store hours and return policies. Which Power Platform tool should they use?

A.Power BI

B.Power Automate

C.Power Apps

D.Copilot Studio

AnswerD

Copilot Studio is designed for building conversational AI chatbots.

Why this answer

Copilot Studio (formerly Power Virtual Agents) is the correct tool because it is specifically designed to create conversational AI chatbots without writing code. It allows the business to build a bot that answers common questions about store hours and return policies by defining topics and using natural language processing to interact with users.

Exam trap

The trap here is that candidates may confuse Power Apps (custom app builder) or Power Automate (workflow automation) with chatbot creation, but only Copilot Studio provides the conversational AI capabilities needed for this use case.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for building chatbots. Option B is wrong because Power Automate is a workflow automation tool that connects apps and services to automate repetitive tasks, but it does not provide a conversational interface for answering customer questions. Option C is wrong because Power Apps is a low-code platform for building custom business applications with forms and data connections, not for creating chatbots.

Practice this question →

160

MCQeasy

Your organization wants to create a public-facing website where customers can submit support requests. The website should be built with minimal custom code and integrate with Dataverse. Which Power Platform component should you use?

A.Power Pages

B.Power BI

C.Power Apps

D.Power Automate

AnswerA

Power Pages is a low-code solution for building external-facing websites.

Why this answer

Power Pages is the correct choice because it is a low-code, secure, enterprise-grade platform for creating public-facing websites that integrate directly with Dataverse. It enables external customers to submit support requests without custom code, leveraging built-in authentication, form components, and Dataverse data binding.

Exam trap

The trap here is that candidates may confuse Power Apps (which also uses Dataverse) with Power Pages, not realizing that Power Apps requires user authentication and is not designed for anonymous public-facing websites, whereas Power Pages is explicitly built for external portals.

How to eliminate wrong answers

Option B is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for building public-facing websites with form submission capabilities. Option C is wrong because Power Apps is designed for building custom business applications (canvas or model-driven) for internal or authenticated users, not for creating public-facing websites accessible to anonymous customers. Option D is wrong because Power Automate is an automation platform for creating workflows and process automations, not a website builder; it can be used to process submissions but cannot serve as the front-end website itself.

Practice this question →

161

MCQmedium

A retail chain uses Power Apps for an inventory management app. Employees report that the app loads slowly. What is the most likely cause?

A.The app has too many controls per screen

B.The app uses a non-delegable query on a large data source

C.The app uses too many screens

D.The app has complex formulas in OnStart

AnswerB

Non-delegable queries retrieve all data before filtering, causing slow performance.

Why this answer

The most likely cause of slow loading in a Power Apps inventory management app is a non-delegable query on a large data source. When a query cannot be delegated, Power Apps retrieves all records from the data source to the client device, then filters locally, causing significant performance degradation with large datasets. This is a common issue when using functions like `Filter` with unsupported operators or columns on large tables.

Exam trap

The trap here is that candidates often assume too many controls or screens cause slowness, but the PL-900 exam specifically tests the concept of delegation as the primary performance bottleneck when dealing with large data sources in Power Apps.

How to eliminate wrong answers

Option A is wrong because having many controls per screen primarily affects rendering and responsiveness during app use, not initial load time; the load time is dominated by data retrieval and formula execution. Option C is wrong because the number of screens does not directly impact load time, as screens are loaded on demand unless preloaded, and the app loads only the first screen initially. Option D is wrong because complex formulas in OnStart can slow down app startup, but the most likely cause for a slow-loading app connected to a large data source is a non-delegable query, which forces all data to be transferred before any filtering.

Practice this question →

162

MCQhard

A healthcare organization uses Power Apps to manage patient intake forms. The app is built on Dataverse and includes a field for medical record number (MRN) that must be unique. The app currently uses a text input, but duplicate MRNs have been entered. What is the best way to enforce uniqueness at the data layer?

A.Create a Dataverse alternate key on the MRN field

B.Use a Power Automate flow to check for duplicates after submission

C.Configure a business rule on the MRN field

D.Add a validation rule in the app to check for duplicates before submitting

AnswerA

Alternate keys enforce uniqueness at the database level, preventing duplicates.

Why this answer

Option A is correct because a Dataverse alternate key enforces uniqueness at the database level, preventing duplicate MRN values from being saved regardless of how data enters the system. This is the only option that operates at the data layer, ensuring integrity even if the app, a flow, or an external integration submits a record. Alternate keys are indexed and validated by Dataverse before commit, making them the proper solution for unique field constraints.

Exam trap

The trap here is that candidates confuse client-side validation (business rules, app validation) with data-layer enforcement, assuming any uniqueness check in the app or a flow is sufficient, but only alternate keys (or unique constraints) guarantee integrity at the database level.

How to eliminate wrong answers

Option B is wrong because a Power Automate flow runs after submission, meaning duplicates can already be committed before the flow checks—this is a reactive, not preventive, approach and does not enforce uniqueness at the data layer. Option C is wrong because a business rule operates on the client side (in a model-driven app form) and cannot enforce uniqueness at the database level; it only provides UI-level validation and can be bypassed by direct API calls or bulk imports. Option D is wrong because a validation rule in the app (canvas or model-driven) runs only within the app client and can be circumvented by direct data operations, such as Dataverse API calls or data imports, so it does not guarantee data-layer uniqueness.

Practice this question →

163

Multi-Selectmedium

Which TWO are benefits of using Microsoft Power Platform for business process automation? (Select TWO)

Select 2 answers

A.It reduces development time compared to traditional coding.

B.It can be used offline without any connectivity.

C.It requires no coding skills for any scenario.

D.It integrates easily with Microsoft 365 and Azure services.

E.It only works with Microsoft data sources.

AnswersA, D

Low-code speeds up development.

Why this answer

Option A is correct because Microsoft Power Platform provides pre-built connectors, templates, and low-code tools like Power Automate and Power Apps that drastically reduce the time required to build business process automation compared to writing code from scratch. This enables rapid development and iteration without the overhead of traditional software development lifecycles.

Exam trap

The trap here is that candidates may assume 'low-code' means 'no-code for all scenarios' (Option C) or that Power Platform is limited to Microsoft ecosystems (Option E), but the exam tests the understanding that low-code reduces but does not eliminate coding needs, and that the platform is designed for broad interoperability.

Practice this question →

164

MCQhard

A Power BI report shows a measure 'Sales Growth %' defined as above. The measure returns blank for some months even though sales data exists. What is the most likely cause?

A.The date table is not marked as a date table in Power BI.

B.The measure should use TOTALYTD instead of SAMEPERIODLASTYEAR.

C.The Sales table has no relationship with the Date table.

D.The DIVIDE function requires a third argument for alternate result.

AnswerA

Time intelligence functions require a marked date table with continuous dates.

Why this answer

When a date table is not marked as a date table in Power BI, time intelligence functions like SAMEPERIODLASTYEAR may not correctly identify the date context, causing them to return blank for certain periods even when data exists. Marking the table as a date table ensures that Power BI uses its built-in date hierarchy and calendar logic, which is required for functions that shift or compare date ranges.

Exam trap

The trap here is that candidates often assume the blank result is due to missing data or a broken relationship, when in fact the root cause is that the date table is not properly configured to support time intelligence functions.

How to eliminate wrong answers

Option B is wrong because TOTALYTD calculates year-to-date totals, not a year-over-year comparison; the issue is about SAMEPERIODLASTYEAR returning blank, not about the aggregation type. Option C is wrong because if the Sales table had no relationship with the Date table, the measure would return blank for all months, not just some months. Option D is wrong because the DIVIDE function’s third argument is optional and defaults to BLANK() when the denominator is zero; the blank return here is not caused by division by zero but by a date context problem.

Practice this question →

165

MCQmedium

A company wants to use AI to automatically categorize customer support tickets based on their description. Which Power Platform AI capability should they use?

A.Power Automate with a regular expression

B.AI Builder category classification model

C.Power Virtual Agents (now Copilot Studio)

D.Power BI AI visuals

AnswerB

AI Builder offers a prebuilt category classification model that can automatically categorize text.

Why this answer

AI Builder provides prebuilt models for text classification, including category classification. Power Automate can trigger the model, but the AI capability itself is AI Builder. Copilot Studio is for custom copilots and chatbots.

Practice this question →

166

MCQmedium

A company uses Microsoft Dataverse to store customer data. They want to create a unified view of sales and support interactions for each customer. Which feature should they use?

A.Power BI

B.Microsoft Copilot Studio

C.Power Automate

D.Microsoft Dataverse

AnswerD

Dataverse can store related tables and be used in apps to show unified views.

Why this answer

Microsoft Dataverse is the correct choice because it provides a unified, relational data store that can combine sales and support interaction data into a single customer entity. By using Dataverse tables and relationships, you can create a 360-degree view of each customer without moving data to external systems, enabling real-time insights within Power Apps or model-driven apps.

Exam trap

The trap here is that candidates often confuse Dataverse with Power BI, thinking that a unified view requires a separate reporting tool, when in fact Dataverse itself provides the relational data model to unify data across different business entities.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and analytics tool, not a data storage or unification platform; it can display Dataverse data but cannot create a unified view of sales and support interactions. Option B is wrong because Microsoft Copilot Studio is used to build custom copilots and conversational AI experiences, not to store or unify customer data. Option C is wrong because Power Automate is an automation workflow tool that can trigger actions based on data changes, but it does not provide a persistent, relational data store for unifying customer records.

Practice this question →

167

Multi-Selecthard

A global organization wants to standardize expense reporting across subsidiaries using Power Platform. They require integration with Microsoft Entra ID for identity and must ensure data residency compliance. Which TWO capabilities should they use?

Select 2 answers

A.AI Builder

B.Power BI dashboards

C.Dataverse environments with specific regions

D.Copilot Studio

E.Data Loss Prevention (DLP) policies

AnswersC, E

Dataverse environments can be created in specific geographic regions.

Why this answer

Dataverse environments can be created in specific geographic regions (e.g., Canada, France, UK) to ensure data residency compliance by storing data at rest within that region. Integration with Microsoft Entra ID is inherent to Dataverse, which uses Entra ID as its identity provider for authentication and authorization, meeting the requirement for standardized identity management across subsidiaries.

Exam trap

Cisco often tests the misconception that Power BI or AI Builder are responsible for compliance features, when in fact data residency is enforced at the Dataverse environment level and identity is handled by Entra ID, not by analytics or AI tools.

Practice this question →

168

MCQhard

An organization wants to analyze customer sentiment from social media data and create interactive dashboards. Which combination of Power Platform tools should they use?

A.Power BI and Power Apps

B.Power BI and AI Builder

C.Power Automate and Power Virtual Agents

D.Power Apps and Power Automate

AnswerB

Power BI provides dashboards; AI Builder analyzes sentiment.

Why this answer

Power BI can connect to data sources and create dashboards, while AI Builder can analyze sentiment. Power Automate is for workflows, and Power Apps for apps.

Practice this question →

169

MCQhard

A large retail chain uses Power Platform to manage store operations. They have 500 stores, each with a tablet running a Power Apps canvas app for inventory management. The app connects to Dataverse. Recently, store managers reported that the app is slow during peak hours. The IT team suspects that the issue is due to the number of concurrent users and the design of the app. They need to improve performance without rewriting the app. What should they do first?

A.Migrate the app to a model-driven app

B.Replace the app with a Power BI dashboard

C.Increase the network bandwidth at each store

D.Redesign the app to use delegation and reduce data requests

AnswerD

Delegation offloads processing to the data source, improving performance.

Why this answer

Reducing the number of data requests by using delegation and filtering can significantly improve performance. Option B is incorrect because moving to model-driven app is not a simple fix. Option C is incorrect because increasing network bandwidth may not help if the app is making inefficient queries.

Option D is incorrect because Power BI is not the issue.

Practice this question →

170

MCQmedium

A logistics company uses Power Apps to build a fleet management app. They need to integrate real-time GPS data from IoT devices. Which connector should they use?

A.SharePoint connector

B.IoT connector

C.Dynamics 365 connector

D.Office 365 Users connector

AnswerB

Enables integration with IoT devices and telemetry data.

Why this answer

The IoT connector is specifically designed to ingest and process data from Internet of Things devices, including real-time GPS streams from fleet telematics. It provides built-in triggers and actions for handling device telemetry, making it the correct choice for integrating live GPS data into a Power Apps fleet management solution.

Exam trap

The trap here is that candidates may confuse the IoT connector with the Dynamics 365 connector, thinking GPS data is part of a CRM system, when in fact IoT requires a dedicated connector for device telemetry ingestion.

How to eliminate wrong answers

Option A is wrong because the SharePoint connector is for document management and list data, not for real-time IoT telemetry streams. Option C is wrong because the Dynamics 365 connector is for CRM/ERP data and workflows, not for direct IoT device integration. Option D is wrong because the Office 365 Users connector only retrieves user profile and directory data, not device or sensor information.

Practice this question →

171

MCQmedium

A company has a legacy on-premises SQL Server database and wants to build a Power BI report that refreshes daily. However, the database is behind a firewall. What should they use to securely access the data?

A.Power Automate with SQL connector

B.An on-premises data gateway

C.Microsoft Dataverse

D.A VPN connection to the database

AnswerB

The on-premises data gateway allows secure data transfer between on-premises sources and cloud services.

Why this answer

An on-premises data gateway is the correct solution because it acts as a secure bridge between on-premises data sources (like SQL Server behind a firewall) and cloud services such as Power BI. The gateway encrypts data in transit and allows scheduled refresh without opening inbound ports in the firewall, using outbound connections to Azure Service Bus.

Exam trap

The trap here is that candidates often confuse a VPN or direct connector (like Power Automate) as sufficient for firewall traversal, but the PL-900 exam specifically tests the on-premises data gateway as the only secure, supported method for scheduled Power BI refresh from behind a firewall.

How to eliminate wrong answers

Option A is wrong because Power Automate with SQL connector is designed for real-time or event-driven workflows, not for scheduled data refresh in Power BI reports; it also cannot bypass a firewall without a gateway. Option C is wrong because Microsoft Dataverse is a cloud-based data storage service, not a connectivity tool for on-premises databases; it does not provide a secure bridge to SQL Server behind a firewall. Option D is wrong because a VPN connection to the database would require opening inbound ports and managing complex network configurations, which is less secure and more cumbersome than the dedicated, outbound-only on-premises data gateway.

Practice this question →

172

Multi-Selecteasy

A manufacturing company wants to use Power Platform to improve operational efficiency. Which TWO benefits of using Microsoft Power Platform are most relevant?

Select 2 answers

A.Replace the need for any third-party software

B.Automate hardware inventory management

C.Build custom apps without extensive coding

D.Eliminate the need for user authentication

E.Automate business processes and workflows

AnswersC, E

Power Apps enables low-code app development.

Why this answer

Option C is correct because Microsoft Power Platform enables citizen developers to build custom apps using low-code tools like Power Apps, which significantly reduces the need for extensive traditional coding. This aligns directly with the company's goal of improving operational efficiency by allowing rapid application development without deep programming expertise.

Exam trap

The trap here is that candidates often confuse 'automating hardware inventory management' (a specific IT task) with the broader business process automation capability of Power Platform, leading them to incorrectly select Option B instead of recognizing that Power Platform's strength lies in automating workflows and building custom apps, not in replacing dedicated inventory management tools.

Practice this question →

173

MCQeasy

A business analyst wants to create a real-time dashboard showing sales performance from Dynamics 365 Sales data. Which tool should they use?

A.Power Apps

B.Power BI

C.Power Pages

D.Power Automate

AnswerB

Power BI connects to Dynamics 365 and creates real-time dashboards.

Why this answer

Power BI is the correct tool for creating real-time dashboards because it is designed specifically for data visualization and business intelligence. It can connect directly to Dynamics 365 Sales data via the Dataverse connector or direct query mode, enabling live, interactive dashboards that refresh automatically as data changes.

Exam trap

The trap here is that candidates may confuse Power Apps' ability to display data in a gallery or chart with the dedicated real-time dashboarding and analytics capabilities of Power BI, leading them to select Power Apps for a visualization task.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom applications, not for creating real-time dashboards or data visualizations. Option C is wrong because Power Pages is used to build external-facing websites, not for internal dashboards or analytics. Option D is wrong because Power Automate is an automation tool for workflows and processes, not for visualizing or analyzing data in a dashboard format.

Practice this question →

174

Multi-Selectmedium

A company wants to use Power Platform to streamline its expense reporting process. Which TWO components can be used together to create a complete solution that allows employees to submit expenses, managers to approve them, and finance to analyze trends?

Select 2 answers

A.Copilot Studio

B.Power BI

C.Power Apps

D.Power Automate

E.Power Pages

AnswersC, D

Power Apps can build the expense submission form.

Why this answer

Power Apps is correct because it allows you to build a custom expense submission form that employees can use to enter expense details. Combined with Power Automate, which handles the approval workflow and data routing, and Power BI for trend analysis, this creates a complete solution. Power Apps provides the user interface, while Power Automate orchestrates the backend process.

Exam trap

The trap here is that candidates often think Power BI alone can handle the entire process, but it only provides analytics, not the submission or approval logic, so you must pair it with Power Apps and Power Automate for a complete solution.

Practice this question →

175

MCQeasy

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?

A.Dynamics 365 Sales

B.Custom app built with Power Apps connected to Dataverse

C.Power Automate flows to send emails

D.Power BI dashboards connected to Excel

AnswerB

Power Apps allows building a comprehensive app for donations and volunteer management with low code.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse Dynamics 365 Sales as a catch-all CRM solution, but the PL-900 exam emphasizes that Power Apps is the correct choice when a custom, low-code application is needed to meet unique organizational requirements without the cost and complexity of a full Dynamics 365 license.

How to eliminate wrong answers

Option A is wrong because Dynamics 365 Sales is a full-featured CRM designed for sales processes, not for general-purpose donation and volunteer tracking, and it requires higher licensing costs and more IT overhead than a custom Power Apps solution. Option C is wrong because Power Automate flows alone only automate email notifications and workflows, but they do not provide a user interface or data storage for tracking donations and volunteers. Option D is wrong because Power BI dashboards connected to Excel are for visualization and reporting only, lacking the transactional data entry, storage, and management capabilities needed for a unified tracking system.

Practice this question →

176

MCQmedium

An organization needs to create a centralized repository of business data that can be used by Power Apps, Power Automate, and Power BI. Which data storage option is designed for this purpose?

A.Microsoft Dataverse

B.SharePoint lists

C.Azure SQL Database

D.Excel Online

AnswerA

Dataverse is the standard data platform for Power Platform, providing a secure, scalable, and integrated data store.

Why this answer

Microsoft Dataverse is the correct choice because it is a low-code data platform specifically designed to securely store and manage business data used by Power Apps, Power Automate, and Power BI. It provides a common data schema, built-in business logic, role-based security, and seamless integration with the Power Platform, making it the centralized repository for business data.

Exam trap

The trap here is that candidates often confuse SharePoint lists or Azure SQL Database as valid centralized repositories, but Dataverse is the only option that provides a unified, low-code data platform with built-in business logic and seamless integration across the entire Power Platform.

How to eliminate wrong answers

Option B is wrong because SharePoint lists are primarily for document management and team collaboration, not designed as a centralized, relational data store with built-in business logic and relationships for Power Platform apps. Option C is wrong because Azure SQL Database is a relational database engine that requires manual schema design, security configuration, and integration, lacking the low-code, out-of-the-box data modeling and business rule capabilities of Dataverse. Option D is wrong because Excel Online is a spreadsheet tool intended for ad-hoc data analysis and manual entry, not a scalable, secure, or relational data storage solution for enterprise applications.

Practice this question →

177

MCQhard

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

A.The Office 365 connector is conflicting with the SQL connector.

B.The flow is using the cloud SQL connector without an on-premises data gateway.

C.The environment type is Production, which restricts access to on-premises data.

D.The region 'eastus' does not support on-premises connectivity.

AnswerB

The cloud SQL connector requires a gateway for on-premises databases.

Why this answer

The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway.

Without this gateway, the flow will fail with a connection error, making option B the correct answer.

Exam trap

The trap here is that candidates may assume the SQL connector can directly access on-premises databases without any additional infrastructure, overlooking the mandatory requirement of an on-premises data gateway for hybrid connectivity.

How to eliminate wrong answers

Option A is wrong because the Office 365 connector and the SQL connector are independent services; they do not conflict with each other, and any such conflict would not cause a failure specific to on-premises database access. Option C is wrong because environment type (Production, Trial, etc.) does not restrict access to on-premises data; the restriction is purely about gateway configuration and network connectivity, not environment classification. Option D is wrong because the 'eastus' region fully supports on-premises connectivity via the data gateway; region does not affect the ability to connect to on-premises resources, as the gateway handles the outbound connection to Azure.

Practice this question →

178

MCQmedium

Refer to the exhibit. You see a Power Automate flow definition in JSON. What does this flow do?

A.It updates a lead record when an email is received.

B.It deletes emails after creating leads.

C.It sends an email when a new lead is created in Dataverse.

D.It creates a lead in Dataverse when a new email arrives in the inbox.

AnswerD

The trigger is new email; the action creates a lead with the sender's email.

Why this answer

Option D is correct because the flow trigger is 'When a new email arrives' (inbox trigger), and the action is 'Create a new lead' in Dataverse. This means the flow automatically creates a lead record in Dataverse whenever a new email arrives in the specified inbox, without requiring any manual intervention.

Exam trap

The trap here is confusing the trigger and action direction: candidates often misread the flow as 'when a lead is created, send an email' (Option C) instead of correctly identifying that an email arrival triggers the creation of a lead.

How to eliminate wrong answers

Option A is wrong because the flow creates a new lead, not updates an existing lead record; the action is 'Create a new lead', not 'Update a lead'. Option B is wrong because the flow does not delete emails; it only creates leads, and there is no delete action in the JSON definition. Option C is wrong because the trigger is an email arriving, not a new lead being created in Dataverse; the flow is triggered by an email event, not a Dataverse event.

Practice this question →

179

MCQeasy

Your team needs to build a custom app that connects to Microsoft 365 and third-party services like Salesforce. Which Power Platform feature enables this?

A.Power Automate triggers

B.Power Pages templates

C.Power Apps connectors

D.Power BI datasets

AnswerC

Connectors allow Power Apps to integrate with external services.

Why this answer

Option C is correct because Power Apps connectors are the specific feature that enables integration with external services like Microsoft 365 and Salesforce. Connectors provide pre-built APIs and authentication wrappers that allow Power Apps to securely read, write, and trigger actions in these services without custom code.

Exam trap

The trap here is that candidates confuse Power Automate triggers (which start flows) with the broader connectivity layer of Power Apps connectors, assuming triggers alone enable app-to-service integration, but triggers only initiate automation, not the bidirectional data binding required in a custom app.

How to eliminate wrong answers

Option A is wrong because Power Automate triggers are events that start a flow, not a feature for building custom apps that connect to services; they are part of automation, not app development. Option B is wrong because Power Pages templates are pre-designed website layouts for external-facing portals, not a mechanism for connecting to third-party services like Salesforce. Option D is wrong because Power BI datasets are data sources used for analytics and visualization, not for building custom apps or establishing live connections to Microsoft 365 and Salesforce.

Practice this question →