Data 360 Consultant Data Ingestion And Modeling Practice Question
An enterprise is ingesting web tracking events via the Interaction SDK. Some event payloads contain nested arrays of product interactions. During mapping, the consultant needs to ensure these nested items are correctly associated with the parent event DMO. How is this handled?
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
✓
Map the nested array to a related child DMO using the parent event primary key as the foreign key.
Nested arrays in streaming or batch ingestion are mapped to related child DMOs using defined foreign key relationships between the parent event and child item DMOs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Write a Calculated Insight to unpack the array after ingestion.
Why it's wrong here
Calculated insights aggregate data; they are not used to unpack hierarchical ingestion structures.
- ✗
Discard nested arrays because Data Cloud only supports flat tabular data structures.
Why it's wrong here
Data Cloud supports nested JSON and hierarchical data modeling.
- ✗
Flatten the array into a comma-separated string inside a single text field.
Why it's wrong here
Flattening arrays into a single text string prevents relational querying and line-item segmentation.
- ✓
Map the nested array to a related child DMO using the parent event primary key as the foreign key.
Why this is correct
Nested arrays are mapped to related child DMOs linked via foreign keys to the parent event.
About these practice questions
This Data 360 Consultant question is part of Courseiva's 519-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.