Courseiva

Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 676–701

701 questions total · 10pages · All types, answers revealed

Data quality score: 70/100 — Review before indexing

2 errors found across 26 questions. This page is set to noindex until issues are resolved.

Page 9

Page 10 of 10

676
Multi-Selectmedium

A maker is building a canvas app that will be used by employees to submit expense reports. The app must allow users to enter multiple line items for each expense report, and the maker wants to store the data in Microsoft Dataverse. The maker needs to choose appropriate controls for the app. Which two controls should the maker use to allow users to enter and manage multiple line items? (Choose two.)

Select 2 answers
A.Gallery control
B.Form control in Edit mode
C.Text input control
D.Data table control
E.Timer control
AnswersA, D

A Gallery control is used to display and manage multiple records, such as expense line items. It can be bound to a collection or a Dataverse table and allows users to view, select, and edit multiple items. For expense reports, a gallery can show each line item and provide a way to add, edit, or remove items, making it ideal for managing multiple entries.

Why this answer

To manage multiple line items, the maker should use a Gallery control or a Data table control. Both allow users to view and edit multiple records in a structured way. A gallery provides flexibility in layout and can contain various controls for each item, while a data table offers a compact grid for inline editing.

These controls enable efficient entry and management of multiple expense line items within the canvas app.

Exam trap

The trap here is thinking that a Form control can handle multiple line items, but it is designed for a single record and cannot natively display or edit a collection of items.

677
MCQeasy

A sales team needs an app to track customer interactions. The app should display a list of accounts, and when an account is selected, show related opportunities and contacts. Which type of app is best suited?

A.Canvas app
B.Power BI dashboard
C.Chatbot in Power Virtual Agents
D.Model-driven app
AnswerD

Model-driven apps generate UI directly from the Dataverse data model, so defining relationships between accounts, opportunities and contacts produces the list-and-related-records navigation automatically, with no manual screen wiring. This satisfies the requirement to show related opportunities and contacts when an account is selected.

Why this answer

Model-driven apps are ideal for complex, data-centric scenarios where the app is built on top of Microsoft Dataverse. They automatically generate a UI based on the data model, including relationships between entities like Account, Opportunity, and Contact. When an account is selected, the app can display related records through built-in navigation and subgrids, exactly as required.

This makes model-driven apps the best fit for tracking customer interactions with linked entities.

Exam trap

PL-900 often tests the distinction between canvas apps (for custom UI and task-specific apps) and model-driven apps (for data-centric, relationship-based apps), so candidates may incorrectly choose canvas apps when the requirement emphasizes automatic relationship navigation.

How to eliminate wrong answers

Option A is wrong because canvas apps are designed for pixel-perfect, task-specific interfaces and do not automatically generate UI from data relationships; building the required linked views would require manual configuration. Option B is wrong because Power BI is a business analytics service for visualizing data, not for creating interactive data-entry or relationship-navigation apps. Option C is wrong because Power Virtual Agents is used to build chatbots for conversational interactions, not for displaying and navigating relational business data.

678
MCQmedium

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

A.Microsoft Dataverse
B.SharePoint lists
C.Azure SQL Database
D.Excel Online
AnswerA

Microsoft Dataverse is the native data service for Power Platform, exposing tables through a common connector so Power Apps, Power Automate and Power BI all read and write the same governed data. That shared layer is precisely the centralised repository the organisation requires.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

679
MCQhard

A global organization has multiple geographic regions and needs to comply with data residency requirements. Each region must have its own Power Platform environment with data stored locally. What is the recommended approach to manage these environments?

A.Use Microsoft Entra ID conditional access policies to enforce data location.
B.Create separate tenants for each region.
C.Create separate environments for each region within the same tenant.
D.Create a single environment and use data policies to restrict data access by region.
AnswerC

Separate environments within one tenant let each region's Dataverse data reside in its own geographic instance, meeting data residency rules while centralising administration and licensing. A single shared environment cannot guarantee regional data storage, and separate tenants add unnecessary identity overhead.

Why this answer

Power Platform environments are the recommended isolation boundary for data residency. Each environment can be created in a specific geographic region (e.g., Australia, Europe) within the same tenant, ensuring data is stored locally per region while maintaining a single tenant for centralized administration and licensing.

Exam trap

The trap here is that candidates confuse data residency (physical storage location) with data access control (policies or conditional access), leading them to choose Option A or D, which address access restrictions but not storage location.

How to eliminate wrong answers

Option A is wrong because Microsoft Entra ID conditional access policies control authentication and access to services, not the physical storage location of data; they cannot enforce where Power Platform data is stored. Option B is wrong because creating separate tenants for each region introduces unnecessary administrative overhead, breaks cross-region collaboration, and violates the principle of a single identity and management plane; Power Platform supports multiple environments per tenant for this exact purpose. Option D is wrong because a single environment stores all data in one geographic location, and data policies (e.g., DLP policies) only restrict how data flows between connectors, not where data is physically stored.

680
MCQmedium

A company wants to create a public-facing website for customers to submit support tickets, view their ticket history, and update their profile information. Non-authenticated users should only see a welcome page and login option. Which Power Pages feature should be used to control access to pages based on authentication status?

A.Content snippets
B.List forms
C.Page permissions
D.Page templates
AnswerC

Page permissions define which web roles can access specific pages, letting you hide ticket and profile pages from anonymous visitors while exposing only the welcome and login pages. This satisfies the requirement to control access based on authentication status.

Why this answer

Page permissions in Power Pages control which web roles can access specific pages, and they can be configured to allow or deny access based on authentication status. By setting page permissions appropriately, you can restrict non-authenticated users to only the welcome and login pages.

Exam trap

PL-900 often tests the confusion between content management features (snippets, templates) and security features (page permissions) — candidates may pick a presentation feature instead of the access control feature.

How to eliminate wrong answers

Option A is wrong because content snippets are reusable HTML/Text fragments, not access control mechanisms. Option B is wrong because list forms display Dataverse records but do not control page access. Option D is wrong because page templates define layout and structure, not authorization.

681
MCQmedium

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

A.Update the app version number
B.Optimize data source connections and queries
C.Increase the app icon size
D.Change the app's background color
AnswerB

Slow mobile loading typically stems from inefficient queries and excessive data retrieval over constrained networks. Optimising data source connections and queries reduces payload size and round trips, directly addressing the performance constraint rather than cosmetic UI changes.

Why this answer

Optimizing data source connections and queries directly reduces the amount of data transferred and the number of round trips between the Canvas app and its data source (e.g., Dataverse, SharePoint, SQL). On mobile devices, network latency and bandwidth are often constrained, so inefficient queries (e.g., loading all records instead of using filters) cause significant slowdowns. This is the primary performance lever for Canvas apps, as per Microsoft's guidance on app optimization.

Exam trap

The trap here is that candidates confuse cosmetic or metadata changes (version, icon, color) with performance optimizations, overlooking that data source efficiency is the root cause of slow loading in Canvas apps on mobile devices.

How to eliminate wrong answers

Option A is wrong because updating the app version number does not affect runtime performance; it only changes the version metadata and may trigger a re-publish, but does not optimize data retrieval or rendering. Option C is wrong because increasing the app icon size has no impact on load time; it only changes the visual asset displayed on the device home screen, not the app's internal data flow. Option D is wrong because changing the app's background color is a purely cosmetic change that does not influence network requests, data caching, or rendering performance.

682
MCQeasy

A Power Pages site needs to display a dynamic banner that changes based on the user's language preference. The banner text is stored in multiple languages. Which Power Pages feature should be used to manage the multilingual content?

A.Web templates
B.Content snippets
C.Basic forms
D.Page templates
AnswerB

Content snippets store reusable text fragments keyed by language, so the banner renders the correct translation for each visitor's preference. This satisfies the multilingual display requirement directly, unlike page-level localisation or hard-coded text. Power Pages resolves the snippet against the user's language setting at render time, keeping one banner component dynamic across all supported languages.

Why this answer

Content snippets in Power Pages store reusable text or HTML fragments that can be referenced across pages and are the standard mechanism for multilingual content, since each snippet can have language-specific values. A dynamic banner whose text varies by the user's language preference is exactly the use case content snippets are designed for.

Exam trap

PL-900 often tests the difference between structural components (web templates, page templates) and content components (content snippets) — candidates who pick web templates confuse layout with localized text.

How to eliminate wrong answers

Option A is wrong because web templates are Liquid/HTML code templates that render page structure, not localized text content — they do not natively manage per-language strings. Option C is wrong because basic forms render Dataverse table records for input, not localized banner text. Option D is wrong because page templates define the layout and structure of pages, not the multilingual content displayed within them.

683
MCQeasy

A user needs to create a Power Automate cloud flow that runs every weekday at 8:00 AM to send a reminder email. Which trigger should the user select?

A.Recurrence
B.When a new email arrives (Outlook)
C.Manually trigger a flow
D.When an item is created (SharePoint)
AnswerA

The 'Recurrence' trigger allows scheduling a flow to run at specified intervals, such as daily, weekly, or monthly, and you can set specific days and times. It is the correct choice for running a flow every weekday at 8:00 AM. This trigger is designed exactly for time-based automation.

Why this answer

The 'Recurrence' trigger is specifically designed for time-based scheduling, allowing configuration of frequency, time zone, and specific days. It is the only trigger among the options that can run automatically every weekday at a set time. The other triggers are event-driven and would not initiate the flow on a schedule.

Exam trap

The trap here is assuming that an email trigger can be scheduled; it only runs when an email arrives, not at a specific time.

684
Multi-Selecteasy

Which TWO of the following are valid reasons to create multiple Power Platform environments?

Select 2 answers
A.To increase the total storage capacity available.
B.To isolate data for different business units or projects.
C.To improve performance of Power Automate flows.
D.To separate development, testing, and production workloads.
E.To reduce the cost of Power Apps licenses.
AnswersB, D

Isolation helps with data governance and security.

Why this answer

Power Platform environments act as security and data boundaries, allowing organizations to isolate data for different business units or projects. Each environment has its own Dataverse database, which prevents data leakage and enables role-based access control tailored to specific teams or initiatives.

Exam trap

The trap here is that candidates may confuse environment isolation with performance or cost benefits, but the PL-900 exam specifically tests the understanding that environments are primarily for data and workload separation, not for scaling or licensing savings.

685
MCQhard

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

A.The Office 365 connector is conflicting with the SQL connector.
B.The flow is using the cloud SQL connector without an on-premises data gateway.
C.The environment type is Production, which restricts access to on-premises data.
D.The region 'eastus' does not support on-premises connectivity.
AnswerB

The cloud SQL connector reaches only internet-accessible databases; on-premises SQL Server requires an on-premises data gateway to bridge the network boundary. Without that gateway installed and configured, the flow's connection attempt fails, matching the exhibit's error.

Why this answer

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

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

Exam trap

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

How to eliminate wrong answers

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

686
MCQmedium

Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?

A.When an email with an attachment arrives
B.When a high-importance email arrives
C.When an email is modified in the Inbox
D.When an email with 'Invoice' in the subject arrives in the Inbox
AnswerD

The trigger's JSON defines a condition on the email subject containing the keyword 'Invoice', scoped to the Inbox folder. The flow fires only when an arriving message satisfies that subject filter, so mail without 'Invoice' in the subject will not start the run.

Why this answer

The trigger fires when a new email arrives in the Inbox with 'Invoice' in the subject. Option A is wrong because 'fetchOnlyWithAttachment' is set to false, so it will trigger even without attachments. Option B is wrong because 'importance' is set to 'Any', so it is not filtering by high importance.

Option C is wrong because the trigger is on new email arrival, not on email modification.

687
MCQmedium

An organization has several Power Platform environments used for development and testing. They want to prevent accidental deletion of important data. What strategy should they implement?

A.Regularly export all data to Excel files and store them in OneDrive.
B.Set environment capacity limits to prevent storage of excessive data.
C.Enable versioning on all SharePoint lists used by Power Apps.
D.Use the Power Platform admin center to configure environment backups and enable solution checker.
AnswerD

Backups allow recovery; solution checker helps enforce best practices to avoid data loss.

Why this answer

The Power Platform admin center provides automated daily backups (with a 28-day retention for production environments) and allows manual backups, which directly protects against accidental data loss. Enabling solution checker is a separate best practice for quality assurance, but the core strategy for preventing accidental deletion is leveraging the built-in backup and restore capabilities.

Exam trap

The trap here is that candidates may confuse data protection strategies (like backups) with data governance tools (like capacity limits or solution checker), or assume that manual exports to Excel are a sufficient enterprise-grade backup solution.

How to eliminate wrong answers

Option A is wrong because manually exporting data to Excel files stored in OneDrive is not a scalable or reliable strategy; it introduces human error, lacks automation, and does not provide point-in-time restore capabilities for the entire environment. Option B is wrong because setting environment capacity limits prevents storage of excessive data but does not protect against accidental deletion of existing important data; it only caps future growth. Option C is wrong because versioning on SharePoint lists only protects data within SharePoint lists used by Power Apps, not the entire Power Platform environment (including Dataverse tables, flows, and apps), and does not provide environment-level backup or restore.

688
MCQeasy

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

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

Power BI connects directly to SQL databases and provides real-time dashboards through its data gateway and streaming datasets. It is the Power Platform visualisation tool, satisfying the requirement for a live sales dashboard, whereas Power Apps and Power Automate handle app building and workflow automation.

Why this answer

Power BI is the correct tool because it is designed specifically for data visualization and business analytics, capable of connecting directly to a SQL database to create real-time dashboards. It supports DirectQuery or live connections to SQL Server, enabling near-real-time updates without requiring data to be imported into a separate store.

Exam trap

The trap here is that candidates may confuse Power Apps' ability to display data in galleries or forms with the dedicated dashboard and visualization capabilities of Power BI, but Power Apps lacks native real-time SQL dashboarding features and is not the appropriate tool for this requirement.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom business applications (canvas or model-driven apps), not for creating dashboards that visualize real-time sales data from a SQL database. Option B is wrong because Power Automate is a workflow automation tool that orchestrates actions across services, but it does not provide dashboard or visualization capabilities for real-time data. Option D is wrong because AI Builder is an add-on for adding AI models (e.g., prediction, object detection) to Power Apps or Power Automate, not for building dashboards or connecting to SQL databases for real-time reporting.

689
MCQmedium

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

A.It updates a lead record when an email is received.
B.It deletes emails after creating leads.
C.It sends an email when a new lead is created in Dataverse.
D.It creates a lead in Dataverse when a new email arrives in the inbox.
AnswerD

The JSON shows an email-arrival trigger in the inbox followed by a Dataverse create-record action targeting the lead table. This satisfies the exhibit's flow definition: each new email automatically generates a lead record, matching the described behaviour precisely.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

690
MCQeasy

A help desk analyst receives a high volume of support emails in a shared Outlook 365 mailbox. The analyst needs to automatically create a task in Microsoft Planner whenever an email is flagged with a specific category called 'Escalation'. The analyst has no coding experience and wants to build the automation with minimal effort. What should the analyst use?

A.A Microsoft Power BI dataflow that ingests the mailbox and pushes records to Planner.
B.A Power Automate cloud flow with the 'When a new email arrives in a shared mailbox (V2)' trigger and a condition that checks the category, followed by the 'Create a task' Planner action.
C.A Power Automate desktop flow that uses UI automation to read the Outlook desktop client and create Planner tasks.
D.A Power Apps canvas app that polls the mailbox every minute and inserts Planner tasks.
AnswerB

This is the correct solution because Power Automate provides a dedicated Outlook 365 trigger for shared mailboxes that supports filtering by category, and the Planner connector includes a 'Create a task' action. The analyst can build this declaratively in the flow designer without writing code, satisfying both the automation requirement and the no-code constraint.

Why this answer

The requirement is an event-driven, no-code automation that reacts to categorized email in a shared mailbox and creates a Planner task. Power Automate is the only service in the Power Platform built for this kind of trigger-and-action workflow, and the Outlook 365 shared mailbox trigger plus the Planner connector directly satisfy both the source and destination requirements.

Exam trap

The trap here is assuming that any Power Platform service can react to email events, when only Power Automate provides event-driven triggers for mailboxes.

691
MCQeasy

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

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

Filter returns a table of records matching the condition, and Status = 'Active' selects only rows where the Status column equals Active. This satisfies the requirement to return a table filtered by that column value.

Why this answer

The Filter function in Power Apps takes a data source as the first argument and a logical expression as the second argument. The correct syntax is Filter(Accounts, Status = 'Active'), which returns records where the Status column equals 'Active'.

Exam trap

PL-900 often tests the correct argument order and syntax of the Filter function, causing candidates to reverse the arguments or misuse quotes around column names.

How to eliminate wrong answers

Option A is wrong because Filter(Accounts, 'Active') passes a string literal as the condition, which is not a valid logical expression. Option C is wrong because it reverses the arguments, using 'Active' as the data source and Accounts as the condition. Option D is wrong because it also reverses the arguments, placing the condition first and the data source second.

692
MCQmedium

A financial services company has a copilot built with Microsoft Copilot Studio that must trigger a Power Automate cloud flow when a customer requests a loan quote. The flow returns a quote amount that the copilot then displays to the customer. The company wants to minimize development effort and keep the solution within the Power Platform. What should the company do?

A.Configure an HTTP request node in the copilot topic that posts to the flow's trigger URL.
B.Add a Call an action node in the copilot topic and select the existing Power Automate flow.
C.Use a Power Apps component to invoke the flow and embed it in the copilot conversation.
D.Create a custom connector that calls the Power Automate flow and register it in the copilot.
AnswerB

The Call an action node lets a Copilot Studio topic invoke a Power Automate cloud flow directly. By selecting the existing flow, the copilot can pass inputs, receive the quote amount as an output, and display it to the customer. This approach requires no custom code and keeps the integration within the Power Platform, matching the requirement to minimize development effort.

Why this answer

Copilot Studio provides a native Call an action node that can invoke Power Automate cloud flows directly. This allows the copilot to send inputs, receive outputs such as a quote amount, and continue the conversation without custom code. Using this built-in integration is the simplest and most aligned approach for the financial services company, avoiding unnecessary connectors or components.

Exam trap

The trap here is assuming you need a custom connector or HTTP call to invoke a Power Automate flow, when Copilot Studio already offers a native Call an action node for that purpose.

693
MCQmedium

A support team uses Microsoft Copilot Studio to build a copilot that helps employees reset their passwords. The copilot must ask the employee to choose their department from a list of five departments and then provide a department-specific reset link. Which Copilot Studio feature should the maker use to present the list of departments and capture the employee's selection?

A.Add a condition node that checks the employee's department variable.
B.Add a Power Automate flow that returns the department list as an adaptive card.
C.Add a message node that lists the departments as plain text.
D.Add a question node and configure it with multiple choice options for the departments.
AnswerD

A question node in Microsoft Copilot Studio can be configured to present multiple choice options to the user. This directly matches the requirement to show a list of five departments and capture the selection. The selected value can then be stored in a variable and used in subsequent condition nodes to provide the correct reset link, making this the appropriate feature.

Why this answer

The question node in Microsoft Copilot Studio is designed to ask the user a question and collect their response. Configuring it with multiple choice options lets the maker present the five departments and capture the employee's selection into a variable. That variable can then drive condition nodes to deliver the correct reset link.

Native question nodes are the simplest and most appropriate way to gather structured input.

Exam trap

The trap here is confusing a condition node, which evaluates a value, with a question node, which collects a value from the user.

694
MCQhard

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

A.Add the credentials to the JSON configuration and redeploy
B.Configure the data source credentials in the Power BI service under dataset settings
C.Set the data source privacy level to Organizational
D.Change the connection string to use SQL Server authentication
AnswerB

Refresh failures citing missing credentials occur because dataset connection details deploy with the report, but authentication secrets are never published. Opening the dataset settings in the Power BI service and supplying the data source credentials satisfies that constraint, allowing the scheduled refresh to authenticate against the source.

Why this answer

The error indicates that the data source credentials are missing in the Power BI service, not in the JSON configuration. The JSON only defines the refresh schedule and dataset parameters; credentials must be configured separately in the Power BI service under dataset settings because they are sensitive and not stored in deployment artifacts. Option B is correct because you must manually enter or update the credentials in the Power BI service to authenticate against the data source.

Exam trap

The trap here is that candidates assume the JSON configuration can include all deployment details, but Power BI intentionally separates credentials from deployment artifacts to enforce security, so the error points to a missing manual configuration step in the service.

How to eliminate wrong answers

Option A is wrong because the JSON configuration for a Power BI dataset refresh does not support embedding credentials; credentials are managed separately in the Power BI service for security reasons. Option C is wrong because setting the data source privacy level to Organizational controls data isolation and cross-source combining, not credential provisioning; it does not resolve a missing credentials error. Option D is wrong because changing the connection string to use SQL Server authentication would still require credentials to be configured in the Power BI service; the error is about missing credentials, not the authentication method.

695
MCQhard

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

A.The connection reference is not shared with the users.
B.The SharePoint list has exceeded its item limit.
C.The users lack write permissions on the SharePoint list.
D.The app is shared with 'Can edit' permission but not 'Can view'.
AnswerC

SharePoint enforces its own item-level permissions independently of the Power Apps canvas app. Users without Contribute or Edit rights on the underlying list can read data but cannot create items, producing the generic 'Access denied' error on submit. Granting write permissions on the list resolves the constraint.

Why this answer

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

Exam trap

The trap here is that candidates often confuse app-level sharing permissions (Can view/Can edit) with data source permissions, assuming that sharing the app with 'Can edit' automatically grants write access to the underlying SharePoint list.

How to eliminate wrong answers

Option A is wrong because connection references are used in solution packaging and environment lifecycle management, not for runtime data access; sharing the app with users automatically shares the underlying connector as long as the user has appropriate permissions on the data source. Option B is wrong because SharePoint list item limits (default 5,000 items in a view, 30 million total) cause performance issues or throttling, not a generic 'Access denied' error; exceeding the limit would produce a different error message related to list view threshold or item count. Option D is wrong because 'Can edit' permission on the app actually grants the user the ability to modify the app itself, not to submit data; the error is about data submission, not app editing, and 'Can view' would be even more restrictive but still unrelated to the data source permissions.

696
Multi-Selecthard

Which FIVE of the following are valid connectors in Power Automate? (Choose five.)

Select 5 answers
A.Google Drive
B.SQL Server
C.SharePoint
D.Dropbox
E.Outlook
AnswersA, B, C, D, E

Google Drive is a certified Power Automate connector, enabling flows to trigger on file changes and perform actions such as uploading, copying or deleting files. It satisfies the stem's requirement for a valid connector, since Microsoft publishes it within the standard connector library alongside SharePoint, Outlook and Dropbox.

Why this answer

Google Drive (A) is a valid Power Automate connector, offering standard and premium actions such as creating files, uploading content, and triggering flows when files change. SQL Server (B) is a valid connector that lets flows run queries, insert rows, and invoke stored procedures against on-premises or Azure SQL databases. SharePoint (C) is a core Microsoft connector providing triggers and actions for lists, libraries, files, and items.

Dropbox (D) is a valid connector for file operations like upload, copy, and delete, plus triggers on file creation. Outlook (E) is a valid connector (Outlook.com and Office 365 Outlook) for sending mail, managing calendar events, and triggering on new messages. No other options are listed, so there are no unmarked choices to exclude.

Exam trap

The trap here is that candidates may assume only Microsoft services are valid connectors, but Power Automate includes many third-party standard connectors like Google Drive and Dropbox. In this question, all options are valid.

How to eliminate wrong answers

Option A is wrong because Google Drive is not a built-in connector in Power Automate; while third-party connectors exist via custom connectors or HTTP requests, it is not listed among the standard Microsoft-managed connectors. Option D is wrong because Dropbox is not a native connector in Power Automate; although it can be integrated through third-party services or custom connectors, it is not one of the out-of-the-box connectors provided by Microsoft.

697
MCQmedium

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

A.SharePoint connector
B.Outlook connector
C.Microsoft Teams connector
D.Dynamics 365 connector
AnswerD

The Dynamics 365 connector provides the 'When a record is created' trigger, which fires immediately on lead creation. This satisfies the stem's requirement that the flow run instantly rather than on a schedule or manual action.

Why this answer

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

698
MCQeasy

A small business wants to give its finance team a dedicated space to build apps and flows that only finance team members can access, separate from the default environment used by the rest of the company. The administrator needs to create this isolated workspace. What should the administrator create?

A.A new Power Platform environment with restricted user access
B.A new Microsoft 365 group and assign it the Global Administrator role
C.A new Dataverse table with column-level security for finance data
D.A new Power Apps solution containing the finance team's apps
AnswerA

A Power Platform environment is the container that isolates apps, flows, connections, and Dataverse data. By creating a new environment and granting access only to finance team members, the administrator provides an isolated workspace. Security roles and environment-level access control who can build and use resources within it, matching the requirement exactly.

Why this answer

Power Platform environments are the fundamental security and isolation boundary. Creating a dedicated environment and granting access only to finance team members ensures their apps, flows, and data are separated from the default environment. Microsoft 365 groups, Dataverse tables, and solutions do not provide this isolation, since they either manage unrelated services, store data inside an existing environment, or package components for transport.

Exam trap

The trap here is confusing a solution, which packages components for deployment, with an environment, which is the actual security and isolation boundary for apps, flows, and data.

699
MCQeasy

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

A.Power Automate triggers
B.Power Pages templates
C.Power Apps connectors
D.Power BI datasets
AnswerC

Connectors provide prebuilt interfaces to Microsoft 365 services and third-party systems such as Salesforce, letting a custom app read and write external data without hand-coding authentication or REST calls. This satisfies the requirement to reach both Microsoft and non-Microsoft services.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

700
MCQeasy

A business analyst wants to create a Power App without writing code. They need to build a mobile-friendly form for inventory tracking. Which approach should they use?

A.Create a canvas app from a template or blank, using drag-and-drop controls
B.Create a model-driven app using Dataverse
C.Create a Power Apps portal
D.Customize a SharePoint list form
AnswerA

Canvas apps provide drag-and-drop controls and prebuilt templates, letting the analyst build a mobile-responsive inventory form without writing code. This directly satisfies the no-code constraint, and the responsive canvas layout ensures the form renders correctly on mobile devices.

Why this answer

Canvas apps allow drag-and-drop design without code, enabling the creation of mobile-friendly custom forms. Option B (model-driven app) is less flexible for custom form design and requires more configuration. Option C (Power Apps portal) is designed for external user-facing websites, not internal inventory tracking.

Option D (customize SharePoint list form) is limited in mobile optimization and customization compared to a canvas app.

701
MCQeasy

A support team at Fabrikam uses Microsoft Copilot Studio to build a copilot for handling customer inquiries. They want the copilot to respond to the phrase 'What are your business hours?' with a fixed answer, and also recognize variations like 'When are you open?' and 'What time do you close?'. What should they configure in Copilot Studio?

A.Configure a fallback topic to handle all unrecognized phrases.
B.Create a topic with trigger phrases and a message node.
C.Add a Power Automate cloud flow that returns the business hours.
D.Use the Question node to ask the user for their preferred contact method.
AnswerB

A topic in Copilot Studio is triggered by phrases. By adding multiple trigger phrases such as 'What are your business hours?', 'When are you open?', and 'What time do you close?', the copilot recognizes variations. The message node then sends the fixed response. This is the standard no-code way to handle common questions.

Why this answer

The correct approach is to create a topic with multiple trigger phrases that match the variations of the question, and then use a message node to output the fixed answer. This uses Copilot Studio's natural language understanding to trigger the topic regardless of how the user phrases the question, ensuring a consistent response without writing code.

Exam trap

The trap here is confusing the purpose of a fallback topic with a regular topic, assuming that any unrecognized phrase will be handled by the fallback rather than creating specific triggers.

Page 9

Page 10 of 10

All pages