You are building a Canvas app that connects directly to a Dataverse table containing over 50,000 'Work Order' records. Users need to search for work orders by entering text that might appear anywhere in the 'Description' column. To ensure the app remains highly performant and does not encounter delegation limits, what is the best architectural approach?
check_circle
Correct AnswerB
Canvas apps have a strict delegation limit (maximum 2,000 records) for non-delegable queries. Loading 50,000 records into a local collection (Option 1) will fail, as `ClearCollect` is subject to this limit and will only pull the first 500-2,000 records. Option 2 is impossible, as the hard limit is 2,000. Dataverse natively supports delegation for the `Search()` function on text columns. By binding the gallery directly to the Dataverse table and using `Search()`, the query execution is pushed to the server (Dataverse), which efficiently searches all 50,000 records and returns only the necessary page of results to the app, ensuring high performance.
Question 132
You are optimizing a Canvas app that has a noticeable delay during the `App.OnStart` execution. Currently, the `OnStart` property contains 15 `Set()` functions that retrieve lookup values, the current user's profile, and various global configuration settings from Dataverse. You need these values available globally across 20 screens, but you want to eliminate the `OnStart` bottleneck. What is the most performant architectural alternative?
check_circle
Correct AnswerB
Named Formulas (defined in the `App.Formulas` property) are the modern, Microsoft-recommended approach to defining global variables and configurations. Unlike `Set()` in `OnStart`, which forces synchronous execution and blocks the app from loading until complete, Named Formulas are 'lazily evaluated'. This means the engine only calculates the value when a screen or control actually requests it. Furthermore, they automatically recalculate if their underlying data changes, drastically improving app load performance.
Question 133
You are auditing a Canvas app for accessibility compliance to ensure visually impaired users utilizing screen readers can effectively navigate and interact with the application. Which of the following configurations are required to ensure interactive controls (like Buttons and Text Inputs) are accessible? (Select two)
Select all that apply
check_circle
Correct AnswersA, C
To make Canvas apps accessible, screen readers rely heavily on the `AccessibleLabel` property. If a button only has an icon, the screen reader needs the `AccessibleLabel` (e.g., 'Save Record') to tell the user what it does. Furthermore, users with visual impairments or motor disabilities often navigate using the keyboard (Tab key). Setting the `TabIndex` to 0 (or >0 for specific ordering) ensures the control falls into the logical tab order and receives focus. Hardcoding colors defeats high-contrast modes, reducing accessibility.
Question 134
You are deploying a Copilot Studio agent to Microsoft Teams for internal employees. The agent is configured with Generative Answers grounded in a Dataverse 'HR Policies' table and an internal SharePoint document library containing employee handbooks. Which of the following statements accurately describe how security and data access are handled in this integrated scenario? (Select two)
Select all that apply
check_circle
Correct AnswersC, D
Copilot Studio agents heavily enforce Microsoft's security trimming principles. When grounded in enterprise data (SharePoint or Dataverse), the agent strictly respects the executing user's authentication context. It will only query and generate answers based on SharePoint documents the user explicitly has access to in SharePoint (Option 2). Furthermore, it respects the Dataverse security model, including Role-Based Access Control and Column-Level Security, ensuring data from restricted columns is never leaked to a user without the proper profile (Option 3).
Question 135
You have a Power Automate flow triggered by a Canvas App. The flow uses the Dataverse 'List rows' action to query the 'Payroll' table, calculates an average, and returns the result to the app. The flow connection is configured to 'Run only users: Provided by run-only user' (Use invoker's connection). A standard employee, who has the 'Basic User' security role and NO read privileges to the 'Payroll' table, clicks the button in the app to run the flow. What will happen?
check_circle
Correct AnswerB
When a flow is triggered from Power Apps and the connections are configured to use the 'invoker's connection' (Provided by run-only user), the flow strictly inherits the Entra ID identity and Dataverse security roles of the person clicking the button in the app. Because the standard employee lacks read privileges to the 'Payroll' table in Dataverse's Role-Based Access Control (RBAC) model, the 'List rows' API call will instantly reject the request and fail the flow with a privilege exception. It does not elevate privileges or silently return empty data.
Question 136
A Dataverse Rollup column on the 'Project' table is configured to `SUM` the 'Estimated Hours' of related child 'Task' records. The business stakeholders request a change: the Rollup column should only sum the hours of Tasks where the 'Due Date' falls within the *next 30 days*. When you attempt to configure this in the Rollup designer, you are unable to achieve the requirement. Why?
check_circle
Correct AnswerC
Dataverse Rollup columns have specific architectural limitations because they are calculated asynchronously via background system jobs (typically every 12 hours). Because the system relies on caching and delta changes, Rollup column filters explicitly prohibit the use of dynamic, time-sensitive queries like 'Next X Days', 'Older than X Months', or `NOW()`. The evaluation of these queries changes continuously, which the background asynchronous calculation engine cannot reliably track or execute efficiently. You would need a scheduled Power Automate flow to calculate and update this specific value.
Question 137
A regional hospital network receives patient referral documents via email in varying formats (PDF, Word, scanned images). The system must automatically extract patient demographics, validate the physician's credentials against a legacy on-premises SQL Server database, and store the structured data in Dataverse. Which solution architecture represents the most appropriate integration of Power Platform components?
check_circle
Correct AnswerD
This is an unattended, backend automation scenario perfectly suited for Power Automate cloud flows. The flow can trigger on the arrival of an email. AI Builder Document Processing is the ideal component for extracting structured data from unstructured or semi-structured documents like PDFs and scanned images. To securely connect a cloud flow to a legacy on-premises SQL Server without exposing it to the public internet, an On-premises Data Gateway is required. Using RPA (Option 4) is unnecessary and inefficient when cloud flows and standard database connectors (via Gateway) are available.
Question 138
A customer service department wants an intelligent routing system. When a new email arrives in a shared support mailbox, the system must automatically analyze the email body. If the customer is expressing frustration or anger, the email must be routed to an 'Escalation' queue in Dataverse. If the tone is neutral or happy, it routes to the 'Standard' queue. What is the most efficient, out-of-the-box architectural design to achieve this?
check_circle
Correct AnswerD
This is an unattended, background automation scenario. A Power Automate cloud flow can trigger automatically ('When a new email arrives'). Within the flow, the prebuilt AI Builder Sentiment Analysis model is perfectly designed to evaluate text and return a specific label ('Positive', 'Negative', 'Neutral', 'Mixed') along with confidence scores. The flow can then use a simple 'Condition' action based on this sentiment label to route the record to the appropriate Dataverse queue. Copilot Studio is for interactive chat, and Text Recognition (OCR) just extracts words from images.
Question 139
You are designing a Dataverse data model for a 'Fleet Management' solution. You have a 'Vehicle' table and a 'Maintenance Log' table with a 1:N (One-to-Many) relationship. Users need a read-only field on the 'Vehicle' main form that displays the date of the most recent 'Maintenance Log' record. This date must automatically reflect the latest related record. Which Dataverse feature should you implement?
check_circle
Correct AnswerC
Rollup columns are designed specifically to aggregate data from related child records in a 1:N relationship. By creating a Rollup column on the parent 'Vehicle' table, you can select the related 'Maintenance Log' table and apply the `MAX` aggregation operator to the date column. This will consistently evaluate and display the most recent (maximum) date among all child records. Calculated columns and Formula columns are generally used for intra-record math or pulling data from a parent record (N:1), not aggregating from child records.
Question 140
A model-driven app includes a system dashboard that displays overall, organization-wide sales pipeline charts. This dashboard contains highly sensitive revenue projections. You want to ensure that this specific dashboard is completely hidden from standard users and only visible to users who hold the 'Sales Director' security role. How do you implement this restriction?
check_circle
Correct AnswerC
System Dashboards in model-driven apps can be tightly controlled using Security Roles. By selecting the dashboard within the maker portal/solution explorer and choosing 'Enable Security Roles', an administrator can detach the dashboard from 'Display to everyone' and explicitly map it to specific security roles (like 'Sales Director'). If a user does not have that designated role, the dashboard will not appear in their dashboard selector. Option 1 refers to Personal Dashboards, not System Dashboards.
