Sample question 1 — Describe the Business Value
A property firm's makers currently keep tenant records in one spreadsheet, maintenance cases in a SharePoint list, and lease documents in a shared folder. They want a single cloud service that stores related records with defined columns, enforces role-based access at the row level, and can be used by both an app and an automated flow. Which Power Platform component provides this?
- A. Microsoft Dataverse, a managed service that stores company tables with built-in security.
- B. A SharePoint list, which stores rows in a site and inherits the site's existing permissions.
- C. Azure SQL Database, a relational engine that requires schema administration.
- D. Power BI datasets, which hold imported tables for reporting and refresh.
Answer: A. Option A is correct: Microsoft Dataverse, a managed service that stores company tables with built-in security. Dataverse holds related tables with typed columns, applies row-level security roles, and exposes the same data to apps and cloud flows. Option B is incorrect because a SharePoint list inherits site permissions and does not provide row-level business roles for flows. Option C is incorrect because a relational engine stores tables but leaves schema design and permission modelling to the team. Option D is incorrect because a reporting dataset holds imported tables for analytics and is not an application data store.
