Salesforce Tableau Crm Einstein Discovery Consultant · Free Practice Question Medium
Question 20
Using the Setup menu, the Universal Containers company activated data sync (replication) in the Tableau CRM settings. After running the sync, they notice that the aggregate sum of a field within their dataset is different than what they manually calculated by summing the same data in the Salesforce object from which the dataset was populated.Which two differences in the newly synced data can explain this? (Choose two.)
- A A. Differences involving trigger-updated fields
- B B. Differences involving permanently deleted records
- C C. Differences involving workflow-updated fields
- D D. Differences involving formula fields
Reveal correct answers
Correct answers: B, D
Explanation
The proposition B, Differences involving permanently deleted records, and the proposition D, Differences involving formula fields, can explain the difference in the aggregate sum of a field within the dataset after running the sync. B. Differences involving permanently deleted records: When data sync is activated, it replicates the data from the Salesforce object to the Tableau CRM dataset. However, if there were any permanently deleted records in the Salesforce object, they would not be replicated in the dataset. This could result in a difference in the aggregate sum of a field within the dataset compared to the manually calculated sum in the Salesforce object. D. Differences involving formula fields: Formula fields in Salesforce are calculated fields that derive their values from other fields in the object. When data sync is activated, the formula fields in the Salesforce object are not replicated in the Tableau CRM dataset. Instead, the values of the formula fields are calculated in real-time in Tableau CRM based on the values of the fields in the dataset. This could result in a difference in the aggregate sum of a field within the dataset compared to the manually calculated sum in the Salesforce object, especially if the formula fields are used in the calculation of the field being summed.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
