Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 47

The Universal Containers company plans to upload target data from an external tool to Tableau CRM 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 a 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. Append
• B. Join
• C. Overwrite
• D. Update

Correct answer: C

Explanation

The correct answer is C - Overwrite, because the target data changes every month and requires the previous data to be replaced completely for accurate updates. The Append option (A) would add new records without removing old ones, which is not suitable in this case. Join (B) is irrelevant as it involves combining data sources rather than uploading new data, and Update (D) suggests modifying existing records rather than replacing the entire dataset.