Data Management (10%)

Question 1

What is true regarding the use of an external ID field for matching the Data Import Wizard? Choose 2

A.) Matching by external ID is only available when importing solutions
B.) Matching by external ID is only available for custom objects
C.) Matching by external ID is available for any object that includes an External ID field and can be imported
D.) An external ID field can be selected if there are multiple external ID fields

Answer 1

C.) Matching by external ID is available for any object that includes an External ID field and can be imported
D.) An external ID field can be selected if there are multiple external ID fields

Matching by external ID is available for any object that has an External ID and can be imported via the Data Import Wizard. If an object has multiple external ID fields, the field to match by can be selected.

Question 2

When an opportunity status is updated to “Closed Won”, the sales team would like to ensure that no users except the VP of Sales can delete that opportunity record from the system. What should the admin customize to achieve this? Choose 1

A.) Use a combination of workflow rule, record type, page layout and validation rule to prevent deletion
B.) Create an assignment rule to assign record deletion for VP of sales
C.) Create a workflow rule to prevent record deletion from the system
D.) Create an approval process to lock the record once the status is updated

Answer 2

A.) Use a combination of workflow rule, record type, page layout and validation rule to prevent deletion

A workflow rule can be used to change the record type of the opportunity. A page layout that does not have a Delete button can be assigned to the record type for all profiles except for the profile of the VP of Sales.

Question 3

G.W. Computin has a global customer base and its Salesforce Org holds over 5,000 Accounts, 15,000 Contacts and more than 20,000 Lead records. There is a persistent complaint from the VP of Sales that the information on Account, Contacts and Leads is not up to date. He requested their admin to validate and update the data with the latest information. What should the admin use to resolve the issue? Choose 1

A.) The admin should validate the information with D&B Optimizer and update every Lead, Account, Contact record with that information
B.) The admin should use Data Loader to validate the information of each record
C.) The admin should find the latest information of every record and update it
D.) This is a cumbersome task and the admin cannot do anything about it

Answer 3

A.) The admin should validate the information with D&B Optimizer and update every Lead, Account, Contact record with that information

D&B Optimzer (Data.com clean’s replacement) is an effective way to validate and update the Leads, Accounts, & Contact information. Manually finding the latest information for that many accounts, contacts and leads with be a very time consuming and cumbersome project. Data Leader is not used for validating data, only inserting, updating, deleting.

Question 4

Jim works for a company that has added 10 new fields to a custom object. Jim needs to modify existing records and add data for the new fields. Which set of steps should Jim follow? Choose 1

A.) Export the records, save a backup, append the new data, update records
B.) Export the records, delete the existing records, append the new data, insert new records
C.) Export the records, append the new data, insert new records
D.) Export the data, save the record, append the new data, insert new records

Answer 4

A.) Export the records, save a backdrop, append the new data, update records

The records should be backed up before any changes are made. The records are already existing so they only need to be updated

Question 5

An admin has y7 million records that need to be loaded into SFDC and wants to do it in one batch. How can records be uploaded in one batch? Choose 1

A.) It is not possible to load 7 million records
B.) Third-party data loading tool
C.) Data Loader
D.) Data Import Wizard

Answer 5

B.) Third-party data loading tool

Data Loader can be used for loading up to 5 million records. The Data Import Wizard can be used to load up to 50,000 records. There are third-party apps available in the AppExchange which can load more than 5 million records at a time.

Question 6

When data is deleted, how long does it stay in the Recycle Bin? Choose 3

A.) Until the Recycle Bin reaches a certain size
B.) 15 days
C.) 30 days
D.) When the Recycle Bin is emptied using the user interface
E.) Forever

Answer 6

A.) Until the Recycle Bin reaches a certain size
B.) 15 days
D.) When the Recycle Bin is emptied using the user interface

Data in the Recycle Bin will be kept for a maximum of 15 days, until he maximum size is reached, or if the user empties it using the user interface, API, or using Apex code.

Question 7

What are some differences between using the Data Import Wizard and Data Loader? Choose 3

A.) Triggering Workflow rules is optional when using the Import Wizard but not with Data Loader
B.) Mappings can be saved with Data Loader but not with the Import Wizard
C.) Both Data Import Wizard and Data Loader can be accessed by all users
D.) The Data Import Wizard can only load standard objects but Data Loader can load custom objects
E.) Data Import Wizard cannot export records but Data Loader can

Answer 7

A.) Triggering Workflow rules is optional when using the Import Wizard but not with Data Loader
B.) Mappings can be saved with Data Loader but not with the Import Wizard
E.) Data Import Wizard cannot export records but Data Loader can

The Data Import Wizard can load both standard and custom objects. Data Loader is only available to users with the “Modify All Data” permission and needs to be downloaded as it is a client application. With Data Loader, Workflow rules, validation rules and triggers will fire. In the Data Import Wizard, running workflow rules and processes when records meet the criteria is optional. Data Import Wizard, running workflow rules and processes when records meet the criteria is optional. Data Import Wizard is used to perform data import tasks, such as adding or updating records while Data Loader is used for tasks such as data import, update and export. There is no option to save mappings in Data Import Wizard but there is a function to do that in the Data Loader user interface.

Question 8

You have discovered that a number of records were deleted by mistake 2 weeks ago. What can you do in this situation to product a list of the deleted records to recover them? Choose 1

A.) Use Data Loader to export the deleted records by checking “Include Deleted Records” in settings
B.) Data Recovery Manager can be accessed in Salesforce Setup to restore deleted records
C.) Nothing, after 10 days deleted records are removed from the recycle bin
D.) Use the “Export All” option in Data Loader and export the records

Answer 8

D.) Use the “Export All” option in Data Loader and export the records

The requirement in the question is about producing a list of all the soft-deleted records, which means you need to extract those records from SFDC. The question tests your knowledge of the option that is available in Data Loader for extracting/exporting records that are in the Recycle Bin. After using the “Export All” option to obtain the soft-deleted records, they can be imported using Data Loader.

Deleted records are available in the recycle bin for 15 days, and can be undeleted. However, if there are a large number and a list is required, the Export All option in Data Loader will include records in the recycle bin. After export, the deleted records can then be imported to restore them.

Question 9

As the total data volume is an organization increases, it has several impacts on the SFDC application users if best practices are not followed. What are some possible impacts of large data volumes? Choose 3

A.) Searches run more slowly
B.) Reports run slowly or time out
C.) Login time increases
D.) Full sandbox refresh time increases
E.) Records are not displayed properly

Answer 9

A.) Searches run more slowly
B.) Reports run slowly or time out
D.) Full sandbox refresh time increases

As data volume increases, searches take more time, reports run more slowly unless they are filtered properly, and a full sandbox refresh takes longer as there is more data to copy. But records are still displayed properly, and the time spent by a user during login does not increase.

Question 10

Sam has created a matching rule on the Contact object to detect duplicates. What is true in this situation? Choose 2

A.) Nothing will happen unless a duplicate rule is defined that uses the matching rule
B.) Duplicate contacts will be blocked or allowed based on the setting in the Duplicate Rule
C.) Only one field can be used for matching in the matching rule
D.) Only one duplicate rule can be active at one time

Answer 10

A.) Nothing will happen unless a duplicate rule is defined that uses the matching rule
B.) Duplicate contacts will be blocked or allowed based on the setting in the Duplicate Rule

A duplicate rule users a matching rule to identify which Contacts are considered duplicates and multiple duplicate rules can be active at the same time on the same object. Multiple fields can be used in the matching rule. The action of Block or Allow is specified in the duplicate rule.

Question 11

What will happen is a record in a Data Loader import file contains a picklist value that does not exist in SFDC and the picklist is not restricted? Choose 1

A.) The record will be added and the picklist value will be added to the list of existing values
B.) The import will fail with an error message
C.) The record will be added but the picklist value will not be added to the list of selectable values
D.) The record will be added with the default value for the picklist field

Answer 11

C.) The record will be added but the picklist value will not be added to the list of selectable values

If a value for a picklist field does not exist and the picklist is not restricted, then the record will be added. However, the picklist value will not be added to the values that can be selected and will not be available when adding other records. If the picklist is restricted e.g. “Restrict picklist to the values defined in the value set” is selected, then additional values cannot be added via the API/Data Loader and the record is not saved.

Question 12

Your org wants to allow users to create duplicate records for a custom object and report on those duplicate records when needed. How can this be done? Choose 1

A.) Utilize duplicate management to allow duplicates on that object and create reports on those duplicate records
B.) Enable duplicate records on custom objects on each user profile you wish to be able to create duplicates
C.) Duplicate records can never be created in SFDC
D.) Create an approval process for duplicate records and approve their submission

Answer 12

A.) Utilize duplicate management to allow duplicates on that object and create reports on those duplicate records

By using Duplicate Management you can control when to allow users to create duplicate records and create reports on the duplicated that are allowed be be saved.

Question 13

A.W. Inc uses SFDC for managing their sales orders. It is a very sensitive data and they need to backup this data at their internal server location automatically. Choose 1

A.) Raise a case with SFDC to backup the data every day
B.) use Data Loader every day, running export all
C.) Use the command line interface of Data Loader and schedule the export
D.) Export the data after running a report

Answer 13

C.) Use the command line interface of Data Loader and schedule the export

A scheduled job can be defined to run the command line interface of Data Loader

Question 14

An admin 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 user tries to save an opportunity that has a Close Date with a value from last month? Choose 2

A.) The error message defined in the validation rule displays on the record
B.) The validation failure is logged on the field history tracking related list
C.) The record will not save
D.) The user receives an email with the reason the validation rule failed

Answer 14

A.) The error message defined in the validation rule displays on the record
C.) The record will not save

A validation rule allows you to specify your own business-specific criteria to prevent users from saving invalid data in one or more fields. If a user enters an invalid Close Date, the error message defined in the validation rule displays on the record and the record will not save. A validation failure will not be logged on the field history tracking related list and the reason for a validation failure will not be sent to the user.

Question 15

Orbit Solutions reached their SFDC data storage limit and it looking to free up some space in order not to buy additional storage in the meantime. The admin would like to archive old inactive Contact records to make space to add new contacts. What is the most effective way to achieve this? Choose 1

A.) Use the Data Import Wizard to export and delete the data in one step
B.) Use Data Loader or create a report to export the data and then use Data Loader to delete the data
C.) Create a Contact Report, export the data and then manually delete the records
D.) use a third-party tool such as Informatica Cloud

Answer 15

B.) Use Data Loader or create a report to export the data and then use Data Loader to delete the data

The most efficient way to achieve this is to export the data (either by creating a report or by using Data loader) and include the Contact IDs. This can then be used as the input file to Data Loader to delete the same records. Data can be exported from SFDC via Data Loader, Reports, or Data Export Service. Although a Contact Report can be created and exported, manually deleting records is not going to be efficient.

Question 16

What are the different ways that data can be backed up? Choose 2

A.) Run a backup manually using Data Export
B.) Export data using Data Loader
C.) Schedule a daily data backup using Data Export
D.) Send an email request to SFDC to export a copy of all data

Answer 16

A.) Run a backup manually using Data Export
B.) Export data using Data Loader

Data export can be run manually or scheduled to run weekly or monthly. Data export also referred to as the “Data Export Wizard”. Backup files can be generated manually only once every 7 days. Data Loader can be used at any time to export data. Sending an email to SFDC to request for a data export is not necessary and would not be entertained as SFDC users with the “Weekly Data Export” permission would be able to do this.

Question 17

Smart Finance is using the Data Import Wizard to import contacts. The admin has chosen to match by email to prevent duplicates. However, if there is data in the file that matches an existing record, they would like to update the existing record in SFDC. Which action should be chosen? Choose 1

A.) Update existing records and no not insert any new records
B.) Update existing records and insert new records
C.) Do not insert new records and no not update existing records
D.) Do not update existing records and only insert new records

Answer 17

B.) Update existing records and insert new records

Since new records have to be inserted, but existing records have to be updated if a match is found based on the email address, the option “Add new and update existing records” should be used.

Question 18

Which of the following is true regarding Data Loader? Choose 2

A.) Data Loader is only available for Mac
B.) Data Loader is only available for Windows
C.) Data Loader Command Line Inerface (CLI) is only supported in Windows
D.) Data Loader runs on both Windows and Mac operating systems

Answer 18

C.) Data Loader Command Line Inerface (CLI) is only supported in Windows
D.) Data Loader runs on both Windows and Mac operating systems

Data loader is supported on Windows and Mac. The Data Loader command-line interface is only supported on Windows.

Question 19

An admin wants to update the records that have a picklist field status of “New” and make that field blank instead. How can this be achieved? Choose 1

A.) Export the records, change the “New” value to blank and import the records using Data Loader
B.) Upload the Data using Data Loader and External ID’s
C.) Use the Data Import Wizard and use the setting “Insert Blanks” for the picklist field
D.) Export the records, change the “New” to blank and upload using Data Loader using the setting “Insert Null Values”

Answer 19

D.) Export the records, change the “New” to blank and upload using Data Loader using the setting “Insert Null Values”

Using the Data Loader setting of “Insert null values” will insert or update fields with null values. Blank cells in the CSV file are treated by Data Loader as though no changes are needed in those fields and therefore will not change the records with the picklist field status of “New”. There is no “Insert Blanks” setting in Data Import Wizard

Question 20

What is true regarding using SFDC IDs to update data via Data Loader? Choose 1

A.) Either the 15- or 18-character SFDC ID can be used
B.) The 15-character SFDC ID must be used
C.) The 18-character SFDC ID must be used
D.) The SFDC ID of the record as displayed in the user interface must be used

Answer 20

A.) Either the 15- or 18-character SFDC ID can be used

Either the 15 character case-seneitive or 18-character case-insensitive ID can be used with Data Loader. SFDC uses a case-sensitive 15-digit ID for all records. As som applications such as Excel do not recognize that 501300000014c is a different ID than 5013000000014C, a case-safe 18 character ID was introduced

Question 21

The marketing team of ZS Global uses SFDC to managing their marketing activities. They generated a little over 213,000 leads across the globe with the latest campaign and want all those leads registered inside SFDC. They requested the admin to perform this task quickly. What tool should the admin use? Choose 1

A.) Use Salesforce Data Loader
B.) Create Records Manually
C.) Use the Data Import Wizard
D.) Contact SFDC support for data import

Answer 21

A.) Use Salesforce Data Loader

Data Loader is the best choice when the number of records to be imported dis between 50,000 and 5 million. Data Import Wizard can import up to 50,000 leads at a time, so it’s not the most optimal tool to use in this scenario.

Question 22

A data file containing Contact records is automatically sent to a computer every day. The admin needs to automatically load contact records from this file into SFDC at 6pm daily. What is the best tool to use for this requirement? Choose 2

A.) Data Loader via command-line interface
B.) Data Loader via user interface
C.) Run a Batch Class to Insert the Records
D.) Use an AppExchange tool such as Jitterbit Data Loader

Answer 22

A.) Data Loader via command-line interface
D.) Use an AppExchange tool such as Jitterbit Data Loader

Data Loader can be used via the user interface or the command line. When using Data Loader via the command line, the configuration, data sources, mappings, and actions can be specified in files, which allows setting up Data Loader for automated processing. For jobs that need to run on a scheduled basis, a third-party app such as “Jitterbit” or the command line interface of Data Loader would be the best option.

Question 23

The Owner field of an Opportunity record owned by an inactive user needs to be updated. What is the best way to achieve this? Choose 1

A.) This can only be done through the API
B.) Grant authorized users the “Update Records with Inactive Owners” permission
C.) Contact SFDC to enable this feature
D.) Ask an admin to do the update any time a record with an inactive user is found

Answer 23

B.) Grant authorized users the “Update Records with Inactive Owners” permission

To change the owner of an inactive record the Update Records with Inactive owners user permission can be used, after first enabling this option in the User Interface customization.

Question 24

An account record owned by an inactive user need to be updated. Who has the ability to update the record? Choose 1

A.) System admins only
B.) Records owned by inactive users cannot be updated; the user must be reactivated first
C.) System admins can all users with visibility to the record and create or edit permissions on the account object
D.) All active users

Answer 24

C.) System admins can all users with visibility to the record and create or edit permissions on the account object

Users with create or edit permissions on an object, as well as System Admins, can update a record owned by an inactive user. The inactive user does not have to be reactivated to do this. to change the owner and sharing based fields of an inactive record required the “Update Records with Inactive Owners” user permission.

Question 25

The owner of a case needs to be changed to another customer support user. The role hierarchy is set up with a customer support rule and a support manager role above. Who can change the ownership of the case? Choose 3

A.) Any user with the customer support role
B.) The support manager
C.) The admin
D.) The current owner of the case
E.) All users

Answer 25

B.) The support manager
C.) The admin
D.) The current owner of the case

Case ownership can be transferred by the current owner of the case, any user above them in the role hierarchy, and users such as the admin that have the Modify All Data permission.

Question 26

In which two scenarios would validation rules be enforced but not show a visual confirmation if a record was created or not? Choose 2

A.) Record Merge
B.) Submission of Web-to-Case form
C.) Lead Conversion
D.) Submission of Web-to-Lead form

Answer 26

B.) Submission of Web-to-Case form
D.) Submission of Web-to-Lead form

SFDC will only create Lead or Case records using “Web-to-Lead” and “Web-to-Case” respectively if they pass the validation rules. No response is provided to the web user if any of the validation rules fail, which will cause the Lead or Case record to not be created.

A successful lead conversion and record merge will display a confirmation message.

Question 27

An admin is asked by sales reps to make sure that the opportunity close date cannot be set in the past. How can this be accomplished? Choose 1

A.) Create a workflow rule to update the close date to the current date when closing the opportunity
B.) Create a validation rule to check the close date against the current date
C.) Create a business process to ensure the opportunity close date is not in the past
D.) Make Opportunity Close date a required field

Answer 27

B.) Create a validation rule to check the close date against the current date

A validation rule that runs when the opportunity status is set to “Closed” is the best way to check if the opportunity close date has been set in the past and display an error message if it has.

Question 28

An org has multi-currency enabled. What can cause a record in an import file to fail? Choose 3

A.) The record fails system validation rules
B.) The record fails custom validation rules
C.) Currency field is left blank
D.) A required field is missing
E.) Currency in the file is an inactive SFDC currency

Answer 28

A.) The record fails system validation rules
B.) The record fails custom validation rules
D.) A required field is missing

A record in the import file could fail because it is missing a required field, fails system validation rules or fails custom validation rules. If multi-currency is enabled and the currency field is left blank or an inactive currency is used, the personal currency of the user will be used.

Question 29

When using the “Data Export” page in Setup, which file type is used to export a backup of SFDC data on a weekly or monthly basis? Choose 1

A.) HTML
B.) DOC
C.) CSV
D.) SFDC

Answer 29

C.) CSV

Question 30

The admin received a request from the Support Team Manger that the email field on the case should be mandatory if the phone field information is not provided. Otherwise if the phone number is provided then it is not necessary to have the email field completed. How can the SFDC admin achieve this? Choose 1

A.) Assignment rule
B.) Workflow rule
C.) Escalation rule
D.) Validation rule

Answer 30

D.) Validation rule

Validation rules can be used to ensure conditional data integrity.

Question 31

The admin found records with duplicate values in a text field even though they were marked as unique when the custom field was created. What could be the problem? Choose 1

A.) SFDC always treats case sensitive and insensitive data as the same
B.) SFDC only looks at the first 10 characters when fields are marked as unique
C.) SFDC only enforces the unique restriction when data is loaded using Data Loader
D.) The option to treat the field as case insensitive was not selected when it was created.

Answer 31

D.) The option to treat the field as case insensitive was not selected when it was created.

When setting fields to be unique, they can be treated as case sensitive or case insensitive.

Question 32

The admin would like a backup of Account, Contact and Opportunity data to be automatically run and stored on a local company server each week. What is the best way to accomplish this? Choose 1

A.) Use the command-line interface of Data Loader and schedule a weekly job on the local server
B.) Use the Data Export Wizard and schedule a weekly run
C.) Write a custom program that accesses the SFDC API
D.) Use the SFDC Data Export service

Answer 32

A.) Use the command-line interface of Data Loader and schedule a weekly job on the local server

The SFDC Data Export service, also known as the Data Export Wizard, allows data exports to be run manually or scheduled weekly or monthly. It will send an email with a link to a secure page where data that has been exported can be downloaded; it cannot be automatically stored on a network server. Data Loader can be run in command-line mode and scheduled to run on a weekly basis and store the fields on a local company server

Question 33

What is required to use the Data Loader client application if the IP address has not been added to the list of trusted IP ranges? Choose 2

A.) Username and password
B.) Security token
C.) Multi-factor authentication
D.) Web Server OAuth token

Answer 33

A.) Username and password
B.) Security token

Data Loader is a client application and must be downloaded. To log in, users must provide the SFDC username and password. The security token is needed is the IP address has not been added to the list of trusted IP ranges. SFDC supports Web Server oAuth, but this is optional; standard and password authentication can be used. Multi-factor authentication is not asked for when logging in to Data Loader.

Question 34

An admin has identified about 200 leads that were generated incorrectly through the Web-to-Lead form. What are the best ways to remove these? Choose 2

A.) Use the Delete function of Data Loader
B.) Select the records from a Leads list view and use the Delete button
C.) Use the Mass Delete Leads link
D.) use the Archive Leads link on the Leads page

Answer 34

A.) Use the Delete function of Data Loader
C.) Use the Mass Delete Leads link

Mass Delete Leads is one of the options in Mass Delete Records. Conditions can be set to delete only certain records. Data Loader could also be used to delete but with a small number of records. Mass Delete would be an easier option.

Question 35

What is the most efficient way of transferring 10 records of a custom object displayed in an existing list view from one owner to another? Choose 1

A.) Change the owner on each record
B.) Use Data Loader
C.) Use the “Mass Transfer” tool
D.) Select the records in the list view and change owner

Answer 35

D.) Select the records in the list view and change owner

After selecting records from a list view, clicking on “Change Owner” allows the owner to be changed. The Mass Transfer tool is available on custom objects, however, it requires a “Find” step where criteria are specified to select the records to be transferred.

Question 36

Fred is an admin who needs to insert custom object records on a weekly basis, and sometimes the record count is above 50,000. There may also be the possibility of duplicate records. What is the best way for Fred to load the records? Choose 1

A.) Use a third-party data import tool
B.) use the Data Import Wizard
C.) Run a Batch Import class
D.) Use Duplicate Management and import the records via Data Loader

Answer 36

D.) Use Duplicate Management and import the records via Data Loader

The Data Import Wizard has a limitation of inserting a maximum of 50,000 records. If there are more than 50,000 records, then Data Loader should be used together with Duplicate Management to prevent duplicate records from being created. Duplicate Management is available for Accounts, Contacts, Leads and Custom objects. Using a third-party tool for this requirement is unnecessary.

Question 37

What record attribute is required to update a record using Data Loader? Choose 1

A.) Record ID
B.) Record name
C.) Record Type
D.) Created by Id

Answer 37

A.) Record ID

Question 38

A sales manager at Cosmic Circle Financial is on a leave of absence, and the sales cloud consultant has been asked to transfer the account records owner by him to another sales manager. Which of the following are transferred with account records by default using the mass transfer feature in SFDC? Choose 2

A.) open opportunities that belong to the existing owner
B.) Open cases that are owned by the existing owner
C.) Completed activities assigned to the existing owner
D.) Open activities assigned to the existing owner

Answer 38

A.) open opportunities that belong to the existing owner
D.) Open activities assigned to the existing owner

In Classic and Lightning, accounts can be mass transferred to other users. By default, the new user will own associated contacts, open Opportunities, Contracts in Draft & In Approval Process status, Orders in Draft status, Notes, Attachments, and open Activities assigned to the existing owner.

The option to transfer associated open cases assigned to the existing owner can be optionally selected. There is no option to include associated completed activities in the mass transfer feature.

Question 39

Where can the SFDC record ID be obtained from? Choose 3

A.) Reports
B.) Data Loader export file
C.) Record name
D.) The record URL in the browser
E.) Setup

Answer 39

A.) Reports
B.) Data Loader export file
D.) The record URL in the browser

Question 40

The admin has scheduled a data backup using the SFDC Data Export service because they would like to download backup files from SFDC to their local machine. How long does a backup data export remain available before it is automatically deleted? Choose 1

A.) 48 hours
B.) 24 hours
C.) 36 hours
D.) 12 hours

Answer 40

A.) 48 hours

After a data export is run, the data available to be downloaded for 48 hours before it is deleted.

Question 41

What is true regarding the Data Export Service? Choose 1

A.) The Data Export service will export data from all record but not attachments
B.) Data will be exported in .csv format
C.) The Data Export service can be set up to run daily
D.) A request must be sent to SFDC to enble the Data Export service

Answer 41

B.) Data will be exported in .csv format

Question 42

The admin of Cosmic Solutions is required to update all opportunity records in SFDC. He has exported all the opportunity data using Data Loader. Changes have been made to the downloaded file, and Data Loader has been used again to update the records. However, the update fails for a large number of records due to validation rules. After analyzing the situation, the SFDC admin has determined that most of the records that fail the validation are old records that were added before the validation rules were created. The rules do not need to apply to these old records. Which process should be used in order to complete the update? Choose 1

A.) Deactivate the validation rules, run the update for the new records, activate the validation rules again, and then run the update for the old records
B.) Remove the validation rules, run the update for all the records, and re-create the validation rules.
C.) Deactivate the validation rules, run the update for all the records, and activate the validation rules again
D.) Deactivate the validation rules, run the update for the old records, activate the validation rules again, and then run the update for the new records.

Answer 42

D.) Deactivate the validation rules, run the update for the old records, activate the validation rules again, and then run the update for the new records.

Validation rules can be deactivated temporarily to run the update for the old records which do not require validation. The rules can be activated again in order to update the new records.

Question 43

On what objects can duplicate rules by configured? Choose 3

A.) Lead
B.) Contact
C.) Opportunity
D.) Custom objects
E.) Product

Answer 43

A.) Lead
B.) Contact
D.) Custom objects

Duplicate rules are available for Accounts, Contacts, Leads, Individuals, and custom objects. All other standard objects, including Opp and Product, are not currently supported.

Question 44

As a responsible admin, it is important to perform data management. Data export is one of the activities within data management. Which of the following are correct in regards to data export and backup? Choose 2

A.) Exports will always complete within 5 hours
B.) The schedule Export option allows you to schedule the export process daily
C.) Formula and roll-up summary fields are always excluded from exports
D.) Large exports are broken up into multiple files

Answer 44

C.) Formula and roll-up summary fields are always excluded from exports
D.) Large exports are broken up into multiple files

The schedule export option allows the scheduling of the export process in weekly or monthly intervals. SFDC can not guarantee the date and time the export will complete.

Question 45

What are some benefits of using a custom picklist? Choose 3

A.) Reduces time to enter data
B.) Multiple values can be entered
C.) Helps maintain data quality
D.) Users can add additional values to the list
E.) Forces a user to make a selection

Answer 45

A.) Reduces time to enter data
B.) Multiple values can be entered
C.) Helps maintain data quality

There are different types of custom picklist fields: local (values are unique to the specific picklist field), shared (values are selected from a global picklist value set), and multi-select. Single or multi-select picklists define list of vlaues which can be used when entering data. The multi-select type of picklist allows more than one picklist value to be selected from a defined list. Having custom predefined lists help maintain quality and reduce the time needed to enter data.