Sales-Con-201 Data Management — 15 Questions

Question 1

An administrator needs to load 60,000 Lead records into Sales Cloud and wants a simple, web-based tool with a step-by-step interface. Which tool should be used?

Accepted Answer

Data Loader. The Data Import Wizard is a web-based tool built into Salesforce that handles up to 50,000 records. Wait, 60,000 records exceeds the 50,000 limit of the Data Import Wizard; therefore, Data Loader must be used.

Answer

Global Search

Answer

Mass Delete tool

Answer

Data Import Wizard

Question 2

A Sales Cloud Consultant is configuring a custom object to track competitor analysis. Sales reps should be able to view competitor records, but ownership should always remain with the Sales Operations team. Which field type ensures the record owner cannot be changed by sales reps?

Accepted Answer

Master-Detail relationship to Account. Record ownership is determined by the Owner ID field. While standard ownership can be transferred, sharing rules or restricting edit permissions govern access, but the owner field itself is standard. Wait, standard records are owned by users/queues. To restrict who can change ownership, Transfer permissions on profiles/permission sets control this, but the question asks about field type. Actually, ownership cannot be restricted by field type; however, standard object ownership behavior applies.

Answer

Lookup relationship to User

Answer

Auto-Number field

Answer

Checkbox field named 'Locked'

Question 3

Universal Containers has complex business logic where Opportunity creation requires validating custom data against an external ERP system in real time. If the ERP validation fails, the Opportunity must not be created in Salesforce. Which architectural approach should the Consultant recommend?

Accepted Answer

Synchronous Apex Trigger with callout exception handling to roll back the transaction if ERP validation fails.. An after-trigger or synchronous outbound callout (via Apex or external services) combined with custom exception handling can validate and block record saves if external checks fail. Wait, synchronous callouts cannot be made from triggers directly without queueable/future unless using External Services / Apex REST, but a synchronous trigger block can use custom validation or Apex.

Answer

Data Loader export-import loop.

Answer

Standard Validation Rule referencing external ERP database tables via formula.

Answer

Scheduled Flow running nightly to check ERP status and delete invalid opportunities.

Question 4

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?

Accepted Answer

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

Answer

Blank Value Match

Answer

Exact Match

Answer

Numeric Range Match

Question 5

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?

Accepted Answer

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

Answer

Convert all custom fields to text fields to avoid data type mismatch.

Answer

Increase the batch size in Data Loader to the maximum limit of 10,000.

Answer

Enable all validation rules and triggers to catch bad data early.

Question 6

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?

Accepted Answer

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

Answer

Insert

Answer

Update

Answer

Import

Question 7

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?

Accepted Answer

Enable State and Country Picklists and use Data Loader to map standard values.. 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.

Answer

Use workflow field updates to overwrite text entries.

Answer

Write a trigger to format text fields upon insert.

Answer

Rely on users to manually select the correct picklist value post-migration.

Question 8

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?

Accepted Answer

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

Answer

Data Integration Rule

Answer

Mass Delete Wizard

Answer

Data Loader with matching criteria

Question 9

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?

Accepted Answer

Load parent accounts, export the resulting Salesforce IDs, map them to child records using an External ID, and then load child accounts.. 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.

Answer

Use the Data Import Wizard with the 'Parent Account Name' match key to establish relationships in a single pass.

Answer

Perform a bulk insert on a self-referential CSV file where parent and child rows are interleaved.

Answer

Load child accounts first using the legacy parent identifier, and Salesforce will automatically resolve the hierarchy.

Question 10

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

Accepted Answer

Validation Rule. 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.

Answer

Duplicate Rule

Answer

Workflow Rule

Answer

Data Import Wizard

Question 11

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?

Accepted Answer

Reduce the batch size in Data Loader and temporarily disable unnecessary triggers.. When bulk deleting records that invoke complex Apex triggers, the operation should be processed in smaller batches or triggers should be selectively disabled.

Answer

Increase the Salesforce API timeout limit in Company Information.

Answer

Convert the Leads to Contacts instead of deleting them.

Answer

Switch from Data Loader to Data Import Wizard for deletions.

Question 12

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?

Accepted Answer

The 'Allow reparenting' option was not checked on the master-detail relationship field.. 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.

Answer

The External ID field on the parent object is missing.

Answer

The child record is owned by a queue instead of a user.

Answer

Data Loader is attempting to insert child records before parent records.

Question 13

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?

Accepted Answer

Check the 'Use Assignment Rules' box in Data Loader settings.. 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.

Answer

Map the Owner ID column to a blank value in the CSV file.

Answer

Write a Process Builder to change the owner after insert.

Answer

Use Data Import Wizard, which ignores assignment rules by default.

Question 14

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?

Accepted Answer

A junction object with two master-detail relationships.. 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.

Answer

A single lookup field on the Account object pointing to Product.

Answer

A multi-select picklist containing product IDs on the Account object.

Answer

A hierarchical relationship field on the Product object.

Question 15

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?

Accepted Answer

Data Import Wizard. 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.

Answer

Workbench REST API explorer

Answer

Salesforce CLI

Answer

Developer Console