Dataverse Data Modeling Flashcards
6 cards from real Microsoft Certified: Power Platform App Maker Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Dataverse Data Modeling flashcards as text
In Dataverse, what is an Alternate Key used for?
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.
Which Dataverse column data type should you use to store a monetary value that automatically handles currency conversion?
Answer: Currency
The Currency data type stores monetary values and links to the currency table for conversion rate support.
What is the maximum length of text that a Dataverse 'Text' (single-line) column can store?
Answer: 4,000 characters
Single-line Text columns in Dataverse support up to 4,000 characters in length.
In Dataverse, what does enabling 'Auditing' on a table do?
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.
Which Dataverse feature allows makers to define a set of valid values for a column that users can select from a dropdown?
Answer: Choice column (Option Set)
Choice columns (formerly Option Sets) define a fixed list of labeled integer values presented as a dropdown to users.
What is the purpose of a 'Virtual Table' in Dataverse?
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.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, score release, renewal, eligibility, retake policy, time limit · verified Oct 2026
- home.pearsonvue.com — Test delivery · verified Oct 2026