Microsoft Certified: Power Platform App Maker Associate Dataverse Data Modeling 2 — Questions and Answers
Question 1: In Dataverse, what is an Alternate Key used for?
- Identify records uniquely using a non-primary-key column or combination of columns (Correct answer)
- Define a secondary sort order for views
- Create a backup unique identifier
- Link two tables without a lookup
Correct answer: Identify records uniquely using a non-primary-key column or combination of columns
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?
- Currency (Correct answer)
- Decimal Number
- Float
- Whole Number
Correct answer: Currency
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?
- 4,000 characters (Correct answer)
- 255 characters
- 1,000 characters
- Unlimited
Correct answer: 4,000 characters
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?
- Records a history of all data changes including who changed what and when (Correct answer)
- Validates data integrity on save
- Sends email notifications on record changes
- Locks the table from deletion
Correct answer: Records a history of all data changes including who changed what and when
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?
- Choice column (Option Set) (Correct answer)
- Lookup column
- Text column with validation
- Calculated column
Correct answer: Choice column (Option Set)
Choice columns (formerly Option Sets) define a fixed list of labeled integer values presented as a dropdown to users.
Question 6: What is the purpose of a 'Virtual Table' in Dataverse?
- Expose external data as if it were a native Dataverse table without storing it in Dataverse (Correct answer)
- Store temporary session data
- Cache large datasets locally
- Create a read-only copy of a table
Correct answer: Expose external data as if it were a native Dataverse table without storing it in Dataverse
Virtual Tables use a data provider to proxy external data sources so apps can query them like regular Dataverse tables.
Microsoft Certified: Power Platform App Maker Associate Dataverse Data Modeling 2
In Dataverse, what is an Alternate Key used for?