Courseiva

Data 360 Consultant · topic practice

Segmentation And Insights practice questions

This domain covers building Calculated Insights with ANSI SQL, constructing segments from Data Model Objects, and analyzing engagement and profile data in Data Cloud. Questions test troubleshooting of validation errors, relationship gaps between DMOs, metric placement across business units, and streaming segment constraints. Expect scenario-based items requiring you to choose the correct object, join, or configuration.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member
20 questionsDomain: Segmentation And Insights

What the exam tests

What to know about Segmentation And Insights

Be able to write ANSI SQL Calculated Insights, join related DMOs correctly for segmentation, and place reusable metrics where all business units can access them. The most important thing is verifying foreign key relationships before trusting segment size or insight output.

Creating Calculated Insights using ANSI SQL against Data Cloud Data Model Objects

Segmenting on related Engagement DMOs and diagnosing missing foreign key relationships

Placing lifetime value metrics in Calculated Insights before segmentation

Identifying streaming segment limitations including refresh behavior and supported filters

Watch out for

Common Segmentation And Insights exam traps

  • ▸Assuming all related DMO records have foreign keys, causing smaller-than-expected segment sizes
  • ▸Building metrics directly in a segment instead of a Calculated Insight when cross-business-unit analysis is required
  • ▸Ignoring streaming segment constraints such as unsupported aggregations or delayed data availability

Practice set

Segmentation And Insights questions

20 questions · select your answer, then reveal the explanation

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days and have an active subscription. However, the purchase data updates in real time via streaming ingestion, while the subscription data is batch-loaded nightly. Which segment type and refresh strategy should the consultant configure?

An enterprise is running multiple batch segments that refresh daily. Due to downstream dependency requirements, Segment B must only evaluate after Segment A has finished its publishing run. How should the consultant orchestrate this dependency in Data Cloud?

Which TWO of the following statements are accurate regarding streaming segments in Data Cloud? (Choose two.)

Which TWO factors can directly impact the execution time and performance of a batch segment publication? (Choose two.)

Which THREE of the following are valid considerations when using Calculated Insights within segment definitions? (Choose three.)

A consultant wants to share audience segment data with an external marketing system that requires real-time API lookups rather than bulk file exports. Which Data Cloud feature should the consultant leverage alongside segmentation?

A consultant wants to create a segment of customers who have not opened any marketing emails in the last 6 months. Which segmentation container type should be used?

An administrator notices that a streaming segment is failing to publish updates despite new data flowing into the underlying Data Lake Object. What is the most likely cause?

Which user permission is required to create and publish audience segments in Data Cloud?

A multinational company needs segments to evaluate rules based on local time zones rather than UTC. How should the consultant configure date-based segment criteria to account for time zone differences?

Which TWO destination types are officially supported for publishing Data Cloud segments via Activation Targets? Choose 2 options.

A consultant needs to segment customers based on whether they have purchased specific product categories. The data model includes Unified Individual, Unified Contact Point, Sales Order DMO, and Product DMO. Which THREE strategies should the consultant employ? Choose 2 options. (Wait, prompt says THREE for half, let's provide 3 correct options). Choose 3 options.

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days. Which type of segment should be used to ensure the membership updates automatically on a scheduled basis?

An organization has configured a segment that includes unified individuals with an open support case. The segment is set to publish daily. However, support agents report that customers who resolved their cases hours before the scheduled publish are still receiving targeted marketing campaigns. How should the consultant redesign this segmentation approach?

An enterprise marketing team needs to publish a segment containing 50 million profiles to an external activation target every morning at 6:00 AM. The data activation job consistently fails due to timeout errors. Which architectural adjustment should the consultant implement?

A consultant is creating a segment that targets individuals who belong to either 'Segment A' or 'Segment B', but explicitly excludes members of 'Segment C'. How should this be constructed on the Segmentation Canvas?

A consultant needs to create a segment based on a specific product category purchased by customers. Which Data Cloud feature allows the consultant to traverse from the Unified Individual object down to the Sales Order and Product objects to define this criteria?

A consultant needs to create a segment that identifies customers who have purchased both 'Electronics' and 'Apparel' categories in the last 30 days. The purchase data is stored in a single DMO with a Category field. Which two approaches are valid for building this segment in Data Cloud? (Choose two.)

A consultant needs to create a segment that identifies customers who have purchased both 'Premium' and 'Basic' subscription tiers in the last 12 months. The data model includes a unified individual profile linked to multiple subscription records via a related object. The consultant wants to ensure the segment includes only customers who have at least one Premium subscription and at least one Basic subscription within the same 12-month period. Which approach should the consultant use?

A consultant is building a segment that uses a Calculated Insight (CI) named 'Total_Spend_CI' which aggregates purchase amounts per customer. The CI is scheduled to refresh daily at 1:00 AM. The segment is scheduled to refresh daily at 2:00 AM. The consultant notices that the segment's member count does not reflect the latest purchases from the previous day. What is the most likely reason?

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Focused Segmentation And Insights sessions

Start a Segmentation And Insights only practice session

Every question in these sessions is drawn from the Segmentation And Insights domain — nothing else.

Related practice questions

Related Data 360 Consultant topic practice pages

Move into related areas when this topic feels solid.

Frequently asked questions

What does the Data 360 Consultant exam test about Segmentation And Insights?
Be able to write ANSI SQL Calculated Insights, join related DMOs correctly for segmentation, and place reusable metrics where all business units can access them. The most important thing is verifying foreign key relationships before trusting segment size or insight output.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Segmentation And Insights questions in a focused session?
Yes — the session launcher on this page draws every question from the Segmentation And Insights domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other Data 360 Consultant topics?
Use the topic links above to move to related areas, or go back to the Data 360 Consultant question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the Data 360 Consultant exam covers. They are not copied from any real exam or dump site.