Microsoft Power Platform Fundamentals Microsoft Dataverse 1 — Questions and Answers
Question 1: What is Microsoft Dataverse?
- A cloud data warehouse for big data analytics in Azure Synapse
- A low-code cloud-based data platform that securely stores and manages data used by Power Platform applications (Correct answer)
- A relational database service available only to enterprise customers
- A file storage system for Power BI report assets
Correct answer: A low-code cloud-based data platform that securely stores and manages data used by Power Platform applications
Microsoft Dataverse is the underlying data platform for Power Platform, providing tables, relationships, business logic, and security for apps and flows.
Question 2: In Dataverse, what is a 'table' equivalent to in traditional database terminology?
- A stored procedure
- A database table (rows and columns) (Correct answer)
- A schema or namespace
- An index on a column
Correct answer: A database table (rows and columns)
A Dataverse table maps to a relational database table, containing rows (records) and columns (fields) to store structured data.
Question 3: Which of the following is an example of a standard table in Microsoft Dataverse?
- Invoice
- Account (Correct answer)
- Product SKU
- Department
Correct answer: Account
Account is one of the core standard tables in Dataverse (shared with Dynamics 365), pre-built to store business account information.
Question 4: What is the purpose of a 'relationship' in Dataverse?
- Defining user security roles and team memberships
- Linking records across two tables so related data can be accessed together (Correct answer)
- Establishing a network connection between two Dataverse environments
- Creating a calculated column that references data from another table
Correct answer: Linking records across two tables so related data can be accessed together
Relationships define how records in one table relate to records in another (e.g., a Contact belongs to an Account), enabling navigation and lookup across tables.
Question 5: What is a 'choice' column type in Dataverse?
- A column that stores a binary true/false value
- A column that stores a selection from a predefined list of options (formerly called OptionSet) (Correct answer)
- A column that allows the user to choose from a list of related records
- A column that randomly selects a value from a dataset
Correct answer: A column that stores a selection from a predefined list of options (formerly called OptionSet)
A choice column (formerly OptionSet) stores a value selected from a predefined list of labeled options, such as status values like Active, Inactive, or Pending.
Question 6: What does Dataverse's 'business rule' feature allow makers to do without writing code?
- Schedule automated data backups
- Define field validation, default values, visibility rules, and requirement levels on table forms (Correct answer)
- Create calculated rollup columns across related tables
- Publish data changes to external APIs automatically
Correct answer: Define field validation, default values, visibility rules, and requirement levels on table forms
Business rules let makers configure logic (show/hide fields, set required/optional, validate values, apply defaults) that runs on Dataverse forms and server-side without code.
Microsoft Power Platform Fundamentals Microsoft Dataverse 1
What is Microsoft Dataverse?