ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 92 - Certified Data Architect discussion

Report
Export

Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

A.
Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.
Answers
A.
Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.
B.
Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.
Answers
B.
Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.
C.
Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.
Answers
C.
Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.
D.
Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.
Answers
D.
Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.
Suggested answer: D

Explanation:

The recommended solution to address the requirements of Universal Containers (UC) is to roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level. This solution would allow UC to show all sums of discounts across line items at an opportunity level using standard roll-up summary fields. Since UC has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request object, they can use two levels of roll-up summary fields to aggregate the discount amounts from the child objects to the parent objects. For example, they can create a roll-up summary field on the custom line item object to sum up the discount request amounts from the custom discount request object. Then, they can create another roll-up summary field on the opportunity object to sum up the line-item-level summary discounts from the custom line item object.

asked 23/09/2024
Misael Mosco Jiménez
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first