CRT-403 practice question 13 of 35

Universal containers (uc) want to delete data in several fields for 5000 lead records. UC export the selected record IDs and fields that need to have data deleted in a csv file. Which two steps should an app builder suggest to meet these requirements? Choose 2 answers

Full set: 291 questions
Answer options
A: Select the correct record type
B: Use import Wizard to update leads using the CSV file
C: Select insert null values in settings. Correct answer
D: Use Data Loader to update leads using the CSV file Correct answer
Correct Answer:
C. Select insert null values in settings.; D. Use Data Loader to update leads using the CSV file
Explanation

To delete data from specific fields for 5,000 Lead records, the most appropriate tool is Data Loader. The process involves preparing a CSV file with the Lead IDs and blank values for the columns corresponding to the fields that need to be cleared. When performing the update operation with Data Loader, the "Insert Null Values" setting must be enabled. This setting instructs Data Loader to treat the blank cells in the CSV file as null values, which then overwrite and effectively delete the existing data in the specified Salesforce fields. This combination provides a precise and reliable method for mass data cleansing.

Why Incorrect

A. Select the correct record type: This step is irrelevant. The records are already identified by their unique IDs, and the operation is to update field values, not change the record type.
B. Use import Wizard to update leads using the CSV file: While the Data Import Wizard can update records, the "Insert Null Values" setting is a specific feature of Data Loader, making the combination of (D) and (C) the most accurate and complete solution presented.

References

1. Salesforce Help Documentation, "Configure Data Loader": This document explicitly describes the "Insert Null Values" setting. It states, "Select Insert Null Values to insert null values for blank fields during an update or upsert operation. You must select this option if your CSV file contains blank values that are used to overwrite existing data in Salesforce. If you leave this option deselected, Data Loader ignores blank values in your CSV file when you update records." This directly supports the necessity of option (C) when using Data Loader for this task.

2. Salesforce Help Documentation, "Insert, Update, or Delete Data Using Data Loader": This guide outlines the procedure for using Data Loader for mass updates. Step 6 of the "Update or Upsert Records" section directs the user to map the CSV columns to Salesforce fields, which is the core of the update operation described in the scenario. This supports the use of Data Loader (D) for the update.

3. Salesforce Help Documentation, "Compare Data Import Tools": This resource compares the Data Import Wizard and Data Loader. It positions Data Loader as the tool for complex imports and mass updates for all objects, suitable for the 5,000-record volume. This further validates the choice of Data Loader (D) over the Import Wizard (B) for this administrative task.

Scroll to Top