Courseiva

Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 601675

904 questions total · 13pages · All types, answers revealed

Page 8

Page 9 of 13

Page 10
601
MCQmedium

Your organization uses Power Automate to automate the creation of support tickets in ServiceNow when a critical alert is triggered in Microsoft Sentinel. The flow uses the 'When a new alert is created' trigger from Sentinel. The flow runs but no tickets are created. You check the Sentinel log and see that alerts are being generated. What should you investigate first?

A.Verify that the flow is enabled.
B.Ensure that the Sentinel data connector is properly installed.
C.Review the trigger condition or filter query.
D.Check if the ServiceNow connector is configured with the correct instance.
AnswerC

Filter may exclude critical alerts.

Why this answer

The flow uses a trigger condition or filter query that may be set to only fire for specific alert severity levels or types. If the filter is misconfigured, critical alerts might be filtered out even though they are generated in Sentinel. Option A is incorrect because the flow runs, so it is enabled.

Option B is incorrect because the issue is not about data connector installation; alerts are appearing in Sentinel logs. Option D is incorrect because if the ServiceNow connector were misconfigured, the flow might fail at a later step, but the issue is likely that the trigger is not firing due to the filter.

602
MCQhard

An organization is configuring a custom connector in Power Automate to connect to Salesforce. The exhibit shows a snippet of the connector definition. However, when attempting to test the connection, the authentication fails. What is the most likely cause?

A.The OAuth flow type is incorrectly set to 'accessCode' instead of 'authorizationCode'.
B.The scopes array is missing the 'id' scope.
C.The apiVersion is not supported by Power Automate.
D.The serviceUrl should point to the Salesforce instance, not login.salesforce.com.
AnswerA

The correct OAuth flow for authorization code is 'authorizationCode'.

Why this answer

The OAuth 2.0 flow type 'accessCode' is not a valid OAuth 2.0 grant type. The correct value for the authorization code grant type is 'authorizationCode'. Power Automate custom connectors require this exact string to properly initiate the OAuth 2.0 authorization code flow with Salesforce.

Using 'accessCode' causes the authentication handshake to fail because the connector cannot map the flow to a supported OAuth grant.

Exam trap

The trap here is that candidates may assume 'accessCode' is a valid OAuth flow type because it appears in some third-party documentation or older samples, but the PL-900 exam expects the exact OAuth 2.0 standard term 'authorizationCode' as used in Power Automate custom connector definitions.

How to eliminate wrong answers

Option B is wrong because the 'scopes' array does not require an 'id' scope; Salesforce OAuth scopes are defined by the connected app and typically include 'api', 'refresh_token', and 'offline_access' but not 'id' unless specifically needed for OpenID Connect. Option C is wrong because Power Automate supports multiple Salesforce API versions (e.g., v58.0, v59.0) and an unsupported version would cause a different error (e.g., 404 or version mismatch), not an authentication failure. Option D is wrong because 'login.salesforce.com' is the correct OAuth token endpoint for Salesforce production instances; pointing to a specific instance URL would break the token exchange because the OAuth endpoint must be the global login URL for token issuance.

603
MCQmedium

A canvas app uses the formula shown in the exhibit to display the name of the most recently created account named 'Contoso'. The formula always shows 'No records found' even though there are accounts named 'Contoso'. What is the likely issue?

A.The SortByColumns function is used incorrectly.
B.The First function cannot be used on a filtered result.
C.The formula is not delegable and returns incomplete data.
D.The column name in the formula uses a space and may be incorrect.
AnswerD

If the actual column is 'AccountName', the filter fails.

Why this answer

The formula references a column name with a space ('Account Name') without using single-quote delimiters. In Power Apps, when a column name contains a space, it must be enclosed in single quotes (e.g., 'Account Name') to be parsed correctly. Without the quotes, Power Apps interprets the space as a separator, causing the lookup to fail and the condition to evaluate as false, always falling back to 'No records found'.

Exam trap

The trap here is that candidates often assume the issue is delegation (Option C) because 'No records found' suggests a data limit, but the real problem is a syntax error in referencing a column with a space, which is a subtle and easily overlooked detail in Power Apps formulas.

How to eliminate wrong answers

Option A is wrong because the SortByColumns function is used correctly here; it sorts the filtered table by the 'Created On' column in descending order, which is syntactically valid and not the cause of the issue. Option B is wrong because the First function can absolutely be used on a filtered result; it returns the first record of a table, and there is no restriction preventing its use after a Filter or SortByColumns. Option C is wrong because the formula is fully delegable—Filter, SortByColumns, and First are all delegable operations in Power Apps for supported data sources like Dataverse or SQL Server—so incomplete data due to delegation limits is not the problem here.

604
MCQmedium

A model-driven app includes a custom entity 'Project' with a lookup to 'Account'. Users need to see the account name and phone number on the Project form. What is the best way to display these fields?

A.Use a calculated field on the Project entity
B.Create a new main form for the Project entity
C.Add the account fields directly to the Project entity
D.Add a quick view form for the Account entity
AnswerD

Quick view form shows related data inline.

Why this answer

A quick view form displays related data from the lookup entity (Account) directly on the Project form without storing duplicate fields. Option A is incorrect because calculated fields only compute values from existing fields within the same entity, not from related entities. Option B is incorrect because creating a new main form for the Project entity does not automatically show related Account fields.

Option C is incorrect because adding account fields directly to the Project entity would duplicate data and violate normalization.

605
MCQhard

An organization uses Power BI to analyze sales data. They notice that the report takes over a minute to load, and they need to improve performance quickly without changing the data source. Which action should they take?

A.Change the data source to use DirectQuery instead of Import.
B.Implement data aggregations in Power BI.
C.Reduce the number of visuals on the dashboard.
D.Create a new composite model.
AnswerC

Fewer visuals reduce the number of queries and rendering time.

Why this answer

Reducing the number of visuals on a Power BI dashboard directly decreases the number of queries sent to the data model and the rendering workload, which can significantly improve load times without altering the data source. This is the quickest performance optimization available when the data source cannot be changed, as each visual typically triggers separate DAX queries and rendering processes.

Exam trap

The trap here is that candidates often assume performance issues must be solved by changing the data connectivity mode (DirectQuery vs. Import) or by adding aggregations, but the quickest and simplest fix—reducing visual count—is overlooked because it seems too trivial.

How to eliminate wrong answers

Option A is wrong because switching from Import to DirectQuery would likely worsen performance for a report that already takes over a minute to load, as DirectQuery sends live queries to the data source for every interaction, increasing latency and load on the source system. Option B is wrong because implementing data aggregations requires modifying the data model and often involves creating pre-summarized tables, which is not a quick fix and may not be feasible without changing the data source structure. Option D is wrong because creating a new composite model involves combining DirectQuery and Import modes, which adds complexity and does not provide an immediate performance improvement; it also requires changes to the data source connection.

606
MCQhard

A Power Apps developer needs to create an app that uses AI Builder to extract information from invoices. The app should allow users to upload an image and then display extracted fields. Which control should be used to capture the image?

A.Camera control
B.Add picture control
C.Image control
D.Button control
AnswerB

Allows users to upload an image.

Why this answer

The Add picture control is the correct choice because it provides functionality for users to either take a photo using their device's camera or upload an existing image file. This is essential for the app's requirement to capture an invoice image and then use AI Builder to extract information from it. Option A (Camera control) is incorrect because it only allows real-time video capture and does not support file upload.

Option C (Image control) is used solely to display images, not to capture them. Option D (Button control) can trigger actions but cannot directly capture images. Therefore, the Add picture control (B) is the only control that enables both photo capture and image upload, meeting the user's needs.

607
MCQmedium

A company uses Power Automate to send approval emails when a new employee is added to Microsoft Entra ID. The approval flow fails intermittently with a '403 Forbidden' error. What is the most likely cause?

A.The Microsoft Entra ID license has expired.
B.The flow is exceeding the API request throttle limit.
C.The connection used in the flow lacks appropriate permissions.
D.The Power Automate connector for Microsoft Entra ID is deprecated.
AnswerC

403 Forbidden indicates the authenticated identity does not have permission to perform the action.

Why this answer

A '403 Forbidden' error typically indicates that the connection used in the flow does not have the necessary permissions to access Microsoft Entra ID. Option A is incorrect because license expiration would result in a different error, such as a '402 Payment Required'. Option B is incorrect because throttling limits cause '429 Too Many Requests' errors.

Option D is incorrect because a deprecated connector would likely cause errors related to compatibility or connectivity, not a '403 Forbidden'.

608
MCQmedium

Refer to the exhibit. A Power BI report connecting to the SalesDB database is slow. The exhibit shows a SQL Server activity snapshot. What is the most likely cause of the performance issue?

A.The database server has insufficient memory
B.SPID 55 is blocked by SPID 54, causing delays
C.The SELECT query (SPID 55) is performing a table scan
D.The sleeping session (SPID 54) is using too much CPU
AnswerB

BlkBy column shows SPID 55 is blocked by SPID 54.

Why this answer

The exhibit shows SPID 55 (a SELECT query) in a 'suspended' state with a non-zero 'blocked_by' column value of 54, indicating it is waiting for a lock held by SPID 54. SPID 54 is in a 'sleeping' state but still holds locks, which blocks SPID 55 from proceeding. This blocking chain directly causes the report's slow performance, as the Power BI query cannot complete until the blocking session releases its locks.

Exam trap

The trap here is that candidates see SPID 54 as 'sleeping' and assume it is idle and harmless, missing that it still holds locks that block other queries, which is the root cause of the performance issue.

How to eliminate wrong answers

Option A is wrong because insufficient memory would typically manifest as high page life expectancy or memory pressure counters, not as a specific SPID being blocked by another; the exhibit shows no memory-related metrics. Option C is wrong because while a table scan could cause slow performance, the exhibit explicitly shows SPID 55 is 'suspended' due to being blocked (blocked_by = 54), not actively running a scan; a table scan would appear as a 'runnable' or 'running' state with high logical reads. Option D is wrong because a sleeping session (SPID 54) uses negligible CPU; the issue is that it holds locks that block other sessions, not its CPU consumption.

609
MCQmedium

Refer to the exhibit. A Power Pages site is configured with the given authentication settings. When a user clicks 'Sign In', they are redirected to Microsoft Entra ID, but after successful login, they are redirected back to the site and see an error. What is the most likely cause?

A.The clientId is invalid.
B.The tenantId is incorrect.
C.The redirectUrl is not registered in the Microsoft Entra ID app.
D.The site requires HTTPS but is using HTTP.
AnswerC

The redirect URL must match the app registration.

Why this answer

The redirectUrl must be registered as a reply URL in the Microsoft Entra ID app registration. If it is missing, the login fails.

610
MCQmedium

An organization uses a Canvas app to capture customer feedback. The app writes data to a Dataverse table. Recently, users have been submitting duplicate records due to double-clicking the submit button. What is the best way to prevent duplicates?

A.Set the form to require a unique ID before submission
B.Disable the submit button after the first click using the DisplayMode property
C.Add a business rule to check for duplicates before saving
D.Use a Power Automate flow to delete duplicates after creation
AnswerB

Setting DisplayMode to Disabled immediately after click prevents further submissions.

Why this answer

Disabling the submit button after the first click using the DisplayMode property prevents duplicate submissions by ensuring the button cannot be clicked again. Option A is not feasible because requiring a unique ID before submission would change the data entry process and does not address the double-click issue directly. Option C is incorrect because a business rule in Dataverse runs after submission, so it would not prevent duplicates from the same double-click.

Option D is incorrect because a Power Automate flow to delete duplicates after creation does not prevent the duplicates from being submitted in the first place.

611
MCQmedium

A retail company wants to reduce the time store managers spend on manual inventory reporting. Currently, managers use paper forms and email to submit daily stock counts, which then need to be manually entered into a central system. This process is error-prone and delays replenishment. The company wants a solution that automates data entry, provides real-time dashboards, and allows managers to submit reports from their phones without installing any software on the phones. Which combination of Microsoft Power Platform tools should the company use?

A.Power Automate only
B.Power Apps only
C.Power Apps, Power Automate, and Power BI
D.Power BI only
AnswerC

Power Apps provides the mobile input form, Power Automate automates data processing, and Power BI provides real-time dashboards.

Why this answer

The scenario requires a combination of Power Apps (for mobile-friendly report submission without installing software), Power Automate (to automate data entry into the central system), and Power BI (to provide real-time dashboards). Power Apps alone cannot automate data entry or provide dashboards; Power Automate alone cannot provide a mobile input interface or dashboards; Power BI alone cannot capture data or automate workflows. Only the trio covers all requirements: mobile input, automated processing, and real-time visualization.

Exam trap

The trap here is that candidates think a single tool can cover all requirements, but the question explicitly demands three distinct capabilities (mobile input, automation, dashboards) that map to three separate Power Platform components, not one or two.

How to eliminate wrong answers

Option A is wrong because Power Automate only handles workflow automation but cannot provide a mobile-friendly input form or real-time dashboards. Option B is wrong because Power Apps only provides the mobile input interface but cannot automate data entry into the central system or generate dashboards. Option D is wrong because Power BI only provides dashboards but cannot capture inventory submissions from phones or automate data entry.

612
MCQeasy

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?

A.Power Apps
B.Power Virtual Agents
C.Power Automate
D.Power BI
AnswerA

Power Apps allows building low-code mobile apps that can integrate with Teams.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse Power Automate (automation) with Power Apps (app creation), assuming any integration with Teams must involve a workflow, but the question specifically asks for a component to build the mobile app itself, not the backend automation.

How to eliminate wrong answers

Option B is wrong because Power Virtual Agents is designed for building conversational chatbots, not for creating custom mobile apps; it could handle ticket submission via chat but does not provide a mobile app interface. Option C is wrong because Power Automate is an automation and workflow tool, not an app-building platform; while it can trigger actions like sending notifications, it cannot create the mobile app UI for ticket submission. Option D is wrong because Power BI is a data visualization and analytics tool, not a platform for building custom applications or forms; it cannot be used to submit help desk tickets.

613
MCQmedium

A company wants to reduce manual data entry by automatically extracting information from invoices and updating a SharePoint list. Which combination of Power Platform components should they use?

A.Power BI and Power Virtual Agents
B.Power Apps and Power Automate
C.Power Automate and AI Builder
D.Power Apps and Power BI
AnswerC

AI Builder extracts data from invoices; Power Automate updates SharePoint.

Why this answer

AI Builder provides prebuilt invoice processing models that can extract key fields (e.g., invoice number, date, total) from documents, and Power Automate can trigger a flow to write that extracted data directly into a SharePoint list. This combination eliminates manual data entry by automating the extraction and storage pipeline.

Exam trap

The trap here is that candidates often assume Power Apps is needed for any data entry scenario, but in this case the automation is purely backend (no user interface required), so Power Automate combined with AI Builder is the correct and minimal solution.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and analytics tool, not a data extraction or automation tool, and Power Virtual Agents is for building conversational chatbots, not for processing invoices. Option B is wrong because Power Apps alone cannot extract data from invoices; it requires AI Builder or another OCR service to perform the extraction, and while Power Automate can orchestrate the flow, the combination lacks the AI extraction capability. Option D is wrong because Power BI is for reporting and analytics, not for data extraction or automation, and Power Apps cannot extract invoice data without an AI service.

614
MCQmedium

A marketing department wants to create a custom portal where external partners can submit project proposals and track their status. Which Power Platform product should they use?

A.Power Automate
B.Power Apps portal (now Power Pages)
C.Power Virtual Agents
D.Power BI
AnswerB

Power Pages enables building external websites with Dataverse integration for partner submissions.

Why this answer

Power Apps portals (now Power Pages) is the correct choice because it enables organizations to create low-code, externally facing websites that allow external users—such as partners—to sign in, submit project proposals, and track their status. It integrates with Microsoft Dataverse to store and manage the proposal data, and supports role-based access control to ensure partners only see their own submissions.

Exam trap

The trap here is that candidates often confuse Power Automate's ability to handle form submissions (e.g., via Microsoft Forms or SharePoint) with the need for a dedicated external-facing portal, overlooking that Power Pages is the only option that provides a customizable, authenticated website for external users.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool that orchestrates processes (e.g., sending approval emails) but does not provide a user-facing portal for external partners to submit or track data. Option C is wrong because Power Virtual Agents is designed for building conversational AI chatbots, not for creating custom web portals with data submission and tracking capabilities. Option D is wrong because Power BI is a business analytics and visualization platform; it can display proposal status dashboards but cannot serve as an interactive submission portal for external users.

615
Multi-Selecteasy

Which TWO data sources can be used directly in a canvas app without a premium connector? (Choose two.)

Select 2 answers
A.Salesforce
B.Microsoft Dataverse
C.Excel Online (Business)
D.SQL Server
E.SharePoint
AnswersB, E

Microsoft Dataverse requires a premium connector.

Why this answer

Microsoft Dataverse and SharePoint are standard connectors that can be used without a premium license. Salesforce requires a premium connector. Excel Online (Business) is also a standard connector, but the correct answers for this question are Dataverse and SharePoint.

SQL Server requires a premium connector.

616
MCQmedium

A company has a legacy on-premises SQL Server database and wants to integrate it with a Power App without moving data to the cloud. Which connector should they use?

A.SQL Server connector directly
B.Power Automate on-premises agent
C.Dataverse
D.On-premises data gateway with SQL Server connector
AnswerD

The gateway securely connects Power Apps to on-premises SQL Server.

Why this answer

The On-premises data gateway acts as a secure bridge between cloud services like Power Apps and on-premises data sources such as SQL Server. When combined with the SQL Server connector, it allows live queries and updates to the on-premises database without requiring data migration to the cloud, fulfilling the requirement to keep data on-premises.

Exam trap

The trap here is that candidates often confuse the On-premises data gateway with the Power Automate on-premises agent, mistakenly thinking the agent can serve as a general data connector, when in fact it is only for desktop flow automation.

How to eliminate wrong answers

Option A is wrong because the SQL Server connector alone cannot directly access an on-premises SQL Server from the cloud; it requires a gateway to traverse the firewall and network boundaries. Option B is wrong because Power Automate on-premises agent is a specific component for robotic process automation (RPA) and desktop flows, not for connecting Power Apps to on-premises SQL Server databases. Option C is wrong because Dataverse is a cloud-based data storage service that would require moving data to the cloud, which contradicts the requirement to keep data on-premises.

617
MCQeasy

A sales manager wants a mobile app to view customer details and open orders. The app should be built quickly without custom code. Which approach should they use?

A.Create a model-driven app from Dataverse
B.Build a canvas app from scratch
C.Use Power BI to create a mobile dashboard
D.Use Power Automate to create a mobile flow
AnswerA

Model-driven apps are generated automatically from data models.

Why this answer

A model-driven app built from Dataverse (formerly Common Data Service) is the best choice because it is generated automatically from the data model, requiring minimal customization and no custom code. This allows the sales manager to quickly create a mobile app that displays customer details and open orders. Canvas apps (B) require manual design and custom code.

Power BI (C) is for analytics dashboards, not interactive apps. Power Automate (D) is for workflow automation, not app creation.

618
Multi-Selecteasy

Which TWO components are required to create a Power Automate flow that sends an email when a new item is added to a SharePoint list? (Choose two.)

Select 2 answers
A.A trigger
B.An approval action
C.A variable
D.A condition
E.A Send an email action
AnswersA, E

Correct. Every flow needs a trigger.

Why this answer

A trigger is required because a Power Automate flow must have a starting event to initiate execution. For a SharePoint list, the 'When an item is created' trigger fires automatically when a new item is added, which is the necessary first step before any actions can run.

Exam trap

The trap here is that candidates often think a condition or approval is needed for any 'smart' automation, but the question only asks for the minimum components to send an email on item creation, which is just a trigger and an action.

619
MCQmedium

A manufacturing company uses Power Apps to manage inventory tracking. The current app is a canvas app connected to a SharePoint list. The operations team needs to add a new feature that allows warehouse staff to scan barcodes using a mobile device camera to look up product details. Additionally, the app must work offline in areas with no internet connectivity and sync data when connectivity is restored. The app should also incorporate a Copilot assistant to help staff quickly find product information using natural language queries. The IT department requires that the app be deployed to all warehouse staff without requiring manual installation. Which approach should you take to meet all requirements?

A.Add a Text input control for manual barcode entry, use Power Automate flows to fetch product details, enable offline by storing data locally in collections, and deploy by sending a deep link.
B.Use a Power Fx formula with the Camera control to decode barcodes, enable offline data in SharePoint lists, add a Copilot chat box, and deploy via Microsoft Intune as a required app.
C.Add the Barcode scanner control to the canvas app, enable offline mode in app settings, integrate Copilot using the Copilot control, and deploy the app by sharing it via email link.
D.Add the Barcode scanner control, configure the app for offline use with sync, integrate Copilot using the AI Builder 'Ask a question' component, and deploy the app via Power Apps mobile app with a managed solution and installation policy.
AnswerD

All requirements are met: barcode scanning, offline sync, Copilot, and automatic deployment.

Why this answer

It combines the Barcode scanner control for camera-based scanning, offline capabilities via Power Apps mobile app with offline sync, Copilot in Power Apps for natural language queries, and automatic deployment using a managed solution and Power Apps mobile app installation policy. Option A fails to address offline and Copilot requirements. Option B uses Power Fx formula, which is not a native barcode scanning method.

Option C uses Power Automate flows, which are not suitable for real-time offline scanning.

620
Multi-Selecteasy

Which TWO of the following are types of connectors available in Power Automate? (Select TWO.)

Select 2 answers
A.Standard
B.Custom
C.Enterprise
D.On-premises
E.Premium
AnswersA, E

Correct. Standard connectors are included with all Power Automate plans.

Why this answer

A and E are correct. Standard connectors are available to all Power Automate users without additional licensing. Premium connectors, such as those for Salesforce or Common Data Service, require a Premium license.

Option B (Custom) is a type of connector but not a licensing tier, and it is not one of the two correct answers. Option C (Enterprise) is not a recognized connector tier in Power Automate. Option D (On-premises) refers to the data gateway needed for on-premises data sources, not a connector type.

621
MCQmedium

A Power Pages site needs to display a list of upcoming events from a Dataverse table. Only events with a start date greater than today should be shown. Which approach should be used to filter the data on the page?

A.Configure a view in Dataverse with a filter for start date > today and use that view on the page.
B.Use a Power Automate flow to remove past events from the table.
C.Use JavaScript on the page to hide past events after loading.
D.Create a calculated column in Dataverse to indicate future events.
AnswerA

Views provide server-side filtering and can be used in Power Pages lists.

Why this answer

The most straightforward and efficient approach in Power Pages is to use a Dataverse view with a pre-applied filter (start date > today) to display only upcoming events. This offloads filtering to the data source, ensuring that users only see relevant data without relying on client-side logic or flows that might be slower or more complex. While OData filters are possible, using a Dataverse view is simpler and aligns with Power Pages' low-code design.

622
MCQeasy

A company wants to build a custom app that allows employees to submit expense reports from their mobile devices. The app must be easy to customize and deploy without writing code. Which type of Power App should they use?

A.Power Automate
B.Power Pages
C.Canvas app
D.Model-driven app
AnswerC

Correct: Canvas apps enable code-free, custom mobile app creation.

Why this answer

Canvas apps allow building custom, code-free apps that can run on mobile devices. Model-driven apps are more data-centric and require more configuration, while Power Pages is for external websites and Power Automate is for workflows.

623
MCQmedium

A company uses Microsoft Power Platform and requires that all environment creation requests go through an approval process. The security team wants to prevent non-admins from creating trial environments. What should the administrator configure?

A.In Power Platform Admin Center, set 'Disable trial environments created by non-admins' to Yes
B.Assign users to an environment group with restricted permissions
C.In Power Apps settings, disable 'Allow users to create environments'
D.Create a Data Loss Prevention (DLP) policy that blocks trial environments
AnswerA

This setting prevents non-admins from creating trial environments.

Why this answer

The Power Platform Admin Center provides a dedicated tenant-level setting called 'Disable trial environments created by non-admins' that, when set to 'Yes', prevents users without administrative privileges from creating trial environments. This directly addresses the security team's requirement to block non-admins from creating trial environments, as it enforces an approval-based control at the environment creation level.

Exam trap

The trap here is that candidates often confuse DLP policies with environment lifecycle controls, assuming DLP can block environment creation, when in reality DLP only governs data connectors and policies across environments, not provisioning actions.

How to eliminate wrong answers

Option B is wrong because environment groups (or environment routing groups) do not exist in Power Platform; this is a fabricated concept and cannot restrict environment creation permissions. Option C is wrong because the setting 'Allow users to create environments' in Power Apps settings is a legacy control that only applies to the default environment and does not specifically block trial environments; it also does not enforce an approval process. Option D is wrong because Data Loss Prevention (DLP) policies control data movement and connector usage across environments, not environment creation or trial environment provisioning; DLP policies cannot block the creation of environments.

624
MCQhard

A developer is trying to create a business process flow (BPF) for the 'Opportunity' table in a model-driven app. When activating the BPF, the developer receives the error shown in the exhibit. What is the most likely cause?

A.The developer does not have sufficient security role permissions to activate BPFs.
B.The BPF has no stages defined.
C.The BPF is trying to use a table that is not enabled for business process flows.
D.The Opportunity table does not exist.
AnswerC

Only certain tables can be used in BPFs; Opportunity is enabled by default, but if it's a custom table, it might not be enabled.

Why this answer

The error shown in the exhibit indicates that the business process flow (BPF) references a table that is not enabled for business process flows. In Power Apps, only tables that have the 'Business process flows' option enabled in their table settings can be used as the primary entity for a BPF. The 'Opportunity' table is a standard table that is enabled by default, but if it has been disabled or the BPF is referencing a custom table that lacks this setting, activation will fail with this error.

Option C correctly identifies this root cause.

Exam trap

The trap here is that candidates often assume the error is due to missing permissions (Option A) or an incomplete BPF (Option B), but the exhibit's error message specifically references the table not being enabled for business process flows, which is a distinct configuration requirement in Dataverse.

How to eliminate wrong answers

Option A is wrong because security role permissions affect the ability to create or activate BPFs only if the user lacks 'Activate Business Process Flow' privilege, but the error message in the exhibit specifically points to a table configuration issue, not a permissions error. Option B is wrong because a BPF with no stages defined would still activate (though it would be non-functional) and would not produce this specific error; the error is about table enablement, not stage count. Option D is wrong because the 'Opportunity' table is a standard table in Dataverse and always exists; if it didn't, the developer would receive a 'table not found' error during BPF creation, not during activation.

625
MCQeasy

A sales team wants to quickly create a mobile app to track customer visits without writing code. Which Microsoft Power Platform component should they use?

A.Power Automate
B.Power Virtual Agents
C.Power Apps
D.Power BI
AnswerC

Power Apps enables rapid, low-code app creation for mobile and web.

Why this answer

Power Apps is the correct choice because it enables users to build custom mobile apps with a low-code or no-code approach, specifically designed for creating data-driven applications like a customer visit tracker. The sales team can connect to data sources (e.g., Dataverse, SharePoint, or Excel) and design a mobile-friendly interface without writing any code, making it ideal for quickly tracking customer visits.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps because both are low-code tools, but Power Automate is for automating workflows (e.g., sending an email after a visit), not for building the app interface itself.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for creating flows between apps and services, not for building mobile app interfaces or tracking customer visits directly. Option B is wrong because Power Virtual Agents is used to create conversational AI chatbots, not for building a mobile app to track visits. Option D is wrong because Power BI is a business analytics and visualization tool for creating reports and dashboards, not for building interactive mobile applications.

626
Multi-Selecteasy

Which TWO data sources can be directly connected to a canvas app without using a premium connector?

Select 2 answers
A.Excel (OneDrive/SharePoint)
B.Microsoft Dataverse
C.SharePoint
D.SQL Server
E.Salesforce
AnswersA, C

Correct: Excel files in OneDrive or SharePoint are standard.

Why this answer

SharePoint and Excel are standard connectors included with Power Apps. Dataverse and SQL Server require premium licenses, and Salesforce is premium.

627
MCQhard

A Power Automate flow processes incoming emails from a shared mailbox. Recently, some emails are being missed. You suspect the flow is hitting a service protection limit. Which action should you take to diagnose the issue?

A.Use the 'Peek code' feature to review the flow definition.
B.Check the gateway status for the shared mailbox.
C.Review the flow run history and look for 'skipped' status.
D.Pause the flow and restart it.
AnswerC

Skipped runs indicate throttling or quota limits.

Why this answer

Flow run history in Power Automate explicitly records 'skipped' status for runs that were throttled due to service protection limits. By reviewing the run history and filtering for 'skipped' runs, you can directly confirm whether the flow is being rate-limited, which is the most likely cause of missed emails.

Exam trap

The trap here is that candidates may confuse 'skipped' status with 'failed' status, or assume that pausing/restarting the flow (Option D) is a valid diagnostic step, when in fact only run history provides the specific throttling evidence needed.

How to eliminate wrong answers

Option A is wrong because 'Peek code' shows the underlying JSON definition of the flow, which is useful for debugging logic or expressions but does not provide any information about runtime throttling or service protection limits. Option B is wrong because gateway status is relevant only for on-premises data gateways; a shared mailbox in Exchange Online does not use a gateway, so checking gateway status would not help diagnose service protection limits. Option D is wrong because pausing and restarting the flow does not diagnose the root cause; it only temporarily resets the flow's state, and the throttling will reoccur if the underlying limit issue is not addressed.

628
MCQhard

You are a Power BI administrator for a retail company. The sales team uses a Power BI report that connects to an on-premises SQL Server database via an on-premises data gateway. Recently, several users reported that the report is showing stale data. The report is configured to refresh daily at 8:00 AM. Upon investigation, you find that the scheduled refresh failed last night at 8:00 AM with an error: 'The data source credentials could not be encrypted using the gateway's encryption key.' The gateway is installed on a server that was rebooted for maintenance at 7:30 AM. The gateway service account is a local service account. The data source credentials were configured using a SQL Server authentication login. What should you do to resolve the issue?

A.Change the gateway service account to a domain account and reconfigure the data source credentials.
B.In the Power BI Online service, go to the gateway settings and click 'Recover' to restore the encryption key.
C.Restart the on-premises data gateway service on the server.
D.Delete and recreate the data source in the gateway settings.
AnswerB

Recovering the gateway restores the encryption key.

Why this answer

The error 'The data source credentials could not be encrypted using the gateway's encryption key' indicates that the gateway's encryption key was lost or corrupted, which commonly occurs after a server reboot if the key is stored in memory or a volatile location. In the Power BI Online service, the 'Recover' option under gateway settings restores the encryption key from a backup stored in the cloud, allowing the gateway to re-encrypt credentials without reconfiguring the data source. This is the direct fix for the reported error and does not require changing the service account or recreating the data source.

Exam trap

The trap here is that candidates assume a service restart or credential reconfiguration is needed, but the specific encryption key error points to a recoverable state in the Power BI service, not a local service or data source issue.

How to eliminate wrong answers

Option A is wrong because changing the gateway service account to a domain account does not address the lost encryption key; the error is about key encryption, not authentication context. Option C is wrong because restarting the gateway service will not restore a lost encryption key; it only reinitializes the service without recovering the key material. Option D is wrong because deleting and recreating the data source would require re-entering credentials, but the underlying issue is the gateway's inability to encrypt those credentials, which is resolved by recovering the encryption key, not by recreating the data source.

629
MCQhard

Your organisation has a Power Apps canvas app that uses a custom connector to call an external API. The API key is stored in a global variable. What is the security concern with this approach?

A.The custom connector cannot be used with Power Apps.
B.Global variables cannot store API keys because they are read-only.
C.The API key will expire quickly.
D.The API key can be exposed to end users in the app code.
AnswerD

Global variables are part of the app code and can be seen by users with edit permissions or through debugging tools.

Why this answer

Storing an API key in a global variable within a Power Apps canvas app is insecure because the app's code is accessible to end users. Anyone with access to the app can view the global variable's value through the App object or by inspecting the app's formulas, potentially exposing the API key. The correct answer is D.

Option A is incorrect because custom connectors can be used with Power Apps. Option B is incorrect because global variables in Power Apps are writable, not read-only. Option C is incorrect because API keys typically do not expire quickly; the security concern is exposure, not expiration.

630
MCQmedium

A Power Automate flow uses the 'Apply to each' action to process items from a SharePoint list. The flow is running slowly. What is the most effective way to improve performance?

A.Add a 'Condition' action inside the loop.
B.Use a 'Do until' loop instead.
C.Enable concurrency control on the 'Apply to each' action.
D.Reduce the number of items in the list.
AnswerC

Concurrency processes items in parallel.

Why this answer

Enabling concurrency control on the 'Apply to each' action allows multiple iterations to run in parallel, significantly reducing total processing time. Option A adds a condition inside the loop, which does not improve performance and may even add overhead. Option B replaces the loop with a 'Do until' loop, which still processes items sequentially.

Option D reduces the number of items, which is not always feasible and does not improve the flow's efficiency when processing large lists.

631
MCQmedium

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?

A.The refresh frequency is set to daily, which is too infrequent
B.The Excel file is stored in an unsupported location
C.The SQL Server data source requires an on-premises data gateway
D.The dashboard uses two data sources, but only one is allowed
AnswerC

The SQL Server is on-premises (no azure in server name), so a gateway is needed for cloud refresh.

Why this answer

The dashboard refreshes automatically but fails. The data sources shown are an Excel file stored on SharePoint (supported, no gateway needed) and an on-premises SQL Server (server name indicates on-premises). For Power BI service to access on-premises data, an on-premises data gateway must be installed and configured.

Without it, the SQL Server connection will fail during refresh. Options A and D are incorrect because daily frequency and using two data sources are not issues. Option B is incorrect because SharePoint is a supported location for Excel files.

Therefore, the most likely cause is that the SQL Server data source requires an on-premises data gateway.

632
MCQmedium

You are a Power Platform administrator for a government agency that uses Power Pages to provide a public portal for business license renewals. The portal includes a multi-step form for users to enter contact information, business details, and payment. Recently, users have reported that the form frequently times out during the payment step, and some submissions are lost. You need to ensure that partial submissions are saved and users can resume from where they left off. Your solution must minimize development effort and work within Power Pages capabilities. What should you do?

A.Create a Power Automate flow that saves form data to a SharePoint list after each step.
B.Implement an Azure Function that caches form data in a Redis cache and provides a resume endpoint.
C.Use JavaScript to store form data in the browser's local storage and restore it on page load.
D.Enable the 'Save Progress' feature on the multi-step form to allow users to save and resume.
AnswerD

Power Pages provides a built-in 'Save Progress' option for multi-step forms that saves data to Dataverse and allows resumption.

Why this answer

Power Pages multi-step forms support saving partial progress by enabling the 'Save Progress' feature, which stores data in Dataverse and allows users to resume later. Option D directly addresses this requirement without custom development. Option A (Power Automate) would require additional setup and may not preserve form state.

Option B (Azure Functions) is overkill and not needed. Option C (JavaScript local storage) is complex and error-prone, and would not integrate with Power Pages' built-in capabilities.

633
MCQhard

An organization has a model-driven app built on Dataverse. Users report that when they try to save a record, they receive an error about missing required fields, but they believe they filled them in. What is the most likely cause?

A.A business rule is setting a field as required based on conditions
B.The user does not have write permissions to the Dataverse table
C.A Power Automate flow is blocking the save
D.A custom connector is failing to validate data
AnswerA

Correct. A business rule can conditionally require a field, which might not be obvious to the user, leading to the error.

Why this answer

Business rules can dynamically set field requirements based on conditions, which may cause users to see missing required fields even if they filled in all originally required fields. Option B is incorrect because write permissions would prevent saving entirely, not just show missing required fields. Option C is incorrect because Power Automate flows run after a record is saved, not before, so they cannot block the save.

Option D is incorrect because custom connectors are used for integrating external systems, not for Dataverse field validation.

634
MCQmedium

A company uses Power Automate to process purchase orders. After a recent update, the flow fails intermittently with a '429 Too Many Requests' error. What is the most likely cause?

A.The flow uses an expired connector authentication.
B.The flow is running an outdated version.
C.The flow is exceeding Power Platform service protection limits.
D.The data source is temporarily unavailable.
AnswerC

429 errors are throttling responses due to rate limits.

Why this answer

The '429 Too Many Requests' error is an HTTP status code indicating rate limiting. In Power Automate, this occurs when a flow exceeds the Power Platform service protection limits, which are designed to prevent resource overconsumption. These limits include API request caps (e.g., 30 requests per 60 seconds per connection) and daily invocation quotas (e.g., 5,000 requests per day for a per-user plan).

The error is not related to authentication expiry, outdated flow versions, or data source availability.

Exam trap

The trap here is that candidates confuse '429 Too Many Requests' with authentication or connectivity issues, but the exam specifically tests knowledge of Power Platform service protection limits as a distinct throttling mechanism.

How to eliminate wrong answers

Option A is wrong because an expired connector authentication would produce a '401 Unauthorized' or '403 Forbidden' error, not a '429 Too Many Requests' error. Option B is wrong because an outdated flow version does not cause HTTP 429 errors; flow versions affect feature availability but not API rate limits. Option D is wrong because a temporarily unavailable data source would return a '503 Service Unavailable' or connection timeout error, not a rate-limiting 429 response.

635
MCQhard

A canvas app uses a SharePoint list with a choice column 'Status' (Pending, Approved, Rejected). The app needs to filter the gallery to show only 'Pending' items. The list has 50,000 items. Why does the filter not work as expected?

A.The column is not a single line of text
B.The gallery's Items property is set to 'Filter' incorrectly
C.The choice column is non-delegable in Power Apps
D.The filter formula uses the wrong syntax
AnswerC

SharePoint choice columns are not delegable, so Filter runs on all 50,000 items locally.

Why this answer

SharePoint choice columns are non-delegable in Power Apps. When filtering a gallery with a choice column, the filter is applied locally, which fails to return all items when the list exceeds the delegation limit (default 500 items). This explains why filtering for 'Pending' does not work as expected with 50,000 items.

Option A is incorrect because the issue is delegation, not the column type itself (choice columns are delegable for some operations but not for filters with '='). Option B is incorrect because the gallery's Items property is set using the Filter function; the problem is that Filter is non-delegable for choice columns. Option D is incorrect because the syntax is not the issue; the formula may be syntactically correct but still fails due to non-delegable filter.

636
MCQmedium

A company needs to ensure that all Power Apps and Power Automate flows in the 'Development' environment are automatically backed up daily. What should the administrator configure?

A.Enable Dataverse backups for the Development environment
B.Enable the 'Backup Policy' in the Power Platform admin center for the Development environment
C.Schedule a daily export of all solutions using the Power Platform admin center
D.Use the 'Solution Backup' feature in the Power Platform admin center
AnswerA

Incorrect because Dataverse backups only protect database data, not the definitions of Power Apps and Power Automate flows.

Why this answer

Dataverse backups are automatically enabled for environments with a Dataverse database, including the Development environment. These backups occur daily and capture the entire environment state, which includes all data, apps (canvas and model-driven), and Power Automate flows stored within Dataverse. No additional configuration is required, making it the simplest way to ensure automatic daily backups of Power Apps and Power Automate flows.

Exam trap

The trap here is that candidates may confuse the automatic Dataverse backup with a manual export or a configurable backup policy, leading them to select options that require manual intervention or do not exist in the Power Platform admin center.

How to eliminate wrong answers

Option B is wrong because there is no 'Backup Policy' feature in the Power Platform admin center; backups are automatic and not configurable via a policy setting. Option C is wrong because scheduling a daily export of all solutions is not an automated backup mechanism—it is a manual or custom process that requires additional tooling and does not cover all data (e.g., Dataverse tables). Option D is wrong because there is no 'Solution Backup' feature in the Power Platform admin center; solutions can be exported manually, but this is not an automatic daily backup solution.

637
MCQmedium

A company wants to build a mobile app for field service technicians to view and update work orders. The app must work offline when technicians are in areas with no connectivity. Which Power Apps capability should the developer use?

A.Canvas apps from Power Apps Studio
B.Microsoft Dataverse offline profiles
C.Model-driven apps
D.Power Apps mobile app with offline sync
AnswerD

The Power Apps mobile app allows offline data caching and sync.

Why this answer

The Power Apps mobile app includes built-in offline sync capabilities that allow field service technicians to view and update work orders even when there is no network connectivity. Data is cached locally and synchronized with the server once connectivity is restored. Option A is incorrect because while canvas apps can be configured for offline use, the question specifically asks about the capability that enables offline functionality, which is the mobile app's offline sync feature rather than the development tool.

Option B is incorrect because Microsoft Dataverse offline profiles are a configuration option within Dataverse, but the enabling feature for offline use in Power Apps is the mobile app itself. Option C is incorrect because model-driven apps rely on Dataverse and can support offline, but again, the key capability that makes offline possible is the Power Apps mobile app's offline sync, not the app type.

638
MCQmedium

A business needs to build a Power Apps app that allows sales representatives to view customer information and update order status while offline. The data source is Microsoft Dataverse. Which type of Power App should the maker create?

A.Model-driven app with offline profile.
B.Power Pages site.
C.AI Builder model.
D.Canvas app with offline enabled.
AnswerD

Canvas apps can cache Dataverse data for offline use.

Why this answer

Canvas apps can be enabled for offline use with Dataverse, allowing sales reps to view customer information and update order status without connectivity. Option A is incorrect because model-driven apps require online connectivity for full functionality; although offline profiles exist for mobile clients, they do not support all operations like creating new records or updating data while completely offline. Option B is incorrect because Power Pages is for external-facing websites, not offline mobile app scenarios.

Option C is incorrect because AI Builder provides AI capabilities, not offline data access.

639
MCQmedium

A Power App uses a Timer control to refresh data every 5 minutes. The app experiences performance degradation after running for several hours. What is the most likely cause?

A.The Timer control has an internal memory leak
B.The timer interval is too short, causing excessive network calls
C.The app is not using a CDN for static resources
D.The data source is not delegating queries, causing the app to load all data each time
AnswerD

Non-delegable queries load entire dataset, consuming memory

Why this answer

If the data source does not support delegation, Power Apps loads all rows into memory each time the Timer control triggers a refresh. Over several hours, the accumulation of data in memory causes performance degradation. Option A is incorrect: while a Timer control could contribute to memory usage if not properly disposed, it does not inherently have a memory leak.

Option B is incorrect: a 5-minute interval is not excessively short for typical data refresh scenarios. Option C is incorrect: CDNs are used for static content delivery, not for resolving memory buildup from non-delegated queries.

640
MCQeasy

A user creates a model-driven app for incident management. They want a custom button on the Incident form that, when clicked, creates a new activity record of type 'Phone Call' with the incident number in the subject. What is the recommended approach?

A.Define a business rule on the form that creates a new activity when the button is clicked.
B.Create a custom connector to the Dataverse API and use it in the app.
C.Use a Power Automate flow triggered from the button with a Dataverse 'Create a new record' action.
D.Add a custom ribbon button with a JavaScript command that uses Xrm.WebApi.createRecord.
AnswerD

This is the standard, license-efficient method for custom actions in model-driven apps.

Why this answer

Adding a custom ribbon button with a JavaScript command that uses Xrm.WebApi.createRecord allows creating a new activity record with specific values directly from the form. Option A is incorrect because business rules cannot create new records; they can only set field values or show/hide fields. Option B is incorrect because custom connectors are used for external APIs, not for standard Dataverse operations.

Option C is incorrect because while Power Automate flows can create records, they require additional licensing and are more complex than a simple client-side script.

641
MCQmedium

A Power Automate flow that sends approval requests is being used by multiple teams. The flow uses the 'Start and wait for an approval' action. The approver reports that they are not receiving the approval request email. What should you check first?

A.The flow owner's mailbox is full
B.The Approvals connector is not properly configured
C.The flow run history shows a success
D.The approver’s email address is incorrect in the flow
AnswerB

Correct: Misconfiguration can prevent email dispatch.

Why this answer

The 'Start and wait for an approval' action relies on the Approvals connector to send approval requests. If the connector is not properly configured (e.g., missing required connections or permissions), the approval email may not be sent. Option A is wrong because the flow owner's mailbox does not directly affect approval delivery.

Option C is wrong because a successful flow run history indicates the action executed, but does not guarantee the email was delivered. Option D is wrong because the approver's email address is defined within the 'Start and wait for an approval' action; if it were incorrect, the flow would likely fail, but the issue here is about email delivery, not address validity.

Exam trap

The 'Start and wait for an approval' action depends on the Approvals connector being correctly configured; a common mistake is to assume the action will work without verifying connector setup.

642
MCQhard

A model-driven app for project management uses a custom entity 'Project' with a status field. The app maker wants to show a timeline of project phases using a timeline control. What must be configured for the timeline to display correctly?

A.Add a subgrid of project phases and configure it as a timeline.
B.Set the timeline control's date field to the project start date.
C.Create an activity entity for project phases and relate it to the Project entity.
D.Integrate with Microsoft Project for timeline data.
AnswerC

Timeline control displays activities related to the record; an activity entity is needed.

Why this answer

The timeline control requires a relationship to an activity entity (like Appointment) or a custom entity configured as an activity. Option A is wrong because the timeline does not require a specific field. Option B is wrong because timeline does not use subgrid.

Option D is wrong because timeline is not a standard SharePoint integration.

643
MCQeasy

A sales team wants to automate lead assignment based on region without writing code. Which Microsoft Power Platform component should they use?

A.Power Apps
B.Power BI
C.Power Automate
D.Power Virtual Agents
AnswerC

Power Automate enables no-code automation of manual processes like lead assignment.

Why this answer

Power Automate is the correct choice because it enables users to create automated workflows that can assign leads based on region using conditional logic and data from sources like Dynamics 365 or SharePoint, all without writing code. It provides prebuilt connectors and triggers (e.g., 'When a lead is created') to automate business processes seamlessly.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking that building an app is required to automate lead assignment, but Power Automate handles the workflow logic independently without a custom user interface.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom apps, not for automating workflows or lead assignment logic. Option B is wrong because Power BI is a business analytics tool for data visualization and reporting, not for triggering automated actions like lead routing. Option D is wrong because Power Virtual Agents is designed for creating conversational chatbots, not for backend process automation or rule-based lead assignment.

644
MCQmedium

An organization wants to allow external partners to access specific Power Apps and data without granting them full access to the tenant. What should they configure?

A.Use Microsoft Intune to manage partner devices.
B.Create a data loss prevention (DLP) policy that allows external sharing.
C.Invite partners as guest users in Microsoft Entra ID and assign them appropriate security roles in the Power Platform environment.
D.Share the app URL with the partners and ask them to sign in with their own accounts.
AnswerC

Guest users (B2B) can be assigned security roles to access specific resources.

Why this answer

Inviting external partners as guest users in Microsoft Entra ID (formerly Azure AD) and assigning them appropriate security roles in the Power Platform environment is the standard method for providing controlled, least-privilege access to specific Power Apps and their underlying data sources. This approach leverages Microsoft Entra B2B collaboration to create guest identities, which can then be granted access to specific environments and resources without giving them full tenant-level permissions.

Exam trap

The trap here is that candidates often confuse sharing the app URL (Option D) with a valid access method, not realizing that Power Apps requires authenticated users with appropriate permissions in the environment, and simply providing a URL does not grant access unless the user is already a guest or member of the tenant.

How to eliminate wrong answers

Option A is wrong because Microsoft Intune is a mobile device management (MDM) and mobile application management (MAM) solution for managing devices and apps, not a mechanism for granting external users access to Power Apps or data. Option B is wrong because a data loss prevention (DLP) policy controls how data can be shared between connectors and prevents data exfiltration, but it does not provide authentication or authorization for external users to access Power Apps. Option D is wrong because sharing the app URL and asking partners to sign in with their own accounts would require those accounts to be recognized by the tenant (e.g., as guest users) or the app to be publicly accessible, which would bypass security controls and is not a supported method for secure external access.

645
MCQhard

In a model-driven app, a user wants to see a map of all customer addresses on a form. Which feature should be enabled?

A.Notes section
B.Map control
C.Associated View
D.Timeline control
AnswerB

Map control renders addresses on a Bing Maps control.

Why this answer

The Map control in model-driven apps displays addresses on a map. Option A is wrong because the Notes section is for attaching notes to records. Option C is wrong because the Associated View shows related records in a list.

Option D is wrong because the Timeline control shows activities and communications.

646
MCQhard

A company has multiple Power Platform environments. They want to automatically apply consistent settings (e.g., DLP policies, audit settings) to all new environments. What should they do?

A.Use PowerShell scripts to configure each environment after creation.
B.Use Azure Blueprints to define and apply a set of Azure resources.
C.Create an environment group in the Power Platform admin center and assign policies to the group.
D.Use Microsoft Intune to enforce settings on Power Platform environments.
AnswerC

Environment groups allow central management of policies that apply to all environments in the group.

Why this answer

Environment groups in the Power Platform admin center allow administrators to define a set of policies (such as DLP policies and audit settings) that are automatically applied to all environments within the group, including newly created ones. This provides a centralized, no-code method to enforce consistent governance across multiple environments without manual intervention.

Exam trap

The trap here is that candidates may confuse Azure Blueprints (which manage Azure infrastructure) with Power Platform environment governance, or think that PowerShell scripting is the only way to automate settings, overlooking the built-in environment group feature that provides automatic, policy-driven consistency.

How to eliminate wrong answers

Option A is wrong because using PowerShell scripts to configure each environment after creation is a manual, reactive approach that does not automatically apply settings to new environments as they are created, and it requires ongoing maintenance and scripting expertise. Option B is wrong because Azure Blueprints are designed to orchestrate the deployment of Azure resources (e.g., VMs, databases) and are not applicable to managing Power Platform environment settings like DLP policies or audit configurations. Option D is wrong because Microsoft Intune is a mobile device management (MDM) and mobile application management (MAM) tool for managing devices and apps, not for enforcing settings on Power Platform environments.

647
MCQeasy

Refer to the exhibit. A Power Pages developer is creating a custom page template using Liquid. The template includes a reference to a CSS file hosted on the portal's CDN. However, the CSS does not apply when the page is viewed. What is the most likely cause?

A.The page template is missing a DOCTYPE declaration.
B.The CSS file URL is incorrect; it should be a relative path to the web file.
C.The header web template is overriding the CSS.
D.The Liquid syntax for including the header is wrong.
AnswerB

The CSS file URL should be a relative path to the web file stored in the portal; using the direct CDN URL is likely blocked or incorrect.

Why this answer

The exhibit shows a Liquid template that includes a direct CDN URL for a CSS file. In Power Pages, custom CSS files should be referenced using a relative path to the web file stored in the portal, not the full CDN URL. The CDN URL may be blocked by Content Security Policy (CSP) or inaccessible.

Therefore, the most likely cause is that the CSS file URL is incorrect (option B). Option A is incorrect: missing DOCTYPE declaration could cause rendering issues but would not prevent the CSS from loading. Option C is incorrect: while the header web template could override styles, the immediate issue is the incorrect URL.

Option D is incorrect: the Liquid syntax for including the header appears correct, so this does not prevent CSS from applying.

648
MCQmedium

A hospital uses Power Virtual Agents to create a chatbot for patient appointment scheduling. The chatbot needs to check real-time availability from a legacy scheduling system that has an API. What is the best way to integrate?

A.Embed a Power BI report in the chatbot to show availability.
B.Use Power Automate as a custom connector to call the API.
C.Use Power Pages to expose the scheduling system.
D.Create a Power Apps portal for the chatbot to query.
AnswerB

Power Automate can call external APIs and be used as a custom connector for Power Virtual Agents.

Why this answer

B is correct because Power Automate can act as a custom connector to call the legacy scheduling system's API, enabling real-time availability checks. This integration allows the Power Virtual Agents chatbot to trigger a Power Automate flow that queries the API and returns the results directly to the user. It is the most direct and efficient method for connecting to external APIs without additional layers.

Exam trap

The trap here is that candidates often confuse Power Automate's role as a workflow engine with Power Apps or Power Pages, thinking those platforms are needed for API integration, when in fact Power Automate's custom connector is the standard bridge for external APIs in Power Virtual Agents.

How to eliminate wrong answers

Option A is wrong because embedding a Power BI report shows static or pre-aggregated data, not real-time availability from a legacy API, and it cannot perform transactional lookups. Option C is wrong because Power Pages is for building external-facing websites, not for integrating a chatbot with a backend API; it would add unnecessary complexity. Option D is wrong because a Power Apps portal is a low-code app platform, not designed to act as a query interface for a chatbot; it would require building a separate app rather than directly calling the API.

649
MCQeasy

A company wants to build a Power App that uses AI to analyze survey responses and extract sentiment. Which Power Platform capability should they use?

A.Power BI dashboards
B.Power Automate flows
C.AI Builder sentiment analysis model
D.Power Apps Canvas app with formulas
AnswerC

AI Builder offers sentiment analysis as a pre-built model.

Why this answer

AI Builder (C) provides pre-built models for sentiment analysis. A is for reporting. B is for automation.

D is for low-code, not AI.

650
Multi-Selecthard

Which THREE of the following are capabilities of Power Pages? (Choose three.)

Select 3 answers
A.Integrate with Microsoft Copilot Studio for chatbots
B.Real-time co-authoring in Microsoft Word
C.Schedule data refresh for reports
D.Connect to Microsoft Dataverse as a data source
E.Create low-code, responsive websites
AnswersA, D, E

Power Pages supports chatbot integration via Copilot Studio.

Why this answer

Power Pages enables users to create low-code, responsive websites (Option E), integrate with Microsoft Copilot Studio for chatbots (Option A), and connect to Microsoft Dataverse as a data source (Option D). Option B (real-time co-authoring in Word) is not a Power Pages feature; it's related to Office apps. Option C (scheduled data refresh) is a Power BI feature, not Power Pages.

651
MCQhard

A financial services company uses Power Automate to process loan applications. The flow uses the ‘When a new email arrives’ trigger from a shared mailbox. The flow recently stopped working after an admin changed the mailbox permissions. What is the most likely cause?

A.The mailbox exceeded its storage limit
B.The mailbox connection lost permissions to access the mailbox
C.The flow owner's Power Automate license was deleted
D.The flow was transferred to another owner
AnswerB

Permission changes can invalidate the existing connection, causing the trigger to fail.

Why this answer

The flow uses the 'When a new email arrives' trigger, which relies on a connection to the shared mailbox. When an admin changes mailbox permissions, the existing connection loses its authorization to access the mailbox, causing the trigger to fail. This is the most direct cause because the connection object in Power Automate must have valid permissions to read emails from the specified mailbox.

Exam trap

The trap here is that candidates may confuse a permissions issue with a storage limit or license problem, but the trigger's dependency on a valid connection object makes permission changes the immediate and most likely cause.

How to eliminate wrong answers

Option A is wrong because exceeding the mailbox storage limit would cause new emails to be rejected or bounce, but the flow trigger would still attempt to run and fail with a different error (e.g., mailbox full), not a permissions-related failure. Option C is wrong because deleting the flow owner's Power Automate license would disable the flow entirely or prevent it from being saved/run, but the scenario specifies the flow stopped working after a permissions change, not a license change. Option D is wrong because transferring the flow to another owner does not inherently break the mailbox connection; the new owner would need to re-authenticate, but the trigger failure is directly tied to the permissions change, not ownership transfer.

652
Multi-Selecthard

Which THREE factors determine the capacity limits (database, file, log) of a Power Platform environment? (Choose three.)

Select 3 answers
A.Environment type (production vs. sandbox)
B.Number of licensed users in the tenant
C.Environment geographic region
D.Base license type (Power Apps, Power Automate, Dynamics 365)
E.Purchased capacity add-ons
AnswersA, D, E

Sandbox environments have reduced capacity limits.

Why this answer

Environment type (production vs. sandbox) directly determines the default capacity limits for database, file, and log storage. Production environments receive higher default entitlements, while sandbox environments are capped at 1 GB of database capacity, ensuring that testing does not consume production resources.

Exam trap

The trap here is that candidates often confuse tenant-wide capacity pooling with per-environment limits, mistakenly thinking the number of licensed users directly sets each environment's cap, when in fact the environment type and base license type are the primary determinants.

653
MCQmedium

A financial services firm needs to create a compliance dashboard for regulators. The dashboard must display real-time data from multiple sources, including on-premises SQL Server and Dataverse. The firm requires interactive visualizations and the ability to drill down to transaction details. They also need to ensure that sensitive data is masked for certain users. Which Power Platform components should they use?

A.Power Automate, AI Builder, and Power BI
B.Power BI, on-premises data gateway, and Dataverse
C.Copilot Studio, Power BI, and Dataverse
D.Power Apps, Dataverse, and Power Automate
AnswerB

Power BI provides dashboards with RLS, gateway connects to on-premises SQL, Dataverse is another data source.

Why this answer

The scenario requires real-time data from on-premises SQL Server and Dataverse, which necessitates an on-premises data gateway for live connectivity. Power BI provides the interactive visualizations and drill-down capabilities, while Dataverse serves as the unified data source for compliance data. The combination of these components enables real-time dashboards with role-based security for data masking.

Exam trap

The trap here is that candidates often confuse Power Automate or Power Apps as dashboard tools, but the question specifically requires interactive visualizations and drill-downs, which are core Power BI capabilities, not automation or app-building features.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool, not a data visualization or dashboard component, and AI Builder is for AI model integration, not real-time data masking or drill-downs. Option C is wrong because Copilot Studio is designed for building conversational AI bots, not for creating compliance dashboards or handling data masking. Option D is wrong because Power Apps is for building custom applications, not for interactive visualizations or drill-down analytics, and Power Automate does not provide dashboard capabilities.

654
MCQeasy

You need to create a flow that sends an email notification when a new file is added to a OneDrive for Business folder. Which trigger should you use?

A.When a file is created (SharePoint)
B.When a file is modified (OneDrive for Business)
C.When a file is created (OneDrive for Business)
D.When a file is created (OneDrive)
AnswerC

This trigger fires when a new file is added to OneDrive for Business.

Why this answer

The requirement specifies a OneDrive for Business folder, and the 'When a file is created (OneDrive for Business)' trigger is the only one that directly monitors a OneDrive for Business location for new file additions. This trigger uses the OneDrive for Business connector, which is designed to work with the Microsoft Graph API for OneDrive for Business, and it fires specifically when a new file is created, not modified.

Exam trap

The trap here is that candidates confuse the 'OneDrive' and 'OneDrive for Business' connectors, assuming they are interchangeable, but they target different services with different authentication and API scopes.

How to eliminate wrong answers

Option A is wrong because the 'When a file is created (SharePoint)' trigger monitors SharePoint document libraries, not OneDrive for Business folders; using it would require a SharePoint site and library, which is a different storage service. Option B is wrong because the 'When a file is modified (OneDrive for Business)' trigger fires when an existing file is changed, not when a new file is added, so it does not meet the requirement to trigger on file creation. Option D is wrong because the 'When a file is created (OneDrive)' trigger targets the consumer OneDrive service (personal Microsoft account), not OneDrive for Business (work or school account), and these are separate connectors with different authentication and API endpoints.

655
MCQmedium

Refer to the exhibit. You are reviewing the app definition XML for a model-driven app. Based on the exhibit, which tables are included in the app?

A.Account, contact, opportunity, lead
B.Account, contact
C.Account, contact, opportunity
D.Account, contact, opportunity, salesDashboard
AnswerC

These are the three table components listed.

Why this answer

The <component> elements list account, contact, and opportunity, which are the tables included in the app. Option A is incorrect because 'lead' is not listed among the components; Option B is incorrect because it omits 'opportunity'; Option D is incorrect because 'salesDashboard' is a dashboard component, not a table.

656
MCQeasy

A user wants to create a Power Apps canvas app that displays data from an Excel spreadsheet stored in Microsoft OneDrive for Business. Which connector should be used?

A.Dataverse connector
B.OneDrive for Business connector
C.SharePoint connector
D.Excel Online (Business) connector
AnswerD

This connector works with Excel files in OneDrive for Business.

Why this answer

The correct connector for accessing an Excel spreadsheet stored in OneDrive for Business is the Excel Online (Business) connector. This connector enables Power Apps to read and write data from Excel files hosted in OneDrive or SharePoint. Option A (Dataverse) is a database service, not for file storage.

Option B (OneDrive for Business connector) is for file and folder operations, but not for reading Excel data directly. Option C (SharePoint connector) is for SharePoint lists and libraries, but the question specifies OneDrive storage, not SharePoint. Therefore, Option D is correct.

657
MCQmedium

You have a model-driven app that includes a custom table. You need to add a field that calculates a value based on other fields (e.g., total price = quantity * unit price). Which type of field should you create?

A.Calculated field
B.Text field
C.Choice field
D.Rollup field
AnswerA

Calculated fields allow formulas that compute values from other fields.

Why this answer

Calculated fields perform calculations at the data source level, such as total price = quantity * unit price. Option A is correct. Option B is wrong because text fields store plain text, not calculations.

Option C is wrong because choice fields provide a dropdown list of options. Option D is wrong because rollup fields aggregate data from related records, not compute values from fields in the same record.

658
MCQeasy

An organization needs to allow external vendors to log in to a Power Pages site using their existing Microsoft Entra ID accounts. What authentication provider should be configured?

A.Microsoft Entra ID provider
B.OAuth 2.0 provider
C.Local authentication provider
D.Microsoft Account provider
AnswerA

Microsoft Entra ID allows vendors to sign in with their work accounts.

Why this answer

Microsoft Entra ID (formerly Azure AD) is the correct provider for organizational accounts. The local provider is for internal users. OAuth 2.0 is a protocol, not a provider name. 'Microsoft Account' is for personal accounts.

659
MCQmedium

You are reviewing a Power Automate flow definition. The exhibit shows an action definition. What is the action doing?

A.Sending an email to multiple recipients.
B.Sending an email with an attachment.
C.Checking if a condition is true before sending.
D.Sending an email to a single recipient.
AnswerD

The operation is SendEmailV2 with a single To address.

Why this answer

The SendEmailV2 action typically includes a 'To' parameter that accepts a single email address (or a dynamic value resolving to one address). The exhibit does not show multiple recipients, attachments, or condition checks. Option A is incorrect as multiple recipients would require semicolons or an array.

Option B is incorrect because no attachment parameter is visible. Option C is incorrect because the action sends an email, not checks a condition.

660
MCQeasy

A business analyst wants to create a simple expense report app without writing code. The app should allow users to submit expenses and managers to approve or reject them. Which type of Power App should the analyst use?

A.Canvas app
B.Power Pages
C.Copilot Studio
D.Model-driven app
AnswerA

Canvas apps are designed for simple form-based apps with drag-and-drop ease

Why this answer

Canvas apps (Option A) are the correct choice because they allow business analysts to build custom apps without writing code, using drag-and-drop interfaces. They are ideal for simple forms like expense reports. Option B (Power Pages) is for creating external-facing websites, not apps.

Option C (Copilot Studio) is for building conversational AI chatbots. Option D (Model-driven apps) requires a Dataverse database and schema, which adds complexity and is not necessary for a simple expense report app.

661
Multi-Selectmedium

Which THREE are valid trigger types in Power Automate? (Select THREE.)

Select 3 answers
A.Scheduled
B.Business process flow
C.Instant
D.Manual
E.Automated
AnswersA, C, E

Triggers based on a schedule (recurrence).

Why this answer

Options A, C, and E are correct. The three main trigger types in Power Automate are Automated (e.g., when an email arrives), Instant (e.g., button trigger), and Scheduled (e.g., recurrence). Option B (Business process flow) is not a trigger type; it is a feature for modeling business processes.

Option D (Manual) is not a separate trigger type; manual triggers are covered under Instant triggers.

662
MCQeasy

Refer to the exhibit. You deploy this ARM template to create a Power Apps environment. What will be the SKU of the created environment?

A.Production
B.Sandbox
C.Developer
D.Trial
AnswerA

The template explicitly sets environmentSku to Production.

Why this answer

The property 'environmentSku' is set to 'Production'. Options B, C, and D are incorrect because they do not match the value in the template.

663
MCQeasy

A nonprofit organization needs to track donations and volunteers using a custom app without writing code. Which Power Platform tool should they use?

A.Power BI
B.Power Pages
C.Power Automate
D.Power Apps
AnswerD

Power Apps enables building custom apps without code.

Why this answer

Power Apps allows building custom apps with low-code or no-code. Power Automate is for automation, Power BI for analytics, and Power Pages for portals.

664
Multi-Selecthard

Which THREE components are required to create an automated approval process using Power Automate and Microsoft Teams?

Select 3 answers
A.A 'Start and wait for an approval' action
B.A manual button to start the flow
C.A trigger such as 'When a new response is submitted' from Microsoft Forms
D.A SharePoint list to store approval history
E.A 'Post a message in a chat or channel' action to notify the approver
AnswersA, C, E

This action creates and waits for the approval.

Why this answer

Options A, C, and E are correct because they represent the trigger, approval action, and notification. Option B is wrong because it's for manual triggers. Option D is wrong because it's not required for approvals.

665
MCQhard

You are troubleshooting a Power Automate flow that uses an HTTP action to call a REST API. The flow fails with a '429 Too Many Requests' error. The API has a rate limit of 100 requests per minute. Which strategy should you implement to handle this error gracefully?

A.Implement retry logic with exponential backoff in the HTTP action settings.
B.Increase the flow's concurrency setting to process more requests simultaneously.
C.Use a 'Condition' action to check the status code and ignore 429 errors.
D.Use the 'Configure Run After' option to skip the action on failure.
AnswerA

Exponential backoff reduces request rate after 429 responses.

Why this answer

Implementing retry logic with exponential backoff allows the flow to automatically retry the request after a delay that increases with each attempt, which is the standard approach to handle rate limiting (HTTP 429 errors) and reduces server load. Option B is wrong because increasing concurrency would send more requests simultaneously, likely exacerbating the rate limit issue. Option C is wrong because simply ignoring 429 errors means requests are not retried and the action fails.

Option D is wrong because 'Configure Run After' can handle failures but does not implement backoff, so it would not effectively manage rate limits.

666
MCQhard

An organization plans to deploy a Power Platform solution that uses Dataverse as the data source. They need to ensure that users can only see records from their own department. What should they implement?

A.Power Automate to filter records
B.Audit logging
C.Column-level security profiles
D.Business units and security roles with team-based access
AnswerD

Business units and security roles can restrict record visibility per department.

Why this answer

Business units and security roles with team-based access are the correct implementation because Dataverse uses a hierarchical security model where business units define the organizational structure and security roles control record-level permissions. By configuring business units per department and assigning users to teams within those units, you can enforce that users only see records belonging to their own department through record ownership and sharing rules.

Exam trap

The trap here is that candidates confuse column-level security (which controls field visibility) with record-level security (which controls row visibility), leading them to choose option C when the requirement is about seeing entire records from their own department.

How to eliminate wrong answers

Option A is wrong because Power Automate is an automation tool, not a data access control mechanism; filtering records via a flow would be inefficient, bypass security model enforcement, and could be circumvented by direct API queries. Option B is wrong because audit logging tracks who accessed or modified records but does not restrict visibility; it is a monitoring feature, not a permission control. Option C is wrong because column-level security profiles restrict access to specific columns (fields) within a record, not to entire records; they cannot limit which rows a user sees based on department.

667
Multi-Selecteasy

Which TWO of the following are benefits of using Microsoft Power Platform for business users?

Select 2 answers
A.Reduced dependency on IT for simple solutions.
B.Citizen developers can build apps without writing code.
C.Ability to use custom code in production environments.
D.Automatic generation of revenue from builds.
AnswersA, B

Business users can solve problems independently.

Why this answer

Power Platform empowers business users to create solutions with minimal code and automate processes. Option C describes a technical benefit for developers, and Option D is not a direct business user benefit.

668
MCQmedium

You are a Power Platform administrator for a medium-sized business. The company uses Power Apps and Power Automate extensively. The development team has requested the ability to create their own sandbox environments for testing without waiting for IT. However, the security team requires that all environments be subject to data loss prevention (DLP) policies and that environment creation be tracked. You need to design a solution that allows developers to self-service environment creation while maintaining governance. The developers currently have Power Apps Plan 2 licenses. What should you do?

A.Assign the Power Platform Administrator role to all developers.
B.Disable environment creation for non-admins and have developers submit requests to IT.
C.Install the CoE Starter Kit and configure the environment creation policy to allow all users.
D.Create a security group in Microsoft Entra ID, add developers, and configure tenant settings to allow only members of that group to create environments. Enable audit logging.
AnswerD

This enables self-service while restricting creation to approved users and tracking activity.

Why this answer

The best approach is to create a security group in Microsoft Entra ID, add developers to it, and then configure the tenant settings to allow that group to create environments. Additionally, enable audit logging to track creation. Option A is incorrect because assigning the Power Platform Administrator role gives too much privilege.

Option B is incorrect because disabling creation for non-admins prevents self-service. Option C is incorrect because the CoE Starter Kit is for governance but does not directly enable self-service creation.

669
MCQeasy

An organization wants to enable Microsoft Copilot Studio (formerly Power Virtual Agents) to answer questions from employees about company policies. The chatbot must only use internal company documents stored in SharePoint as its knowledge source. Which configuration should the administrator use?

A.Enable the 'Use generative AI' feature in the Power Platform admin center
B.Deploy a custom connector to SharePoint
C.Create a Power Automate flow to fetch data from SharePoint and pass it to the chatbot
D.Add a SharePoint knowledge source in Copilot Studio and configure authentication to use the company's Microsoft Entra ID
AnswerD

This allows the chatbot to access SharePoint documents securely.

Why this answer

Microsoft Copilot Studio allows administrators to add SharePoint as a knowledge source directly, enabling the chatbot to retrieve answers from internal documents without custom development. Configuring authentication with Microsoft Entra ID ensures that only authorized users can access the company policies, maintaining security and compliance.

Exam trap

The trap here is that candidates may overcomplicate the solution by thinking a custom connector or Power Automate flow is required, when in fact Copilot Studio's native SharePoint integration handles the connection directly.

How to eliminate wrong answers

Option A is wrong because the 'Use generative AI' feature in the Power Platform admin center is a tenant-level setting that enables AI capabilities across environments, but it does not directly connect a chatbot to SharePoint documents as a knowledge source. Option B is wrong because deploying a custom connector to SharePoint is unnecessary and overly complex; Copilot Studio natively supports SharePoint as a knowledge source without requiring custom connectors. Option C is wrong because creating a Power Automate flow to fetch data from SharePoint and pass it to the chatbot introduces unnecessary latency and complexity, whereas Copilot Studio can directly query SharePoint using its built-in integration.

670
MCQhard

A Power Platform administrator is configuring data loss prevention (DLP) policies. The company uses Power Automate flows that connect to Microsoft SharePoint and Microsoft Teams. The security team wants to block any flow from sending data from SharePoint to unsanctioned third-party services. Which DLP policy configuration should the administrator apply?

A.Create a policy that only applies to non-production environments
B.Classify SharePoint as Business and all third-party services as Blocked
C.Classify SharePoint as Business and all third-party services as Non-Business
D.Classify all connectors as Blocked
AnswerB

Blocked group prevents any connection to those services.

Why this answer

DLP policies in Power Platform allow administrators to classify connectors into Business, Non-Business, and Blocked categories. By classifying SharePoint as Business and all third-party services as Blocked, the administrator ensures that no flow can send data from SharePoint to unsanctioned third-party connectors, as blocked connectors cannot be used in any flow that also uses a Business connector. This directly enforces the security team's requirement to prevent data exfiltration to unsanctioned services.

Exam trap

The trap here is that candidates often confuse 'Non-Business' with 'Blocked', not realizing that Non-Business connectors can still be used in flows alongside Business connectors, whereas only the Blocked category prevents data from being sent to those services entirely.

How to eliminate wrong answers

Option A is wrong because applying a policy only to non-production environments would not protect production flows that connect SharePoint to unsanctioned third-party services, leaving the security requirement unmet. Option C is wrong because classifying third-party services as Non-Business would still allow flows to use both Business (SharePoint) and Non-Business connectors in the same flow, which does not block data from being sent to those services—only the 'Blocked' category prevents connector usage entirely. Option D is wrong because classifying all connectors as Blocked would prevent all flows from using any connector, including SharePoint and Teams, which would break legitimate business flows and is not the targeted restriction the security team requires.

671
MCQhard

An organization uses Power Apps to submit expense reports. The app connects to Dataverse. Users report that some submissions fail with a 'table not found' error. The developer verified the table exists. What is the most likely cause?

A.The table has a missing required column
B.The table was renamed after the app was published
C.The app's service principal lacks read permissions on the table
D.The app uses a deprecated connector
AnswerC

The app's service principal lacking read permissions can result in a 'table not found' error even though the table exists, because the app cannot access it.

Why this answer

The 'table not found' error despite the table existing most likely indicates a permissions issue. Option C is correct because if the app's service principal lacks read permissions, the app cannot access the table, resulting in a 'not found' error. Option A is wrong because a missing required column would cause a validation or submission error, not a 'table not found' error.

Option B is wrong because the developer verified the table exists, so renaming would have been noticed. Option D is wrong because a deprecated connector would cause connection issues, not a table-specific error.

672
Multi-Selecthard

Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)

Select 3 answers
A.Formula bar
B.Solution Explorer
C.Tree view
D.Property pane
E.Report Designer
AnswersA, C, D

Correct: Used to write Power Fx formulas.

Why this answer

Options A, C, and D are correct because Power Apps Studio for building canvas apps includes the Formula bar, Tree view, and Property pane. Option B (Solution Explorer) is incorrect because it is a component of Power Apps for model-driven apps, not canvas apps. Option E (Report Designer) is incorrect because it is a component of Power BI, not Power Apps Studio.

673
MCQmedium

A user created a canvas app to collect feedback. The app writes data to an Excel file stored in OneDrive. When multiple users submit feedback simultaneously, some entries are lost. What is the most likely cause?

A.The app has a performance issue
B.The Excel file is locked by OneDrive sync
C.A Power Automate flow is delaying the write
D.Excel is not designed for concurrent multi-user writes
AnswerD

Excel cannot handle simultaneous writes; data conflicts or loss occurs.

Why this answer

Excel is not designed for concurrent multi-user writes. When multiple users submit data simultaneously, conflicts and data loss occur. Option A is incorrect because the issue is not performance but concurrency.

Option B is incorrect because OneDrive sync does not lock the file in a way that causes data loss; the underlying problem is Excel's lack of concurrent write support. Option C is incorrect because a Power Automate flow would not cause entries to be lost; it might introduce delays but not data loss.

674
MCQhard

A Power App connected to Dataverse uses a column of type 'Choice' with two options: 'Active' and 'Inactive'. The app needs to display only active records by default. Which filter expression should be used in the app's OnStart property?

A.Filter(Accounts, Status = 'Active')
B.Filter(Accounts, "Status" = 'Active')
C.Filter(Accounts, Status = "Active")
D.Filter(Accounts, "Status" = "Active")
AnswerA

Correct. Uses proper syntax: column name (no quotes) = 'Choice value'.

Why this answer

Uses the correct syntax: Filter(Accounts, Status = 'Active') with no quotes around the column name and single quotes around the choice value. Option D incorrectly uses double quotes around both the column name and value, which will cause an error. Options B and C also have wrong quotation usage.

Therefore, only Option A is correct.

675
Multi-Selecteasy

Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)

Select 2 answers
A.On-premises SQL Server
B.On-premises Oracle Database
C.On-premises SAP HANA
D.Dataverse
E.SharePoint Online
AnswersD, E

Dataverse is a cloud data source that does not require a gateway.

Why this answer

The correct answers are D (Dataverse) and E (SharePoint Online). Both are cloud-based data sources that can be directly accessed in a canvas app without needing an on-premises data gateway. On-premises data sources such as SQL Server, Oracle Database, and SAP HANA (options A, B, and C) require a gateway to connect from a cloud canvas app.

Page 8

Page 9 of 13

Page 10