Data 360 Consultant Segmentation And Insights Practice Question
Which THREE of the following best practices should a consultant follow when building Calculated Insights to ensure optimal performance? (Choose three.)
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
✓
Test and validate the SQL query logic using smaller datasets before scheduling full CI runs.
Calculated Insight performance depends on efficient SQL writing, proper selection of dimensions, avoiding overly complex nested subqueries where possible, and leveraging appropriate DMO relationships.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Test and validate the SQL query logic using smaller datasets before scheduling full CI runs.
Why this is correct
Validating syntax and logic ensures successful publication without wasting processing resources.
- ✗
Embed REST API callouts inside the CI SQL to fetch external enrichment data.
Why it's wrong here
Calculated Insights do not support external API callouts during execution.
- ✓
Always include the Individual or Profile dimension if the CI is intended for segmentation.
Why this is correct
CIs must map to the Profile/Individual dimension to be visible and usable in segmentation.
- ✓
Include only necessary dimensions and measures to avoid unnecessary data explosion.
Why this is correct
Limiting dimensions and measures keeps processing efficient and avoids large result sets.
- ✗
Write queries against raw DLO files instead of normalized DMOs for faster execution.
Why it's wrong here
Calculated Insights are designed to query mapped DMOs to leverage data harmonization and identity resolution.
About these practice questions
Courseiva writes every Data 360 Consultant question from scratch — 519 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.