Salesforce Certified Einstein Analytics and Discovery Consultant — Question 8

The Universal Containers company plans to upload target data from an external tool to Einstein Analytics so they can calculate the Sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is CSV file that contains the Salesforce ID of the sales representative, the target amount, and the month of the target. For each sales representative, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?

Answer options

• A. Overwrite
• B. Upsert
• C. Append
• D. Update

Correct answer: A

Explanation

The correct answer is 'Overwrite' because the target data is being completely replaced each month with new values, ensuring that only the most current data is maintained. 'Upsert' would not be appropriate as it is used for merging records, while 'Append' would add new records without removing the old ones, which is not suitable for monthly updates. 'Update' would imply modifying existing records, which does not fit the requirement of replacing the entire dataset.