Salesforce Certified Service Cloud Consultant — Question 96

Universal Containers (UC) receives partner data in Excel format. The Excel data is all text, but needs to be imported into existing Salesforce Date, Number, and Text fields.
Which three best practices should a consultant recommend? (Choose three.)

Answer options

• A. Deduplicate the data before importing into Salesforce.
• B. Import the records and use Duplicate Management.
• C. Install the Data Quality Analysis Dashboards from the AppExchange.
• D. Standardize all rows to match Salesforce data types.
• E. Import the records and create a workflow rule to change the data type.

Correct answer: A, B, D

Explanation

The correct answer includes A, B, and D because deduplicating data is essential to maintain integrity, using Duplicate Management helps manage any remaining duplicates, and standardizing data types ensures compatibility with Salesforce fields. Option C is not a direct best practice for data import, and option E is inappropriate as workflow rules cannot change data types after import.