Microsoft Certified: Power Platform App Maker Associate Dataverse Data Modeling 2

Question 1

In Dataverse, what is an Alternate Key used for?

Accepted Answer

Identify records uniquely using a non-primary-key column or combination of columns

Answer

Alternate Keys define one or more columns whose combined values must be unique, enabling upsert operations using business keys.

Question 2

Which Dataverse column data type should you use to store a monetary value that automatically handles currency conversion?

Accepted Answer

Currency

Answer

The Currency data type stores monetary values and links to the currency table for conversion rate support.

Question 3

What is the maximum length of text that a Dataverse 'Text' (single-line) column can store?

Accepted Answer

4,000 characters

Answer

Single-line Text columns in Dataverse support up to 4,000 characters in length.

Question 4

In Dataverse, what does enabling 'Auditing' on a table do?

Accepted Answer

Records a history of all data changes including who changed what and when

Answer

Auditing logs create, update, and delete operations on records, capturing the user, timestamp, and changed values.

Question 5

Which Dataverse feature allows makers to define a set of valid values for a column that users can select from a dropdown?

Accepted Answer

Choice column (Option Set)

Answer

Choice columns (formerly Option Sets) define a fixed list of labeled integer values presented as a dropdown to users.

Microsoft Certified: Power Platform App Maker Associate Practice Test