View Full Microsoft PL-200 Exam Dumps and Practice Test Dumps.
Question 381
A company needs to store the date and time when a customer submitted a service request. Which Dataverse column type should be used?
- Date and Time
- Whole Number
- Currency
- Choice
Correct Answer: 1
Explanation
The Date and Time column type is designed to store temporal information such as when a customer submitted a service request. It can store both the date and time, allowing the organization to track when records were created or when specific events occurred. Whole Number is intended for integer values, Currency is used for monetary amounts, and Choice provides predefined selectable options. Using Date and Time allows the service organization to sort, filter, and report on requests based on submission time. Therefore, Date and Time is the most appropriate column type for this requirement.
Question 382
A sales organization wants users to select a customer’s membership level from Bronze, Silver, Gold, or Platinum. The values should be standardized across records. Which column type should be used?
- Text
- Choice
- Lookup
- File
Correct Answer: 2
Explanation
A Choice column is appropriate when users need to select a value from a predefined list. Bronze, Silver, Gold, and Platinum can be configured as the available options, helping ensure consistent data entry across customer records. A Text column would allow users to enter any value, potentially resulting in inconsistent spellings or values. A Lookup is appropriate when the selectable values are maintained as records in another Dataverse table, while File is intended for document storage. Therefore, Choice is the best option for implementing standardized membership levels.
Question 383
A sales manager wants a view that shows only Open Opportunities with an estimated revenue above $100,000. Which component should be configured?
- Dashboard
- Chart
- View
- Business process flow
Correct Answer: 3
Explanation
A view controls the records displayed in a model-driven app list and can include filtering, sorting, and selected columns. The manager can configure filters for Opportunity status and estimated revenue so that only Open Opportunities above $100,000 appear. A dashboard provides a broader visual summary, while a chart represents data graphically. A business process flow guides users through business stages rather than filtering records. Therefore, a view is the correct component for presenting a filtered list of high-value Open Opportunities to sales users.
Question 384
A Power Automate cloud flow must automatically start whenever a new Lead record is created in Dataverse. Which trigger should be used?
- Manually trigger a flow
- Recurrence
- When a row is added, modified, or deleted
- Power Apps trigger
Correct Answer: 3
Explanation
The Dataverse trigger called When a row is added, modified, or deleted can start a cloud flow when a new Lead record is created. The maker can select the Lead table and configure the change type to respond to newly added rows. This allows the flow to automatically perform actions such as sending notifications, creating follow-up tasks, or updating related information. A manual trigger requires user interaction, Recurrence runs on a schedule, and the Power Apps trigger is designed for flows initiated from an app. Therefore, the Dataverse row-change trigger is the appropriate choice.
Question 385
A Case form should require the Escalation Reason field only when the Case priority is changed to High. Which feature should be used?
- Business rule
- Dashboard
- Chart
- View
Correct Answer: 1
Explanation
A business rule can apply conditional logic to supported form fields without requiring custom code. In this scenario, the rule can check whether the Case priority is High and then make the Escalation Reason field required. This helps ensure that users provide the necessary information only when the business condition applies. A dashboard and chart are primarily used for data visualization, while a view controls the records and columns displayed in a list. Therefore, a business rule is the most suitable feature for implementing this conditional field requirement on the Case form.
Question 386
A company wants sales representatives to follow the stages Qualify, Develop, Propose, and Close when working with Opportunities. Which feature should be implemented?
- View
- Business process flow
- Choice column
- Subgrid
Correct Answer: 2
Explanation
A business process flow is designed to guide users through a standardized sequence of stages for a business process. For Opportunities, stages such as Qualify, Develop, Propose, and Close can be configured to help sales representatives follow the organization’s process consistently. A Choice column can store a selected value but does not provide the guided stage experience. A view displays filtered records, and a subgrid displays related records. Therefore, a business process flow is the appropriate feature for guiding sales representatives through standardized Opportunity stages.
Question 387
An Account form needs to show all Cases associated with the current Account. Which component should be added to the form?
- Subgrid
- Chart
- Site map
- Business rule
Correct Answer: 1
Explanation
A subgrid displays related records directly on a model-driven app form. By adding a Cases subgrid to the Account form, users can see the Cases associated with the current Account and interact with them according to their permissions. A chart is used to visualize information, while a site map controls navigation within the model-driven app. A business rule controls supported form behavior such as visibility, requirement level, or field values. Therefore, a subgrid is the correct component for displaying related Cases on the Account form.
Question 388
A development team wants to move a canvas app, Dataverse tables, and related cloud flows from development to a test environment. Which component should be used to package these components?
- Dashboard
- Solution
- View
- Chart
Correct Answer: 2
Explanation
A solution is used to package Power Platform components so they can be moved between environments. The development team can add the canvas app, Dataverse tables, flows, and other required components to a solution and then export it for import into the test environment. This supports application lifecycle management and helps maintain relationships and dependencies between components. A dashboard, view, or chart is an individual application component and does not provide the same packaging and deployment capability. Therefore, Solution is the correct choice for moving these components between environments.
Question 389
An Opportunity should reference an existing Account as its customer. Which Dataverse column type should be used?
- Lookup
- Text
- Choice
- Whole Number
Correct Answer: 1
Explanation
A Lookup column is used when a record needs to reference an existing record from another Dataverse table. In this case, the Opportunity can use a lookup to the Account table so users can select the appropriate existing Account. This maintains a structured relationship between the Opportunity and Account rather than storing the account name as plain text. Text is intended for character data, Choice is used for predefined options, and Whole Number stores integer values. Therefore, Lookup is the correct column type for associating an Opportunity with an existing Account.
Question 390
An organization needs to store the total tax amount on an invoice, including decimal values and currency formatting. Which Dataverse column type is most appropriate?
- Whole Number
- Text
- Currency
- Yes/No
Correct Answer: 3
Explanation
Currency is the appropriate Dataverse column type for storing monetary values such as invoice tax amounts. It supports decimal financial values and is designed for use with currency-related calculations and presentation. Whole Number is intended for integer values and is not appropriate when monetary amounts can contain decimals. Text would store the amount as characters rather than as a financial value, while Yes/No only represents a Boolean state. Therefore, Currency should be used for the invoice tax amount to maintain accurate financial data and support appropriate calculations and reporting.
Question 391
A canvas app contains a button that should open a screen named CustomerDetailsScreen. Which Power Fx function should be placed in the button’s OnSelect property?
- Navigate
- Filter
- Patch
- SubmitForm
Correct Answer: 1
Explanation
The Navigate function is used to move users between screens in a canvas app. The button’s OnSelect property can use Navigate(CustomerDetailsScreen) to open the CustomerDetailsScreen when the user selects the button. Filter is used to return records that meet specified conditions, Patch is used to create or modify records, and SubmitForm submits changes made through an Edit Form or New Form control. Because the requirement is specifically to move the user to another screen, Navigate is the appropriate Power Fx function.
Question 392
A canvas app displays a gallery of Cases. The maker wants to show only Cases whose Priority is High. Which Power Fx function should be used?
- LookUp
- Navigate
- Filter
- Patch
Correct Answer: 3
Explanation
The Filter function returns a table containing records that satisfy a specified condition. For example, the gallery’s Items property could use Filter(Cases, Priority = “High”) to display only high-priority Cases. LookUp is generally used to retrieve a single matching record, Navigate changes the current screen, and Patch is used to create or update records. Therefore, Filter is the correct function for limiting the gallery to Cases with High priority. Additional filtering conditions can also be combined when the application requires more complex criteria.
Question 393
A canvas app needs to retrieve a single Account record whose Account Number matches a value entered by the user. Which Power Fx function should be used?
- Filter
- Patch
- SubmitForm
- LookUp
Correct Answer: 4
Explanation
LookUp is designed to find a single record that meets a specified condition and can return either the complete record or a particular field from it. In this scenario, the app can use LookUp to find the Account whose Account Number matches the value entered by the user. Filter would return a table of matching records rather than directly targeting one record. Patch modifies or creates records, while SubmitForm submits changes through a form control. Therefore, LookUp is the most appropriate Power Fx function for retrieving the matching Account record.
Question 394
A cloud flow must retrieve multiple Contact records from Dataverse that meet a specified filter condition. Which Dataverse action should be used?
- Get a row by ID
- List rows
- Update a row
- Add a new row
Correct Answer: 2
Explanation
The List rows action retrieves multiple records from a Dataverse table. It can be configured with filter criteria so that the flow receives only Contacts that meet the required conditions. This is useful when a flow needs to process a collection of records rather than a single known record. Get a row by ID retrieves one specific record, Update a row changes an existing record, and Add a new row creates a record. Therefore, List rows is the appropriate Dataverse action for retrieving multiple Contact records based on filtering criteria.
Question 395
An administrator wants users to have Read and Write access to Opportunity records but not Delete access. Which Dataverse feature should be configured?
- Security role
- View
- Dashboard
- Business process flow
Correct Answer: 1
Explanation
Security roles define Dataverse privileges such as Read, Write, Create, Delete, Append, and Append To. An administrator can configure the appropriate security role to grant users Read and Write privileges while removing or restricting Delete privileges. This provides control over what users can do with records. A view determines which records are displayed and does not replace the security model. Dashboards provide visual summaries, while business process flows guide users through stages. Therefore, a security role is the correct feature for controlling these Dataverse permissions.
Question 396
A Power Pages site allows customers to access their Support Request records. The administrator needs to control whether these users can read and create records in the Support Request table. Which feature should be configured?
- Chart
- Table permissions
- Solution layer
- Business process flow
Correct Answer: 2
Explanation
Table permissions control how Power Pages users can interact with Dataverse tables. An administrator can configure permissions that allow customers to read existing Support Request records and create new ones, depending on the site’s requirements and web-role configuration. This provides controlled access to Dataverse data through Power Pages. A chart is used for visualization, a solution layer concerns component customization and deployment, and a business process flow guides users through business stages. Therefore, Table permissions are the appropriate feature for controlling customer access to Support Request records.
Question 397
A Dataverse table needs a value that automatically calculates the total amount by multiplying Quantity by Unit Price. Which column type should be considered?
- Formula
- File
- Image
- Choice
Correct Answer: 1
Explanation
A Formula column can calculate a value based on other supported fields and expressions. For example, a calculated total can be derived from Quantity multiplied by Unit Price, allowing the value to be generated automatically rather than manually entered. This can improve consistency and reduce the need for additional automation for straightforward calculations. File and Image columns are designed for their respective data types, while Choice provides predefined selectable options. Therefore, a Formula column is the appropriate option when the requirement is to derive a value automatically from other supported Dataverse columns.
Question 398
A solution contains a Power Automate flow that uses an Outlook connector. When the solution is moved to another environment, the connection should be mapped to the appropriate account for that environment. Which component should be used?
- Environment variable
- Connection reference
- View
- 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 associated with the appropriate connection in each environment. This is useful when moving solutions between development, test, and production because the underlying account or connection may differ between environments. An environment variable is commonly used for configurable values such as URLs, IDs, or settings, but it does not replace a connector connection reference. Views and Choice columns serve unrelated purposes. Therefore, Connection reference is the correct component for this requirement.
Question 399
A canvas app needs to update only the Email field of an existing Contact record while leaving all other fields unchanged. Which Power Fx function is most appropriate?
- Filter
- Navigate
- LookUp
- Patch
Correct Answer: 4
Explanation
Patch is appropriate when a canvas app needs to modify specific fields of an existing record without submitting an entire form. The app can identify the Contact record and provide a record containing only the Email field that needs to be changed. Other fields remain unchanged unless explicitly included in the update. Filter is used to return matching records, Navigate changes screens, and LookUp retrieves a matching record. Therefore, Patch provides the required targeted update capability and is the best choice for changing only the Contact’s Email field.
Question 400
A maker is investigating slow behavior in a canvas app and wants to inspect network requests, data operations, formulas, and runtime events. Which tool should be used?
- Solution checker
- Monitor
- Site map
- View
Correct Answer: 2
Explanation
Power Apps Monitor is designed to provide runtime diagnostics for Power Apps. It allows makers to inspect application events, data operations, network activity, errors, and other runtime behavior while troubleshooting an app. This information can help identify slow operations, problematic formulas, connector issues, or unexpected application behavior. Solution checker serves a different purpose by analyzing solution components for potential issues. Site maps and views are application configuration components rather than runtime troubleshooting tools. Therefore, Monitor is the correct tool for investigating performance and runtime behavior in a canvas app.