QuestionQ72

Configure Microsoft Dataverse

A travel company has a Common Data Service (CDS) environment.

The company needs the following:

  • Custom entities to record the regions that clients have traveled to.
  • The dates on which clients traveled to those regions.

Question Image

You need to create the entities and relationships that meet the requirements.

Which three actions should you take? Each correct answer represents part of the solution.

NOTE: Each correct selection is worth one point.

Choose three
  • A Create a N:N relationship from Contact to the Region entity.
  • B Create a 1:N relationship from the ContactRegion intersect entity and Region.
  • C Create an intersect entity named ContactRegion and create 1:N relationships to Contact and Region.
  • D On the main form for ContactRegion, add lookup fields for Contact and Region, and a date field for the visit date.
  • E Create a 1:N relationship from Contact to the Region entity.
  • F Create the Region entity.
Explanation

A custom intersect entity is needed when the relationship between Contact and Region must store additional data, such as the visit date. Contact and Region each have a one-to-many relationship to ContactRegion, making ContactRegion the many-side record that stores lookups to both entities and the date field. The Region entity must exist before it can participate in that design. A built-in N:N relationship cannot store custom columns on its relationship table.

Learn more

Community Discussion

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