Microsoft Power Platform Fundamentals Microsoft Dataverse 2 — Questions and Answers
Question 1: Which Dataverse security concept restricts which records a user can see based on their position in an organization hierarchy?
- Field-level security
- Row-level security via owner/team/business unit hierarchy (Correct answer)
- Role-based access control (RBAC)
- Attribute-based access control (ABAC)
Correct answer: Row-level security via owner/team/business unit hierarchy
Dataverse security uses a hierarchy of business units, teams, and record ownership to control which rows a user can read, write, or delete.
Question 2: What is a Dataverse 'security role'?
- A user group in Azure Active Directory synced to Dataverse
- A set of privilege definitions that control what operations a user can perform on tables and records (Correct answer)
- An encryption certificate applied to sensitive Dataverse columns
- A workflow that audits user actions on Dataverse records
Correct answer: A set of privilege definitions that control what operations a user can perform on tables and records
Security roles define the Create, Read, Update, Delete (CRUD) and other privileges a user has on each table, with scope settings (user, business unit, organization, etc.).
Question 3: What is 'field-level security' in Dataverse used for?
- Restricting which columns a user can view or edit, independent of table-level access (Correct answer)
- Encrypting specific columns in the database at rest
- Requiring multi-factor authentication to access sensitive fields
- Masking PII data in exported Excel files
Correct answer: Restricting which columns a user can view or edit, independent of table-level access
Field-level security profiles restrict which users can read, create, or update specific columns in a table, adding granular control beyond table-level security roles.
Question 4: What is a Dataverse 'calculated column'?
- A column whose value is computed by a DAX formula at report time
- A column whose value is automatically derived by a formula based on other column values in the same row (Correct answer)
- A column that sums child record values from a related table
- A column populated by a Power Automate flow on record save
Correct answer: A column whose value is automatically derived by a formula based on other column values in the same row
A calculated column in Dataverse uses a formula to automatically compute its value from other fields in the same record, updated whenever the source fields change.
Question 5: Which Dataverse feature allows a column to store the sum or count of related child records?
- Calculated column
- Rollup column (Correct answer)
- Formula column
- Lookup column
Correct answer: Rollup column
Rollup columns aggregate data from related child records (e.g., total revenue from all Opportunities on an Account) and recalculate on a scheduled basis.
Question 6: What is the purpose of Dataverse's 'audit' feature?
- Running automated data quality checks on new records
- Tracking changes to records and field values for compliance and troubleshooting (Correct answer)
- Monitoring API call volume and throttling limits
- Validating that business rules are correctly configured
Correct answer: Tracking changes to records and field values for compliance and troubleshooting
Dataverse auditing logs create, update, and delete operations on records, recording the old and new values so changes can be reviewed for compliance or debugging.
Microsoft Power Platform Fundamentals Microsoft Dataverse 2
Which Dataverse security concept restricts which records a user can see based on their position in an organization hierarchy?