60 questions · Dataverse Foundations topic · All types, answers revealed
You need to create a column that stores the total cost of a project, which is derived from the sum of all associated expense records. Which column type should you use?
Rollup columns aggregate data from related records in a hierarchical or relational structure.
Why this answer
Rollup columns are specifically designed to calculate aggregate values, such as sums, counts, or averages, from related records.
Which type of chart can you create in a Model-driven app?
System charts are platform-native and configurable for all users.
Why this answer
System charts are defined at the entity level and are available to all users.
Which THREE components can be included in a Dataverse solution?
Tables are core solution components.
Why this answer
Solutions are containers that can hold tables, flows, and security roles, among others.
You are creating a custom table to track project milestones. You need to ensure that every milestone is associated with a specific project, and if the project is deleted, all associated milestones must also be deleted. Which relationship type should you configure?
Parental relationships allow for cascading delete actions, ensuring data integrity when the parent record is removed.
Why this answer
A parental relationship provides cascading behavior, including delete, which ensures that related child records are removed when the parent record is deleted.
You need to enforce data consistency across forms in a Model-driven app by hiding a field based on the value of another field. Which mechanism should you use?
Business Rules provide a low-code way to set visibility, default values, and validation.
Why this answer
Business Rules are the standard, declarative way to apply logic across forms and server-side in Dataverse.
Which TWO types of environments can be created in the Power Platform?
Used for building and testing.
Why this answer
Production and Developer (or Sandbox) are standard environment types.
When creating a new environment, what is the default database type?
Dataverse is the standard database for Power Platform.
Why this answer
Dataverse is the native database technology within the Power Platform.
Which TWO types of forms exist for Model-driven apps?
The primary form for record interaction.
Why this answer
Main and Quick View are two primary form types used in Model-driven apps.
A user needs to see records based on specific criteria. Which object should you configure?
Views define the criteria for filtering and listing records.
Why this answer
Views are used to define the filtering and sorting of record lists.
You are auditing environment security. You find that a user can see records they should not have access to. The user is assigned two security roles, one that grants access and one that restricts it. How does Dataverse handle this?
Security roles are cumulative; if any role grants access, the user has access.
Why this answer
Dataverse uses a 'Union' approach; the user receives the sum of all privileges from all assigned roles.
Which security role type is provided by default in Dataverse?
System Administrator is the built-in role for full access.
Why this answer
System Administrator is the default, all-access role provided in every environment.
Which TWO properties can you configure for a column in Dataverse?
Mandatory status is a standard column configuration.
Why this answer
Column configuration includes data types and mandatory/required status.
You want to ensure that a user can only see records belonging to their business unit. Which access level should you set in the security role?
Business Unit level allows access to all records in the user's unit.
Why this answer
The 'Business Unit' access level restricts visibility to records owned within the same business unit.
What feature helps you identify errors in your model-driven app configuration?
App Checker validates the app components for errors.
Why this answer
The App Checker scans the application components for potential issues and best-practice violations.
Which THREE items can be configured in a table relationship?
The type is fundamental.
Why this answer
Relationships define behavior, cardinality, and cascading rules.
Which TWO of the following are valid relationship types in Dataverse?
This is a fundamental relationship type.
Why this answer
Dataverse supports One-to-Many and Many-to-Many as primary relationship types.
Which tool is used to manage Dataverse environments and solutions?
Admin center is for environment management and solution deployment.
Why this answer
The Power Platform admin center is the centralized portal for environment administration.
You are configuring a new table. Which TWO of the following are true regarding 'Auditing' in Dataverse?
The environment setting acts as the master switch for all auditing features.
Why this answer
Auditing tracks changes to data and access, but must be enabled both at the environment level and the individual table/field level.
You have a business rule that sets a field value when a form loads. Users report that the value is not being updated when they change the trigger field. What is the most likely cause?
If a business rule is set to Entity scope, it does not execute on the form interface, meaning it will not react to field changes in real-time.
Why this answer
Business rules run in the 'Entity' scope for server-side updates, but must be set to 'All Forms' or a specific form scope to execute client-side logic on the form.
What happens when you delete a 'Managed' solution in a target environment?
Managed solutions are uninstalled, removing their components.
Why this answer
Deleting a managed solution removes all components bundled within that solution, provided they are not referenced by others.
Which component allows users to navigate between different entities in a Model-driven app?
The site map manages the application navigation.
Why this answer
The Site Map defines the navigation structure of a Model-driven app.
You need to import a large volume of data into Dataverse. Which feature allows you to perform bulk operations efficiently?
Dataflows provide robust, scheduled, and scalable data ingestion.
Why this answer
Dataflows are designed for ETL (Extract, Transform, Load) tasks and bulk ingestion.
Which Dataverse feature is best for synchronizing data from an external SQL database?
Virtual tables provide real-time access to external data sources.
Why this answer
Virtual tables (or Virtual Entities) allow you to interact with external data as if it were a native Dataverse table.
Which TWO field types allow for mathematical calculations?
Used for row-level math.
Why this answer
Calculated and Rollup fields are the primary types for performing math in Dataverse.
Which THREE of the following are primary capabilities of Dataverse business rules?
Business rules can change the requirement level of a field dynamically.
Why this answer
Business rules provide a UI-based way to set field values, set default values, and perform validation logic.
Which THREE items are required to create a new Model-driven app?
The site map defines navigation.
Why this answer
A model-driven app requires a site map, a table, and a security role for access.
Which THREE items are considered 'Managed' components in a solution?
Views are solution-aware components.
Why this answer
Managed components are locked items like entities, forms, and views after they have been imported.
Which TWO types of security roles exist in Dataverse?
Roles created by makers to meet specific business needs.
Why this answer
Security roles can be custom created or system-provided.
You need to enforce data security where a user can only view records that belong to their specific business unit. Which security setting should you modify?
The Business Unit access level limits record visibility to those owned by members of the user's specific business unit.
Why this answer
The 'Business Unit' access level in a security role restricts data visibility to records owned by users within the same business unit.
Which THREE of the following are valid components of a Dataverse solution?
Tables are core components of Dataverse solutions.
Why this answer
Solutions are containers for Dataverse components including Tables, Power Automate flows, and Canvas Apps.
Where do you define the table relationships in the Power Apps maker portal?
The table editor is where you manage schema, including relationships.
Why this answer
The 'Relationships' tab within the table definition interface is where links are managed.
A user needs to see the history of changes made to a record's fields. What feature must be enabled?
Auditing tracks field changes and provides a history view.
Why this answer
Auditing is the mechanism that tracks and logs changes to record fields over time.
Which component should you use to create a user-friendly process guide on a form?
BPFs provide a structured, multi-step process UI.
Why this answer
Business Process Flows (BPF) provide a visual, guided stage-gate interface for users.
What is the primary purpose of a Dataverse 'Solution'?
Solutions are the standard for ALM and moving customizations.
Why this answer
Solutions are the mechanism to bundle and transport components between environments.
What is the purpose of the 'Default Solution' in Dataverse?
The Default Solution captures every unmanaged change in the environment.
Why this answer
The Default Solution contains all unmanaged components in the system.
You are migrating a solution from development to production. You notice the custom table is missing. What is the most common reason?
Components must be explicitly added to a solution to be part of the transport.
Why this answer
If a component is not added to the solution, it will not be included in the exported package.
You need to group fields together on a form for better readability. What should you use?
Sections are the primary way to group fields within a tab.
Why this answer
Sections are the standard form container used to group fields logically.
What is the primary role of a 'Security Role' in Dataverse?
Security roles are the core mechanism for row/table level access.
Why this answer
Security roles define the granular access (create, read, write, delete) to tables and components.
You have a table that is set to 'Organization' owned. What does this mean for security?
Organization-owned tables lack the 'Owner' field.
Why this answer
Organization-owned tables do not have an owner field, and access is typically controlled via global privileges rather than per-record ownership.
You are auditing Dataverse environment performance. You find that a custom table has excessive growth. Which action should you take to manage storage capacity effectively?
Retention policies are designed to automatically remove or archive records based on criteria, helping manage storage growth.
Why this answer
Setting a retention policy allows you to automatically delete or archive old records, reducing storage consumption.
You need to prevent a user from deleting a record. Which permission should you remove from their security role?
The Delete privilege explicitly controls record removal.
Why this answer
The Delete privilege within a security role controls the ability to remove records.
A Power Platform environment requires that users from the 'Sales' team cannot see 'Lead' records owned by the 'Marketing' team. You have already verified security roles. What is the next logical step?
Separating teams into distinct business units allows you to use business unit-level security roles to restrict data visibility effectively.
Why this answer
Business units are the primary mechanism for partitioning data access in Dataverse; placing teams into different business units enables security role-based filtering.
Which THREE actions are permitted by a Business Rule?
Rules can toggle field display.
Why this answer
Business rules can set values, show/hide fields, and validate data.
Which entity property determines if a record can be renamed by a user?
The Primary Name field holds the string representation of the record.
Why this answer
The 'Primary Name' field is the identifier that users see as the record name.
You are configuring field-level security for a sensitive 'Salary' field. You have enabled the field for security. What must be done next to ensure the user cannot read the data?
Field security requires a profile to explicitly grant or deny field access.
Why this answer
You must create a Field Security Profile and add the user to it with specific permissions.
Which THREE actions can a system administrator perform in an environment?
Solution deployment is a standard admin responsibility.
Why this answer
Admins manage security, backups, and app deployments.
Which TWO methods can be used to import data into Dataverse?
Dataflows are a primary ETL tool.
Why this answer
Dataflows and Data Import wizards are standard tools for bringing data into the system.
A developer needs to ensure that a custom field value is validated before the record is saved to the database. Where should this logic be placed?
Plugins execute within the data pipeline and can abort the operation if validation fails.
Why this answer
Synchronous plugins or real-time workflows run during the data pipeline and can block saves.
You are designing a data model for a CRM. You need to link a 'Contact' record to a 'Company' record such that deleting the Company also deletes all associated Contacts. Which relationship type do you choose?
Parental relationships enforce cascading actions like delete on the child records.
Why this answer
A parental (cascading) relationship is used to manage record lifecycles in parent-child hierarchies.
Which type of relationship is required to allow multiple 'Contacts' to be associated with multiple 'Accounts'?
M:N supports the required cross-reference structure.
Why this answer
Many-to-Many relationships are designed for scenarios where records can relate to multiple records on both sides.
You have a business rule that runs on a form. It sets a field to mandatory. Can this be bypassed?
Client-side rules are not as secure as server-side requirements.
Why this answer
Business rules on forms are client-side only and can be bypassed by users using browser dev tools or API calls.
A user has 'User' level access to a table. They create a record. Who is the owner of the record?
The creator is set as the owner by default.
Why this answer
In Dataverse, the user who creates the record is automatically assigned as the owner unless otherwise specified by logic.
You need to create a field that automatically calculates the total revenue of a customer based on related invoices. Which field type should you use?
Rollup fields perform aggregations on related entity records.
Why this answer
Rollup fields are designed to aggregate data from related records.
What is the maximum number of environments a single tenant can create?
Environment quotas are determined by the number of licenses purchased.
Why this answer
The limit depends on the license, but the question implies the concept of environment provisioning limitations.
You have a business requirement to categorize 'Project' records by a 'Status' field. You need to ensure users can only select from a predefined list. Which field type is most appropriate?
Choice columns enforce data integrity by restricting selection to a predefined list.
Why this answer
Choice columns provide a controlled list of values for consistent categorization.
You want to automate the process of sending an email whenever a specific field value changes. What is the best way to achieve this?
Flows are designed to trigger on field changes and perform actions like sending emails.
Why this answer
Power Automate flows are the standard tool for cross-platform automation and notifications.
A user reports they cannot see a custom table in their app, even though the table is part of the solution. What is the most likely cause?
Without Read access on the table, the user cannot see it in the app interface.
Why this answer
Security roles determine access to tables. If the role does not have the necessary privileges, the table will not appear.
Which TWO actions can be performed in the Power Platform admin center?
DLP is a key admin security feature.
Why this answer
Admin center manages environments and data policies (DLP).
Which THREE items are considered default table behaviors?
Standard feature for user-based access control.
Why this answer
Dataverse tables support auditing, record ownership, and connections by default.
Which THREE features are part of Dataverse security?
Core security component.
Why this answer
Security is based on roles, field-level profiles, and business units.
Ready to test yourself?
Try a timed practice session using only Dataverse Foundations questions.