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

 

Question 281

A company needs to store the number of units purchased by a customer. The value must be a whole integer, such as 1, 25, or 100. Which Dataverse column type should you use?

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

Correct Answer: 1

Explanation

The Whole Number column type is appropriate for storing integer values where decimal places are not required. A field such as Units Purchased could contain values like 1, 25, or 100 and can be used for calculations, sorting, and filtering. Currency is intended for monetary values, while Choice provides predefined selectable options. Date and Time is designed for temporal information. Choosing the correct Dataverse column type ensures that the data is stored in an appropriate format and can be used effectively in views, business rules, Power Automate flows, and other Power Platform components.

Question 282

A model-driven app needs a view that allows users to see Account Name, Primary Contact, City, and Annual Revenue, while also allowing them to sort and filter the records. Which component should you configure?

1. Business process flow
2. View
3. Business rule
4. Canvas gallery

Correct Answer: 2

Explanation

A view in a model-driven app defines which records and columns users see in a list. The view can include Account Name, Primary Contact, City, and Annual Revenue and can provide sorting and filtering capabilities appropriate to the user’s needs. Business process flows guide users through stages, while business rules control supported form behavior. A canvas gallery is a control used in canvas apps rather than the primary list component for model-driven app tables. Therefore, configuring a Dataverse view is the correct approach for presenting and organizing the Account records in this scenario.

Question 283

You create a cloud flow that should automatically notify a sales manager whenever a new Opportunity is created in Dataverse. Which trigger should you use?

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

Correct Answer: 3

Explanation

The Dataverse trigger When a row is added, modified, or deleted can automatically start a cloud flow when a new Opportunity record is created. The trigger can be configured for the Opportunity table and limited to the required change type. The flow can then send a notification or email to the sales manager. A manual trigger requires a person to start the flow, while Recurrence runs according to a schedule rather than responding immediately to a Dataverse event. A Power Apps trigger is appropriate when the flow is explicitly initiated from an app. Therefore, the Dataverse row-change trigger is the best option.

Question 284

A company wants sales representatives to follow the same sequence of stages when processing Leads. Which Power Platform feature should be configured?

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

Correct Answer: 2

Explanation

A business process flow provides a guided sequence of stages that helps users follow a consistent business process. For Leads, an organization could define stages such as Qualify, Develop, and Convert, with relevant steps at each stage. This improves consistency and helps users understand what information or actions are expected at each point in the process. A business rule is primarily used for conditional form logic, while a view filters and displays records. A dashboard presents visual summaries and does not guide users through operational stages. Therefore, a business process flow is the appropriate feature.

Question 285

A Contact form should make the Preferred Contact Method field mandatory only when the Contact’s Status is Active. Which feature should you use?

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

Correct Answer: 1

Explanation

A business rule can evaluate conditions on a Dataverse form and change field behavior accordingly. In this example, the business rule can check whether the Contact Status is Active and then make Preferred Contact Method a required field. This provides a declarative solution without requiring custom JavaScript. A chart is used for data visualization, while a site map controls navigation in a model-driven app. A solution packages application components for deployment but does not itself implement the conditional requirement. Therefore, the business rule is the correct feature for making the field conditionally mandatory.

Question 286

An Account main form needs to display related Cases so customer service representatives can quickly review the support history. Which component should be added?

1. Chart
2. Subgrid
3. Business rule
4. Business process flow

Correct Answer: 2

Explanation

A subgrid is designed to display a collection of related Dataverse records directly on a model-driven app form. An Account form can contain a Cases subgrid that displays Cases associated with that Account. This allows users to review related records without navigating away from the Account. A chart provides visual analysis rather than a detailed related-record list. A business rule controls conditional form behavior, while a business process flow guides users through stages. Therefore, adding a Cases subgrid to the Account main form is the appropriate configuration for displaying support history.

Question 287

A developer wants to package an application and its Dataverse components so they can be moved from development to a test environment. Which component should contain the application components?

1. View
2. Solution
3. Dashboard
4. Choice column

Correct Answer: 2

Explanation

A solution provides a container for related Power Platform components that need to be managed and moved between environments. It can include tables, columns, relationships, apps, flows, business rules, views, and other components. The development team can export the solution and import it into the test environment as part of the application’s lifecycle. A view, dashboard, or Choice column is only an individual component and does not provide the same packaging capability. Therefore, the solution should be used to contain and deploy the application components.

Question 288

An Opportunity record needs to reference an existing Product record selected by the user. Which Dataverse column type should be used?

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

Correct Answer: 2

Explanation

A Lookup column is used to create a reference from one Dataverse record to another. In this scenario, the Opportunity needs to reference an existing Product record, so a Product lookup allows users to select the appropriate record from the Product table. Text would only store the product name without creating a relational reference. Yes/No supports only Boolean values, and Currency stores monetary amounts. A Lookup also enables the application to take advantage of relationships between tables and retrieve related information. Therefore, the Lookup column is the correct choice.

Question 289

A Dataverse table needs to store a customer’s email address. Which column type is most appropriate for storing the email text?

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

Correct Answer: 1

Explanation

A Text column is appropriate for storing an email address as textual data. It can hold values such as customer@example.com and can be displayed or used in application logic as required. Whole Number is intended for integer values, while Currency is used for monetary amounts. Yes/No is designed for Boolean values. Although Dataverse can provide specialized email-related functionality in appropriate scenarios, a standard text field is suitable when the requirement is simply to store an email address as text. Selecting the correct data type helps maintain consistent and usable data throughout the application.

Question 290

A cloud flow retrieves a set of Orders and needs to continue only when the Order Total is greater than $5,000. Which Power Automate component should you use?

1. Condition
2. Connection reference
3. Environment variable
4. Trigger

Correct Answer: 1

Explanation

A Condition action allows a Power Automate flow to evaluate a value and execute different paths depending on whether the condition is true or false. In this case, the flow can compare Order Total with $5,000 and continue with the required actions only when the value exceeds that amount. A trigger starts the flow, while a connection reference manages a connector connection in a solution. An environment variable stores configurable values that can differ between environments. Therefore, the Condition action is the appropriate component for implementing this decision logic.

Question 291

A canvas app needs to display multiple customer records from a Dataverse table, with each record shown using the same visual layout. Which control should you use?

1. Gallery
2. Timer
3. Button
4. Form

Correct Answer: 1

Explanation

A Gallery control is designed to display multiple records in a repeating layout. The gallery can connect to a Dataverse table and display fields such as customer name, phone number, and city for each record. Developers can customize the controls inside the gallery while maintaining the same layout for every item. A Timer is used for time-based operations, a Button is primarily used for user actions, and a Form is generally used to display or edit a single record at a time. Therefore, a Gallery is the most suitable control for this requirement.

Question 292

A canvas app contains a button that should take the user from the Home screen to a screen called CustomerScreen. Which Power Fx expression should be used?

1. Filter(Customers, Active = true)
2. Navigate(CustomerScreen)
3. Patch(Customers, Defaults(Customers), {})
4. LookUp(Customers, ID = 1)

Correct Answer: 2

Explanation

The Navigate function is used to move between screens in a canvas app. When placed in a button’s OnSelect property, Navigate(CustomerScreen) directs the user to the CustomerScreen when the button is selected. Filter returns a table of records, Patch creates or updates records, and LookUp retrieves a matching record. None of those functions are intended primarily for screen navigation. Therefore, Navigate is the correct Power Fx function for changing the current screen after the user selects the button.

Question 293

A canvas app needs to find a single Account whose Account Number matches the value entered in a text input control. Which Power Fx function should you use?

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

Correct Answer: 1

Explanation

LookUp is designed to find a record that matches a specified condition and return that record or a specific field from it. For example, the app can use a formula such as LookUp(Accounts, AccountNumber = txtAccountNumber.Text) to retrieve the matching Account. Filter is used when the application needs a table of matching records rather than a single result. Navigate changes screens, while SubmitForm submits the data from a form control. Because an Account Number is typically used to identify a specific Account, LookUp is the appropriate function for this requirement.

Question 294

A Power Automate flow must retrieve all active Contact records from Dataverse so that each record can be processed. Which action should you use?

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

Correct Answer: 3

Explanation

The List rows action in the Microsoft Dataverse connector retrieves multiple records from a table. The action can be configured with a filter so that only active Contacts are returned. The resulting records can then be processed by subsequent flow actions, often using an Apply to each loop when multiple records are returned. Add a new row creates data, Delete a row removes data, and Get a row by ID retrieves a specific record. Therefore, List rows is the appropriate action when the flow needs to retrieve and process a collection of active Contacts.

Question 295

A user needs permission to create, read, and update records in a specific Dataverse table. Which component defines these privileges?

1. Security role
2. View
3. Business process flow
4. Dashboard

Correct Answer: 1

Explanation

Dataverse security roles define the privileges that users have for tables and other secured resources. A role can grant Create, Read, Write, Delete, Append, Append To, Assign, and Share privileges with different access levels. This allows administrators to implement role-based security according to users’ responsibilities. Views control which records and columns are presented but do not replace the underlying security model. Business process flows guide users through stages, while dashboards summarize data visually. Therefore, a security role is the appropriate component for granting create, read, and update privileges.

Question 296

A Power Pages site should allow a specific group of website users to create and read records in a Dataverse table. Which feature should be configured?

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

Correct Answer: 2

Explanation

Table permissions are a key Power Pages security mechanism for controlling access to Dataverse tables. They can be associated with web roles so that specific groups of website users receive permissions such as Read, Create, Write, or other supported access. This allows the website to expose only the data and operations appropriate for its users. Business rules are primarily used for application logic, solution layers relate to component customization and ALM, and model-driven forms are used within model-driven apps rather than controlling Power Pages website access. Therefore, table permissions are the correct choice.

Question 297

A Dataverse table needs a value that is automatically calculated from other columns in the same row, without requiring a Power Automate flow. Which column type can be used for this purpose?

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

Correct Answer: 1

Explanation

A Formula column can calculate a value based on other data using supported formula expressions. This allows certain calculations to be maintained within Dataverse rather than requiring a separate cloud flow to calculate and write the value. For example, a formula can derive a value from other columns when the supported scenario fits the formula column capabilities. File columns store documents, Choice columns provide predefined options, and Image columns store image data. Therefore, a Formula column is the most appropriate option when the required value can be calculated directly from other Dataverse data.

Question 298

A solution contains a cloud flow that uses a SharePoint connection. When the solution is moved to another environment, the team wants to associate the flow with the appropriate SharePoint connection in that environment. Which component should be used?

1. Business rule
2. Connection reference
3. View
4. Choice column

Correct Answer: 2

Explanation

A connection reference allows solution-aware components such as Power Automate flows to refer to a connector connection separately from the component itself. This is useful when solutions move between environments because the SharePoint connection used in development may not be the same connection required in testing or production. The connection reference can be associated with the appropriate connection in the target environment. Business rules, views, and Choice columns do not provide this connection-management capability. Therefore, a connection reference is the appropriate component for handling the SharePoint connection across environments.

Question 299

A canvas app needs to update the City field of an existing Account record without submitting an entire edit form. Which Power Fx function should you use?

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

Correct Answer: 3

Explanation

Patch is appropriate when a canvas app needs to modify selected fields of an existing record without submitting a complete form. The app can identify the Account record and provide the City field with its new value. This provides precise control over which fields are updated. Filter is used to retrieve multiple matching records, Navigate changes screens, and LookUp retrieves a matching record. Since the requirement is to update a specific field on an existing Account directly, Patch provides the appropriate Power Fx functionality and avoids unnecessary form submission.

Question 300

A developer is troubleshooting a canvas app and wants to observe data requests, formula evaluations, and runtime events while reproducing a problem. Which Power Apps feature should be used?

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

Correct Answer: 3

Explanation

Power Apps Monitor provides runtime diagnostic information that helps makers investigate how a canvas app behaves during execution. It can expose events, data requests, formula activity, network operations, and other useful information while the developer reproduces an issue. This makes Monitor valuable for identifying unexpected behavior and performance problems. A site map controls navigation in model-driven apps, a business process flow guides users through business stages, and a solution is primarily used for packaging and application lifecycle management. Therefore, Monitor is the appropriate tool for runtime troubleshooting and analyzing canvas app behavior.