Be able to select the correct load tool, sequence parent-then-child loads, and use External IDs with upsert to link records. The most important thing is planning load order and deduplication before touching production data.
Start practicing
Data Management — choose a session length
Free · No account required
Domain overview
This domain covers moving, cleaning, and relating Salesforce records at scale: Data Loader, Data Import Wizard, the Bulk and REST/SOAP APIs, duplicate management, and external IDs. Questions present migration or sync scenarios and ask you to choose the right tool, load order, and field-mapping approach while avoiding governor limits and timeouts.
Exam objectives
Choosing Data Loader, Data Import Wizard, or Bulk API 2.0 based on volume and object support
Using External IDs and upsert to relate records and prevent duplicates during migration
Loading parent accounts before children to preserve hierarchical relationships
Applying duplicate rules, matching rules, and address standardization before or during load
Loading child records before parents, which breaks lookups and forces rework of the entire migration
Assuming Data Import Wizard handles millions of records when it is meant for smaller, simpler imports
Ignoring duplicate rules and matching rules, so messy legacy data creates duplicate Accounts and Contacts
Click any question to see the full explanation and answer options, or start a focused practice session above.
Universal Containers tracks customer accounts globally. Sales reps frequently create duplicate accounts by entering minor spelling variations in company names. Which matching rule component should be configured to catch phonetic variations or typos?
2A Sales Cloud Consultant is preparing to migrate millions of records. To optimize performance and prevent API timeout errors, what should the Consultant do before initiating the data load?
3A Sales Cloud Consultant is migrating legacy accounts into Salesforce using Data Loader. The legacy system uses a custom External ID field. Which operation should be used to update existing records and insert new ones simultaneously?
4Universal Containers has thousands of legacy Account records containing messy address data. They want to standardize state and country values to ISO codes automatically during migration. What is the best approach?
5A sales manager is concerned about duplicate Contact records being created manually by sales reps. Which tool should the Consultant configure to alert users and prevent duplicate creation in real time?
6Universal Containers needs to map complex hierarchies during data migration. They have parent and child accounts across multiple legacy systems. What is the recommended best practice for loading hierarchical account data?
7Universal Containers wants to ensure that all newly created Accounts have an industry classification populated before saving. Which declarative tool should the Consultant recommend?
8An administrator is deleting a large volume of obsolete Lead records using Data Loader. Some deletions fail due to 'Apex CPU time limit exceeded' errors caused by cascading triggers. How should this be resolved?
9Universal Containers has a master-detail relationship between custom objects Project__c (Parent) and Milestone__c (Child). During migration, a Consultant encounters an error stating that reparenting is not allowed. What does this error signify?
10A Sales Cloud Consultant is designing a data model where Accounts have a many-to-many relationship with Products (e.g., tracking which products a customer currently uses). Which structure should be used?
11An administrator needs to update the phone numbers for 500 Contact records quickly using a CSV file. Which tool is best suited for this task?
12A Sales Cloud Consultant needs to back up Account and Opportunity data weekly in CSV format. Which tool provides a scheduled, automated export capability directly from the Salesforce setup menu?
13An administrator needs to remove all sample data from a newly provisioned Developer Edition sandbox. Which feature allows clearing specific standard object records quickly?
14During a data migration using Data Loader, a Consultant notices that CurrencyIsoCode values are failing for multi-currency enabled organizations. What must the Consultant verify in the CSV file?
15An administrator wants to prevent users from accidentally entering leading or trailing whitespace in email address fields. Which formula function should be used in a Validation Rule?
16Universal Containers requires that whenever an Account's billing address is updated, all related child Contacts must have their mailing addresses updated automatically if a checkbox 'Sync Address' is checked. Which declarative feature should be used?
17A Consultant is planning a data migration for custom objects in Sales Cloud and needs to choose between Data Loader and Data Import Wizard. Which THREE characteristics are true for Data Loader compared to Data Import Wizard? Choose 3 options.
18A Sales Cloud Consultant is preparing a data migration strategy for Accounts, Contacts, and Opportunities. Which THREE best practices should be followed to ensure data integrity? Choose 3 options.
19Universal Containers wants to ensure data quality by validating phone numbers and postal codes during user entry. Which TWO tools or features should the Consultant implement? Choose 2 options.
20Universal Containers has duplicate Leads in their Sales Cloud instance. Which TWO criteria can be used when configuring standard Matching Rules for Leads? Choose 2 options.
21A Consultant is troubleshooting a failed Data Loader insert operation where multiple records failed due to system lock errors. Which THREE strategies can mitigate record locking in Sales Cloud? Choose 3 options.
22Universal Containers needs to structure their Sales Cloud data model to reflect territory-based sales management. Which TWO features should the Consultant consider when designing the data model? Choose 2 options.
23A Sales Cloud Consultant is reviewing a client's data model to prepare for a large data migration. Which THREE data hygiene and structuring tasks should be performed beforehand? Choose 3 options.
24A Sales Cloud Consultant is designing custom roll-up summaries across objects that do not have a master-detail relationship (e.g., looking up custom data from a sibling object or via a lookup relationship). Which THREE alternative solutions can achieve roll-up summary functionality? Choose 3 options.
25Universal Containers utilizes multi-currency and wants to migrate historical opportunities with various currencies. Some currencies are no longer active in Salesforce. What action must the Consultant take?
26An administrator needs to create a custom relationship between custom object 'Shipment__c' and the standard 'Account' object, where deleting the Account should also delete the related Shipment records. Which relationship type should be chosen?
27A consultant is preparing to migrate 1 million account records and their related contacts into Sales Cloud. The organization has a complex data model with many required fields and validation rules. Which TWO steps should the consultant take to ensure a successful migration? (Choose two.)
Be able to select the correct load tool, sequence parent-then-child loads, and use External IDs with upsert to link records. The most important thing is planning load order and deduplication before touching production data.
The Courseiva Sales-Con-201 question bank contains 27 questions in the Data Management domain. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Data Management domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included