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

Question 1

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. Data Export Service (Weekly Export) allows administrators to schedule automated weekly or monthly exports of all organization data into CSV files.

Answer

Data Import Wizard

Answer

Mass Transfer Tool

Answer

Data Loader CLI

Question 2

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?

Accepted Answer

Active duplicate rules are blocking record insertion based on matching contact data.. 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.

Answer

Data Loader cannot process Person Accounts without a parent Business Account.

Answer

Person accounts require a separate insert for the Contact object first.

Answer

Person accounts do not support custom fields in Data Loader.

Question 3

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 4

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 5

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?

Accepted Answer

The Contact is already a member of the specified Campaign, violating uniqueness.. Campaign Members have unique constraints; attempting to insert a duplicate Contact/Lead into the same Campaign will trigger validation or database errors.

Answer

Campaign records must be locked before adding members.

Answer

Campaign Status is a required field that was omitted from the mapping.

Answer

Campaign members cannot be loaded via Data Loader; they require Data Import Wizard.

Question 6

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

Accepted Answer

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

Answer

Escalation Rule

Answer

Sharing Rule

Answer

Assignment Rule

Question 7

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?

Accepted Answer

Move records to a custom object named 'Archived Opportunity' using Data Loader, then delete the originals.. 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.

Answer

Change the record type of old opportunities to 'Archived' and apply a sharing rule to hide them.

Answer

Mark the opportunities as inactive using workflow field updates.

Answer

Contact Salesforce Support to delete the primary database indexes for those records.

Question 8

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 9

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. Record-Triggered Flows can evaluate changes on parent records and update related child records when specific criteria (like a checkbox) are met.

Answer

Standard Account-Contact Address Inheritance setting

Answer

Duplicate Rule

Answer

Roll-Up Summary Field

Question 10

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?

Accepted Answer

Use Data Loader with smaller batch sizes and map WhatId for Accounts/Opportunities and WhoId for Contacts/Leads.. When loading activities, breaking batches down, disabling parent-account automatic roll-ups where possible, and loading during maintenance windows ensures high throughput.

Answer

Load Tasks and Events using the parent Account ID directly in the WhoId field.

Answer

Perform a single bulk insert of 2 million records with a batch size of 2,000.

Answer

Convert all historical activities into custom object records to bypass standard activity limits.

Question 11

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?

Accepted Answer

Validation Rule utilizing the $Permission global variable. Custom permissions referenced in Validation Rules or Apex triggers can restrict deletion, or profile-based 'Delete' object permissions can be adjusted.

Answer

Duplicate Rule set to block on delete

Answer

Sharing Rule with Read-Only access

Answer

Escalation Rule

Question 12

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.

Accepted Answer

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

Answer

Mass Delete Wizard

Answer

Data Import Wizard deduplication wizard

Answer

Data Loader upsert operation

Question 13

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

Answer

Provides a browser-based wizard interface directly inside Setup.

Answer

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

Question 14

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

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 15

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. Validation rules and regular expressions (REGEX) or AppExchange address verification tools ensure phone numbers and postal codes follow strict formats.

Answer

Mass Transfer tool

Answer

Assignment Rules

Answer

Data Export Service