Microsoft Certified: Power Platform App Maker Associate Dataverse Data Modeling

Question 1

In Dataverse, what type of relationship creates a strict parent-child dependency where child records are deleted when the parent is deleted?

Accepted Answer

Parental relationship

Answer

Referential relationship

Answer

One-to-one relationship

Answer

Custom cascade

Question 2

Which Dataverse column type automatically calculates its value based on a formula referencing other columns in the same table?

Accepted Answer

Calculated column

Answer

Rollup column

Answer

Formula column

Answer

Lookup column

Question 3

What is the purpose of a Rollup column in Dataverse?

Accepted Answer

Aggregate values from related child records into the parent record

Answer

Calculate a value from columns on the same record

Answer

Store a computed text value

Answer

Sync data from an external source

Question 4

In Dataverse, which table type stores data that rarely changes and is used to provide reference values, such as country codes?

Accepted Answer

Standard table

Answer

Virtual table

Answer

Elastic table

Answer

Activity table

Question 5

What does a Many-to-Many (N:N) relationship in Dataverse require behind the scenes?

Accepted Answer

An auto-created intersect (junction) table to store the associations

Answer

A lookup column on each table

Answer

A calculated column linking both tables

Answer

A Power Automate flow to maintain the links

Question 6

Which Dataverse feature enforces data consistency by defining rules that must be true before a record can be saved?

Accepted Answer

Business Rules

Answer

Calculated columns

Answer

Alternate keys

Answer

Audit settings