Exam Certified Data Architect topic 1 question 29 discussion

I think correct optio is D. Data Volume: With the loyalty program generating 100 million records each month, it is important to consider data volume and performance Real-time Integration: Salesforce Connect allows you to seamlessly integrate external data sources with Salesforce using external objects. Trailing 12-Month Summary: Since the reward levels are earned based on the amount spent during the previous 12 months, it is crucial to present a summary that reflects this trailing period.

I echo all the other comments that it's definitely D

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 solution allows for the large volume of data (100 million records each month) to be stored externally, which can help with performance and storage considerations. Salesforce Connect and an external object can provide a live connection to this data, allowing customer support agents to see a summary of a customer’s recent transactions and attained reward levels. This approach aligns with NTO’s requirements and can provide an efficient and effective solution for their loyalty program.

+1 to D. Salesforce Connect + External object, then you could then aggregate the data into a custom object or use a LWC to help the agent visualize, but you need the data integrated into salesforce without chewing through data storage.

A can't be true because it's not possible to show big object records in the related list (https://ideas.salesforce.com/s/idea/a0B8W00000GdbpiUAB/native-support-for-big-object-reports-and-related-lists). So the answer is D

Ans: is A as it is clearly mentioned in the question "Within Salesforce"Keyword Question "Which solution should the data architect use to provide the information within Salesforce for the customer support agents?"

+1 to D as the correct answer

The answer is D. Given the large volume of data generated (100 million records each month) and the need for a 12-month trailing summary, it is advisable to leverage an external data store to handle the data storage and processing. Salesforce Connect allows you to integrate external data with Salesforce seamlessly. By capturing the reward program data in an external data store, such as a separate database or data warehouse, you can efficiently manage and process the large volume of transaction records. Salesforce Connect can be used to establish a real-time connection between Salesforce and the external data store, enabling access to the necessary customer information. Using an external object in Salesforce, which represents the data stored in the external data store, you can surface the 12-month trailing summary of transactions and reward levels within Salesforce. This approach allows customer support agents to view the relevant information without storing the entire transaction history directly in Salesforce.