Your organization is migrating from a legacy SQL Server application to Power Platform. The legacy system uses complex stored procedures and cross-table joins. The new solution must be maintainable by low-code developers and must support real-time data entry. What is the most important trade-off to consider when using Dataverse instead of SQL Server?

Dataverse has limitations on complex queries and stored procedures, so some logic may need to be re-implemented using Power Automate or business rules.

Dataverse requires custom code for all business logic.

Dataverse cannot handle real-time data entry.

Dataverse does not support relationships between tables.

What is a benefit of using AI in Dataverse for data modeling?

It can generate a data model from a natural language description, saving time.

It automatically enforces all security rules.

It eliminates the need for any manual adjustments.

It guarantees that the data model is perfectly optimized for performance.

A company uses Dataverse to manage project information. They need to ensure that when a user enters a project's start date, the end date must be after the start date. They also want to display a warning message if the end date is invalid. What should they use?

Use a Power Automate flow that triggers on update and sends an email if the end date is before the start date.

Create a calculated column that compares the two dates and displays a warning.

Add a validation rule in the underlying SQL database that rejects the transaction.

Create a business rule on the Project table that validates the dates and shows an error message.

An organization currently uses an Excel spreadsheet to track customer issues. They want to move to Dataverse so that multiple users can enter data through a canvas app and see the same information in real time. They also want to enforce that each issue has a priority. What is the main benefit of Dataverse over Excel for this scenario?

Dataverse automatically creates a user interface for data entry, while Excel requires manual formatting.

Dataverse provides centralized data storage with built-in security, relationships, and data validation, while Excel lacks these capabilities.

Dataverse can store up to 10 million rows, while Excel is limited to 1 million rows.

Dataverse is free, while Excel requires a Microsoft 365 license.

Your organization uses a Dataverse table to track support tickets. Support agents need to enter ticket details, and managers need to see a read-only summary of the same ticket. What should you do to meet both requirements?

Create a single form and rely on security roles to restrict editing.

Create a business rule to make fields read-only for managers.

Create two forms: one for agents with editable fields and one for managers with read-only fields.

Create two views: one for agents and one for managers.

Microsoft Certified:Power Platform Fundamentals

Domain 2Objective 1

Describe Microsoft Dataverse PL-900 Practice Questions (Page 3)

Part of the Manage the Microsoft Power Platform environment domain, which accounts for 20–25% of the PL-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~4–8 in this domain), expect 2–4 from this objective — we provide 40 practice questions to prepare you well beyond it. (estimate)

40questions here

8free pages

8concepts

20–25%of the exam

Questions 11–15

11expert · hard
Your organization is migrating from a legacy SQL Server application to Power Platform. The legacy system uses complex stored procedures and cross-table joins. The new solution must be maintainable by low-code developers and must support real-time data entry. What is the most important trade-off to consider when using Dataverse instead of SQL Server?
Select an answer first
12foundation · easy
What is a benefit of using AI in Dataverse for data modeling?
Select an answer first
13application · medium
A company uses Dataverse to manage project information. They need to ensure that when a user enters a project's start date, the end date must be after the start date. They also want to display a warning message if the end date is invalid. What should they use?
Select an answer first
14application · medium
An organization currently uses an Excel spreadsheet to track customer issues. They want to move to Dataverse so that multiple users can enter data through a canvas app and see the same information in real time. They also want to enforce that each issue has a priority. What is the main benefit of Dataverse over Excel for this scenario?
Select an answer first
15application · medium
Your organization uses a Dataverse table to track support tickets. Support agents need to enter ticket details, and managers need to see a read-only summary of the same ticket. What should you do to meet both requirements?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-900

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-900” is a trademark of its owner, used for identification only.

Describe Microsoft Dataverse PL-900 Practice Questions (Page 3)

Questions 11–15

What is a benefit of using AI in Dataverse for data modeling?

A company uses Dataverse to manage project information. They need to ensure that when a user enters a project's start date, the end date must be after the start date. They also want to display a warning message if the end date is invalid. What should they use?

Your organization uses a Dataverse table to track support tickets. Support agents need to enter ticket details, and managers need to see a read-only summary of the same ticket. What should you do to meet both requirements?

Keep studying — Manage the Microsoft Power Platform environment