Data Modeling Exam Questions and Correct Answers

Data Modeling Exam Questions and Correct Answers What are the security considerations between master-detail and lookup relationships? - ANSWER Master-detail: Ownership of child record is determined by the parent record Lookup: each child record had an owner and is not related to the parent record Master-detail: Detail record inherits sharing and security from the parent Lookup: no security or inheritance between parent and child How do deletes of a parent record affect child records in master-detail vs lookup relationships? - ANSWER Master-Detail: All child records are deleted (unless reparenting is allowed) Lookup: options available to clear the parent info from the child, prevent delete of a parent with a child, or delete both (if the records are highly coupled) What are some restrictions of master-detail relationships that don't apply to lookup relationships? - ANSWER You can only have 2 master-detail relationships per object You can convert a master-detail relationship to a lookup relationship only if no roll-up summary fields exist on the master object. Under what conditions can you convert between master-detail and lookup relationships? - ANSWER You can convert a master-detail relationship to a lookup relationship only if no roll-up summary fields exist on the master object. You can convert a lookup relationship to a master-detail relationship, but only if the lookup field in all records contains a value. What information can be displayed in a roll-up summary field? - ANSWER Summarized values about the DETAIL side of a master-detail or lookup relationship: -Record count -Sum -Minimum -Maximum