View Full Microsoft PL-200 Exam Dumps and Practice Test Dumps.
Question 81
You need to create a Dataverse table that stores information about company departments. Which component represents one individual department record?
- Row
- View
- Column
- Relationship
Correct Answer: 1
Explanation
In Dataverse, a row represents one individual record stored in a table. For example, if a Department table contains Sales, Finance, and Human Resources, each department is represented by a separate row. Columns define the individual attributes stored within each row, such as Department Name or Manager. Views determine how multiple rows are displayed, while relationships connect records between tables. Therefore, when referring to one individual department stored in the Department table, the correct component is a row.
Question 82
A maker needs to store a customer’s email address in Dataverse. Which column type is most appropriate for this information?
- Currency
- Text
- Yes/No
- Date and time
Correct Answer: 2
Explanation
A Text column is appropriate for storing an email address because an email address consists of characters and symbols rather than a numerical value. Text columns can store strings such as names, email addresses, telephone numbers, and identification codes. Currency is intended for monetary values, Yes/No stores Boolean values, and Date and time stores temporal information. Choosing an appropriate data type helps maintain data integrity and makes the information easier to use in forms, views, searches, and other Power Platform components.
Question 83
A company wants to provide a visual summary of sales opportunities, including charts and key metrics, inside a model-driven app. Which component should be used?
- Lookup
- Business rule
- Dashboard
- Security role
Correct Answer: 3
Explanation
A dashboard provides a visual summary of business information and can contain charts, lists, and other components. In a sales application, a dashboard could display opportunity values, sales stages, pipeline information, and other useful metrics. Lookup columns establish relationships between records, business rules control form behavior, and security roles manage permissions. Dashboards are particularly useful for giving users an overview of important information without requiring them to inspect individual records. Therefore, a dashboard is the appropriate component for presenting sales opportunities and key metrics visually.
Question 84
A company wants users to navigate through a standardized sequence of stages while processing an opportunity. Which feature should be implemented?
- View
- Dashboard
- Business rule
- Business process flow
Correct Answer: 4
Explanation
A business process flow guides users through predefined stages of a business process. For example, an opportunity process can contain stages such as Qualify, Develop, Propose, and Close. Each stage can contain steps that identify information users should complete. This helps organizations standardize processes and gives users a clear understanding of their current position in the workflow. Views display records, dashboards summarize information, and business rules provide conditional form logic. Therefore, a business process flow is the appropriate feature for guiding users through a standardized sequence.
Question 85
You need to create a Dataverse relationship where one customer can have many orders. Which relationship type should be used?
- One-to-many
- One-to-one
- Many-to-many
- No relationship
Correct Answer: 1
Explanation
A one-to-many relationship is used when one record in a parent table can be associated with multiple records in another table. In this scenario, one Customer can have many Orders. Each order can be associated with the appropriate customer through the relationship. A one-to-one relationship would allow only one related record, while a many-to-many relationship allows multiple records on both sides. Establishing the correct relationship also allows model-driven apps to display related records and helps maintain the structure of business data.
Question 86
A maker wants to allow users to select a customer from existing Account records when entering an Order. Which Dataverse column should be used?
- Choice
- Lookup
- File
- Currency
Correct Answer: 2
Explanation
A Lookup column allows users to select an existing record from another Dataverse table. In this scenario, the Order can contain a lookup to the Account table, allowing the user to select the appropriate customer. This creates a structured relationship between the Order and Account records rather than storing the customer name as plain text. Choice columns provide predefined values, File columns store files, and Currency columns store monetary values. Therefore, a Lookup column is the most appropriate option for associating an Order with an existing Account.
Question 87
A maker wants to make a field mandatory when a user selects a particular value in another field on a model-driven form. Which feature should be used?
- Dashboard
- View
- Business rule
- Site map
Correct Answer: 3
Explanation
Business rules can apply conditional logic to model-driven app forms. One of their capabilities is making a field required when a specific condition is satisfied. For example, if a customer is marked as a business customer, a Tax Registration Number field could become mandatory. Business rules can also set values, show or hide fields, enable or disable fields, and display validation messages. Dashboards and views focus on displaying information, while site maps control navigation. Therefore, a business rule is the appropriate low-code feature for this requirement.
Question 88
A company wants to move a model-driven app and its related components from development to testing. What should be used to package the components?
- View
- Dashboard
- Business process flow
- Solution
Correct Answer: 4
Explanation
Solutions are used to package Power Platform components for movement between environments. A solution can contain model-driven apps, Dataverse tables, columns, forms, views, cloud flows, business rules, and other components. This makes solutions an important part of application lifecycle management. Individual views or dashboards do not provide the same deployment packaging capability. A business process flow is also an application component rather than the overall deployment container. Therefore, the maker should use a solution to package the application and related components for deployment to the test environment.
Question 89
Which Dataverse component defines the individual attributes of a table, such as Customer Name, Email, and Phone Number?
- Columns
- Rows
- Views
- Dashboards
Correct Answer: 1
Explanation
Columns define the attributes or fields contained within a Dataverse table. For example, a Customer table could contain columns such as Customer Name, Email Address, Phone Number, and Customer Type. Rows contain the actual records, with each row holding values for the defined columns. Views determine how records are displayed, while dashboards provide visual summaries. Columns also have data types that control what kind of values they can store. Therefore, when defining the individual attributes of a Dataverse table, columns are the appropriate component.
Question 90
A maker needs to store whether an invoice has been paid. The value should have only two possible states. Which column type should be used?
- Currency
- Text
- Yes/No
- Date and time
Correct Answer: 3
Explanation
A Yes/No column is designed for values that have two logical states. For an invoice payment field, the possible values could be Yes and No, indicating whether the invoice has been paid. This is more appropriate than a text field because it enforces a consistent two-state value. Currency stores monetary information, while Date and time stores dates or times. Using the correct data type makes filtering, reporting, and business logic easier. Therefore, a Yes/No column is the best choice for the payment-status requirement.
Question 91
A company wants a Power Automate flow to start whenever a new Account record is created in Dataverse. What should trigger the flow?
- When a row is added, modified or deleted
- A Power BI refresh
- A dashboard event
- A model-driven app theme
Correct Answer: 1
Explanation
Power Automate provides Dataverse triggers that can respond when a row is added, modified, or deleted. The maker can configure the trigger for the Account table and specify the appropriate change type. When a new Account record is created, the flow can then perform actions such as sending notifications, creating related records, or updating another system. Power BI refreshes, dashboard events, and app themes do not provide the appropriate Dataverse event trigger. Therefore, the row-change trigger is the correct option for starting automation when an Account is created.
Question 92
A maker wants to display only active customer records in a model-driven app list. Which component should be configured?
- Business process flow
- View
- Security role
- Form
Correct Answer: 2
Explanation
A view can define filtering criteria that determine which Dataverse records are displayed. In this scenario, the maker can create or modify a view to filter customers where the status is Active. The view can also define which columns appear and how records are sorted. A business process flow guides users through stages, security roles control access, and forms display individual records. Therefore, a view is the appropriate component for displaying only active customer records in a model-driven app list.
Question 93
You need to automatically create a follow-up task when a new high-value opportunity is created. Which Power Platform capability should be used?
- Power BI
- Power Pages
- Power Automate
- Power Query
Correct Answer: 3
Explanation
Power Automate can automate actions based on events and conditions. A cloud flow can trigger when an Opportunity is created, evaluate its estimated value, and create a follow-up Task when the value meets the defined threshold. This type of event-driven automation is a common Power Automate scenario. Power BI is focused on analytics, Power Pages provides external-facing websites, and Power Query is primarily used for data transformation. Therefore, Power Automate is the appropriate capability for automatically creating the follow-up task.
Question 94
A model-driven app should display several related Contacts within an Account form. Which component should the maker add?
- Subgrid
- Dashboard
- Site map
- Business rule
Correct Answer: 4
Explanation
A subgrid displays a collection of related records within a model-driven form. For example, an Account form can contain a Contacts subgrid that shows all Contacts associated with that Account. This allows users to access related information without leaving the current record. Dashboards are used for visual summaries, site maps control navigation, and business rules apply conditional logic. Therefore, a subgrid is the appropriate component for displaying multiple related Contact records within an Account form.
Question 95
A company wants to control which users can read and update records in a sensitive Dataverse table. Which feature provides the primary mechanism for this requirement?
- Security roles
- Views
- Charts
- Business process flows
Correct Answer: 1
Explanation
Security roles provide the primary mechanism for controlling access to Dataverse data. They define privileges such as Read, Write, Create, Delete, Assign, and Share, along with appropriate access levels. This allows organizations to determine what different users or teams can do with specific tables and records. Views and charts influence how information is presented but do not replace authorization. Business process flows guide users through business processes. Therefore, security roles should be configured when an organization needs to control who can read or update sensitive Dataverse records.
Question 96
A company needs an external website where customers can submit service requests that are stored in Dataverse. Which product should be used?
- Power Automate
- Power Pages
- Power BI
- Power Query
Correct Answer: 2
Explanation
Power Pages is designed for creating external-facing business websites that can interact with Dataverse and other business services. A company can use Power Pages to create a customer-facing service portal where users submit requests, forms collect information, and appropriate Dataverse records are created. Power Automate can automate actions after submission, but it is not itself the website platform. Power BI is intended for analytics, and Power Query is used primarily for data transformation. Therefore, Power Pages is the most suitable product for this external customer website.
Question 97
A maker wants to prevent users from entering arbitrary values for a Customer Type field. The allowed values are Individual, Business, and Government. Which column type is appropriate?
- Choice
- Lookup
- File
- Image
Correct Answer: 1
Explanation
A Choice column allows the maker to define a controlled list of predefined values. In this scenario, Customer Type can contain Individual, Business, and Government, ensuring users select one of the approved options. This improves data consistency and makes filtering and reporting easier. A Lookup column would be appropriate if these customer types were maintained as records in another table, while File and Image columns are intended for content storage. Therefore, a Choice column is the appropriate solution for a fixed set of predefined customer categories.
Question 98
A user needs to open an individual Account record and edit its fields in a model-driven app. Which component provides the detailed record interface?
- View
- Dashboard
- Main form
- Site map
Correct Answer: 3
Explanation
The main form provides the detailed interface for viewing and editing an individual Dataverse record. It can contain fields, tabs, sections, subgrids, business process flows, and other form components. A view displays multiple records in a list or grid, while a dashboard provides summarized information. The site map controls navigation to application pages. Therefore, when users need to open an Account and edit its individual fields, the main form is the appropriate component.
Question 99
A company wants to guide employees through a standardized customer onboarding process containing several stages. Which component should be used?
- Business process flow
- Dashboard
- View
- Lookup
Correct Answer: 1
Explanation
A business process flow is designed to guide users through a sequence of stages and steps. For customer onboarding, stages could include Application, Verification, Approval, and Activation. The process can identify important information that users should complete as they move through each stage. Dashboards are intended for information visualization, views display collections of records, and lookup columns establish relationships between records. Therefore, a business process flow is the appropriate component for creating a standardized and guided customer onboarding process.
Question 100
A maker has created a solution containing an app, tables, forms, views, and flows. The solution needs to be moved from the development environment into production. What should the maker do?
- Rebuild all components manually
- Export the solution and import it into production
- Copy the app’s screenshots into production
- Export only the Dataverse records
Correct Answer: 2
Explanation
Solutions are designed to package Power Platform components for deployment between environments. The maker can export the solution from the development environment and then import it into the production environment, subject to the organization’s deployment and lifecycle procedures. This allows related components such as apps, tables, forms, views, and flows to be moved together. Rebuilding components manually is inefficient, screenshots are not deployable components, and exporting only records does not deploy the application configuration. Therefore, exporting the solution and importing it into production is the appropriate deployment approach.