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

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?

Accepted Answer

Calculated column

Answer

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?

Accepted Answer

Aggregate values from related child records into the parent record

Answer

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?

Accepted Answer

Standard table

Answer

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?

Accepted Answer

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

Answer

Dataverse automatically creates a hidden intersect table to store the pairs of related records for N:N relationships.

Microsoft Certified: Power Platform App Maker Associate Practice Test