Dataverse Data Modeling Flashcards

In Dataverse, which security concept restricts a user's access to records based on the owner (user or team) of those records?

Answer: Record-level security through ownership and sharing

Record ownership and sharing rules in security roles define which records a user can read, write, or delete based on the owner.

What does 'Column Security Profile' in Dataverse control?

Answer: Access to specific sensitive columns, independent of the table-level security role

Column Security Profiles define which users or teams can read or write specific secured columns, adding field-level access control.

In Dataverse, what is the 'Dataverse Search' (formerly Relevance Search) feature?

Answer: A full-text search index that provides fast, relevance-ranked results across multiple tables

Dataverse Search uses Azure Cognitive Search to index selected tables and return ranked, cross-table results quickly.

Which Dataverse table stores the history of all status changes and activities for a record when using Business Process Flows?

Answer: Process Instance table (Process Stage)

Business Process Flow instances and stage progression are stored in the associated BPF process instance table created for each BPF.

What is the recommended approach when you need to store and query large volumes of time-series or event data in Dataverse?

Answer: Use Elastic Tables which support flexible schemas and are optimized for high-volume append workloads

Elastic Tables use Azure Cosmos DB under the hood to handle high-volume, schema-flexible, time-based data efficiently.

In Dataverse, which relationship behavior setting ensures that when a parent record is assigned to a new owner, all child records are also assigned to that owner?

Answer: Cascade Assign

The 'Assign' cascade option propagates ownership changes from the parent record down to all related child records.