Universal Containers plans to upload target data from an external tool to CRM Analytics so it 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 a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, 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?
Show Answer
Hide Answer
Correct Answer:
A
For uploading target data that changes on a monthly basis and includes historical data (previous years' targets), the appropriate operation is 'Overwrite.' This ensures that each time the CSV file is uploaded, the existing data in the dataset is replaced with the new data. This is critical because the target data includes both current and historical data, and using 'Overwrite' will update the entire dataset while maintaining historical accuracy.
'Append' would add new data without replacing the old records, leading to duplication, and 'Update' is not suitable for completely replacing data in this context.
