Exam Data-Con-101 Topic 5 Question 82 Discussion

Actual exam question for Salesforce's Data-Con-101 exam
Question #: 82
Topic #: 5
A consultant at Northern Trail Outfitters is attempting to ingest a field from the Contact object in Salesforce CRM that contains both yyyy-mm-dd and yyyy-mm-dd hh:mm:ss values. The target field is set to Date datatype.
Which statement is true in this situation?

Suggested Answer: D Vote an answer

Field Data Types: Salesforce CRM's Contact object fields can store data in various formats. When ingesting data into Salesforce Data Cloud, the target field's data type determines how the data is processed and stored.
Date Data Type: If the target field in Data Cloud is set to Date data type, it is designed to store date values without time information.
Mixed Format Values: When ingesting a field containing both date (yyyy-mm-dd) and datetime (yyyy-mm- dd hh:mm:ss) values into a Date data type field:
The Date field will extract and store only the date part (yyyy-mm-dd), ignoring the time part (hh:mm:ss).
Result:
Date Values: yyyy-mm-dd values are stored as-is.
Datetime Values: yyyy-mm-dd hh:mm:ss values are truncated to yyyy-mm-dd, and the time component is ignored.
References:
Salesforce Data Cloud Field Mapping
Salesforce Data Types

by Michael at Jul 10, 2026, 11:51 PM

Limited Time Offer

15%

Off

Get Premium Data-Con-101 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10