When are Data validation Rules Enforced?
Upon opening a record
Upon editing a field
Upon saving a record
Upon closing the record
What should a system administrator consider before importing a set of records into Salesforce?
The import file should include a record owner for each record
Validation rules are not triggered when importing data using the import wizard
Data should of de-duplicated in the import file prior to import
Currency field values will default to the personal currency of the record owner
Fields which are hidden using Field-Level-Security are still subject to Validation Rules?
What is the maximum number of records you can import with the Import Wizard?
50.000
100.000
25.000
500.000
What types of records can be imported with the Import Wizard?
Custom objects
Opportunities
Accounts
Contacts
How many days will the recycle bin hold deleted data?
10
50
25
15
Universal Containers wants to automatically back up all the Salesforce data on a monthly basis. Which tool can a system administrator use to meet this requirement?
Data export service
Analytic Snapshot
Import Wizard
Scheduled report
What are the common ways Administrators can back up Salesforce data?
Reports
Scheduled backups
Manual backups
In order to update records using the Data Loader, what field must be present in the csv file?
Owner
Salesforce ID
Record Owner
Object Name
A customer has 7 million records that need to be loaded into Salesforce. How would you suggest to load these records?
Use a third party data loading tool
It is not possible to load 7 million records
Data Loader
Data Import Wizard
A system administrator at Universal containers incorrectly imported a set of records and needs to remove them from Salesforce. Which tool should the administrator use to complete the task? (Choose 2)
Excel Connector
Mass Delete
A marketing user has received a file of leads to import into Salesforce. What is the best way to avoid duplicating records?
Validation rules
Merge Leads Function
Which functionality is available when using the data export service? (Choose 2)
Schedule a recurring export
Include the values for formula fields
Include attachments
Export a subset of records for a given object
Which tool can automatically prevent duplicate records?
Connect for Office
Excel connector
Universal Containers requires that its Salesforce account data, including attachments, be backed up weekly. Which tool should a system administrator use to accomplish this?
Account report export
Account analytic snapshot
Data Export Service
Which field type can be used as an external ID? (Choose 3)
Formula field
URL field
Email field
Number field
Text field
A system administrator at Universal Containers needs to mass update the lead source of opportunity records. How can this be accomplished? (Choose 2)
Use similar opportunities to update the opportunities
Export opportunities and update using the import wizard
Create a list view for opportunities and update using inline editing
Export opportunities and update using the data loader
Universal Containers needs to synchronize data between Salesforce and an external financial system. How can a system administrator accomplish this?
Use the Excel connector to export records from both systems into Excel
Use an external ID field to match records between the systems
Use the data loader to match records between the systems
Use the data loader to insert Salesforce records into the financial system
When importing data, what happens if some records do NOT meet the data validation criteria?
Import process fails only for the records with invalid data
Import process ignores the data validation criteria
Import process aborts when it encounters the first invalid record
Import process requires user authorization to import the invalid records
When can a validation rule be used to prevent invalid data? (3 answers)
When records are updated by a workflow rule
When records are imported
When records are edited by a user
When records are submitted using web-to-lead
When records are deleted by a user
What can be transferred from one user to another user during mass transfer of account records? (3 answers)
Open cases
Related custom object records
Closed cases
Closed activities
Open activities
A system administrator at Universal Containers needs to transfer records from one user to another. What object can be transferred using the mass transfer tool? (2 answers)
Campaigns
Quotas
Leads
When importing records using the Data Import Wizard, what conditions will cause a record to not be imported? Pick two.
The value of a field doesn't meet the data validation criteria.
The import file does not contain the Salesforce ID.
A universally required field is left blank.
A picklist value does not exist in Salesforce.
What are the benefits of using the Data Import Wizard to import data into Salesforce? Pick two.
Import greater than 50,000 records.
Choose whether or not to trigger workflow rules.
Prevent duplicate records from entering the system.
Load data for all standard and custom objects.
Why would a user choose data loader instead of the Data Import Wizard? Pick two.
Export or delete data.
Choose whether or not to run data validation rules.
Import lead records and prevent duplicate records.
Save field mappings for later use.
What features provides an automated way to obtain a complete set of Salesforce data for archiving? Pick two.
Data loader
An administrator at AW Computing incorrectly imported a set of records into Salesforce. Which tools can the administrator use to remove the records from Salesforce? Pick two.
Salesforce roll-back
Mass delete records
How often can Export requests be made using the Data Export tool? (Choose 2)
Every day
Once every week
Once a month
No Limit
Data Cleansing is the process of:
Transferring data from one repository to another
Improving existing data by linking additional data sources
Creating format consistency and removing bad data
Identifying and merging duplicate records
What is the most common identifier when searching for duplicate records?
Address
Phone number
Record Name
Record ID
Which of the following statements are true about Data Validation? (Choose 2)
Validation rules apply to all new and updated records for an object.
Validation rules can update fields which are not included in a page layout.
Validation rules can refer fields which are not included in a page layout.
If an error message is not set, a default message will be prompted instead.
How many cases records can be imported via Import Wizard?
500
5,000
50,000
Any number over 50,000
Case records cannot be imported via Import Wizard
What are the limits for the Account + Contacts Import Wizard per session?
1000 records for end users. 10,000 records for Administrators importing for multiple users
50 records for end users. 5,000 records for Administrators importing for multiple users
500 records for end users. 50,000 records for Administrators importing for multiple users
End users cannot import records. 50,000 records for Administrators importing for multiple users.
If you need to insert, delete, or extract data, what is the best tool to use?
Connect for office
How can an import be undone?
By repeating the import
Using Mass Update records
Using Mass Transfer records
Using Mass Delete records
What is data validation rules executed on?
Record
Object
Page Layout
Field
A system administrator wants to schedule a weekly data export. What can they select to include? (Choose 4 answers)
A specific objects data
The folder you want it exported to
The organization's attachment
All of the data for the organization
Replace the carriage return with spaces
You can specify who the export gets sent to
A marketing user imported a list of leads into Salesforce using the lead import wizard, but missed a custom field when mapping the data for upload. What strategies can you employ to ensure this does not happen again? (Select 2 answers)
Instruct users to test upload a limited number of records (e.g. 3-5 records) to ensure that the data is properly mapped prior to importing a data file with a large number of records.
Instruct users to run the data correction wizard when they've discovered there was a problem with the data import.
When a mass import (e.g. 300 records) is performed incorrectly, instruct users to manually correct the data.
Provide users a lead upload template file that matches the field naming convention used in Salesforce. This will ensure that fields are automatically mapped when using an import wizard.
The sales team wants to prevent sales reps from entering an opportunity close date more than 1 year from today's date. Instead of pushing the close date this far, the opportunity should be marked as Closed/Lost and the account revisited in one year. How should this be enforced?
Opportunity Stage Configuration
Opportunity Settings
Validation Rule
One sales rep leaves your company, and another sales rep joins the company. All account records owned by the previous sales rep should be transferred to the new sales rep. The number of accounts to transfer is less than 200. What is the easiest way to accomplish this?
Use the Data Import Wizard.
Use the Mass Transfer Records wizard.
Use the data loader to extract and then update the account records.
When deactivating the old user, select the transfer records option.
Your organization requires a regular backup of all Salesforce data to adhere to its disaster recovery policies set by the IT department. What is the easiest way for you as an administrator to regularly export all of your Salesforce data?
Use the Data Loader to export data from all objects.
Use a 3rd party data tool.
Schedule a recurring data export within Salesforce; include all data when creating the export job.
Use the mass export data wizard.
Which automation tool will prevent a record from being created in Salesforce if the rule conditions are not met?
Validation Rules
Escalation Rules
Workflow Rules
Auto-Response Rules
An administrator created a validation rule to ensure that users do not change the Close Date of an opportunity to a day in the past. What happens when a users tries to save an opportunity that has a Close Date from last month? Pick two.
The validation failure is logged on the field history tracking related list
The error message defined in the validation rule displays on the record
The record will not save
The user receives an email with the reason the validation rule failed
