Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Exam Data-Architect Topic 5 Question 41 Discussion

Actual exam question for Salesforce's Salesforce Certified Data Architect exam
Question #: 41
Topic #: 5
[All Salesforce Certified Data Architect Questions]

Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.

Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled

as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.

What should a data architect suggest to mitigate Issues related to lookup skew?

Show Suggested Answer Hide Answer
Suggested Answer: A

creating multiple similar products and distributing the skew across those products can be a way to mitigate issues related to lookup skew. The article explains that lookup skew happens when a very large number of records are associated with a single record in the lookup object, and this can cause record locking and performance issues. The article suggests creating multiple copies of the same product record and assigning different child records to each copy, so that the number of child records per parent record is reduced.


Contribute your Thoughts:

Ula
14 days ago
I'm going to have to go with option C. It's the only one that really addresses the root of the problem. Plus, it'll give me an excuse to create a fancy custom object. Win-win!
upvoted 0 times
...
My
15 days ago
Oh boy, this question is giving me flashbacks to that time I accidentally created a million-record lookup table. Nightmare fuel! Option B for sure, though I'd throw in a little prayer just to be safe.
upvoted 0 times
...
Jesusa
17 days ago
D? Really? Clearing the value of the lookup field? That's just sweeping the problem under the rug. Let's be proactive and actually fix the underlying issue. I'm with Fannie on this one.
upvoted 0 times
Stephanie
20 hours ago
B) Change the lookup relationship to master-detail relationship.
upvoted 0 times
...
Trinidad
9 days ago
A) Create multiple similar products and distribute the skew across those products.
upvoted 0 times
...
...
Kenda
30 days ago
I agree with Gabriele. Option B seems like the best choice to mitigate lookup skew issues.
upvoted 0 times
...
Adela
1 months ago
Hmm, I'm not sure about that. Creating multiple similar products seems like a lot of work and could get messy. I'd go with option C - a custom object to manage the relationship. That feels like a cleaner approach.
upvoted 0 times
Margot
21 hours ago
Clearing the value of the field might not be the best solution. Option C seems like a more organized approach.
upvoted 0 times
...
Alexia
7 days ago
I think changing the relationship to master-detail could also help with the lookup skew issue.
upvoted 0 times
...
Ona
12 days ago
I agree, creating multiple products could be messy. Option C sounds like a cleaner approach.
upvoted 0 times
...
...
Gabriele
1 months ago
But wouldn't changing to master-detail relationship provide better data integrity and control?
upvoted 0 times
...
Wendell
1 months ago
I disagree, I believe option A is better. Creating multiple similar products can help distribute the skew.
upvoted 0 times
...
Fannie
1 months ago
I think option B is the way to go. Converting the lookup to a master-detail relationship will definitely help with the lookup skew issue. It's a simple and effective solution.
upvoted 0 times
Alpha
28 days ago
Yes, converting the lookup to a master-detail relationship will definitely help distribute the skew across the products.
upvoted 0 times
...
Marge
30 days ago
I agree, option B seems like the best solution to handle the lookup skew.
upvoted 0 times
...
...
Gabriele
1 months ago
I think we should go with option B and change the lookup relationship to master-detail.
upvoted 0 times
...

Save Cancel