Data 360 Consultant Data Ingestion And Modeling Practice Question
A consultant has created a custom Data Model Object (DMO) and needs to relate it to the standard Individual DMO. The relationship type chosen is N:1 (Many custom DMO records to One Individual). When configuring this relationship in Data Cloud, what is a mandatory requirement for the foreign key field in the custom DMO?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
It must have the exact same data type (Text) and precision as the primary key of the parent DMO.
When establishing relationships between DMOs in Data Cloud, the foreign key field in the child object must match the data type and length of the primary key field in the parent object (Individual ID) to ensure successful joins and identity resolution.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
It must be indexed using a SOQL custom index.
Why it's wrong here
Data Cloud handles indexing automatically; SOQL custom indexes are not managed this way for DMO relationships.
- ✗
It must be mapped directly to a Data Source Object formula field.
Why it's wrong here
While formula fields can populate it, the requirement itself is about data type compatibility, not the source of the population.
- ✗
It must be configured as a measure data type.
Why it's wrong here
Measures are numeric fields used for aggregations, not foreign keys.
- ✓
It must have the exact same data type (Text) and precision as the primary key of the parent DMO.
Why this is correct
Foreign keys must match the parent primary key's data type and attributes for relational integrity.
About these practice questions
This Data 360 Consultant question is part of Courseiva's 521-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Salesforce exam blueprint
This Data 360 Consultant practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Data 360 Consultant exam.