Sales-Con-201 Data Management — Timed 10 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