Examkin

Question

Difficulty: MediumData Import Wizard and Data Loader Utilities

A Salesforce administrator needs to update 3500035{}000 Account records with new custom category fields. The data operation requires matching existing records by Account Name and Site to prevent duplicate creation, while also suppressing active Workflow Rules from executing during the import. Which data utility should the administrator select to meet these requirements?

  1. Data Import Wizard, because it supports record matching by Account Name and Site, handles up to 5000050{}000 records, and provides an option to disable workflow rule execution.Answer
  2. B
    Data Loader, because workflow rule suppression during data operations is only available within the desktop application settings.
  3. C
    Data Import Wizard, because it automatically bypasses all system validation rules and workflow processes for updates under 100000100{}000 records.
  4. D
    Data Loader, because updating standard Account records exceeding 1000010{}000 rows requires Bulk API asynchronous processing.

Answer

Data Import Wizard, because it supports record matching by Account Name and Site, handles up to 5000050{}000 records, and provides an option to disable workflow rule execution.
The correct answer identifies that the Data Import Wizard is the appropriate tool for this scenario. The job volume of 3500035{}000 records is below the wizard's 5000050{}000 limit. Additionally, the Data Import Wizard supports Account matching by Name and Site to avoid duplicate record creation and includes an explicit configuration option to enable or disable workflow rules during the import process.

Step-by-Step Solution

1
Evaluate record volume requirement
The requirement is 3500035{}000 records, which is within the 5000050{}000 record capacity limit of the Data Import Wizard.
Data Import Wizard supports up to 5000050{}000 records per import job, whereas Data Loader is required for up to 50000005{}000{}000 records.
2
Evaluate object and matching requirements
Accounts are supported by the Data Import Wizard with built-in deduplication matching on Account Name and Site.
Data Import Wizard provides native duplicate matching options for standard objects like Accounts and Contacts based on Name, Site, or Email.
3
Evaluate workflow suppression capability
The Data Import Wizard features a checkbox to enable or disable triggering workflow rules and processes.
Unlike Data Loader, which executes active automation unless manually deactivated in Setup, the Data Import Wizard allows admins to uncheck workflow rule execution during the import process.

Key Concept

Data Import Wizard vs Data Loader capabilities for Account deduplication, volume limits, and workflow suppression
Estimated Time:1m 30s
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic