MC-101 practice question 2 of 25
A marketing associate needs to import a CSV file into a data extension. Which delimiter should the associate select to correctly import this file type?
Full set: 122 questionsThe acronym CSV stands for "Comma-Separated Values." This file format uses a comma to separate or delimit distinct values within the data. When importing a CSV file into a Salesforce Marketing Cloud data extension, the import wizard requires the user to specify the character used to separate the columns in the source file. For a standard CSV file, the correct delimiter is the comma. Selecting the comma ensures that the import process correctly parses the data from the file and maps it to the corresponding fields in the data extension.
A. Tab: This delimiter is used for tab-separated values (TSV) files, where a tab character separates the data fields, not a comma.
B. Pipe: This delimiter (|) is used for pipe-delimited files, which is another common flat-file format but is distinct from a standard CSV.
1. Salesforce Help, Marketing Cloud Documentation: Import into a Data Extension in Marketing Cloud. This document outlines the steps for the import wizard, stating in Step 6, "Select the delimiter used in the import file. Options include Comma, Tab, or Other." This confirms that 'Comma' is the specified option for comma-delimited files.
2. Salesforce Help, Marketing Cloud Documentation: Import File Activity. In the section "Configure an Import File Activity," the documentation details the "File Naming and Delimiter" options. It explicitly lists "Comma" as a primary delimiter choice, reinforcing its use for corresponding file types like CSV.
3. Salesforce Help, Marketing Cloud Documentation: Data Extensions. This guide, while providing a general overview, implicitly supports the concept by defining how structured data is imported. The import functionality it links to consistently requires specifying the correct delimiter (e.g., comma for CSV) to maintain data integrity.
Keep practicing
Take the free MC-101 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MC-101 practice questions
- Question 1Northern Trail Outfitters (NTO) wants more insight into website traffic and behavior gene…
- Question 3Northern Trail Outfitters created a new team to oversee its marketing strategy. They want…
- Question 4The marketing team at Northern Trail Outfitters is exploring helpful features from Salesf…
- Question 5Management at Northern Trail Outfitters wants to run a new campaign and has asked the mar…
- Question 6Management at Northern Trail Outfitters would like to start sending personalized emails t…
- Question 7The digital marketing associate at Northern Trail Outfitters is looking for self-paced le…
