A company wants to create a new table to track employee training. Each training record should have a unique identifier, a title, and a completion date. They also want the table to support auditing and to be available in offline mode for mobile users. What should you configure when creating the table?

Enable auditing and enable the 'This table is available offline' option.

Enable the 'This table is available offline' option and set the table to read-only.

Enable auditing and set the table to use a custom alternate key.

Enable auditing and set the table to use a custom primary name column.

A functional consultant needs to create a new standard table in Microsoft Dataverse to store information about company projects. Which tool should they use to create this table?

Power BI service (app.powerbi.com)

Power Apps portal (make.powerapps.com)

Power Automate portal (make.powerautomate.com)

A column named 'Status' currently has a data type of 'Text'. The business now needs to store numeric status codes. What is the correct action?

Delete the 'Status' column and recreate it as a number

Use a formula column to convert the text to a number

Change the data type of the 'Status' column to 'Whole Number'

Create a new column with data type 'Whole Number' and migrate the data

What does the 'Ownership' property of a table define?

How records are secured and who can access them

Whether the table can be customized

Microsoft Certified:Power Platform Functional Consultant Associate

Domain 1Objective 1

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

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 1–5

1application · medium
A company wants to create a new table to track employee training. Each training record should have a unique identifier, a title, and a completion date. They also want the table to support auditing and to be available in offline mode for mobile users. What should you configure when creating the table?
Select an answer first
2foundation · medium
A functional consultant needs to add a column to store a customer's annual revenue as a whole number. Which data type should they choose?
Select an answer first
3foundation · medium
A functional consultant needs to create a new standard table in Microsoft Dataverse to store information about company projects. Which tool should they use to create this table?
Select an answer first
4foundation · medium
A column named 'Status' currently has a data type of 'Text'. The business now needs to store numeric status codes. What is the correct action?
Select an answer first
5foundation · medium
What does the 'Ownership' property of a table define?
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.

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

Questions 1–5

A functional consultant needs to add a column to store a customer's annual revenue as a whole number. Which data type should they choose?

A functional consultant needs to create a new standard table in Microsoft Dataverse to store information about company projects. Which tool should they use to create this table?

A column named 'Status' currently has a data type of 'Text'. The business now needs to store numeric status codes. What is the correct action?

What does the 'Ownership' property of a table define?

Keep studying — Configure Microsoft Dataverse