ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 90 - Certified Data Cloud Consultant discussion

Report
Export

A consultant is setting up a data stream with transactional data,

Which field type should the consultant choose to ensure that leading zeros in the purchase order number are preserved?

A.
Text
Answers
A.
Text
B.
Number
Answers
B.
Number
C.
Decimal
Answers
C.
Decimal
D.
Serial
Answers
D.
Serial
Suggested answer: A

Explanation:

The field typeTextshould be chosen to ensure that leading zeros in the purchase order number are preserved. This is because text fields store alphanumeric characters as strings, and do not remove any leading or trailing characters.On the other hand, number, decimal, and serial fields store numeric values as numbers, and automatically remove any leading zeros when displaying or exporting the data123. Therefore, text fields are more suitable for storing data that needs to retain its original format, such as purchase order numbers, zip codes, phone numbers, etc.

Zeros at the start of a field appear to be omitted in Data Exports

Keep First '0' When Importing a CSV File

Import and export address fields that begin with a zero or contain a plus symbol

asked 23/09/2024
- Paulo Fonseca
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first