Describe the Considerations When Importing, Updating, Transferring, and Mass Deleting Data (e.g., CSV Files, Data Quality, Field Mapping, Record IDs, External IDs, Duplicate Records). PLATFORM-ADMINISTRATOR Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   An admin imports contacts from a CSV where the 'Company' column contains the account name. The account records already exist in Salesforce. The admin wants to link each contact to the correct account during import. What should the admin use as the matching field for the AccountId?

   • AThe Account External ID field
   • BThe Account Number field
   • CThe Account Owner field
   • DThe Account Name field
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Before importing a large CSV file, an administrator wants to prevent duplicate Account records. Which feature should be used?

   • AWorkflow Rules
   • BValidation Rules
   • CDuplicate Rules
   • DApproval Processes
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company plans to import 20,000 leads from a purchased list. The admin notices that 15% of the records have missing email addresses, 10% have duplicate phone numbers, and 5% have inconsistent state abbreviations (e.g., 'CA' vs 'California'). The sales team will use email as the primary matching key. What should the admin do FIRST?

   • AClean the data by removing records with missing emails and standardizing state abbreviations before import.
   • BMap the state field to a picklist and enable strict validation to reject invalid values.
   • CUse an external ID on the phone field to prevent duplicates during import.
   • DImport the data as-is and rely on Salesforce duplicate rules to catch issues.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   An administrator is evaluating data quality before a mass update. Which issue is an example of inconsistent data?

   • AThe 'Phone' field contains letters in some records.
   • BThe 'State' field contains 'CA' in some records and 'California' in others.
   • CThe 'Annual Revenue' field has values in different currencies.
   • DSome records have a blank 'Industry' field.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   An admin mass deletes 5,000 obsolete opportunities using the Data Loader 'Delete' operation. After the deletion, the admin realizes that 200 of those opportunities were needed for a quarterly report. What is the most immediate recovery option?

   • AContact Salesforce support to restore the data from a backup.
   • BRestore the opportunities from the Recycle Bin within 15 days.
   • CUse the 'Undelete' operation in Data Loader to restore the records.
   • DRe-import the opportunities from the original CSV file.
   Reveal Solution Discussion Select an answer first