Salesforce Certified Data Architect: Which solution should data architect provide within Salesforce for customer support agents?

Table of Contents

Question
Answer
Explanation
Reference

Question

Northern Trail Outfitters (NTO) has a loyalty program to reward repeat customers. The following conditions exist:

Reward levels are earned based on the amount spent during the previous 12 months.
The program will track every item a customer has bought and grant them points for discounts.
The program generates 100 million records each month.

NTO Customer Support would like to see a summary of a customer’s recent transactions and the reward level(s) they have attained. Which solution should the data architect use to provide the information within Salesforce for the customer support agents?

A. Create a custom big object to capture the reward program data, display it on the contact record, and update nightly from the point-of-sale system.
B. Create a custom object in Salesforce to capture and store all reward programs, populate nightly from the point-of-sale system, and present on the customer record.
C. Provide a button so that the agent can quickly open the point-of-sale system that displays the customer’s history.
D. Capture the reward program data in an external data store, and present the 12-month trailing summary in Salesforce using Salesforce Connect and an external object.

Answer

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

Explanation

The correct answer is A. Create a custom big object to capture the reward program data, display it on the contact record, and update nightly from the point-of-sale system.

The reason for choosing this option is that custom big objects are designed to store and manage massive data volumes within Salesforce without affecting performance. They can be queried and displayed on standard or custom objects using a custom lookup field. They can also be updated using asynchronous Apex or external tools.

The other options are not suitable for the following reasons:

B. Create a custom object in Salesforce to capture and store all reward programs, populate nightly from the point-of-sale system, and present on the customer record.

This option is not scalable because custom objects have storage limits that may not accommodate 100 million records per month. Also, loading such a large amount of data into Salesforce every night may cause performance issues and governor limits.

C. Provide a button so that the agent can quickly open the point-of-sale system that displays the customer’s history.

This option is not user-friendly because it requires the agent to switch between two systems and look for the relevant information in the point-of-sale system. It also does not provide a summary of the customer’s reward level(s) within Salesforce.

D. Capture the reward program data in an external data store, and present the 12-month trailing summary in Salesforce using Salesforce Connect and an external object.

This option is not efficient because it requires real-time integration with an external data store, which may have latency and availability issues. It also does not allow for querying or updating the reward program data within Salesforce.

Reference

Salesforce Certified Data Architect certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Salesforce Certified Data Architect exam and earn Salesforce Certified Data Architect certification.