A company uses an external SQL Server database to store customer loyalty data. They want this data to appear in Power Apps and Power Automate without duplicating it into Dataverse. The data should be read-only in Dataverse. What should you create?

A custom connector that queries SQL Server from within Power Apps

A rollup column that pulls data from SQL Server

A virtual table that connects to the SQL Server data source

A standard table with columns matching the SQL Server schema and a dataflow to import the data

A company has an existing 'Customer' table with a 'Phone' column that is a text field. They now need to store multiple phone numbers per customer (e.g., home, mobile, work). They also need to maintain the existing Phone column for backward compatibility with integrations. What should you do?

Create a new related table called Customer Phone with a lookup to Customer, and keep the existing Phone column unchanged.

Add multiple new text columns to the Customer table, such as Home Phone, Mobile Phone, and Work Phone.

Delete the existing Phone column and create a new related table.

Change the Phone column data type to a multi-select option set.

Which of the following data sources can be used to create a virtual table in Dataverse?

On-premises SQL Server without a gateway

A company wants to add a custom column to the existing 'Email' activity table to track the email's priority level. What is the correct approach?

Use Power Automate to add the column to the Email table

Modify the Email table's schema using a database management tool

Create a new custom activity table and add the column there

Open the Email 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 3)

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 11–15

11application · medium
A company uses an external SQL Server database to store customer loyalty data. They want this data to appear in Power Apps and Power Automate without duplicating it into Dataverse. The data should be read-only in Dataverse. What should you create?
Select an answer first
12expert · medium
A company has an existing 'Customer' table with a 'Phone' column that is a text field. They now need to store multiple phone numbers per customer (e.g., home, mobile, work). They also need to maintain the existing Phone column for backward compatibility with integrations. What should you do?
Select an answer first
13foundation · medium
Which of the following data sources can be used to create a virtual table in Dataverse?
Select an answer first
14foundation · medium
A company wants to add a custom column to the existing 'Email' activity table to track the email's priority level. What is the correct approach?
Select an answer first
15foundation · medium
When creating a new custom table in Dataverse, which of the following must be specified?
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.