ExamTopics Logo
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Marketing Cloud Consultant All Questions

View all questions & answers for the Certified Marketing Cloud Consultant exam
Go to Exam

Exam Certified Marketing Cloud Consultant topic 1 question 121 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Consultant
Question #: 121
Topic #: 1
[All Certified Marketing Cloud Consultant Questions]

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?

  • A. Number
  • B. Text (15)
  • C. Decimal (15,2)
  • D. Decimal (15,0)
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by duyduc27 at June 9, 2021, 8:18 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Guillermo_Verduzco
2 months, 1 week ago
A) is excluding the zeros providing only primary key numeric without zeros those are not necessary, that´s the right answer
upvoted 1 times
...
elis_nata10
2 years, 2 months ago
Selected Answer: D
decimal (15,0) it will also 'cut' leading zeroes
upvoted 1 times
...
Charishna
3 years, 2 months ago
Answer is D only as Number data type will not accept integers more than 10 digit. In question they have not specified how many leading zeroes are there. Hence it is decimal (15,0)
upvoted 2 times
...
duyduc27
3 years, 6 months ago
It should be A - Number since leading zeros will be removed when using Integer data type
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago