PL 400 Configure Microsoft Dataverse 2 — Questions and Answers
Question 1: Which Dataverse feature allows you to enforce that a column value must be unique across all rows in a table?
- Alternate key (Correct answer)
- Primary key
- Lookup column
- Calculated column
Correct answer: Alternate key
Alternate keys in Dataverse enforce uniqueness on one or more columns and can also be used for upsert operations.
Question 2: A developer needs to run custom logic automatically whenever a record is deleted in Dataverse, without user interaction. What is the best approach?
- Classic workflow
- Power Automate cloud flow with manual trigger
- Plug-in registered on the Delete message (Correct answer)
- Business rule
Correct answer: Plug-in registered on the Delete message
A plug-in registered on the Delete message executes synchronously in the Dataverse pipeline whenever a delete operation occurs.
Question 3: What is the maximum number of columns that can be included in a Dataverse alternate key?
- 5
- 10 (Correct answer)
- 3
- 1
Correct answer: 10
Dataverse supports up to 10 columns in a single alternate key definition.
Question 4: In Dataverse, which security concept restricts what data a user can see based on their position in a business hierarchy?
- Field-level security
- Business unit
- Hierarchy security (Correct answer)
- Team-based security
Correct answer: Hierarchy security
Hierarchy security allows managers to access records owned by their direct and indirect reports.
Question 5: A developer wants to store a list of predefined options for a column that is shared across multiple tables. Which column type should they use?
- Local choice column
- Lookup column
- Global choice column (Correct answer)
- Text column with validation
Correct answer: Global choice column
Global choice columns (option sets) are defined once and reused across multiple tables in the environment.
Question 6: Which Dataverse table type stores data outside of Dataverse storage and requires a virtual table provider?
- Activity table
- Elastic table
- Virtual table (Correct answer)
- Standard table
Correct answer: Virtual table
Virtual tables surface external data in Dataverse without storing it, using a data provider to query the source system.
Question 7: When configuring column-level security in Dataverse, what must a user have to read a secured column?
- System Administrator role
- A field security profile that grants Read permission on that column (Correct answer)
- Owner of the record
- Business unit manager role
Correct answer: A field security profile that grants Read permission on that column
Field security profiles control access to secured columns; a user or team must be assigned a profile granting the appropriate permission.
Which Dataverse feature allows you to enforce that a column value must be unique across all rows in a table?