Courseiva

CCNA Data Management Questions

42 questions · Data Management · All types, answers revealed

Practice these questionsDomain overviewAll questions
1
MCQhard

A Consultant is loading Campaign Members into Salesforce. The CSV contains Contact IDs and Campaign IDs. Some rows fail with a 'Entity failed validation' error. What is the most likely cause?

A.Campaign records must be locked before adding members.
B.The Contact is already a member of the specified Campaign, violating uniqueness.
C.Campaign Status is a required field that was omitted from the mapping.
D.Campaign members cannot be loaded via Data Loader; they require Data Import Wizard.
AnswerB

A Contact or Lead can only exist once per Campaign, causing duplicate membership inserts to fail.

Why this answer

Campaign Members have unique constraints; attempting to insert a duplicate Contact/Lead into the same Campaign will trigger validation or database errors.

Practice this question →
2
MCQhard

Universal Containers wants to archive closed-won opportunities older than 5 years to maintain system performance. What is Salesforce's recommended approach for handling long-term data archiving?

A.Move records to a custom object named 'Archived Opportunity' using Data Loader, then delete the originals.
B.Change the record type of old opportunities to 'Archived' and apply a sharing rule to hide them.
C.Mark the opportunities as inactive using workflow field updates.
D.Contact Salesforce Support to delete the primary database indexes for those records.
AnswerA

Archiving to custom objects or external storage via Data Loader/API is a standard practice for maintaining lean primary tables.

Why this answer

Salesforce recommends exporting historical data using Data Loader or Data Export Service and storing it in an external system or utilizing certified AppExchange data archiving solutions.

Practice this question →
3
MCQmedium

A 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?

A.Insert
B.Update
C.Import
D.Upsert
AnswerD

Upsert performs either an insert or an update based on the presence of a matching record using an External ID.

Why this answer

The Upsert operation in Data Loader matches source records against existing Salesforce records using a designated External ID field, inserting new ones and updating existing ones in a single pass.

Practice this question →
4
Multi-Selecthard

A 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.

Select 3 answers
A.Reduce the Data Loader batch size.
B.Convert all master-detail relationships to lookups permanently.
C.Avoid updating parent records (such as Accounts) simultaneously from multiple child threads.
D.Increase batch size to the maximum of 10,000 to complete the job faster.
E.Execute the data load using serial mode rather than bulk API parallel mode if necessary.
AnswersA, C, E

Smaller batch sizes reduce the number of records locked in a single database transaction.

Why this answer

Record locking is often caused by parent roll-ups, sharing recalculations, or concurrent updates to parent records. Reducing batch size, serializing loads, and disabling unnecessary roll-ups helps.

Practice this question →
5
Multi-Selecthard

A Consultant is configuring Duplicate Management rules for Contacts. Which THREE actions can be configured when a duplicate is detected during manual creation or editing? Choose 3 options.

Select 3 answers
A.Automatically merge the duplicate with the master record in real time.
B.Report on duplicate creation by logging it in the duplicate record report.
C.Automatically delete the newly entered duplicate record.
D.Alert the user and allow them to save the record.
E.Block the user from saving the record.
AnswersB, D, E

Duplicate rules can log matches to report on attempted duplicate creation.

Why this answer

Duplicate rules can be configured to alert users (show alert), allow creation (report), or block creation entirely on create and/or edit operations.

Practice this question →
6
Multi-Selectmedium

Universal 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.

Select 2 answers
A.Opportunity Amount
B.Email (Exact or Fuzzy)
C.Product Family
D.Company Name (Exact or Fuzzy)
E.Case Description
AnswersB, D

Email is a standard field supported in lead matching rules.

Why this answer

Standard matching rules for leads support matching on fields like Name, Company, Email, Phone, and Lead Source using exact or fuzzy criteria.

Practice this question →
7
Multi-Selecthard

A 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.

Select 3 answers
A.Establish External ID fields on objects to facilitate upserts and relationship mapping.
B.Standardize picklist values and enable State and Country Picklists.
C.Identify and remove obsolete, redundant, or incomplete legacy records.
D.Disable all user profiles except the System Administrator.
E.Delete all standard object definitions to make room for custom objects.
AnswersA, B, C

External IDs are vital for mapping relationships during multi-object migrations.

Why this answer

Data hygiene prior to migration includes purging obsolete records, standardizing picklist values, and defining external IDs for relational mapping.

Practice this question →
8
MCQmedium

A Sales Cloud Consultant is asked to ensure that users cannot delete Opportunity records unless they possess a specific custom permission set. Which tool is appropriate?

A.Duplicate Rule set to block on delete
B.Validation Rule utilizing the $Permission global variable
C.Sharing Rule with Read-Only access
D.Escalation Rule
AnswerB

Validation rules can check ISNEW() or ISCHANGED() or be used with custom permissions, though deletion validation requires specific syntax or trigger/permission configuration. Wait, validation rules do not fire on delete; a Trigger or Permission Set object permission is required for delete restrictions. Let's look at the options.

Why this answer

Custom permissions referenced in Validation Rules or Apex triggers can restrict deletion, or profile-based 'Delete' object permissions can be adjusted.

Practice this question →
9
MCQeasy

A 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?

A.Data Import Wizard
B.Mass Transfer Tool
C.Data Loader CLI
D.Data Export Service
AnswerD

Data Export Service is the native scheduled export tool found in Setup.

Why this answer

Data Export Service (Weekly Export) allows administrators to schedule automated weekly or monthly exports of all organization data into CSV files.

Practice this question →
10
Multi-Selectmedium

Universal 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.

Select 2 answers
A.Mass Transfer tool
B.Validation Rules using REGEX functions
C.AppExchange Address Verification Solutions
D.Assignment Rules
E.Data Export Service
AnswersB, C

REGEX formulas within Validation Rules can enforce strict pattern matching for phone numbers and postal codes.

Why this answer

Validation rules and regular expressions (REGEX) or AppExchange address verification tools ensure phone numbers and postal codes follow strict formats.

Practice this question →
11
MCQeasy

Universal Containers wants to ensure that all newly created Accounts have an industry classification populated before saving. Which declarative tool should the Consultant recommend?

A.Duplicate Rule
B.Workflow Rule
C.Data Import Wizard
D.Validation Rule
AnswerD

A Validation Rule evaluates conditions when a record is saved and prevents saving if the condition is met (e.g., Industry is blank).

Why this answer

Validation Rules are the ideal declarative tool to enforce data quality and ensure required fields are populated based on specific conditions before a record is saved.

Practice this question →
12
MCQeasy

An 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?

A.VLOOKUP()
B.ISBLANK()
C.TRIM()
D.CONTAINS()
AnswerC

TRIM removes spaces, allowing validation rules to check if original text differs from trimmed text.

Why this answer

The TRIM() function removes leading and trailing spaces from a text string, helping validate cleanliness.

Practice this question →
13
MCQeasy

An administrator needs to update the phone numbers for 500 Contact records quickly using a CSV file. Which tool is best suited for this task?

A.Workbench REST API explorer
B.Salesforce CLI
C.Data Import Wizard
D.Developer Console
AnswerC

Data Import Wizard easily handles up to 50,000 records for quick browser-based updates.

Why this answer

Data Import Wizard is fast, web-based, and easily handles up to 50,000 records, making it ideal for updating 500 contacts without installing software.

Practice this question →
14
MCQmedium

A 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?

A.Data Integration Rule
B.Duplicate Rule and Matching Rule
C.Mass Delete Wizard
D.Data Loader with matching criteria
AnswerB

Duplicate Rules use Matching Rules to identify duplicates in real time and can be configured to block saving or alert the user.

Why this answer

Standard Duplicate Management allows administrators to define matching rules and duplicate rules that alert users or block creation when a potential duplicate is detected.

Practice this question →
15
MCQeasy

An 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?

A.Master-Detail Relationship
B.Lookup Relationship
C.External Relationship
D.Hierarchical Relationship
AnswerA

Master-Detail relationships cause child records to be deleted when the parent record is deleted.

Why this answer

A Master-Detail relationship cascades deletion from parent to child and enforces sharing and security inheritance.

Practice this question →
16
MCQhard

Universal Containers uses Person Accounts. During data migration, the Consultant encounters errors when attempting to insert records with matching email addresses. What is the cause of this behavior?

A.Active duplicate rules are blocking record insertion based on matching contact data.
B.Data Loader cannot process Person Accounts without a parent Business Account.
C.Person accounts require a separate insert for the Contact object first.
D.Person accounts do not support custom fields in Data Loader.
AnswerA

Person accounts act as Contacts; active duplicate rules evaluating email or name will flag and potentially block inserts.

Why this answer

Person accounts combine Account and Contact fields. Duplicate rules or unique field constraints on standard fields (like email if configured as unique) apply to person accounts.

Practice this question →
17
Multi-Selectmedium

Universal Containers needs to migrate attachments and notes associated with legacy accounts into Salesforce. Which TWO considerations should the Consultant keep in mind? Choose 2 options.

Select 2 answers
A.Attachments cannot exceed 5 MB when loaded via Data Loader.
B.Attachments must be converted into Campaign records first.
C.Salesforce Files (ContentVersion and ContentDocumentLink) is the modern recommended storage model for file migrations.
D.Notes and attachments must be loaded into the User object.
E.Attachments can be loaded using the Attachment object with the ParentId mapped to the Account ID.
AnswersC, E

ContentVersion and ContentDocumentLink represent the modern Salesforce Files architecture.

Why this answer

Notes and Attachments can be migrated via Data Loader using the ContentDocumentLink or Attachment objects, keeping parent record links in mind.

Practice this question →
18
Multi-Selecthard

A Consultant is preparing a data migration plan and needs to determine which standard objects support custom External IDs for upsert operations. Which THREE standard Sales Cloud objects support External IDs? Choose 3 options.

Select 3 answers
A.OpportunityLineItem
B.Lead
C.Task
D.Account
E.Contact
AnswersB, D, E

Lead supports custom fields configured as External IDs.

Why this answer

Accounts, Contacts, Leads, and Campaigns support custom fields designated as External IDs, enabling upsert operations.

Practice this question →
19
Multi-Selecthard

A 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.

Select 3 answers
A.Provides a browser-based wizard interface directly inside Setup.
B.Supports custom objects as well as most standard objects.
C.Supports hard deletion of records.
D.Has a strict limit of 50,000 records per import transaction.
E.Can be executed from the command line for automated scripts.
AnswersB, C, E

Data Loader supports virtually all standard and custom objects in Salesforce.

Why this answer

Data Loader supports all objects, supports hard delete, and can be run from the command line, whereas Data Import Wizard has object restrictions and a 50k limit.

Practice this question →
20
MCQmedium

A 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?

A.A single lookup field on the Account object pointing to Product.
B.A multi-select picklist containing product IDs on the Account object.
C.A junction object with two master-detail relationships.
D.A hierarchical relationship field on the Product object.
AnswerC

A junction object bridges two objects in a many-to-many relationship using master-detail relationships.

Why this answer

To achieve a many-to-many relationship in Salesforce, a junction object must be created with two master-detail relationships pointing to the two parent objects.

Practice this question →
21
MCQmedium

A Sales Cloud Consultant is migrating opportunities and needs to ensure that closed-won opportunities retain their historical closed dates without being overwritten by automation. What must the Consultant ensure during data loading?

A.Enable 'Set Audit Fields upon Record Creation' and map the historical CloseDate.
B.Rely on workflow rules to backdate the opportunity automatically.
C.Map CloseDate to the SystemModstamp field.
D.Convert opportunities as closed-lost first, then reopen them.
AnswerA

Enabling audit fields allows administrators to load historical CloseDate and CreatedDate values accurately.

Why this answer

System fields like Closedate and CreatedDate can be populated with historical values if 'Create Audit Fields' is enabled and mapped correctly in Data Loader.

Practice this question →
22
MCQeasy

An administrator needs to remove all sample data from a newly provisioned Developer Edition sandbox. Which feature allows clearing specific standard object records quickly?

A.Data Integration Rule
B.Mass Delete Records tool
C.Data Export Service
D.Sandbox Refresh
AnswerB

Mass Delete Records in Setup allows filtering and deleting standard object records in bulk.

Why this answer

Mass Delete records functionality allows administrators to select standard objects (like accounts, leads, contacts) and delete records matching specified criteria.

Practice this question →
23
Multi-Selectmedium

Universal Containers wants to ensure that specific fields (e.g., Tax ID) are masked or restricted so that only finance managers can view them, while sales reps cannot. Which TWO features should the Consultant implement? Choose 2 options.

Select 2 answers
A.Web-to-Lead settings
B.Assignment Rules
C.Sharing Rules
D.Salesforce Shield Platform Encryption
E.Field-Level Security (FLS)
AnswersD, E

Shield Encryption masks or restricts sensitive field data for users without specific permissions.

Why this answer

Field-Level Security (FLS) and encrypted fields (using Shield Platform Encryption) secure sensitive data from unauthorized profiles/users.

Practice this question →
24
MCQhard

Universal 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?

A.Disable multi-currency during the migration process.
B.Map the currency ISO codes to the standard CurrencyIsoCode field and Salesforce will reactivate them automatically.
C.Convert all historical currency amounts into the corporate currency in the CSV file.
D.Temporarily reactivate the historical currencies in Company Information before data loading.
AnswerD

Salesforce requires currencies to be active to accept them during record creation or migration.

Why this answer

Inactive currencies cannot be assigned to new or migrated records until they are temporarily reactivated in Company Information.

Practice this question →
25
MCQmedium

A Consultant is importing Leads and needs to ensure that lead owners are assigned based on existing Assignment Rules rather than defaulting to the user performing the import. How should this be configured in Data Loader?

A.Map the Owner ID column to a blank value in the CSV file.
B.Check the 'Use Assignment Rules' box in Data Loader settings.
C.Write a Process Builder to change the owner after insert.
D.Use Data Import Wizard, which ignores assignment rules by default.
AnswerB

Data Loader advanced settings include an option to trigger active assignment rules during insert/update.

Why this answer

When using Data Loader, administrators can check the 'Insert Null Values' or configure the batch settings, but assignment rules are respected by checking the 'Assignment Rules' checkbox in Advanced Settings.

Practice this question →
26
MCQhard

Universal 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?

A.The External ID field on the parent object is missing.
B.The child record is owned by a queue instead of a user.
C.The 'Allow reparenting' option was not checked on the master-detail relationship field.
D.Data Loader is attempting to insert child records before parent records.
AnswerC

If 'Allow reparenting' is unchecked, child records cannot be moved to a different parent record after creation.

Why this answer

By default, master-detail relationships do not allow reparenting once a child record is created unless the 'Allow reparenting' setting is enabled on the field definition.

Practice this question →
27
MCQmedium

During 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?

A.Currency amounts must include the currency symbol ($, €).
B.Multi-currency must be temporarily disabled in Company Information during data loads.
C.The CurrencyIsoCode column must contain active 3-letter ISO currency codes.
D.Currency values must be converted to corporate currency manually before loading.
AnswerC

Salesforce requires active 3-letter ISO codes (like USD, GBP) in the CurrencyIsoCode field during data loads.

Why this answer

When multi-currency is enabled, records must include the ISO code (e.g., USD, EUR) in the CurrencyIsoCode field to correctly associate monetary amounts.

Practice this question →
28
Multi-Selecthard

A 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.

Select 3 answers
A.Custom Apex Triggers.
B.Record-Triggered Flows to calculate and write aggregate values to parent fields.
C.Standard Global Search summary settings.
D.Declarative Lookup Rollup Summaries (DLRS) or similar AppExchange packages.
E.Standard Roll-Up Summary field type.
AnswersA, B, D

Apex triggers can aggregate child data and update parent records upon insert, update, or delete.

Why this answer

Since standard roll-up summaries require master-detail relationships, lookups require alternative solutions like Record-Triggered Flows, custom Apex, or AppExchange declarative roll-up packages.

Practice this question →
29
MCQhard

An 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?

A.Increase the Salesforce API timeout limit in Company Information.
B.Reduce the batch size in Data Loader and temporarily disable unnecessary triggers.
C.Convert the Leads to Contacts instead of deleting them.
D.Switch from Data Loader to Data Import Wizard for deletions.
AnswerB

Lowering batch size reduces the processing load per transaction, and disabling triggers prevents CPU limit exceptions.

Why this answer

When bulk deleting records that invoke complex Apex triggers, the operation should be processed in smaller batches or triggers should be selectively disabled.

Practice this question →
30
Multi-Selectmedium

Universal Containers wants to ensure that all Accounts have a valid website URL format entered. Which TWO functions can be used in a Validation Rule formula to help validate this requirement? Choose 2 options.

Select 2 answers
A.ISCHANGED()
B.CONTAINS()
C.NOT()
D.VLOOKUP()
E.PRIORVALUE()
AnswersB, C

CONTAINS checks if a URL string includes necessary characters or domains.

Why this answer

Validation rules can use functions like CONTAINS, NOT, and REGEX to check if web addresses contain expected strings like 'http' or '.'.

Practice this question →
31
MCQeasy

Universal Containers wants to ensure that when a Lead is converted, the Account record created is automatically assigned a specific Record Type based on the lead source. Where is this configured in Setup?

A.Lead Settings / Lead Processes and Conversion Mapping
B.Duplicate Rule configuration
C.Data Import Wizard
D.Territory Management rules
AnswerA

Lead processes and field mapping in Setup govern how data maps and which record types are assigned upon conversion.

Why this answer

Lead Conversion settings in Setup allow administrators to map lead fields to Account, Contact, and Opportunity fields and set default record types.

Practice this question →
32
MCQmedium

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?

A.Fuzzy Match
B.Blank Value Match
C.Exact Match
D.Numeric Range Match
AnswerA

Fuzzy match identifies similar strings accounting for typos, transpositions, and phonetic spellings.

Why this answer

Fuzzy matching algorithms in standard duplicate management can detect typos, phonetic spelling, and abbreviations when comparing names.

Practice this question →
33
Multi-Selectmedium

Universal 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.

Select 2 answers
A.Campaign Hierarchy
B.Account Teams and Opportunity Teams
C.Enterprise Territory Management
D.Product Schedule settings
E.Data Import Wizard mapping files
AnswersB, C

Teams allow collaborative selling and access management alongside territory structures.

Why this answer

Territory Management (Enterprise Territory Management) and sharing settings structure territory-based access and account assignments.

Practice this question →
34
MCQhard

Universal 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?

A.Use workflow field updates to overwrite text entries.
B.Enable State and Country Picklists and use Data Loader to map standard values.
C.Write a trigger to format text fields upon insert.
D.Rely on users to manually select the correct picklist value post-migration.
AnswerB

State and Country Picklists provide native standardization, and Data Loader maps standard values or ISO codes directly.

Why this answer

Enabling State and Country Picklists and mapping the legacy values to the integration values via the user interface or Data Loader ensures data integrity and adherence to standard formats.

Practice this question →
35
Multi-Selecthard

A 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.

Select 3 answers
A.Load parent records (Accounts) before child records (Contacts and Opportunities).
B.Use External IDs to map relationships between related objects during upsert operations.
C.Perform a test migration in a full or partial sandbox environment first.
D.Import all objects in a single flat CSV file simultaneously.
E.Leave all triggers, validation rules, and workflows enabled during the entire migration.
AnswersA, B, C

Child records require parent IDs, so parents must be loaded first.

Why this answer

Best practices include disabling automation during loads, loading data in the correct relational order (Accounts -> Contacts -> Opportunities), and testing in a full sandbox first.

Practice this question →
36
MCQmedium

Universal 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?

A.Standard Account-Contact Address Inheritance setting
B.Duplicate Rule
C.Record-Triggered Flow
D.Roll-Up Summary Field
AnswerC

A Record-Triggered Flow on the Account object can evaluate address changes and update related child Contacts.

Why this answer

Record-Triggered Flows can evaluate changes on parent records and update related child records when specific criteria (like a checkbox) are met.

Practice this question →
37
MCQeasy

Universal Containers wants to ensure that a custom field 'Discount Percentage' cannot exceed 20% for standard sales reps. Which declarative feature should be used?

A.Validation Rule
B.Escalation Rule
C.Sharing Rule
D.Assignment Rule
AnswerA

A Validation Rule evaluates a condition and displays an error message if the rule evaluates to true.

Why this answer

Validation Rules allow writing conditional formulas (e.g., Discount_Percentage__c > 0.20) to prevent users from saving records with invalid data.

Practice this question →
38
MCQmedium

A Sales Cloud Consultant is configuring data cleansing rules. They want to ensure that all user-entered phone numbers are stripped of formatting symbols (like dashes and parentheses) and saved in standard E.164 format. Which tool is best suited for real-time formatting?

A.Data Import Wizard
B.Assignment Rule
C.Before-save Record-Triggered Flow
D.Web-to-Lead auto-response rule
AnswerC

Before-save flows execute rapidly and can modify field values on the record prior to committing to the database.

Why this answer

Before-save Record-Triggered Flows can evaluate text fields and apply formulas or formatting functions to standardize phone numbers automatically upon entry.

Practice this question →
39
MCQhard

Universal Containers is migrating 2 million historical activities (Tasks and Events) linked to Accounts and Opportunities. To ensure high performance and avoid database locking errors, what should the Consultant do?

A.Load Tasks and Events using the parent Account ID directly in the WhoId field.
B.Perform a single bulk insert of 2 million records with a batch size of 2,000.
C.Use Data Loader with smaller batch sizes and map WhatId for Accounts/Opportunities and WhoId for Contacts/Leads.
D.Convert all historical activities into custom object records to bypass standard activity limits.
AnswerC

Activities use WhoId for people and WhatId for objects, and smaller batches prevent locking errors during high-volume loads.

Why this answer

When loading activities, breaking batches down, disabling parent-account automatic roll-ups where possible, and loading during maintenance windows ensures high throughput.

Practice this question →
40
MCQhard

Universal 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?

A.Use the Data Import Wizard with the 'Parent Account Name' match key to establish relationships in a single pass.
B.Perform a bulk insert on a self-referential CSV file where parent and child rows are interleaved.
C.Load child accounts first using the legacy parent identifier, and Salesforce will automatically resolve the hierarchy.
D.Load parent accounts, export the resulting Salesforce IDs, map them to child records using an External ID, and then load child accounts.
AnswerD

This is the standard two-pass migration pattern required to properly establish parent-child lookups.

Why this answer

When loading accounts with parent-child relationships, you must load parent accounts first, export their generated Salesforce IDs, map those IDs to the child records' Parent Account field using an External ID or Salesforce ID, and then load the child records.

Practice this question →
41
Multi-Selectmedium

Universal Containers wants to clean up duplicate Account records currently residing in Sales Cloud. Which TWO native Salesforce features can help identify and merge these duplicates? Choose 2 options.

Select 2 answers
A.Lightning Account Merge tool
B.Mass Delete Wizard
C.Data Import Wizard deduplication wizard
D.Standard Duplicate Management (Matching and Duplicate Rules)
E.Data Loader upsert operation
AnswersA, D

The standard Merge tool in Lightning allows merging up to 3 duplicate account records into a master record.

Why this answer

Native duplicate management includes Duplicate Rules (with matching rules) and the standard Merge Accounts tool available in Lightning Experience.

Practice this question →
42
MCQmedium

A 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?

A.Convert all custom fields to text fields to avoid data type mismatch.
B.Increase the batch size in Data Loader to the maximum limit of 10,000.
C.Enable all validation rules and triggers to catch bad data early.
D.Temporarily disable unnecessary validation rules, triggers, and workflows.
AnswerD

Disabling automation minimizes CPU processing time per record during bulk migration.

Why this answer

Disabling triggers, validation rules, workflow rules, and assignment rules reduces database overhead and speeds up bulk data loads significantly.

Practice this question →

Ready to test yourself?

Try a timed practice session using only Data Management questions.

Start 20-question session