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

 

Question 361

A company needs to store the number of products purchased by a customer. The value must be a whole integer with no decimal places. Which Dataverse column type should be used?

1. Whole Number
2. Currency
3. Text
4. Date and Time

Correct Answer: 1

Explanation

The Whole Number column type is designed for values that must be stored as integers without decimal places. A quantity such as the number of products purchased is a typical example because values such as 5, 20, or 100 are appropriate, while decimal values would not normally make sense. Currency is intended for monetary amounts, Text stores character data, and Date and Time is used for temporal information. Using Whole Number also allows the value to be used appropriately in filtering, sorting, calculations, and business logic. Therefore, Whole Number is the best choice for storing product quantities.

Question 362

A business wants users to select a customer’s preferred contact method from Email, Phone, SMS, or Mail. The options should be predefined. Which column type should be used?

1. Text
2. Choice
3. Lookup
4. File

Correct Answer: 2

Explanation

A Choice column is appropriate when users need to select one value from a predefined set of options. Email, Phone, SMS, and Mail can be configured as the available choices, ensuring that users consistently select valid values. Text would allow users to enter arbitrary values and could result in inconsistent data. Lookup should be used when the values are stored as records in another Dataverse table, while File is intended for documents. Therefore, a Choice column provides the appropriate structure for storing a customer’s preferred contact method.

Question 363

A sales manager wants a model-driven app view that displays only Open Opportunities with an estimated revenue greater than $75,000. Which component should be configured?

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

Correct Answer: 3

Explanation

A view is used in a model-driven app to define which records users see in a list. The manager can configure filters so that only Opportunities with an Open status and estimated revenue greater than $75,000 are displayed. Views can also specify which columns appear and how records are sorted. A chart visualizes data, while a dashboard combines multiple visual components. A business process flow guides users through stages rather than filtering records. Therefore, a view is the correct component for creating this filtered Opportunity list.

Question 364

A Power Automate cloud flow should automatically run whenever an existing Opportunity record is modified in Dataverse. Which trigger should be configured?

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 trigger When a row is added, modified, or deleted can be configured to start a flow when an Opportunity record is modified. The maker can select the Opportunity table and configure the change type to respond to modifications. This enables automated actions such as notifications, updates, or integrations after a record changes. A manual trigger requires a user to start the flow, Recurrence runs according to a schedule, and the Power Apps trigger is intended for flows initiated from an app. Therefore, the Dataverse row-change trigger is the appropriate choice.

Question 365

A Case form should make the Resolution Details field required only when the Case Status is set to Resolved. Which Power Platform feature should be used?

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

Correct Answer: 1

Explanation

A business rule can evaluate a field value and change the behavior of another field on a supported form. In this scenario, the rule can check whether the Case Status is Resolved and then set Resolution Details as a required field. This provides declarative logic without requiring custom JavaScript for a straightforward form behavior requirement. A chart and dashboard are intended for visualization, while a view controls which records and columns appear in a list. Therefore, a business rule is the most suitable feature for implementing this conditional requirement.

Question 366

A customer service organization wants agents to follow the stages Identify Issue, Investigate, Resolve, and Close for every service Case. Which feature should be used?

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

Correct Answer: 2

Explanation

A business process flow is designed to guide users through standardized stages of a business process. The service organization can configure stages such as Identify Issue, Investigate, Resolve, and Close and define the information users should complete during those stages. This promotes consistency across Case handling. A Choice column can store a selected status but does not provide the guided process experience of a business process flow. A subgrid displays related records, and a view filters and displays records. Therefore, a business process flow is the correct feature for guiding service agents through standardized Case stages.

Question 367

An Account form needs to display all Opportunities associated with the current Account. Which model-driven app component should be added to the form?

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

Correct Answer: 1

Explanation

A subgrid is used to display related Dataverse records directly within a model-driven app form. By adding an Opportunities subgrid to the Account form, users can see the Opportunities associated with the current Account and, depending on configuration, interact with those related records. A chart is used for visual analysis, a site map controls navigation between application areas, and a business rule controls supported form behavior. Therefore, a subgrid is the appropriate component for displaying related Opportunities on the Account form.

Question 368

A development team needs to deploy a model-driven app, its Dataverse tables, views, forms, and Power Automate flows from a development environment to a test environment. What should they use?

1. Dashboard
2. Solution
3. Chart
4. Business process flow

Correct Answer: 2

Explanation

A solution packages Power Platform components so they can be moved between environments as part of application lifecycle management. The development team can include the model-driven app, Dataverse tables, forms, views, and flows in a solution and then export and import that solution into the test environment. This is more appropriate than deploying individual components separately. Dashboards and charts are individual application components, while business process flows represent business processes. Therefore, a solution is the correct mechanism for packaging and moving the application’s components between environments.

Question 369

An Opportunity should reference an existing Contact record as its primary contact. Which Dataverse column type should be used?

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

Correct Answer: 1

Explanation

A Lookup column is used to create a reference to an existing record in another Dataverse table. In this case, the Opportunity can have a lookup to the Contact table so users can select the appropriate Contact as the primary contact. This preserves the relationship between the Opportunity and Contact records and avoids storing the contact’s name as unstructured text. Text would only store characters, Choice is intended for predefined options, and Yes/No supports Boolean values. Therefore, Lookup is the correct column type for referencing an existing Contact record.

Question 370

An organization needs to store the total discount amount applied to an invoice. The value must support decimal amounts and currency calculations. Which Dataverse column type should be used?

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

Correct Answer: 3

Explanation

Currency is the appropriate Dataverse column type for monetary values such as invoice discounts. It supports financial amounts and can be used in calculations, views, reports, and other business logic where monetary data is required. Whole Number does not support decimal monetary values appropriately, while Text would store the amount as characters and make financial calculations more difficult. Yes/No only stores a Boolean state. Therefore, Currency is the correct choice for an invoice discount amount. Using the appropriate monetary data type also helps maintain consistency across financial fields in the application.

Question 371

A canvas app has a button that should open a screen named OrderDetailsScreen when the user selects the button. Which Power Fx function should be used?

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

Correct Answer: 1

Explanation

The Navigate function is used in canvas apps to move users from one screen to another. The button’s OnSelect property can use Navigate(OrderDetailsScreen) to open the specified screen when selected. Filter is used to return records that meet specified conditions, Patch is used to create or modify records, and LookUp retrieves a matching record. Since the requirement is specifically to move from the current screen to OrderDetailsScreen, Navigate is the appropriate Power Fx function. Additional parameters can also be supplied when information needs to be passed to the destination screen.

Question 372

A canvas app displays a gallery of customers. The maker wants the gallery to show only customers whose status is Active. Which Power Fx function should be used?

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

Correct Answer: 3

Explanation

The Filter function returns a table containing records that satisfy a specified condition. The gallery’s Items property can use an expression such as Filter(Customers, Status = “Active”) to display only active customers. LookUp is more appropriate when retrieving a single matching record, Navigate changes screens, and Patch is used to create or modify records. Therefore, Filter is the correct function for limiting the gallery to Active customers. It can also be combined with additional conditions when the app needs to apply multiple filtering criteria.

Question 373

A canvas app needs to retrieve the phone number of a specific Contact based on the Contact’s email address. Which Power Fx function is most appropriate?

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

Correct Answer: 4

Explanation

LookUp is designed to find a record that matches a specified condition and can return a particular field from that record. For example, LookUp(Contacts, Email = selectedEmail, Phone) can return the phone number of the matching Contact. Filter would return a table of matching records instead of directly returning the requested field. Patch is used for creating or modifying data, while Navigate changes screens. Therefore, LookUp is the most suitable function when the application needs to find a specific Contact and retrieve its phone number.

Question 374

A Power Automate flow needs to retrieve multiple Account records that meet specified criteria from Dataverse. Which action should be used?

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

Correct Answer: 4

Explanation

The List rows action is used with Dataverse when a flow needs to retrieve multiple records from a table. The action can be configured with filtering and other query options so that only Accounts meeting the required conditions are returned. Get a row by ID is intended for retrieving one known record, Update a row modifies an existing record, and Add a new row creates a record. Therefore, List rows is the appropriate action when multiple Account records need to be retrieved for processing in a cloud flow.

Question 375

A company wants to prevent a group of users from deleting Customer records while allowing them to read and update those records. Which feature controls these Dataverse privileges?

1. Security role
2. View
3. Dashboard
4. Chart

Correct Answer: 1

Explanation

Dataverse security roles define privileges such as Read, Write, Create, Delete, Append, and Append To. An administrator can configure a security role to provide users with Read and Write access to Customer records while withholding Delete privileges. Views can filter and display records but do not replace the underlying security model. Dashboards and charts are visualization features and do not control record-level privileges. Therefore, the security role is the correct feature for controlling whether users can read, update, or delete Customer records.

Question 376

A Power Pages site should allow registered customers to create new Support Ticket records in Dataverse. Which configuration is required to grant the appropriate table access?

1. Chart configuration
2. Table permissions
3. Business process flow
4. Canvas gallery

Correct Answer: 2

Explanation

Power Pages uses table permissions to control how website users can interact with Dataverse data. To allow registered customers to create Support Ticket records, the appropriate table permission must grant Create access and be associated with the relevant web role. This provides controlled access to the Dataverse table through the website. A chart only visualizes data, a business process flow guides users through business stages, and a canvas gallery is a control used in canvas apps. Therefore, table permissions are required to allow customers to create Support Ticket records through Power Pages.

Question 377

A Dataverse table contains a value that should automatically calculate the difference between two supported numeric fields. Which column type is appropriate?

1. Formula
2. File
3. Image
4. Choice

Correct Answer: 1

Explanation

A Formula column can be used to calculate a value based on other supported columns and expressions. For example, a table could use a formula to calculate a remaining amount from an original amount and an amount already used. This avoids manually entering the calculated result and can reduce the need for additional automation for straightforward calculations. File and Image columns are intended for storing or referencing corresponding data types, while Choice provides predefined options. Therefore, Formula is the appropriate column type when a Dataverse value should be automatically calculated from other supported fields.

Question 378

A Power Automate flow uses a connection reference in a solution. During deployment to production, the administrator needs to associate it with the production connector connection. What does the connection reference provide?

1. A filtered Dataverse view
2. A model-driven app chart
3. A reusable reference to a connector connection
4. A business process stage

Correct Answer: 3

Explanation

A connection reference provides a reusable reference to a connector connection for solution-aware components such as Power Automate flows. This is especially useful in application lifecycle management because the connection used in development may differ from the connection required in test or production. During deployment, administrators can associate the connection reference with the appropriate environment-specific connection. A view, chart, or business process stage does not provide this capability. Therefore, the connection reference is the correct mechanism for managing connector connections across solution environments.

Question 379

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

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

Correct Answer: 4

Explanation

Patch is used in canvas apps to create or modify records directly. In this scenario, the developer can identify the existing Case and use Patch to update only its Status field without submitting an Edit Form. Filter returns a set of records that meet specified conditions, Navigate changes screens, and LookUp retrieves a matching record. Patch provides the flexibility needed for targeted updates and can modify one or more fields in a record. Therefore, Patch is the correct Power Fx function for changing the Case Status directly from the canvas app.

Question 380

A maker is troubleshooting a canvas app and wants to inspect runtime events, data operations, and possible performance problems while the app is running. Which feature should be used?

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

Correct Answer: 2

Explanation

Power Apps Monitor is designed to help makers and developers troubleshoot applications while they are running. It provides runtime information about events, data operations, network activity, and other behavior that can help identify performance or functional problems. A solution checker focuses on analyzing solution components and identifying potential issues rather than providing live runtime diagnostics. A site map controls navigation in model-driven apps, while a business process flow guides users through business stages. Therefore, Monitor is the most appropriate feature for investigating runtime behavior and performance issues in a canvas app.