CertArea
All Microsoft exams

Free PL-200 practice test: 30 questions with answers

30 original questions for Microsoft Power Platform Functional Consultant, drawn from every topic area. Answer each one to see whether you got it right and why. No sign-up.

Free questions
30
Full bank
112 questions

PL-200 exam guide: topics, cost and format

All 30 PL-200 questions with answers

The same questions as the test above, grouped by exam topic. Open any question to see the answer and explanation.

Configure Microsoft Dataverse (8 questions)

  1. Question 1

    Which relationship type should be used when many contacts can belong to many marketing lists?

    1. AA self-referencing lookup, which links a list only to other lists inside the same table and never to contacts
    2. BA one-to-many relationship, which allows each list to hold many contacts but each contact only one list at a time
    3. CA many-to-many relationship, which links each contact to any number of lists and each list to any number of contacts
    4. DA calculated column, which stores the number of lists for each contact but creates no link between the tables
    Show answer and explanation
    Correct answer: C

    A many-to-many relationship links records in both directions in any number. One-to-many, self-referencing lookups and calculated columns do not model that case.

  2. Question 2

    What does a cascading delete behaviour on a relationship do?

    1. AIt copies the child records into an archive table each time the parent record is saved by the system
    2. BIt deletes the parent record automatically when any child record is changed by a user in the application
    3. CIt prevents the parent from being deleted while any child records exist, with no other effect on the children
    4. DIt deletes related child records automatically when the parent record is deleted
    Show answer and explanation
    Correct answer: D

    Cascading delete removes related child records when the parent is deleted. Other behaviours describe changes or blocks that are different settings.

  3. Question 3

    Which column type calculates a value from other columns on the same row automatically?

    1. AA formula column, which computes its value from the other columns in the same row
    2. BA rollup column, which aggregates values from related child records rather than the same row
    3. CA choice column, which stores one value from a predefined list chosen by the user for each record
    4. DA lookup column, which stores a reference to a record in another table and does not compute values
    Show answer and explanation
    Correct answer: A

    A formula column computes from columns in the same row. Rollup aggregates related records, choice stores list values, and lookup stores references.

  4. Question 4

    Which column type aggregates values from related child records, such as a total of order amounts?

    1. AA text column, which stores a fixed string for each record and cannot hold a numeric aggregate of any kind
    2. BA formula column, which calculates from values in the same row without looking at any related records
    3. CA rollup column, which aggregates values across related child records
    4. DA date column, which stores a single date for each record and is used for scheduling rather than totals
    Show answer and explanation
    Correct answer: C

    A rollup column aggregates across related child records. Formula, text and date columns do not compute aggregates over children.

  5. Question 5

    What is the purpose of a business unit in Dataverse security?

    1. ATo store the list of products sold by the company in a separate table for pricing purposes only
    2. BTo set the currency used by each user for the reports produced in the Power Platform environment
    3. CTo define the language of the interface shown to users who sign in to the model-driven app
    4. DTo group users and records so that access can be scoped to a part of the organisation
    Show answer and explanation
    Correct answer: D

    Business units group users and records to scope access. Currency, language and product lists are not business unit functions.

  6. Question 6

    What does a security role define in Dataverse?

    1. AThe number of licences purchased for the environment by the finance team for the financial year
    2. BThe physical location of the Dataverse database in the Azure region that hosts the organisation
    3. CThe colour theme applied to the model-driven app for the users assigned to that role in the environment
    4. DThe privileges a user has on tables and records at different access levels
    Show answer and explanation
    Correct answer: D

    A security role defines table privileges and access levels. Database location, theme and licence counts are not defined by roles.

  7. Question 7

    Which feature restricts access to a sensitive column such as salary for selected users?

    1. AA duplicate detection rule, which flags possible duplicate records but does not restrict access to any column
    2. BColumn-level security profiles, which grant access to specific secured columns
    3. CA bulk deletion job, which removes old records on a schedule and does not restrict column access at all
    4. DA view filter, which hides rows that do not match the filter but does not restrict access to a column
    Show answer and explanation
    Correct answer: B

    Column-level security profiles restrict access to specific secured columns. Duplicate detection, bulk deletion and view filters do other jobs.

  8. Question 8

    What is the purpose of Dataverse duplicate detection?

    1. ATo copy every record into a second table so that the team has a backup of the data each day
    2. BTo identify possible duplicate records using matching rules so users can review them
    3. CTo delete records that match another record automatically, without any review by the users
    4. DTo rename records that share a name so that each record has a unique identifier in the list
    Show answer and explanation
    Correct answer: B

    Duplicate detection identifies possible duplicates through matching rules for review. It does not copy, delete automatically or rename records.

Create apps by using Microsoft Power Apps (8 questions)

  1. Question 9

    Which Power Apps app type is built around Dataverse tables and business processes with forms and views?

    1. AA model-driven app, which is generated from the data model with forms, views and dashboards
    2. BA canvas app, which is designed pixel by pixel from a blank screen with free placement of each control on it
    3. CA portal built on Power Pages, which is used for external websites rather than for internal business processes
    4. DA flow, which automates steps in the background and does not present forms or views to users in any screen
    Show answer and explanation
    Correct answer: A

    Model-driven apps are generated from the data model with forms and views. Canvas apps are freeform, Power Pages serves websites and flows automate background steps.

  2. Question 10

    Which app type gives the designer full control over the layout of each screen?

    1. AA model-driven app, which generates its layout from the data model and offers limited control over placement
    2. BA canvas app, which allows free placement and styling of controls on each screen
    3. CA business process flow, which shows the stages of a process and does not define any layout for screens at all
    4. DA solution checker report, which lists the issues found in an app and does not provide any layout tools
    Show answer and explanation
    Correct answer: B

    Canvas apps give full control over screen layout. Model-driven apps generate layouts, while business process flows and solution checker reports are not layout tools.

  3. Question 11

    Which control would a designer use to display a form for a record in a model-driven app?

    1. AA flow trigger, which starts a cloud flow when an event happens and displays no record data to the user
    2. BA canvas app gallery, which shows a list of items on a screen but is not used inside model-driven forms at all
    3. CA main form, which displays the columns of a record for viewing and editing
    4. DA solution, which packages components for transport between environments and does not display records
    Show answer and explanation
    Correct answer: C

    A main form displays record columns in a model-driven app. A gallery, a flow trigger and a solution are different features.

  4. Question 12

    What does a view in a model-driven app define?

    1. AThe set of rows and columns shown in a list of records, with a filter and sort order
    2. BThe colours and fonts used throughout the app for every user in the organisation in every language
    3. CThe security roles that may open the app for the users in the organisation in each business unit
    4. DThe cloud flows that run each time the list is refreshed by the user in the browser for the team
    Show answer and explanation
    Correct answer: A

    A view defines the rows, columns, filter and sort order of a list. Colours, security roles and flows are defined elsewhere.

  5. Question 13

    Which Power Platform feature lets a model-driven app show a Power BI report?

    1. ACopying the report's data into a spreadsheet that the user opens in a separate application each morning
    2. BAdding a Power BI dashboard or report to the app's navigation or form
    3. CPrinting the report on paper for the team to read in the office at the start of each week
    4. DSending the report by email only, with no link to the app or any place inside the app for the user
    Show answer and explanation
    Correct answer: B

    Power BI dashboards and reports can be added to a model-driven app. Copying data, printing and email-only delivery do not embed the report in the app.

  6. Question 14

    Which THREE are valid components of a model-driven app? (Choose three.)

    1. AForms for viewing and editing records
    2. BViews for listing records with filters and sort orders
    3. CDashboards for summarising information with charts and lists
    4. DPixel-level brush strokes for hand-drawn artwork on each screen of the app for the design team
    5. EPhysical hardware sensors connected to the device of the user during each session of the app
    Show answer and explanation
    Correct answer: A, B, C

    Forms, views and dashboards are components of model-driven apps. Hand-drawn artwork and hardware sensors are not app components.

  7. Question 15

    Which TWO are valid ways to control which web visitors can see a Power Pages page? (Choose two.)

    1. AAssigning web roles and table permissions to the page
    2. BSetting page access rules that require a specific web role for the page to be shown
    3. CUsing a flow trigger that hides the page from every visitor for the rest of the day in each session
    4. DUsing the solution checker to make a page private, which it does automatically when it finds an issue
    5. EChanging the colour of the page header for each visitor group so that the group is recognised on the site
    Show answer and explanation
    Correct answer: A, B

    Web roles, table permissions and page access rules control visibility in Power Pages. Flow triggers, solution checks and header colours do not control visitor access.

  8. Question 16

    What does a canvas app use to pass data between screens?

    1. AThe colour of each button, which is set by the designer to show the state of each screen for the user
    2. BThe page title in the browser tab, which displays the name of the current screen to the user in the window
    3. CVariables and collections, which store values and sets of records for use across screens
    4. DThe file name of the app package, which is updated by the designer each time a screen is added to the app
    Show answer and explanation
    Correct answer: C

    Variables and collections store values and records across screens in canvas apps. Titles, colours and file names do not pass data.

Create and manage logic and process automation (7 questions)

  1. Question 17

    Which automation type runs in response to a Dataverse row being created or updated?

    1. AA canvas app timer that refreshes a gallery on a schedule and does not respond to table events
    2. BA scheduled flow that runs only at fixed times and has no connection to any table event in Dataverse
    3. CA manual flow that a user starts from a button and that does not respond to table changes by itself
    4. DAn automated cloud flow with a Dataverse trigger for the relevant table event
    Show answer and explanation
    Correct answer: D

    An automated cloud flow with a Dataverse trigger responds to row events. Scheduled, manual and timer approaches do not respond to table events in that way.

  2. Question 18

    What is a business process flow used for in Dataverse?

    1. ATo guide users through a defined sequence of stages and steps for a business process
    2. BTo run a background job every night that deletes old records from the tables in the environment for storage
    3. CTo store the security roles that apply to each user in the environment, kept for the audit record of each change
    4. DTo design the screens of a canvas app with drag-and-drop controls and free placement of each element on the screen
    Show answer and explanation
    Correct answer: A

    Business process flows guide users through defined stages and steps. Nightly deletion, role storage and canvas design are different functions.

  3. Question 19

    Which component is used to apply simple validation or field logic in a model-driven form without code?

    1. AA view, which defines the rows shown in a list and does not apply validation or logic to fields
    2. BA solution, which packages components for transport between environments and applies no logic to any form
    3. CA business rule, which sets field values, shows messages and enforces conditions on a form
    4. DA connection reference, which stores the credentials for a connector and applies no validation to any field
    Show answer and explanation
    Correct answer: C

    Business rules apply simple field logic and validation on forms without code. Solutions, views and connection references do not.

  4. Question 20

    What is a Power Fx formula used for in a canvas app?

    1. ACreating a new Dataverse table with its columns and relationships automatically from the formula text alone
    2. BStoring the app's source code in a repository on a server in the company's data centre for backup
    3. CCalculating values and controlling behaviour, such as visibility and navigation, in the app
    4. DSending the app to the app store of the user's mobile device for public download by any customer
    Show answer and explanation
    Correct answer: C

    Power Fx formulas calculate values and control app behaviour. Source storage, table creation and app store publishing are different tasks.

  5. Question 21

    Which component of a cloud flow runs a set of actions only when a condition is true?

    1. AA solution, which packages the flow for transport and does not affect when any action inside the flow runs
    2. BA trigger, which starts the flow when an event occurs and does not decide which actions to run afterwards
    3. CA connector, which connects the flow to an external service but does not decide whether actions run at all
    4. DA condition control, which branches the flow based on a true or false test
    Show answer and explanation
    Correct answer: D

    A condition control branches the flow on a true or false test. Triggers, connectors and solutions do not decide conditional branches.

  6. Question 22

    What is the purpose of a try-catch style scope in a cloud flow?

    1. ATo catch the mouse clicks of the user in the app and send them to the flow for each action on the screen
    2. BTo group actions and handle failures in a run-after branch that follows the scope
    3. CTo remove the need for any error handling, since the flow never fails in any scenario in production
    4. DTo store the flow's errors in a separate table for the finance team's review each month of the year
    Show answer and explanation
    Correct answer: B

    A scope groups actions, and run-after settings let a flow handle failures in a following branch. Click capture, removing error handling and error storage misstate its role.

  7. Question 23

    Which TWO are good practices when building cloud flows for an organisation? (Choose two.)

    1. AUsing environment variables and connection references so that flows move between environments without editing
    2. BStoring credentials in plain text inside the flow's expressions so that the flow can run without any configuration
    3. CNaming actions and flows clearly, and documenting the purpose of each for other makers in the team
    4. DCreating a new flow for every single record so that each record has its own separate automation in the system
    5. ERunning every flow under the account of the first administrator, so that no other account is needed for any change
    Show answer and explanation
    Correct answer: A, C

    Environment variables, connection references and clear naming support maintainable flows. Plaintext credentials, a flow per record and a single administrator account are poor practices.

Manage environments (7 questions)

  1. Question 24

    What is a development environment in Power Platform used for?

    1. AStoring archived records that users no longer need for their work in the business each day of the year
    2. BServing live customers directly with the production data of the company's most important business process
    3. CBuilding and testing solutions away from production users and data
    4. DHosting the public website of the company for search engines to index on the internet for the marketing team
    Show answer and explanation
    Correct answer: C

    Development environments are for building and testing away from production users. The other options describe production or archive use.

  2. Question 25

    What is the difference between a managed and an unmanaged Dataverse solution?

    1. AA managed solution can be edited freely in production, while an unmanaged solution cannot be changed at all afterwards
    2. BA managed solution is locked from editing in the target environment, while an unmanaged solution can be edited there
    3. CThere is no difference, since both types of solution can be edited freely in any environment at any stage of the lifecycle
    4. DA managed solution is only used for canvas apps, while an unmanaged solution is only used for model-driven apps
    Show answer and explanation
    Correct answer: B

    A managed solution is locked from editing in the target, while an unmanaged solution can be edited. The other options reverse or misstate the difference.

  3. Question 26

    Which tool checks a solution for common issues before deployment?

    1. AThe solution checker, which analyses components and reports issues before deployment
    2. BThe flow run history, which shows past runs of cloud flows and does not analyse solution components at all
    3. CThe audit log, which records data changes and does not analyse solution components for issues of any kind
    4. DThe colour picker, which selects theme colours for the app and has no checking function for any solution
    Show answer and explanation
    Correct answer: A

    The solution checker analyses components and reports issues. Run history, audit logs and colour pickers do not check solutions.

  4. Question 27

    What is a connection reference used for in a solution?

    1. AIt links two tables with a relationship so that the records are shown together in the model-driven app
    2. BIt stores the password of each user as plain text so that the flow can sign in to every service without any prompt
    3. CIt lets a solution use a connection that can be set differently in each environment during deployment
    4. DIt sends the connection status of the environment to the administrator each morning for the operations team review
    Show answer and explanation
    Correct answer: C

    A connection reference lets a solution use a connection that varies by environment. Plaintext passwords, table relationships and status reports are unrelated.

  5. Question 28

    Which environment setting is used to supply different values to a solution in each environment?

    1. AEnvironment variables, which hold values that change by environment without editing the solution
    2. BThe admin centre's billing contact, which holds the name of the person who pays for the licences each month
    3. CThe app's icon, which is shown to users in the launcher and does not hold any values used by the solution
    4. DThe table's description, which explains the purpose of the table to the users and does not hold configuration values
    Show answer and explanation
    Correct answer: A

    Environment variables hold values that change by environment. Billing contacts, icons and descriptions do not provide solution configuration values.

  6. Question 29

    Which Power Platform capability lets a team manage Dataverse solutions in a controlled way across environments?

    1. AA personal folder on each developer's laptop, which is copied to production by the developer each time
    2. BA shared spreadsheet that the team edits by hand in each environment separately without any export or import
    3. CSolution lifecycle with export and import of managed or unmanaged solutions between environments
    4. DA screen recording of each change, which is watched by the team to reproduce the change in the target environment
    Show answer and explanation
    Correct answer: C

    Solution export and import between environments supports controlled ALM. Spreadsheets, personal folders and recordings are not controlled deployment methods.

  7. Question 30

    Which TWO are good practices for moving a solution from development to production? (Choose two.)

    1. AUsing a managed solution in production so that the production copy cannot be edited directly by makers
    2. BExporting the solution from development and importing it into test before production
    3. CEditing the production environment directly for each small fix so that the change reaches users quickly
    4. DSkipping the test environment entirely so that the release date is not delayed by testing work for the team
    5. ECopying the development solution by hand into production without any export or import record kept
    Show answer and explanation
    Correct answer: A, B

    Managed solutions in production and staged export and import through test protect the release. Direct production edits, skipped testing and untracked copies are risky.