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.
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.
D.
Implement a new Categories custom object and create a lookup field from Account to Category.
B.
Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
Explanation
For categorizing accounts into a small, fixed set of categories evenly distributed (Gold/Silver/Bronze), a picklist field is highly efficient, straightforward, and scalable for long-term growth. The expected volume (500,000 customers plus incremental growth) is manageable with picklist fields, offering immediate reporting efficiency and simplicity. Global picklists (A) offer no advantage here and add unnecessary complexity. Creating a new object (C/D) for just three category values introduces unnecessary relational complexity and overhead, negatively impacting performance and simplicity. Thus, a simple Account picklist is optimal for clear categorization, reporting ease, and performance efficiency.