ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 109 - Certified Data Architect discussion

Report
Export

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

A.
Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
Answers
A.
Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
B.
Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
Answers
B.
Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
C.
Implement a new Categories custom object and a master-detail relationship from Account to Category.
Answers
C.
Implement a new Categories custom object and a master-detail relationship from Account to Category.
D.
Implement a new Categories custom object and create a lookup field from Account to Category.
Answers
D.
Implement a new Categories custom object and create a lookup field from Account to Category.
Suggested answer: B

Explanation:

The recommended solution to ensure long-term performance for the customer categorization process is to implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values. A picklist field is a simple and efficient way to store a predefined set of values for a record. A picklist field has the following benefits:

It allows you to easily filter, sort, and group records by their category values, which can help you analyze and segment your customers.

It does not require creating any additional objects or relationships, which can reduce the data model complexity and maintenance overhead.

It supports large data volumes and can handle millions of records without affecting performance or scalability.

asked 23/09/2024
Deniz Cimen
28 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first