A Microsoft Dataverse database contains two custom tables named TableA and TableB. The tables are configured with the following:
• A one-to-many relationship is configured between TableA and TableB.
• A lookup to TableA appears on a form in TableB.
• Both tables are components of an unmanaged solution.
• Both tables are components in a Power BI report.
You receive an error when attempting to delete TableA.
You need to delete the table.
What should you do?
A. Remove TableA from the Power BI report.
B. Remove the relationship between TableA and Table
C. Remove TableA from the unmanaged solution.
D. Remove the lookup field to TableA on the TableB form.
Show Answer
Correct Answer: B
Explanation: In Dataverse, a table cannot be deleted while it has active schema dependencies. The one-to-many relationship between TableA and TableB creates a hard dependency (including the lookup column). Removing a lookup from a form only affects the UI and does not remove the underlying relationship. You must remove the relationship to eliminate the dependency before deleting TableA.
Question 167
HOTSPOT -
You are troubleshooting Power Apps solutions.
You need to determine the cause for the identified issues.
What is the root cause for each issue? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: Box 1: A canvas app in the first solution has errors.
Box 2: The code uses the following rule: web-use-strict-mode.
Explanation: Solution Checker can report errors for only one solution when that solution contains a canvas app with issues. The JavaScript warning on line three is triggered by the web-use-strict-mode rule, which flags non-strict equality (==) comparisons that can cause unexpected type coercion.
Question 168
HOTSPOT -
A company delivers packages to businesses and consumers. A custom entity named Package captures the package details.
You need to add the following sets of fields to the entity and leverage the built-in operations of the platform:
✑ A set of fields to represent the package length, width, depth, and weight. The maximum value for any dimension is 100 centimeters.
✑ A set of fields for time-sensitive attributes to calculate the efficiency of a delivery. The calculation must be based on a delivery is entered in the system and the value for a custom field named Delivery time.
Which constructs should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: DIFFINMINUTES(Created On, Delivery Time)
Duration
Explanation: Delivery efficiency is a calculated field based on the difference between when the record is created and the delivery time, best expressed in minutes using DIFFINMINUTES. The Delivery time field requires built-in time formatting and transformations, which are provided by the Duration data type.
Question 169
You develop a model-driven app. You add the following users as members to the Sales Microsoft Azure Active Directory (Azure AD) security group: User1, User2, and User3.
The Sales Azure AD security group is linked to a pre-existing Microsoft Dataverse Azure AD security group team that is associated with the Sales security role. You assign each of the appropriate licenses to each user.
User1 is not listed in the Team Members subgrid for the app. User2 and User3 are listed in the subgrid.
You need to ensure that User1 can use the model-driven app.
What should you do?
A. Change the membership of the Sales Azure AD Security group to Dynamic User.
B. Change the membership type for User1 to Owner in the Azure AD security group.
C. Create an Owner team for the members of the Sales Azure AD group.
D. Ask User1 to sign into the model-driven app.
Show Answer
Correct Answer: D
Explanation: In Dataverse, users added to an Azure AD security group that is linked to a security group team do not appear as team members until they access the environment for the first time. User1 has the correct group membership and licenses, but their Dataverse user record and team membership are created only upon first sign-in. Having User1 sign into the model-driven app will provision the user and enable access.
Question 170
You enable change tracking on the Account table in Microsoft Dataverse.
You plan to use the Organization Service to retrieve the delta data by using C#.
You need to determine which message to use.
What should you use?
A. RetrieveAttributeRequest
B. odata.track-changes
C. RetrieveEntityChangesRequest
D. UpdateEntityRequest
E. UpdateRequest
Show Answer
Correct Answer: C
Explanation: When using the Organization Service with C# to retrieve delta (change tracking) data in Microsoft Dataverse, the correct message is RetrieveEntityChangesRequest. The odata.track-changes option applies only to the Web API, not the Organization Service.
Question 171
DRAG DROP -
You are modifying a model-driven app for a bicycle company.
The app modifications must meet the following requirements:
• The order form must include a column that calculates payments based on how many years the customer wants to finance a bicycle.
• A pop-up box must remind the employee to validate the information entered before saving.
You must use out-of-the-box features before customizing the application.
What should you do?
Show Answer
Correct Answer: Calculate payments
Configure an out-of-the-box feature
A pop-up box must appear
Configure an out-of-the-box feature
Explanation: Payment calculation can be implemented using a Dataverse calculated column, which is an out-of-the-box feature. The reminder pop-up can be achieved with out-of-the-box capabilities such as business rules or form-level notifications, without editing XML or adding custom code.
Question 172
You develop a model-driven app to include a form containing several columns. Two groups of users. named Group1 and Group2 will access the form.
A column contains sensitive data that should not be read by Group2. Group1 must be able to access the column.
You need to prevent Group2 users from viewing the sensitive data.
What should you do?
A. Create a security role for users in Group1 to grant users access to the column.
B. Create multiple forms. Assign a form containing the sensitive data to Group1. Assign a form that does not contain the sensitive data to Group2.
C. Use JavaScript to set visibility of the column based on the group of the current user.
D. Create a field-level security profile for Group1 users to grant the users access to the column.
Show Answer
Correct Answer: D
Explanation: Use field-level security to control read access to a specific column. Create a field security profile that allows Group1 to read the sensitive column and does not grant read access to Group2. This enforces true data security regardless of form, view, or API access, unlike multiple forms or JavaScript.
Question 173
You develop and deploy a Power Apps solution.
The following changes must be made to the solution:
• Delete a column of data.
• Modify several views.
• Add several charts to dashboards.
You need to re-deploy the app.
What should you do?
A. Update the solution.
B. Upgrade the solution.
C. Create a new solution.
D. Patch the solution.
Show Answer
Correct Answer: B
Explanation: The required changes include deleting a column and modifying solution components. When re-deploying a managed solution, an Upgrade ensures that components removed from the newer version (such as a deleted column) are also removed from the target environment. An Update would leave removed components behind, Patch is only for incremental fixes, and creating a new solution is unnecessary. Therefore, upgrading the solution is the correct approach.
Question 174
HOTSPOT -
The planning department for municipal government wants to survey the land in town and define new property lines. You define a data model for the surveys.
Surveyors and other department employees need a phone app to capture survey data.
You need to define a Power Apps component framework (PCF) component to be used across multiple functional areas.
How should you complete the PCF control manifest? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Decimal
Utility
Explanation: Latitude requires high precision; the Decimal type group supports up to 10 decimal places, which is suitable for geospatial coordinates. The PCF control uses device capabilities like getCurrentPosition, which requires declaring the Utility feature in the manifest.
Question 175
You create and deploy a Power Platform solution that includes synchronous plug-ins.
Users report performance issues with the solution.
You need to determine whether a plug-in is the cause of the performance issues.
Which two tools can you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Tracing
B. Data policies
C. Solution checker
D. ISV Studio
E. Microsoft Dataverse Analytics
Show Answer
Correct Answer: A, E
Explanation: Tracing allows you to capture detailed execution logs for synchronous plug-ins, including execution flow and timing, which helps identify slow or problematic plug-ins. Microsoft Dataverse Analytics provides performance metrics and insights such as plug-in execution duration and frequency, enabling you to analyze whether a specific plug-in is contributing to overall performance issues.
$19
Get all 406 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
