Question

Northern Trail Outfitters (NTO) 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 NTO does not want to include them in the final values.

Which data type should they use for the Order ID field?

A. Decimal

B. Integer

C. Number

D. Text

Answer 1

The correct data type to use for the Order ID field, where leading zeroes need to be preserved, is Text. Numerical data types like Integer, Number, and Decimal will not maintain leading zeroes. So, the correct answer is option d.

Step-by-step explanation:

The suitable data type for the Order ID field where Northern Trail Outfitters (NTO) wishes to exclude leading zeros is Text. Integer and Number data types inherently do not support leading zeros as they are numerical and will automatically discard any zeros at the beginning of a number.

A Decimal is also a numerical type and not suitable for ID fields that include leading zeros. Therefore, to preserve the integrity of the 15-digit integer including leading zeroes for display purposes, a Text data type should be used in the data extension. Storing Order ID as Text allows the ID to be stored exactly as provided, including any leading zeros. So, the correct answer is option d.