View Full Microsoft PL-200 Exam Dumps and Practice Test Dumps.

 

Question 241

You are creating a Dataverse table for storing employee records. Each employee can belong to one department, while each department can have many employees. Which relationship should you create?

1. One-to-many relationship from Department to Employee
2. Many-to-many relationship between Department and Employee
3. One-to-one relationship between Department and Employee
4. Self-referential relationship on Employee

Correct Answer: 1

Explanation

A one-to-many relationship is appropriate because one department can contain many employee records, while each employee belongs to one department. In Dataverse, the relationship can be implemented with a lookup column on the Employee table that references the Department table. This allows users to select the employee’s department from existing records rather than entering department information as plain text. A many-to-many relationship would be unnecessary unless an employee could belong to multiple departments. A one-to-one relationship would also not represent the business requirement because multiple employees need to be associated with the same department.

Question 242

You need to store a customer’s membership level with the predefined values Bronze, Silver, Gold, and Platinum. Which Dataverse column type should you use?

1. Text
2. Choice
3. Lookup
4. Whole Number

Correct Answer: 2

Explanation

A Choice column is designed for fields where users must select from a predefined set of values. In this scenario, Bronze, Silver, Gold, and Platinum represent a controlled list of membership levels. Using a Choice column improves data consistency because users cannot enter arbitrary variations such as “Gold Member” or “gold.” A Text column would allow inconsistent values, while a Lookup would be more appropriate if membership levels were maintained as records in another Dataverse table. A Whole Number could technically represent levels numerically, but it would not provide the same meaningful predefined choices to users.

Question 243

A company wants a model-driven app view that displays only active Accounts with annual revenue greater than $100,000. Which component should you configure?

1. Business process flow
2. Business rule
3. View
4. Dashboard

Correct Answer: 3

Explanation

A view is the appropriate model-driven app component for displaying a filtered and organized list of Dataverse records. You can configure the Account view with conditions such as Status equals Active and Annual Revenue greater than $100,000. Users can then open the view to see only records meeting those criteria. A business rule is intended for applying logic to forms and fields, not for defining record lists. A business process flow guides users through stages of a process, while a dashboard provides visual summaries rather than serving as the primary mechanism for filtering a record list.

Question 244

You create a Power Automate cloud flow that should automatically send an email whenever a new high-priority Case is created in Dataverse. Which approach should you use to start the flow?

1. Manually run the flow whenever a Case is created
2. Use a scheduled trigger that runs every hour
3. Use a business process flow stage-change trigger
4. Use the Dataverse trigger for when a row is added, modified, or deleted and configure it for new Cases

Correct Answer: 4

Explanation

The Microsoft Dataverse trigger for when a row is added, modified, or deleted can automatically start a cloud flow when a new Case record is created. The flow can then use conditions to determine whether the Case has high priority before sending the email. A manual trigger would require user intervention, which defeats the automation requirement. A scheduled trigger introduces unnecessary delay and does not respond immediately to the event. A business process flow is used to guide users through stages and is not the appropriate mechanism for starting this type of automated notification.

Question 245

A Case form contains a Resolution Details field. The business requires this field to become mandatory only when the Case Status is set to Resolved. What should you configure?

1. A business rule
2. A view filter
3. A dashboard
4. A Power Pages list

Correct Answer: 1

Explanation

A business rule is suitable for applying conditional logic to fields on Dataverse forms. In this scenario, the rule can evaluate the Case Status and make the Resolution Details field required when the status becomes Resolved. This provides immediate guidance to users while they work with the form. A view filter only controls which records appear in a list and does not change field requirements. A dashboard is intended for visual analysis, while a Power Pages list is designed to expose Dataverse records through a website. Therefore, the business rule directly matches the requirement.

Question 246

A sales organization wants users to follow the same stages whenever they process a new Opportunity. Which Power Platform feature should you use?

1. Business rule
2. Business process flow
3. Canvas app gallery
4. Dataverse view

Correct Answer: 2

Explanation

A business process flow is designed to guide users through standardized stages of a business process. For Opportunities, it can define stages such as Qualify, Develop, Propose, and Close, with required steps or fields at appropriate stages. This provides consistency while users work through the sales process. A business rule is more appropriate for conditional field behavior, while a canvas app gallery displays collections of records or items. A Dataverse view controls which records are displayed and how they are filtered or sorted. Therefore, the business process flow best satisfies the requirement for standardized Opportunity stages.

Question 247

You need to display all related Contacts directly on an Account main form in a model-driven app. Which control should you add?

1. Business process flow
2. Chart
3. Subgrid
4. Command bar

Correct Answer: 3

Explanation

A subgrid is used on model-driven forms to display a collection of related records. When configured on an Account form, a Contacts subgrid can show Contacts associated with that Account. Users can often interact with those related records directly from the subgrid, depending on the configured table relationships and commands. A business process flow is used for process stages, not related-record lists. A chart visualizes data, while the command bar provides actions such as creating or editing records. Therefore, a subgrid is the correct component for presenting related Contacts within the Account form.

Question 248

You are preparing to move a Power Apps solution from a development environment to a test environment. What should you use to package the app and its related components?

1. A dashboard
2. A solution
3. A business rule
4. A view

Correct Answer: 2

Explanation

Solutions are the primary mechanism for packaging Power Platform components for application lifecycle management. A solution can contain tables, columns, relationships, model-driven apps, canvas apps, flows, business rules, and other components. The solution can then be exported from the development environment and imported into a test environment. A dashboard or view is an individual application component rather than a deployment package. A business rule provides form logic but does not package the overall application. Using solutions helps maintain dependencies and provides a structured way to move application components between environments.

Question 249

An Opportunity table needs a column that allows users to select an existing Account as the Opportunity’s customer. Which column type should you create?

1. Lookup
2. Choice
3. Text
4. Yes/No

Correct Answer: 1

Explanation

A Lookup column is used when a Dataverse record needs to reference an existing record from another table. In this case, the Opportunity needs to reference an Account, so an Account lookup provides the appropriate relationship. Users can select an existing Account rather than manually typing the customer’s name. A Choice column is intended for predefined options, while a Text column would store unstructured text and would not establish a Dataverse relationship. A Yes/No column can only represent a Boolean value and cannot reference another record. Therefore, the Lookup column is the correct design.

Question 250

A company needs to store the total monetary value of an invoice and allow users to work with the amount using the organization’s currency settings. Which Dataverse column type should you use?

1. Whole Number
2. Currency
3. Text
4. Yes/No

Correct Answer: 2

Explanation

The Currency column type is designed for monetary values in Dataverse. It supports currency-aware data and is appropriate for fields such as invoice amounts, sales values, costs, and budgets. Using a Currency column provides better functionality than storing the amount as text because the value remains numeric and can be used in calculations, sorting, filtering, and reporting. Whole Number is intended for integer quantities rather than financial amounts. Text would store the value as characters and make calculations difficult, while Yes/No can only represent two logical states. Therefore, Currency is the appropriate choice for an invoice total.

Question 251

In a canvas app, a button should take the user to a screen named OrderDetailsScreen. Which Power Fx function should be used in the button’s OnSelect property?

1. SubmitForm(OrderForm)
2. Patch(Orders, Defaults(Orders), {})
3. Navigate(OrderDetailsScreen)
4. Filter(Orders, Status = “Open”)

Correct Answer: 3

Explanation

The Navigate function is used in Power Fx to move the user from one screen to another in a canvas app. Setting the button’s OnSelect property to Navigate(OrderDetailsScreen) directs the user to the specified screen when the button is selected. SubmitForm is used to submit data from a form, while Patch is used to create or modify records. Filter returns a filtered table of records and does not perform screen navigation. Therefore, Navigate is the correct function for changing the current screen in response to a button click.

Question 252

A canvas app contains an Orders data source. You need to display only orders whose Status is “Open”. Which Power Fx function should you use?

1. Navigate
2. SubmitForm
3. LookUp
4. Filter

Correct Answer: 4

Explanation

The Filter function is designed to return a table containing only records that satisfy a specified condition. For example, Filter(Orders, Status = “Open”) can be used as the Items property of a gallery to display only open orders. Navigate changes the current screen, while SubmitForm submits the contents of an edit or data-entry form. LookUp is generally used to retrieve a single record matching a condition rather than return a collection of matching records. Since the requirement is to display multiple records meeting the Open status condition, Filter is the appropriate Power Fx function.

Question 253

A canvas app needs to retrieve the Account record whose Account Number matches a value entered by the user. Which Power Fx function is most appropriate?

1. LookUp
2. Filter
3. Navigate
4. Patch

Correct Answer: 1

Explanation

The LookUp function is appropriate when the app needs to find a specific record that matches a condition and return that record or a field from it. For example, LookUp(Accounts, AccountNumber = txtAccountNumber.Text) can locate the Account associated with the entered account number. Filter would return a table of all matching records rather than a single matching record. Navigate changes screens, while Patch is used to create or update records. Therefore, LookUp is the most suitable function when the requirement is to retrieve one Account based on a unique identifying value.

Question 254

A Power Automate flow needs to create a new row in a Dataverse Orders table after receiving an approved request. Which action should you use?

1. List rows
2. Add a new row
3. Get a row by ID
4. Delete a row

Correct Answer: 2

Explanation

The Add a new row action in the Microsoft Dataverse connector is used to create a new record in a Dataverse table. The flow can map values from the approved request into the appropriate columns of the new Order record. List rows is used to retrieve multiple records, while Get a row by ID retrieves an existing specific record. Delete a row removes an existing record and therefore does not satisfy the requirement. Because the flow must create a brand-new Order after approval, the Add a new row action is the correct choice.

Question 255

A company wants sales representatives to have different Dataverse privileges based on their job roles. Which feature should an administrator configure?

1. Views
2. Business process flows
3. Security roles
4. Charts

Correct Answer: 3

Explanation

Security roles define the privileges users have when working with Dataverse data. Administrators can configure privileges such as Create, Read, Write, Delete, Append, Append To, Assign, and Share, along with appropriate access levels. This allows sales representatives, managers, and administrators to have different permissions based on their responsibilities. Views determine which records are displayed but do not provide the underlying security boundary. Business process flows guide users through processes, while charts provide data visualization. Therefore, security roles are the correct feature for implementing role-based Dataverse access control.

Question 256

A company uses Power Pages and wants only users with a specific web role to access records from a Dataverse table. Which feature should be configured?

1. Business rules
2. Table permissions
3. Model-driven views
4. Canvas app controls

Correct Answer: 4

Explanation

Table permissions are used in Power Pages to control which Dataverse table records website users can access. They can be associated with web roles so that permissions are granted to the appropriate groups of users. This provides a security layer between the external website user and the underlying Dataverse data. Business rules are primarily used for form logic, model-driven views control record presentation within model-driven apps, and canvas app controls manage user interfaces in canvas apps. Therefore, configuring table permissions with appropriate web roles is the correct approach for controlling Power Pages data access.

Question 257

A model-driven app should make the Discount field read-only when the Order Status is Closed. Which feature can implement this requirement without custom JavaScript?

1. Business rule
2. View
3. Chart
4. Dashboard

Correct Answer: 1

Explanation

A business rule can apply conditional form behavior without requiring custom JavaScript. The rule can evaluate the Order Status field and, when the status is Closed, lock the Discount field so that users cannot modify it through the form. This provides a declarative way to implement common business logic. A view controls the records and columns displayed in a list, while a chart visualizes data. A dashboard combines visual components for monitoring information. None of those features directly provide conditional field locking. Therefore, a business rule is the best choice for this requirement.

Question 258

You need to move a solution containing Dataverse tables, a model-driven app, and cloud flows from development to production. Which process should you follow?

1. Recreate every component manually in production
2. Export the solution from development and import it into production
3. Copy the browser URL of the development app
4. Export only the model-driven app

Correct Answer: 2

Explanation

Solutions provide the standard method for moving Power Platform application components between environments. The developer can package the required components into a solution, export it from the development environment, and import it into the production environment. Dependencies included in the solution help ensure that related components are available in the target environment. Manually recreating components is inefficient and can lead to configuration differences. Copying a browser URL does not deploy the underlying application components. Exporting only the model-driven app would also omit required tables and flows. Therefore, solution export and import is the correct ALM approach.

Question 259

A canvas app needs to modify an existing Dataverse Account record based on values entered in a custom form. Which Power Fx function can be used to update the record directly?

1. Navigate
2. Filter
3. Patch
4. SubmitForm

Correct Answer: 3

Explanation

Patch is a Power Fx function used to create or modify records in a data source. It is especially useful when an app needs to update specific fields of an existing Dataverse record without relying entirely on the standard form submission process. For example, Patch(Accounts, selectedAccount, {Name: txtName.Text}) can update the Name field of an existing Account. Navigate is for screen navigation, Filter retrieves matching records, and SubmitForm submits a form control. Therefore, Patch is the appropriate function when the app needs direct and controlled updates to an existing Dataverse record.

Question 260

A canvas app is experiencing slow performance, and the developer needs to inspect formulas, network activity, and app behavior while reproducing the issue. Which Power Apps feature should be used?

1. Business process flow
2. Power Pages table permissions
3. Solution checker only
4. Monitor

Correct Answer: 4

Explanation

Power Apps Monitor is designed to help makers troubleshoot and diagnose canvas app behavior. It provides information about app events, formulas, data requests, network activity, and other runtime operations. A developer can use Monitor while reproducing a performance or functional issue to identify potentially problematic operations or slow data requests. A business process flow is intended to guide users through business stages, while Power Pages table permissions control external website access to Dataverse data. Solution checker can identify certain solution issues but is not a replacement for runtime monitoring. Therefore, Monitor is the best tool for this troubleshooting scenario.