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 questionsTo 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.
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.
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.
Keep practicing
Take the free CRT-403 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CRT-403 practice questions
- Question 1Universal Containers is adding drone delivery to service offerings, and the developer has…
- Question 2An app builder at Ursa Major Solar has been working on a new custom app in a sandbox that…
- Question 3An app builder would like to streamline the user experience by reflecting summarized calc…
- Question 4The services manager wants to make sure the team enters case priority consistently. What …
- Question 5Ursa Major Solar wants to convert the relationship between Galaxy and Star from a lookup …
- Question 6Universal Containers has two types of applicants, hourly and salary. There are separate r…
