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 2)

Questions 6–10

1. 6application · medium

   An admin imports 10,000 accounts from a CSV. The data contains several accounts with the same name but different addresses. The admin wants to prevent duplicate accounts from being created during the import. What should the admin configure BEFORE running the import?

   • AA workflow rule that alerts the admin when a duplicate is detected.
   • BA custom external ID on the Account Name field to enforce uniqueness.
   • CA duplicate rule with a matching rule on Account Name and a standard 'Block' action.
   • DA validation rule that checks if an account with the same name already exists.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   An administrator wants to update existing Contact records using an external ID field that uniquely identifies each contact in the source system. Which import operation should be used?

   • AUpsert
   • BDelete
   • CInsert
   • DUpdate
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   When importing records into Salesforce, which fields must be included in the field mapping?

   • AOnly fields that are not nullable.
   • BOnly custom fields, because standard fields are automatically mapped.
   • CAll required fields on the target object.
   • DAll fields that exist on the target object.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   During a data import, an administrator maps a source column to a custom field on the Account object. What must be true for the mapping to be valid?

   • AThe source column must contain data in the same format as the field's display label.
   • BThe source column must be the first column in the CSV file.
   • CThe source column header must exactly match the custom field's API name.
   • DThe custom field must be a required field on the Account object.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company uses Data Loader to upsert 5,000 leads. The CSV contains a custom external ID field 'Lead_ID__c'. The admin maps the external ID field and runs the upsert. After the job, the admin finds that 500 records were inserted instead of updated, even though the Lead_ID__c values matched existing records. What is the most likely cause?

   • AThe admin used the 'Insert' operation instead of 'Upsert'.
   • BThe external ID field was not marked as 'External ID' in Salesforce.
   • CThe leads were already in the recycle bin, so they were recreated.
   • DThe CSV file was too large and Data Loader truncated the external ID values.
   Reveal Solution Discussion Select an answer first