You are designing a data model for a CRM. You need to link a 'Contact' record to a 'Company' record such that deleting the Company also deletes all associated Contacts. Which relationship type do you choose?
You have a business rule that sets a field value when a form loads. Users report that the value is not being updated when they change the trigger field. What is the most likely cause?
You need to enforce data security where a user can only view records that belong to their specific business unit. Which security setting should you modify?
You are migrating data into Dataverse. You need to ensure that the data import does not trigger existing Power Automate cloud flows. Which feature should you utilize?
You are designing a Dataverse data model for a customer support application. The support manager wants each case to be linked to a single customer account, and when viewing a case record, they want to see the account's primary contact and phone number directly on the case form without navigating away. Which Dataverse feature should you use to achieve this?
You are building a model-driven app for a sales team. The app uses a custom table called 'Opportunity' that has a many-to-one relationship with the 'Account' table. When viewing an Opportunity record, users need to see the name of the related Account. Which type of column should you add to the Opportunity table to display the Account name?
You need to add a column to the Account table that stores a monetary value with a maximum of four decimal places. The column must be available in all forms and views. Which Dataverse column data type should you use?
A sales manager wants a new column on the Account table that automatically calculates a discount percentage based on the Annual Revenue column. The value should be recalculated whenever the revenue changes. Which type of column should you create?
You are configuring a Dataverse table for a project management app. You need to track the total number of tasks associated with each project. Each task is a record in a related 'Task' table and has a status column indicating whether it is complete. You want the 'Project' table to display the count of all tasks and also the count of completed tasks. Which column type should you use to achieve this?
You are a Dataverse administrator. A custom table named Project has a column named Budget of type Currency. You need to ensure that when a user enters a budget amount, it is automatically formatted with the organization's base currency and that the value is stored in the base currency. Which configuration should you apply?
You are building a model-driven app for a real estate agency. The app includes a custom table named Property. You need to ensure that when a user creates a new Property record, the 'Listing Date' column automatically defaults to the current date and time. You also need to ensure that this default is applied only when the record is created, not when it is updated. What should you do?
A developer is designing a Dataverse table for a customer support system. They need to track interactions with customers, including emails, phone calls, and meetings. They want to use built-in activity tables to leverage existing functionality. Which two activity tables are available out-of-the-box in Dataverse? (Choose two.)
A sales team uses a model-driven app with a custom 'Project' table. The team wants to automatically create a related 'Task' record whenever a new Project is created. They need the logic to run immediately after the Project record is saved to Dataverse. What should they use?
You are designing a Dataverse data model for a customer support system. You need to track cases and the products associated with each case. A case can be related to multiple products, and a product can be related to multiple cases. You also need to store additional information about each relationship, such as the quantity of the product involved and the date it was added. Which two actions should you perform? (Choose two.)
You are creating a new custom table in Dataverse to store product information. You need to ensure that each product has a unique identifier that is automatically generated and cannot be changed by users. Which column should you use for this purpose?
You are managing a Dataverse environment and need to ensure that when a new record is created in the 'Project' table, a related 'Task' record is automatically created and assigned to the project owner. Which feature should you use to implement this business logic?
You are configuring a Dataverse table to track projects. You need to ensure that when a project record is created, a related task record is automatically created. You also need to ensure that when a project is deleted, all related tasks are also deleted. Which two features should you use? (Choose two.)
A sales manager wants to ensure that when a user creates a new Account record, the 'Credit Limit' column cannot be left empty and must be a positive number. The manager asks you to enforce this at the data platform level so that it applies regardless of whether the record is created from a model-driven app, a canvas app, or the Web API. What should you configure?
A maker at Contoso creates a custom table named Project Tracker in Dataverse. The maker needs to prevent records from being deleted after they are created, while still allowing users to modify column values. Which table property should the maker configure?
You are a Power Platform administrator. You need to create a new environment for a development team. The environment must be able to host Dataverse and must be isolated from production data. Which two environment types should you consider? (Choose two.)
You are creating a canvas app that connects to Dataverse. You need to display a list of active accounts and allow users to filter by name. Which Dataverse feature should you use to retrieve the data efficiently?
You are designing a Dataverse solution that includes a custom table named Project. You need to ensure that users can only see Projects that belong to their business unit. Which two features should you configure? (Choose two.)
You are configuring a new Dataverse environment for a sales team. You need to set up relationships between the Account and Contact tables. Which two relationship types are supported in Dataverse? (Choose two.)
A developer is configuring a new custom table in Dataverse. They need to enable features that allow users to track changes to records and to see who created or modified a record. Which two actions should they take? (Choose two.)
You are designing a data model in Dataverse. You need to establish relationships between tables. Which two relationship types are supported in Dataverse? (Choose two.)
A developer is building a model-driven app for a help desk. Agents must see only the support cases assigned to their own team, and the filtering must apply automatically whenever the app loads the case list. Which Dataverse mechanism should the developer use to enforce this consistently?
You are managing a Dataverse environment that contains a custom table named Invoice. You need to prevent users from deleting Invoice records that have a status of 'Paid'. Which feature should you configure?
You are a Power Platform developer. You have a model-driven app that uses a custom table named Order. The Order table has a lookup column to the Account table. You need to ensure that users can only select active accounts when creating or editing an Order record. What should you do?
You are designing a Dataverse solution for a healthcare provider. The solution includes a custom table named Patient that stores sensitive health information. You need to ensure that only users with a specific security role can view Patient records, and that even users with that role cannot delete records. Which combination of security role settings should you configure?
A team is configuring a new custom table in Dataverse. They want to ensure the table supports relationships to other tables and that records can be associated with multiple related records. Which TWO configuration choices are required or appropriate to meet these goals? (Choose two.)
A maker is troubleshooting an app that queries a Dataverse table containing several million rows. A view returns results quickly when filtered by a custom text column, but a similar query filtered and sorted on a custom whole number column is very slow. The maker confirms both columns are used in the same view definition. What is the most likely explanation?
You are auditing environment security. You find that a user can see records they should not have access to. The user is assigned two security roles, one that grants access and one that restricts it. How does Dataverse handle this?
You have a business requirement to categorize 'Project' records by a 'Status' field. You need to ensure users can only select from a predefined list. Which field type is most appropriate?
You need to enforce data consistency across forms in a Model-driven app by hiding a field based on the value of another field. Which mechanism should you use?
You are configuring field-level security for a sensitive 'Salary' field. You have enabled the field for security. What must be done next to ensure the user cannot read the data?
You are creating a custom table to track project milestones. You need to ensure that every milestone is associated with a specific project, and if the project is deleted, all associated milestones must also be deleted. Which relationship type should you configure?
You are auditing Dataverse environment performance. You find that a custom table has excessive growth. Which action should you take to manage storage capacity effectively?
You need to create a column that stores the total cost of a project, which is derived from the sum of all associated expense records. Which column type should you use?
A Power Platform environment requires that users from the 'Sales' team cannot see 'Lead' records owned by the 'Marketing' team. You have already verified security roles. What is the next logical step?
You are designing a Dataverse table to store support tickets. Each ticket must be assigned a unique, automatically generated identifier that users can easily reference. The identifier should follow a consistent pattern, such as 'TCK-00001', and increment for each new record. Which Dataverse feature should you use to meet this requirement?
You are creating a Dataverse table for a real estate application. You need to store a list of property features for each listing, such as 'Pool', 'Garage', and 'Fireplace'. Each listing can have multiple features, and you want to easily filter listings by a specific feature. The features are chosen from a predefined list of 20 options. Which column type should you use?
You are designing a Dataverse solution for a sales tracking app. You need to categorize each opportunity by a predefined set of stages, such as 'Prospecting', 'Qualification', and 'Proposal'. Each opportunity can have only one stage at a time, and you want to ensure users select from these exact values. What should you create?
You are creating a new custom table in Dataverse to store product information. You need to ensure that each product has a unique identifier that is automatically generated and can be used as a primary key. Which column type should you use?
You need to create a relationship between two Dataverse tables where a single record in Table A can be associated with many records in Table B, but each record in Table B can be associated with only one record in Table A. Additionally, you want to ensure that when a record in Table A is deleted, all related records in Table B are also deleted. Which relationship type and behavior should you configure?
A developer creates a custom table named 'Project' in Dataverse. They need to ensure that each project record has a unique project code that is automatically generated when the record is created. The code must follow the format 'PRJ-00001', 'PRJ-00002', etc. Which Dataverse feature should they use to achieve this?
You are designing a Dataverse table to store customer orders. You need to ensure that each order is automatically assigned a unique, sequential order number that users can easily reference. The number should be generated when a new record is created and should not be editable by users. What should you use?
A system administrator is setting up a new Dataverse environment. They need to ensure that users can only access records that they own or that are shared with them, and that they cannot see records owned by other users in the same business unit. Which security concept should they configure?
You are designing a solution for a sales tracking app. You need to create a new custom table called 'Project' that will store project details. The table must have a primary column that uniquely identifies each project and a secondary column for the project's start date. Which of the following best describes the default behavior when you create a new custom table in Dataverse?
You are a builder working on a Power Platform solution that includes a custom Dataverse table named ProjectTask. You need to ensure that each ProjectTask record has a unique, human-readable identifier that is automatically generated when the record is created, and users should not be able to change it after creation. What should you use?
A Power Platform administrator needs to allow users in a specific department to create and edit records in a custom table, but they should not be able to delete any records. The department users already have a security role with Read and Write privileges on the table. Which security role privilege should you modify?
You are configuring a Dataverse environment for a multinational company. The company requires that certain records be accessible only to users in the same business unit, while other records should be accessible to all users in the organization. You need to set up security roles to enforce this. Which of the following security role privileges should you configure to allow users to read records only within their business unit?
You are creating a new custom table in Dataverse. You need to ensure that users can quickly find records by searching for a specific text field. Which column property should you enable to allow the field to be used in search?
A developer is building a model-driven app that must display a list of active contacts related to an account, with the ability to quickly filter and sort by multiple columns. The developer needs to add this to the account main form. Which control should be used?
You are building a model-driven app that uses Dataverse. You need to ensure that users can only view records that they own or that are shared with them. Which security concept should you implement?
You are a Power Platform developer. You need to create a new custom table in Dataverse to store product information. The table must have a column that can store a monetary value and another column that can store a yes/no choice. Which column data types should you use?
A developer is configuring a new custom table in Dataverse. They need to ensure that the table supports auditing and that users can search for records using the Dataverse search. Which two table properties must be enabled? (Choose two.)
A Dataverse environment contains a custom table 'Invoice' with a column 'TotalAmount' of type Currency. You need to ensure that the 'TotalAmount' is automatically calculated as the sum of line items whenever a related 'InvoiceLine' record is created, updated, or deleted. The calculation must be consistent regardless of how the data is modified (e.g., through the app, API, or import). What should you use?
You are building a canvas app that connects to Dataverse. You need to store a list of product categories that will be used across multiple apps. The categories should be easy to update without modifying any app. What should you create?
A developer needs to create a relationship between two Dataverse tables: 'Project' and 'Task'. A project can have many tasks, but each task belongs to exactly one project. The developer also wants to ensure that when a project is deleted, all related tasks are automatically deleted. Which type of relationship and configuration should they use?
You are building a model-driven app for a sales team. The app uses a Dataverse table named Opportunity. You need to ensure that when a user opens an Opportunity record, they see a read-only list of related Contacts that are associated with that Opportunity. The list should appear on the main form and allow users to open a Contact record. What should you add to the form?
A developer is creating a Power Automate cloud flow that must retrieve all active accounts with a specific industry and then update a custom column on each. The flow will run daily. Which Dataverse action should be used to efficiently retrieve the records?
You are designing a Dataverse solution for a real estate agency. The agency needs to track properties and the agents who list them. Each property can have only one listing agent, but an agent can list many properties. You create a table named Property and a table named Agent. You need to establish the relationship so that when an agent is deleted, their listed properties remain but the Listing Agent column is cleared. Which relationship type and behavior should you configure?
You are creating a new custom table in Dataverse to store customer feedback. You need to ensure that each feedback record is associated with a specific account. Which type of column should you add to the feedback table to create this association?
You are designing a Dataverse data model for a field service application. A dispatcher must be able to assign a work order to exactly one technician, but a technician can be assigned many work orders over time. The work order table already exists and the technician table already exists. You need to add the relationship that enforces this business rule with the least administrative effort. What should you create?
You are designing a Dataverse solution for a hospital. You need to track patient visits and the medications prescribed during each visit. A visit can have multiple medications, and a medication can be prescribed in multiple visits. You also need to store the dosage and frequency for each medication prescribed in a visit. What is the most appropriate way to model this relationship?
You need to enforce that a custom table named Project has a unique project code. The project code is entered by users and must be unique across all records. You also want to ensure that the uniqueness check is performed server-side to prevent duplicates from any client. What should you do?
You are configuring a new custom table in Dataverse to store project tasks. You need to ensure that the table supports attachments, allows users to add notes, and tracks when records are created and modified. Which two actions should you perform? (Choose two.)
A company stores customer feedback in a Dataverse table named Feedback. Analysts frequently run reports filtered by the date the feedback was submitted, and they also sort by that date. The column currently stores the value as a single line of text, which forces slow client-side filtering. You need the column to support efficient server-side filtering, sorting, and date range queries. What should you do?
You are building a model-driven app for a healthcare clinic. The clinic wants to track patients and their appointments. A patient can have many appointments, and each appointment is associated with exactly one patient. When a patient is deleted, all their appointments should also be deleted. Which relationship behavior should you configure between the Patient and Appointment tables?
You are preparing a solution for transport from a development environment to a production environment. The solution contains a custom table, a model-driven app, and several cloud flows that reference environment variables. During import testing, you discover that the flows fail because their connection references point to the developer's personal connections. You need to identify which behaviors are true of connection references and environment variables when a solution is exported and imported. (Choose two.)
You are configuring a Dataverse table to store customer feedback. You need to ensure that the table supports auditing and that users can track changes to specific columns. Which two actions must you perform? (Choose two.)
A Power Platform developer is creating a new custom table in Dataverse. They need to store a list of predefined options that users can select from, such as 'High', 'Medium', or 'Low' priority. Which type of column should they use?
A solution architect must design a Dataverse table that stores historical sensor readings. The table will grow to hundreds of millions of rows, and queries will almost always filter by sensor identifier and a timestamp range. Which design choice best supports efficient querying at this scale?
A team is building an app on Dataverse. They need to record the moment a support ticket is escalated so that downstream automations can trigger on that event, and they want the value captured automatically without the user entering it. They also want the value to remain unchanged if the ticket is later edited. Which column type best fits this requirement?
A company has a Dataverse environment with a custom table 'Order' that includes a Lookup column to the 'Account' table. The company wants to ensure that when an Order is created, the 'Account' record's 'CreditLimit' is checked and the Order is rejected if the order total exceeds the credit limit. The validation must occur regardless of whether the Order is created via the model-driven app, API, or import. What should they implement?
A maker publishes a canvas app that reads from a Dataverse table. Users report that records created by teammates are visible, but when a user tries to update a record created by someone else, the save fails with a permission error. The maker confirms the users share the same security role. Which Dataverse concept most likely explains why updates fail while reads succeed?
You are building a model-driven app for a chain of fitness studios. The app uses a custom Dataverse table named ClassSession that has a Many-to-One relationship to a custom table named Studio. Each studio has a weekly capacity limit stored in a Whole Number column named WeeklyCapacity. You need to prevent a user from creating a ClassSession record if the total number of ClassSessions for that studio in the same week would exceed the studio's WeeklyCapacity. The validation must run whenever a ClassSession is created or updated, regardless of whether the change comes from the model-driven app, a Power Automate flow, or the Web API. What should you use?
You are designing a Dataverse solution for a municipal permits office. The Permits table must record the date a permit application was received and the date the inspection was completed. Auditors require that the received date never changes after the record is created, but the inspection date must be editable by inspectors. You also need to report on the number of days between receipt and inspection. Which configuration should you use?
You are an app builder for a logistics company. The company uses a Dataverse table named Shipment with a choice column named ShipmentStatus that includes options such as Draft, InTransit, Delivered, and Cancelled. Business rules must automatically set the ShipmentStatus to Delivered when the ActualDeliveryDate column is populated, but users should not be able to manually change the status to Delivered if the ActualDeliveryDate is empty. Which Dataverse feature should you use to implement this requirement?
You are creating a Dataverse table to store customer feedback. You need to capture the date and time when the feedback was submitted, including the time zone offset. Which data type should you use for the column?
You are a Power Platform maker designing a Dataverse solution for a project management app. You need to create a relationship between a custom table named Project and a custom table named Task. A project can have many tasks, and each task belongs to exactly one project. You also need to ensure that when a project is deleted, all related tasks are automatically deleted. Which two actions should you perform? (Choose two.)
You are a solution architect for a large enterprise. The company uses Dataverse and needs to ensure that when a custom table named Invoice is created or updated, a series of complex calculations are performed and the results are stored in related records across multiple tables. The calculations involve aggregating data from several other tables and must run reliably even if initiated from bulk data imports or background processes. You need to minimize development effort and ensure the logic is reusable across multiple apps. What should you use?