Salesforce Certified Marketing Cloud Consultant — Question 18

Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeroes, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

Answer options

• A. Number
• B. Text (15)
• C. Decimal (15,2)
• D. Decimal (15,0)

Correct answer: D

Explanation

The correct answer is D, Decimal (15,0), because this format allows for a 15-digit integer without any decimal places, which is ideal for an Order ID. Option A, Number, would not retain leading zeroes, while Option B, Text (15), is unnecessary since a numeric type is more appropriate for integer values. Option C, Decimal (15,2), includes decimal places, which are not needed for an Order ID.