A business requires storing information about 'Product Reviews' that includes the review text, rating, and the product being reviewed. There is no existing table that fits this need. What should the functional consultant do?

Use a SharePoint list to store the data

Create a new custom table named 'Product Review'

Add columns to the 'Product' table

Use the existing 'Feedback' table

A company has a custom table named Employee with a column named Department that is a text column. The business now wants to standardize departments by using a separate Department table and relate employees to it. What should you do?

Create a Department table, add a lookup column to Employee, and populate it from the existing text values.

Change the text column to a choice column with the department names.

Keep the text column and add a separate Department table for reporting only.

Create a many-to-many relationship between Employee and Department without changing the text column.

A company stores product pricing in a custom table. The Price column is a decimal, and the TaxRate column is a decimal representing a percentage (e.g., 0.08 for 8%). They need a column that displays the total price including tax. This value must always be calculated from the current Price and TaxRate. What should you create?

A formula column with the expression: Price * (1 + TaxRate)

A rollup column that sums Price and TaxRate

A calculated column with the expression: Price + TaxRate

A business rule that sets a TotalPrice column to Price * (1 + TaxRate)

Which of the following properties of an existing column can be modified after the column has been created?

Column type (e.g., text to lookup)

Microsoft Certified:Power Platform Functional Consultant Associate

Domain 1Objective 1

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

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 6–10

6foundation · medium
When creating a new column in Dataverse, which of the following is a required property?
Select an answer first
7foundation · medium
A business requires storing information about 'Product Reviews' that includes the review text, rating, and the product being reviewed. There is no existing table that fits this need. What should the functional consultant do?
Select an answer first
8application · medium
A company has a custom table named Employee with a column named Department that is a text column. The business now wants to standardize departments by using a separate Department table and relate employees to it. What should you do?
Select an answer first
9application · medium
A company stores product pricing in a custom table. The Price column is a decimal, and the TaxRate column is a decimal representing a percentage (e.g., 0.08 for 8%). They need a column that displays the total price including tax. This value must always be calculated from the current Price and TaxRate. What should you create?
Select an answer first
10foundation · medium
Which of the following properties of an existing column can be modified after the column has been created?
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 2)

Questions 6–10

When creating a new column in Dataverse, which of the following is a required property?

A business requires storing information about 'Product Reviews' that includes the review text, rating, and the product being reviewed. There is no existing table that fits this need. What should the functional consultant do?

A company has a custom table named Employee with a column named Department that is a text column. The business now wants to standardize departments by using a separate Department table and relate employees to it. What should you do?

Which of the following properties of an existing column can be modified after the column has been created?

Keep studying — Configure Microsoft Dataverse