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

 

Question 321

A Dataverse table needs to store a customer’s complete name, such as “Ahmed Khan.” Which column type is most appropriate?

1. Text
2. Currency
3. Choice
4. Date and Time

Correct Answer: 1

Explanation

A Text column is appropriate for storing a customer’s name because names are character-based information rather than numeric, monetary, or date values. The column can store values such as “Ahmed Khan” and can be used in forms, views, searches, and other application components. Currency is designed for monetary values, Choice provides predefined options, and Date and Time stores temporal information. Choosing Text ensures that the customer’s name is stored in a format suitable for displaying and searching within Dataverse. Additional validation or formatting can be applied when required by the application.

Question 322

A company wants to track whether a customer has agreed to receive marketing communications. The field must contain only Yes or No. Which Dataverse column type should you use?

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

Correct Answer: 2

Explanation

A Yes/No column is designed specifically for Boolean values where only two states are required. In this scenario, the field can represent whether the customer has agreed to receive marketing communications. Using a Yes/No column provides a clear and consistent value that can easily be used in views, business rules, and Power Automate conditions. Text would allow inconsistent entries, while a Choice column would be unnecessary for a simple two-state value. Whole Number is intended for integers. Therefore, Yes/No is the most appropriate Dataverse column type for this requirement.

Question 323

A sales manager wants to see only active Leads that have a rating of Hot in a model-driven app. Which component should be configured?

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

Correct Answer: 3

Explanation

A view is used in a model-driven app to define which Dataverse records are displayed and which filtering conditions are applied. The manager can configure a Lead view with conditions such as Status equals Active and Rating equals Hot. The view can also specify the columns shown and the sorting order. A dashboard is designed for visual summaries, while a business rule controls form behavior. A business process flow guides users through process stages rather than defining a filtered list of records. Therefore, a view is the appropriate component for displaying only active Hot Leads.

Question 324

A cloud flow should run whenever an existing Opportunity is modified in Dataverse. Which trigger should you configure?

1. Manually trigger a flow
2. Recurrence
3. When a row is added, modified, or deleted
4. Power Apps trigger

Correct Answer: 3

Explanation

The Dataverse When a row is added, modified, or deleted trigger can respond automatically to changes in Dataverse records. It can be configured for the Opportunity table and set to respond to modifications. This allows the flow to execute whenever an existing Opportunity is updated. A manual trigger requires a user to start the flow, while Recurrence runs according to a schedule. A Power Apps trigger is useful when a canvas or model-driven app explicitly starts the flow. Therefore, the Dataverse row-change trigger is the correct choice for responding to Opportunity modifications.

Question 325

A model-driven app should make the Customer Reference field required when the Case Type is “External.” Which feature should you configure?

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

Correct Answer: 1

Explanation

A business rule can evaluate conditions on a Dataverse form and modify field behavior accordingly. In this scenario, the rule can check the Case Type and make Customer Reference required whenever the value is External. This provides declarative conditional logic without requiring custom JavaScript for the requirement. A view controls the records displayed in a list, while a chart and dashboard are intended for data visualization and monitoring. None of these features directly makes a field conditionally required. Therefore, a business rule is the appropriate feature for implementing this form requirement.

Question 326

A company wants to guide users through standardized stages for processing service Requests. Which feature is designed for this purpose?

1. Choice column
2. Business process flow
3. View
4. Gallery

Correct Answer: 2

Explanation

A business process flow is designed to guide users through defined stages of a business process. For service Requests, an organization could create stages such as New, Investigating, Waiting for Customer, Resolved, and Closed. Each stage can contain steps that help users complete the necessary information or activities. A Choice column can store a selected status but does not provide the guided process experience. A view displays records, and a gallery is primarily a canvas app control. Therefore, the business process flow is the correct feature for guiding users through standardized Request-handling stages.

Question 327

An Account main form needs to show all related Opportunities and allow users to open those records. Which component should be added to the form?

1. Subgrid
2. Business rule
3. Chart
4. Site map

Correct Answer: 1

Explanation

A subgrid displays a collection of related Dataverse records directly on a model-driven form. Adding an Opportunities subgrid to the Account main form allows users to review Opportunities associated with that Account and, depending on configuration and permissions, open or create related records. A business rule provides conditional form logic, while a chart visualizes data rather than displaying a detailed related-record list. A site map controls navigation between areas, groups, and pages in a model-driven app. Therefore, a subgrid is the appropriate component for displaying related Opportunities on the Account form.

Question 328

A developer needs to move an application containing Dataverse tables, views, forms, and flows from a development environment to a test environment. What should be used?

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

Correct Answer: 2

Explanation

Solutions provide a structured way to package Power Platform components for application lifecycle management. The development team can include the required Dataverse tables, views, forms, flows, and other components in a solution, export it from development, and import it into the test environment. This approach is more reliable than manually recreating each component. A dashboard, business rule, or chart is only an individual application component and cannot package the entire application. Therefore, a solution is the correct mechanism for moving the application between environments.

Question 329

An Opportunity needs to reference an existing Account record. Users should be able to search for and select the Account from the Opportunity form. Which column type should be used?

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

Correct Answer: 2

Explanation

A Lookup column is designed to reference an existing record in another Dataverse table. In this case, the Opportunity can contain an Account lookup that allows users to search for and select the appropriate Account. This creates a proper relationship between the Opportunity and Account rather than storing the Account name as plain text. Choice is used for predefined values, Text stores character data without establishing a relationship, and Yes/No supports only Boolean values. Therefore, a Lookup column is the appropriate way to connect an Opportunity with an existing Account record.

Question 330

A company needs to store the amount paid on an invoice, including decimal values such as 2450.75. Which Dataverse column type should be used?

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

Correct Answer: 1

Explanation

Currency is the appropriate Dataverse column type for storing monetary amounts. It supports financial values such as 2450.75 and is designed for calculations, sorting, filtering, reporting, and currency-aware operations. Whole Number does not support decimal monetary values appropriately, while Text would store the amount as characters rather than a numeric financial value. Yes/No is intended for Boolean states. Using Currency also allows the application to take advantage of Dataverse’s currency functionality when multiple currencies or financial calculations are involved. Therefore, Currency is the correct choice for an invoice payment amount.

Question 331

A canvas app has a button that should open a screen named ProductDetailsScreen. Which Power Fx function should be used?

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

Correct Answer: 1

Explanation

The Navigate function is used to move from one screen to another in a canvas app. When placed in the button’s OnSelect property, Navigate(ProductDetailsScreen) can take the user to the specified screen. Patch is used to create or update records, Filter returns records that meet specified conditions, and LookUp retrieves a matching record or field. Because the requirement is specifically to move the user to another screen, Navigate is the correct Power Fx function. Navigation can also include transition settings and context parameters when the application requires them.

Question 332

A gallery in a canvas app should display only Orders whose Status is “Pending”. Which Power Fx function should be used in the gallery’s Items property?

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

Correct Answer: 2

Explanation

The Filter function returns a table containing records that meet a specified condition. The gallery’s Items property can use an expression such as Filter(Orders, Status = “Pending”) to display only pending Orders. LookUp is generally used to retrieve a single matching record, Navigate changes screens, and Patch modifies or creates records. Since the gallery needs to display multiple records that satisfy the Pending condition, Filter is the correct function. This approach also allows the gallery to update dynamically when the underlying data or filtering criteria change.

Question 333

A canvas app needs to retrieve a single Contact record using the Contact’s unique identifier. Which Power Fx function should be used?

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

Correct Answer: 3

Explanation

LookUp is designed to retrieve a single record that matches a specified condition. If the Contact ID is unique, a formula such as LookUp(Contacts, ContactID = selectedContactID) can return the corresponding Contact record. Filter would return a table of matching records rather than a single record. Patch is used to create or modify records, while Navigate changes the current screen. Therefore, LookUp is the most suitable function for finding one Contact based on its unique identifier. It can also return a specific field from the matching record when required.

Question 334

A Power Automate flow needs to create a new Customer record in Dataverse after an approved application is received. Which action should be used?

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

Correct Answer: 3

Explanation

The Add a new row action in the Microsoft Dataverse connector creates a new record in a specified table. The flow can map information from the approved application into the appropriate Customer columns and create the record automatically. Update a row modifies an existing record, List rows retrieves multiple records, and Get a row by ID retrieves one existing record. Since the requirement is to create a brand-new Customer record after approval, Add a new row is the correct action. This allows the flow to automate record creation without manual data entry.

Question 335

A company wants managers and sales representatives to have different privileges when accessing Opportunity records. Which Dataverse feature should be configured?

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

Correct Answer: 1

Explanation

Security roles provide the mechanism for controlling Dataverse privileges based on user responsibilities. An administrator can configure different roles for managers and sales representatives, giving each role appropriate privileges such as Read, Write, Create, Delete, Assign, and Share. Views can filter or organize records but do not replace the underlying security model. Charts visualize data, while business process flows guide users through stages. Therefore, security roles should be configured to provide the required differences in Opportunity access. This supports role-based security and helps ensure users can perform only authorized operations.

Question 336

A Power Pages website should allow registered customers to read and create records in a specific Dataverse table. Which feature should control this access?

1. Business rule
2. Table permissions
3. Solution
4. Model-driven view

Correct Answer: 2

Explanation

Table permissions are used in Power Pages to control what website users can do with Dataverse records. They can grant permissions such as Read and Create and can be associated with appropriate web roles. This provides a controlled security model for exposing Dataverse data through the website. Business rules are primarily used for conditional application logic, solutions package application components, and model-driven views control record presentation inside model-driven apps. Therefore, table permissions are the correct feature for determining whether registered Power Pages users can read and create records in a Dataverse table.

Question 337

A Dataverse table contains a Formula column that calculates a value from other columns. What is the main purpose of this column type?

1. Store uploaded documents
2. Provide predefined selections
3. Calculate values using supported expressions
4. Store image files

Correct Answer: 3

Explanation

Formula columns are designed to calculate values using supported formula expressions based on data available in Dataverse. They can reduce the need for separate automation when the calculation fits the capabilities of Formula columns. For example, a calculated result can be derived from numeric or other supported fields and used within the application. Storing uploaded documents requires a File column, predefined selections are handled by Choice columns, and image data can be stored using appropriate image capabilities. Therefore, calculating values through supported expressions is the primary purpose of a Formula column.

Question 338

A Power Automate flow in a solution uses an external connector. The connection will be different in development and production. Which solution component should represent the connection?

1. View
2. Connection reference
3. Business rule
4. Dashboard

Correct Answer: 2

Explanation

A connection reference is designed to represent connector connections used by solution-aware components such as Power Automate flows. It helps separate the flow definition from a specific connection so that the appropriate connection can be configured in each environment. This is especially useful in development, test, and production scenarios where different credentials or connection resources are required. A view, business rule, and dashboard do not manage connector authentication or environment-specific connection configuration. Therefore, a connection reference is the correct solution component for managing the external connector connection across environments.

Question 339

A canvas app needs to update the address of an existing Account record without using an Edit Form. Which Power Fx function should be used?

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

Correct Answer: 4

Explanation

Patch is used to create or modify records directly from Power Fx. In this scenario, the app can identify the existing Account and use Patch to update its address fields without relying on an Edit Form. Filter returns a table of records that match specified conditions, LookUp retrieves a matching record, and Navigate changes the current screen. Although LookUp could be used to identify the Account before an update, it does not perform the update itself. Therefore, Patch is the correct function for directly changing the Account address.

Question 340

A developer wants to diagnose unexpected network requests and runtime behavior in a canvas app while reproducing a user issue. Which Power Apps feature should be used?

1. Monitor
2. Site map
3. Business process flow
4. Solution

Correct Answer: 1

Explanation

Power Apps Monitor provides runtime diagnostic information for canvas apps. Developers can use it while reproducing an issue to inspect events, data requests, network activity, formula behavior, and other runtime operations. This makes Monitor particularly useful for identifying unexpected network calls, slow operations, or other problems that are difficult to diagnose by simply reviewing the app design. A site map controls navigation in model-driven apps, a business process flow guides users through process stages, and a solution packages components for deployment. Therefore, Monitor is the appropriate tool for runtime troubleshooting.