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

 

Question 301

A Dataverse table needs to store the exact time when a customer request was submitted. Which column type should you use?

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

Correct Answer: 1

Explanation

The Date and Time column type is appropriate for storing timestamps such as the date and time when a customer request was submitted. It allows the value to be used for sorting, filtering, reporting, and time-based business logic. A Choice column is intended for predefined selections, while Currency is used for monetary values. Whole Number is appropriate for integer values such as quantities. Using Date and Time ensures that the submission timestamp is stored as structured temporal data that can be used by model-driven apps, canvas apps, Power Automate flows, and Dataverse queries.

Question 302

A company maintains a list of customer service priorities with the values Low, Medium, High, and Critical. Which Dataverse column type is most appropriate?

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

Correct Answer: 2

Explanation

A Choice column is appropriate when users must select from a predefined list of values. In this case, Low, Medium, High, and Critical can be configured as controlled options for the priority field. This improves data consistency and makes the field easier to use in views, business rules, and Power Automate conditions. A Text column would allow users to enter inconsistent values manually. A Lookup should be used when the options are maintained as records in another Dataverse table, while File is designed for documents. Therefore, Choice is the best fit for the priority requirement.

Question 303

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

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

Correct Answer: 3

Explanation

A view is designed to display a filtered set of Dataverse records in a model-driven app. The Opportunity view can be configured with conditions such as Status equals Open and Estimated Revenue greater than $75,000. It can also specify the columns displayed and the sorting order. A dashboard is used for visual summaries, while a business rule controls supported form behavior. A business process flow guides users through business stages. Since the requirement is to create a filtered list of Opportunities, a view is the correct component to configure.

Question 304

A cloud flow should automatically send an email when a new high-priority Case is created in Dataverse. Which trigger should be used?

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

Correct Answer: 2

Explanation

The Dataverse trigger When a row is added, modified, or deleted can start the flow automatically when a Case record is created. The trigger can be configured for the Case table and the appropriate change type. After the trigger runs, the flow can check whether the Case has a high-priority value and then send the required email. A Recurrence trigger would run on a schedule rather than immediately when the record is created. A manual trigger requires user intervention, and a Power Apps trigger requires an app to initiate the flow. Therefore, the Dataverse trigger is correct.

Question 305

A model-driven app should make the Discount field required only when the Opportunity’s Estimated Revenue is greater than $100,000. Which feature should you use?

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

Correct Answer: 1

Explanation

A business rule can evaluate conditions and modify field behavior on supported model-driven app forms. In this scenario, the rule can check whether Estimated Revenue is greater than $100,000 and then make the Discount field required. This provides conditional form behavior without requiring custom JavaScript. A view controls which records are displayed, while dashboards and charts provide visual summaries of data. They do not provide the required conditional field behavior. Therefore, a business rule is the most appropriate feature for making the Discount field mandatory based on the Opportunity’s revenue.

Question 306

A company wants customer service agents to follow standardized stages when processing Cases. Each stage should contain specific steps that agents must complete. Which feature should be used?

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

Correct Answer: 2

Explanation

A business process flow provides a guided process consisting of stages and steps. For customer service Cases, stages could include Identify, Investigate, Resolve, and Close, with relevant fields or steps associated with each stage. This helps agents follow a consistent process and improves the quality of Case handling. A view is used to display filtered records, while a Choice column stores predefined values. A chart provides visual analysis. None of these provides the same guided stage-based experience. Therefore, a business process flow is the appropriate feature for standardizing the Case process.

Question 307

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

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

Correct Answer: 1

Explanation

A subgrid is used to display related records directly on a model-driven app form. By adding a Contacts subgrid to the Account main form, users can see Contacts associated with that Account without leaving the Account record. Depending on configuration and permissions, users may also be able to create or open related records from the subgrid. A chart is intended for data visualization, while a site map controls application navigation. A business rule controls form behavior based on conditions. Therefore, the subgrid is the correct component for displaying related Contacts on the Account form.

Question 308

A development team needs to deploy a model-driven app, Dataverse tables, views, and Power Automate flows from development to test. Which component should be used to package these items?

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

Correct Answer: 3

Explanation

A solution is used to package related Power Platform components for application lifecycle management. It can contain Dataverse tables, columns, relationships, views, model-driven apps, cloud flows, business rules, and other components. The solution can be exported from the development environment and imported into the test environment. A dashboard, business rule, or view represents only an individual component and cannot serve as the overall application deployment package. Solutions also help manage dependencies between components. Therefore, using a solution is the appropriate approach for moving the application from development to test.

Question 309

An Opportunity table needs a column that allows a user to select an existing Contact record as the primary contact. Which column type should be used?

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

Correct Answer: 2

Explanation

A Lookup column establishes a reference to an existing record in another Dataverse table. In this scenario, the Opportunity can use a Contact lookup so users can select an existing Contact as the primary contact. This creates a proper relationship instead of storing the contact’s name as plain text. A Text column would not establish a relational reference, while a Choice column is intended for predefined options. A Yes/No column supports only Boolean values. Therefore, a Lookup column is the appropriate data model for connecting the Opportunity to an existing Contact.

Question 310

A company needs to store the total value of a sales order, including decimal amounts and currency information. 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 specifically for monetary values. It supports amounts such as 1250.50 and works with Dataverse currency functionality, making it suitable for sales orders, invoices, prices, costs, and revenue. Whole Number is intended for integer values and is not appropriate for monetary amounts that may include decimals. Text would store the amount as characters, making calculations and reporting less appropriate. Yes/No can only represent two states. Therefore, Currency is the correct choice for storing the total value of a sales order.

Question 311

A canvas app contains an Edit Form control named OrderForm. A button should save the data entered by the user. Which Power Fx function should be used?

1. SubmitForm(OrderForm)
2. Navigate(HomeScreen)
3. Filter(Orders, Status = “Open”)
4. LookUp(Orders, OrderID = 1)

Correct Answer: 1

Explanation

SubmitForm is used to submit the contents of a Form control to its connected data source. If OrderForm is an Edit Form connected to a Dataverse Orders table, SubmitForm(OrderForm) will validate and submit the user’s changes. Navigate changes the current screen, Filter returns a table of records that meet a condition, and LookUp retrieves a matching record. Therefore, SubmitForm is the appropriate function for saving information entered into the OrderForm. Developers can also use the form’s OnSuccess and OnFailure properties to respond to the result of the submission.

Question 312

A canvas app contains a gallery displaying customer records. You need to show only customers whose Status is “Active”. Which Power Fx function should you use?

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

Correct Answer: 3

Explanation

The Filter function returns a table containing records that meet a specified condition. For example, Filter(Customers, Status = “Active”) can be used as the Items property of a gallery to display only active customers. LookUp is intended to retrieve a specific matching record, while Navigate changes the current screen. Patch is used to create or update records. Since the requirement is to display multiple customer records that satisfy the Active condition, Filter is the most appropriate Power Fx function. It allows the gallery to dynamically display the desired subset of records.

Question 313

A canvas app needs to retrieve one Account record based on a unique Account Number entered by the user. Which Power Fx function should be used?

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

Correct Answer: 2

Explanation

LookUp is designed to find a record that satisfies a specified condition and return that record or a particular field from it. Because Account Number is being used as a unique identifier, a formula such as LookUp(Accounts, AccountNumber = txtAccountNumber.Text) can retrieve the corresponding Account. Filter would return a table of matching records rather than a single record. Navigate changes screens, while Patch creates or updates records. Therefore, LookUp is the most appropriate function for retrieving one Account based on its unique Account Number.

Question 314

A Power Automate flow needs to update the Status column of an existing Dataverse Case after an approval is completed. Which action should be used?

1. List rows
2. Add a new row
3. Update a row
4. Delete a row

Correct Answer: 3

Explanation

The Update a row action in the Microsoft Dataverse connector is designed to modify an existing Dataverse record. The flow can use the Case’s unique identifier to locate the record and then set its Status or other required fields after the approval is completed. List rows retrieves multiple records, Add a new row creates a new record, and Delete a row removes an existing record. Because the requirement is to modify an existing Case, Update a row is the correct Dataverse action. This approach allows the flow to automate status changes reliably after the approval process.

Question 315

An administrator wants to prevent users in a particular role from deleting Account records while still allowing them to read and update those records. Which feature should be configured?

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

Correct Answer: 2

Explanation

Security roles control Dataverse privileges such as Create, Read, Write, Delete, Append, Append To, Assign, and Share. The administrator can configure the appropriate role to grant Read and Write privileges while withholding Delete privileges for the Account table. This provides the required level of access without preventing users from working with the records entirely. A view controls record presentation but does not replace security privileges. Dashboards provide visual summaries, and business process flows guide users through stages. Therefore, the security role is the correct feature for controlling the user’s ability to delete Account records.

Question 316

A Power Pages site should allow customers to view only the records associated with their own account. Which feature is primarily used to define this type of Dataverse access?

1. Table permissions
2. Business process flow
3. Model-driven chart
4. Canvas app form

Correct Answer: 1

Explanation

Table permissions are used in Power Pages to control access to Dataverse records. They can be configured to provide access based on relationships between the website user and Dataverse records, allowing scenarios such as customers seeing records associated with their own account. Web roles can be used to associate permissions with groups of website users. Business process flows are used for guided processes, while model-driven charts and canvas app forms serve different application purposes. Therefore, table permissions are the primary feature for controlling which Dataverse records Power Pages users can access.

Question 317

A Dataverse table contains a Formula column that calculates a customer’s total order value from other supported columns. What is the primary benefit of using this type of column?

1. It can calculate values without requiring a separate automation flow
2. It automatically creates a security role
3. It replaces all Dataverse relationships
4. It creates a Power Pages web role

Correct Answer: 1

Explanation

Formula columns allow supported calculations to be defined directly within Dataverse using formula expressions. This means a calculated value can be derived from other columns without requiring a separate Power Automate flow simply to perform the calculation and store the result. This can simplify the application architecture and keep appropriate calculation logic close to the data model. Formula columns do not create security roles, replace relationships, or create Power Pages web roles. Those capabilities are handled by different Power Platform features. Therefore, reducing the need for separate automation for supported calculations is a key benefit.

Question 318

A solution contains a cloud flow that uses a Dataverse connection. During deployment to production, the production environment requires a different connection. Which component helps manage this difference?

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

Correct Answer: 2

Explanation

A connection reference allows solution-aware components such as Power Automate flows to use a connector connection that can be mapped appropriately in each environment. This is particularly useful when moving solutions from development to test and production because different environments may require different credentials or connection resources. Instead of embedding a specific connection directly into the solution component, the connection reference provides an abstraction that can be associated with the appropriate connection in the target environment. Views, business rules, and Choice columns do not provide this capability. Therefore, Connection reference is the correct answer.

Question 319

A canvas app needs to update the Phone field of an existing Contact record without submitting a form. Which Power Fx function should be used?

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

Correct Answer: 3

Explanation

Patch allows a canvas app to create or modify records directly and is useful when only selected fields need to be changed. In this scenario, the app can identify the existing Contact record and use Patch to update its Phone field without submitting an entire form. Navigate is used for moving between screens, Filter returns multiple matching records, and LookUp retrieves a record or field value. Therefore, Patch provides the required direct update capability. It is especially useful when the app needs precise control over which fields are changed during an operation.

Question 320

A maker is investigating why a canvas app is performing slowly and wants to inspect data calls and runtime events while reproducing the issue. Which tool should be used?

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

Correct Answer: 3

Explanation

Power Apps Monitor is a runtime diagnostic tool that helps makers understand what is happening inside a canvas app. It can provide visibility into data requests, events, formula activity, network operations, and other runtime behavior. This makes it useful for investigating slow performance or unexpected data calls while reproducing an issue. A business process flow is used to guide users through stages, a solution packages components for deployment, and a site map defines navigation in model-driven apps. Therefore, Monitor is the appropriate tool for diagnosing runtime behavior and performance issues in a canvas app.