QuestionQ22

VerifiedCreate a foundation for intelligent applications

You are designing a data model for a company that uses only standard Microsoft Dataverse tables.

You must extend the existing Accounts and Contacts tables to support these business requirements:

  • Store an additional classification value on the Accounts table.
  • Add a field that indicates a customer’s engagement tier on the Contacts table.
  • Create a mechanism to improve lookup performance and ensure uniqueness across selected fields.

You need to modify the tables to meet the business requirements. You may use each component once, more than once, or not at all.

Drag & Drop
Add a classification value to the Accounts table.
Add a customer engagement tier to the Contacts table.
Improve lookup performance and enforce uniqueness.
Explanation

A choice column stores a value selected from a fixed, predefined list, which suits both an account classification and a customer engagement tier (for example Bronze, Silver, Gold). Every column added to a table is a custom column, so that is not a distinct column type to pick here. An alternate key is enforced by a database index, which enforces uniqueness across the selected columns and improves lookup performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!