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 questions
Answer options
A: Tab
B: Pipe
C: Comma Correct answer
Correct Answer:
C. Comma
Explanation

The 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.

Why Incorrect

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.

References

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.

Scroll to Top