Microsoft Certified: Power Platform App Maker Associate Dataverse Data Modeling 1 — Questions and Answers
Question 1: In Dataverse, what type of relationship creates a strict parent-child dependency where child records are deleted when the parent is deleted?
- Parental relationship (Correct answer)
- Referential relationship
- One-to-one relationship
- Custom cascade
Correct answer: Parental relationship
A Parental relationship configures cascading deletes so child records are automatically removed when the parent record is deleted.
Question 2: Which Dataverse column type automatically calculates its value based on a formula referencing other columns in the same table?
- Calculated column (Correct answer)
- Rollup column
- Formula column
- Lookup column
Correct answer: Calculated column
Calculated columns use a formula defined in the column editor to derive their value from other fields on the same record.
Question 3: What is the purpose of a Rollup column in Dataverse?
- Aggregate values from related child records into the parent record (Correct answer)
- Calculate a value from columns on the same record
- Store a computed text value
- Sync data from an external source
Correct answer: Aggregate values from related child records into the parent record
Rollup columns summarize data (sum, count, avg, min, max) from related child records and store the result on the parent record.
Question 4: In Dataverse, which table type stores data that rarely changes and is used to provide reference values, such as country codes?
- Virtual table
- Elastic table
- Standard table (Correct answer)
- Activity table
Correct answer: Standard table
Standard tables are the default Dataverse table type and are used for all persistent reference and transactional data.
Question 5: What does a Many-to-Many (N:N) relationship in Dataverse require behind the scenes?
- An auto-created intersect (junction) table to store the associations (Correct answer)
- A lookup column on each table
- A calculated column linking both tables
- A Power Automate flow to maintain the links
Correct answer: An auto-created intersect (junction) table to store the associations
Dataverse automatically creates a hidden intersect table to store the pairs of related records for N:N relationships.
Question 6: Which Dataverse feature enforces data consistency by defining rules that must be true before a record can be saved?
- Business Rules (Correct answer)
- Calculated columns
- Alternate keys
- Audit settings
Correct answer: Business Rules
Business Rules can set field requirements and display error messages that prevent saving if conditions are not met.
Microsoft Certified: Power Platform App Maker Associate Dataverse Data Modeling 1
In Dataverse, what type of relationship creates a strict parent-child dependency where child records are deleted when the parent is deleted?