Sales-Con-201 Data Management Practice Test 3 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

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 2

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.. A many-to-many relationship in Salesforce requires a junction object with two master-detail relationships, one to each parent object (Account and Product). This creates two master-detail fields on the junction object, enabling each Account to relate to many Products and vice versa. The junction object inherits sharing and ownership from both parents, and supports roll-up summary fields to each parent.

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 3

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. The Data Import Wizard is purpose-built for business users to import and update up to 50,000 records using a guided UI, supports Contact updates via CSV, and automatically handles field mapping and duplicate checking. For 500 Contact phone number updates, it is the fastest, lowest-friction tool with no setup required.

Answer

Workbench REST API explorer

Answer

Salesforce CLI

Answer

Developer Console

Question 4

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?

Accepted Answer

Data Export Service. The Data Export Service in Salesforce Setup provides a scheduled, automated export of data in CSV format. It allows administrators to schedule weekly or monthly exports of all data or specific objects, and the files are available for download. This is the only tool directly accessible from the Setup menu that offers scheduled automated exports.

Answer

Data Import Wizard

Answer

Mass Transfer Tool

Answer

Data Loader CLI

Question 5

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

Accepted Answer

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

Answer

Data Integration Rule

Answer

Data Export Service

Answer

Sandbox Refresh

Question 6

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?

Accepted Answer

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

Answer

Currency amounts must include the currency symbol ($, €).

Answer

Multi-currency must be temporarily disabled in Company Information during data loads.

Answer

Currency values must be converted to corporate currency manually before loading.

Question 7

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?

Accepted Answer

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

Answer

VLOOKUP()

Answer

ISBLANK()

Answer

CONTAINS()

Question 8

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?

Accepted Answer

Record-Triggered Flow. A Record-Triggered Flow on the Account object can be configured to run after save, evaluate the 'Sync Address' checkbox, and use a Get Records element to retrieve related Contacts and an Update Records element to write the billing address values into each Contact's mailing address fields. This is the only declarative option that supports conditional, cross-object updates triggered by a field change on the parent record.

Answer

Standard Account-Contact Address Inheritance setting

Answer

Duplicate Rule

Answer

Roll-Up Summary Field

Question 9

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.

Accepted Answer

Supports custom objects as well as most standard objects.. Option B is correct because Data Loader supports custom objects as well as most standard objects, which is essential for the consultant's custom object migration scenario. Option C is correct because Data Loader supports hard deletion of records (via the Delete operation, which performs a hard delete), whereas Data Import Wizard only offers soft delete through the Recycle Bin. Option E is correct because Data Loader can be executed from the command line (using the process.bat/process.sh scripts or CLI) to enable automated, scheduled, or scripted data loads. Option A is incorrect because the browser-based wizard interface inside Setup describes Data Import Wizard, not Data Loader, which is a client application. Option D is incorrect because Data Loader does not have a strict 50,000-record limit per transaction; that limit applies to Data Import Wizard, while Data Loader can process up to 5 million records (or more with bulk API and proper configuration).

Answer

Provides a browser-based wizard interface directly inside Setup.

Answer

Has a strict limit of 50,000 records per import transaction.

Question 10

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.

Accepted Answer

Load parent records (Accounts) before child records (Contacts and Opportunities).. Option A is correct because Salesforce relationships are hierarchical: Accounts are the parent of Contacts and Opportunities, so parent records must exist and have their IDs available before child records can reference them via lookup or master-detail fields. Option B is correct because External IDs enable upsert operations and relationship mapping without needing to know the 15/18-character Salesforce record IDs, allowing child records to reference parents by a unique business key. Option C is correct because performing a test migration in a full or partial sandbox validates field mappings, data quality, and load order, and surfaces errors before touching production data. Option D is not correct because loading all objects in a single flat CSV ignores object relationships and field-level differences, making it impossible to resolve parent-child lookups correctly. Option E is not correct because leaving all triggers, validation rules, and workflows enabled during migration can cause failures, unintended automation side effects, and record updates; these should typically be selectively disabled or controlled during the load.

Answer

Import all objects in a single flat CSV file simultaneously.

Answer

Leave all triggers, validation rules, and workflows enabled during the entire migration.

Question 11

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.

Accepted Answer

Validation Rules using REGEX functions. Option B (Validation Rules using REGEX functions) is correct because Salesforce validation rules can enforce format-level data quality at the point of user entry, and REGEX() lets you match phone numbers and postal codes against a defined pattern (e.g., REGEX(Phone, "^[0-9]{10}$") or a postal-code pattern) so invalid values are blocked before the record is saved. Option C (AppExchange Address Verification Solutions) is correct because third-party AppExchange packages provide real address/postal-code verification and standardization against authoritative postal databases, which goes beyond simple format checking and validates that the postal code actually exists and matches the address. Option A (Mass Transfer tool) is incorrect because it only transfers ownership of multiple records between users and does not validate phone numbers or postal codes. Option D (Assignment Rules) is incorrect because it routes leads or cases to users/queues based on criteria and does not perform data-quality validation. Option E (Data Export Service) is incorrect because it is a backup/export mechanism for extracting data, not an entry-time validation feature.

Answer

Mass Transfer tool

Answer

Assignment Rules

Answer

Data Export Service

Question 12

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.

Accepted Answer

Email (Exact or Fuzzy). Email is a standard, matchable field on the Lead object, and standard Matching Rules allow the match method to be set to Exact or Fuzzy for text fields like Email. Option D (Company Name, Exact or Fuzzy) is also correct because Company is a standard Lead field, and standard Matching Rules support Exact or Fuzzy matching on it to detect duplicate companies. Options A (Opportunity Amount), C (Product Family), and E (Case Description) are incorrect because these fields belong to other objects (Opportunity, Product, and Case respectively) and are not available as Lead fields when configuring standard Matching Rules for Leads.

Answer

Opportunity Amount

Answer

Product Family

Answer

Case Description

Question 13

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.

Accepted Answer

Reduce the Data Loader batch size.. Option A is correct because reducing the Data Loader batch size lowers the number of records processed per transaction, which shortens the duration each transaction holds locks on parent records and reduces the chance of lock contention and UNABLE_TO_LOCK_ROW errors. Option C is correct because record locking typically occurs when multiple threads or processes try to update the same parent record (for example, an Account) at the same time through its child records, so serializing or avoiding concurrent parent updates prevents lock conflicts. Option E is correct because the Bulk API in parallel mode processes batches concurrently across multiple threads, increasing the likelihood of locking conflicts, whereas serial mode processes batches one at a time and avoids simultaneous lock contention. Option B is not appropriate because permanently converting master-detail relationships to lookups changes the data model and sharing/roll-up behavior and is not a valid locking mitigation strategy. Option D is incorrect because increasing the batch size to 10,000 makes each transaction larger and longer-running, which worsens rather than mitigates record locking.

Answer

Convert all master-detail relationships to lookups permanently.

Answer

Increase batch size to the maximum of 10,000 to complete the job faster.

Question 14

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.

Accepted Answer

Account Teams and Opportunity Teams. Option C, Enterprise Territory Management, is correct because it is the Salesforce feature purpose-built for modeling territory-based sales management, allowing accounts to be assigned to territories based on rules and enabling territory-aligned forecasting, reporting, and sharing. Option B, Account Teams and Opportunity Teams, is correct because these features let sellers collaborate on accounts and opportunities across territory boundaries, supporting the shared ownership and split-credit scenarios typical of territory-based selling. Option A, Campaign Hierarchy, is incorrect because it structures marketing campaigns and their parent-child relationships, not sales territories. Option D, Product Schedule settings, is incorrect because it governs revenue and quantity scheduling for products on opportunities, which is unrelated to territory structure. Option E, Data Import Wizard mapping files, is incorrect because it is merely a data-loading utility for mapping source fields to Salesforce fields, not a data-model feature for territory management.

Answer

Campaign Hierarchy

Answer

Product Schedule settings

Answer

Data Import Wizard mapping files

Question 15

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.

Accepted Answer

Establish External ID fields on objects to facilitate upserts and relationship mapping.. Option A is correct because External ID fields enable upsert operations in the Data Loader and DML, letting the migration match incoming records to existing ones and resolve lookup relationships without relying on Salesforce IDs. Option B is correct because standardizing picklist values and enabling State and Country Picklists enforces consistent, validated address and picklist data before load, preventing dirty values and failed record creation. Option C is correct because cleansing obsolete, redundant, or incomplete legacy records before migration reduces data volume, avoids duplicate records, and improves overall data quality in the target org. Option D is not appropriate because disabling user profiles would break user access and security and has nothing to do with data hygiene or structuring. Option E is not appropriate because standard objects cannot and should not be deleted; they are required for core Salesforce functionality and custom objects are added alongside them.

Answer

Disable all user profiles except the System Administrator.

Answer

Delete all standard object definitions to make room for custom objects.