Data Management

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

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.

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.

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?

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.

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

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?

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

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

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?

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

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?

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?

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

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 consultant is preparing to migrate 1 million account records and their related contacts into Sales Cloud. The organization has a complex data model with many required fields and validation rules. Which TWO steps should the consultant take to ensure a successful migration? (Choose two.)

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?

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.

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

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?

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