Microsoft Dynamics 365 for Finance and Operations (legacy) — Question 6

You are adding a relationship to a table.
Which two best practices should you follow? Each correct answer presents part of the solution.

Answer options

• A. Define the relationship to a foreign key on the child table by setting the validate property on the relation to Yes.
• B. Define a navigational relationship; the validate property on the relation should be set to "Yes" for easier navigation.
• C. Name the relationship with an "_rel" suffix in order to differentiate it from the index that is appended with "_idx".
• D. Set the validate property to No when you are using navigational relationships so that the application is easy to navigate.

Correct answer: A, B

Explanation

The correct answers are A and B because they emphasize the importance of establishing foreign key constraints and enabling validation for navigability. Options C and D are incorrect as they either focus on naming conventions that do not impact functionality or suggest disabling validation, which contradicts best practices for ensuring data integrity.