Exam PL-400 topic 3 question 12 discussion

DEF is the correct answer.

Answer is correct. The requirements can be broken down per requirement. 1. Client records include links to the places that clients visit. -A. Create a 1:N relationship between the Contact system entity and the Address system entity named Destination. 2. The company must be able to link multiple rating records to the new address record. -C. Create a 1:N relationship between the Address system entity and the Rating entity. 3. You need to expand the Rating entity to include contact, address, and rating information in one place. -E. Create a mapping for the Destination "" Rating relationship.

FRom chatGPT: (mapping used to auto fill the fileds, so no mapping required to expand the Rating entity) C. Create a 1:N relationship between the Address system entity and the Rating entity. D. Create a 1:N relationship between the Contact system entity and the Rating entity. F. Create a 1:N relationship between the Destination entity and the Rating entity.

A travel company plans to track the address of places their clients visit in an "entity named Destination". D. Create a 1:N relationship between the Contact system entity and the Rating entity. E. Create a mapping for the Destination ג€" Rating relationship.(destination entity refers-address) F. Create a 1:N relationship between the Destination entity and the Rating entity.

You need to expand the Rating entity to include contact, address, and rating information in one place.

There is no "Address system entity", the scenario says that "Destination" was used for that, so that leaves A and C out of the equation. Then, to decide between B and E I just used this "You need to expand the Rating entity to include contact, address, and rating information in one place", being ADDRESS the key here, because Address information is on the "Destination" entity, so that is why E should be the one. So that leaves us with: D E F

according to gpt o3 high answer is DEF , A incorrect bcz This would mean each Contact can have many Destinations, but each Destination is tied to a single Contact. In a travel scenario, multiple clients might visit (and rate) the same place, so a simple 1:N is not usually what you want here—and the question states “Client records include links to the places they visit” (likely already handled, or possibly many-to-many).

Answer DEF

In exam - 9/23/2023

DEF should be

A. Create a 1:N relationship between the Contact system entity and the Destination entity. D. Create a 1:N relationship between the Contact system entity and the Rating entity. F. Create a 1:N relationship between the Destination entity and the Rating entity.

I think answer is right. To meet the requirement with those but if you choose: D. -> If this is your answer means you will probably choose DEF in which case you will end up with more relations than needed and is wrong because you are not meeting the requirement of "One contact can have many Destination" you are just mapping ratings. E. -> Wrong for previous reasons, you are mapping information, not creating new Destinations records for each Contact F. -> Wrong for same reasons as before stated. Also to seek Destination you will have a bad performance as you first need to map Rating from contact, ("EDF") and then seek the Destination record related to Rating.

answer: DEF

DEF of course

Please explain: D. Create a 1:N relationship between the Contact system entity and the Rating entity. Here's the statement again: A travel company plans to track the address of places their clients visit in an entity named Destination. Client information is captured as contact records. Client records include links to the places that clients visit. The company must be able to link multiple rating records to the new address record. You find a custom Rating entity that is incomplete. Why I have a problem: No part of that statement produces an idea that there should be a relationship between Contact and Rating. There is a popular idea: "but rating has to be done by contact": yet I don't read that at all. Please help!

E is correct. Key thing to note is that the address is stored in the Destination... but question states that this address must be included in the Rating entity. I dont think it is B because it just wants the Contact in the rating entity... not any of the Contact fields that you would usually map to another entity.

I have tried to implement this to verify. There is no way you can create any relationship with system address entity and hence ACE is not correct answer. The only correct option is DEF