NTO has a loyalty program to reward repeat customers.

Salesforce Data-Architect Question Answer

NTO has a loyalty program to reward repeat customers. The following conditions exists:

1.Reward levels are earned based on the amount spent during the previous 12 months.

2.The program will track every item a customer has bought and grant them points for discount.

3.The program generates 100 million records each month.

NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.

Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.