A company has a custom table named Customer with a column named Email that is a text column. They now need to enforce that each email address is unique across all customer records. What should you do?

Create a business rule that checks for duplicate email addresses on save.

Change the Email column to a text column and enable the 'Unique' option in the column properties.

Create a rollup column that counts email addresses and use a validation rule to block duplicates.

Use a Power Automate flow to check for duplicates whenever a record is created or updated.

In a one-to-many relationship between 'Account' and 'Contact', what does the 'Cascade Delete' behavior do?

Deletes all related contacts when an account is deleted

Prevents the deletion of an account if it has contacts

Sets the contact's account lookup to null

Removes the relationship but keeps the contacts

What is the primary purpose of a formula column in Dataverse?

To aggregate data from related tables

To integrate with external data sources

To perform calculations using values from the same table

A company needs to add a 'Preferred Contact Method' column to the existing 'Contact' table. What is the correct way to do this?

Use Power Automate to create the column

Create a new table and relate it to Contact

Use the Contact form to add the column

Edit the Contact table in the table designer and add a new column

Microsoft Certified:Power Platform Functional Consultant Associate

Domain 1Objective 1

Manage the Data Model PL-200 Practice Questions (Page 4)

Part of the Configure Microsoft Dataverse domain, which accounts for 25–30% of the PL-200 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 37 practice questions to prepare you well beyond it. (estimate)

37questions here

8free pages

12concepts

25–30%of the exam

Questions 16–20

16expert · hard
A company has a custom table named Customer with a column named Email that is a text column. They now need to enforce that each email address is unique across all customer records. What should you do?
Select an answer first
17foundation · medium
In a one-to-many relationship between 'Account' and 'Contact', what does the 'Cascade Delete' behavior do?
Select an answer first
18foundation · medium
What is the primary purpose of a formula column in Dataverse?
Select an answer first
19foundation · medium
A business needs to record that a single 'Order' can contain multiple 'Order Products'. Each order product belongs to exactly one order. What type of relationship should be configured between the Order and Order Product tables?
Select an answer first
20foundation · medium
A company needs to add a 'Preferred Contact Method' column to the existing 'Contact' table. What is the correct way to do this?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-200

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-200” is a trademark of its owner, used for identification only.