ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 143 - Certified Data Architect discussion

Report
Export

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

A.
Use picklist fields rather than lookup to custom object.
Answers
A.
Use picklist fields rather than lookup to custom object.
B.
Limit assigning one user 10000 records ownership.
Answers
B.
Limit assigning one user 10000 records ownership.
C.
Assign 10000 opportunities to one account.
Answers
C.
Assign 10000 opportunities to one account.
D.
Limit associating 10000 opportunities to one account.
Answers
D.
Limit associating 10000 opportunities to one account.
E.
Limit associating 10000 records looking up to same records.
Answers
E.
Limit associating 10000 records looking up to same records.
Suggested answer: B, D, E

Explanation:

Data skew occurs when a large number of child records are associated with a single parent record, or when a single user owns a large number of records. This can cause performance issues and lock contention.To avoid data skew, the data architect should limit assigning one user 10,000 records ownership, limit associating 10,000 opportunities to one account, and limit associating 10,000 records looking up to the same record

asked 23/09/2024
Mario Perez Hervas
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first