Data 360 Consultant Segmentation And Insights Practice Test 2 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Use a single container with 'OR' logic for Segment A and Segment B, and add an Exclusion container for Segment C.. Container logic allows combining multiple segment criteria using AND/OR operators along with exclusion containers.

Answer

Use a Calculated Insight to evaluate the boolean expression of all three segments simultaneously.

Answer

Use an 'AND' operator between Segment A, Segment B, and Segment C within the same container.

Answer

Create three separate segments and publish them to a single activation target with priority rules.

Question 2

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?

Accepted Answer

Segmentation Canvas Container and Related Attributes. Segmentation canvas allows users to navigate related Data Model Objects using relationship paths to build container criteria.

Answer

Identity Resolution Ruleset

Answer

Calculated Insights Builder

Answer

Activation Target Mapper

Question 3

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.)

Accepted Answer

Create two calculated insights: one for Electronics purchases and one for Apparel purchases, then use both in the segment with an AND condition.. To identify customers who purchased both categories, the consultant can either use two separate related lists on the same DMO combined with AND, or create two calculated insights and combine them with AND. Both methods ensure the customer meets both criteria. The other options either use unsupported operators or incorrect join logic.

Answer

Create a segment that joins the Purchase History DMO to itself and filters one side for Electronics and the other for Apparel.

Answer

Use a single filter on the Category field with an 'IN' operator listing both categories, and set the condition to require at least two distinct categories.

Answer

Use a segment with a single related list and apply a filter on the Category field with the condition 'contains all of' and select both categories.

Question 4

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?

Accepted Answer

Create a Calculated Insight that aggregates subscription tiers per customer over the last 12 months, then use that Calculated Insight as a filter in the segment.. The requirement is to find customers with both tiers within the same 12-month window. A Calculated Insight can aggregate subscription records per customer over a defined period and produce boolean flags for each tier. Filtering the segment on both flags ensures the same time window is applied to both conditions, avoiding the risk of independent date filters that could match different periods. This approach also scales well and centralizes the logic.

Answer

Create two separate segments, one for Premium and one for Basic, then use a segment-on-segment intersection to combine them.

Answer

Use a single segment with a related-object filter that groups subscription records by customer and applies a count distinct condition for both tiers.

Answer

Use a segment with two separate related-object filters, one for Premium and one for Basic, each with its own 12-month date filter, combined with an AND operator.

Question 5

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?

Accepted Answer

The CI's refresh only processes data up to the previous day, so purchases from the previous day are not included until the next refresh.. Calculated insights often aggregate data up to a specific point in time, such as the end of the previous day. If the CI refreshes at 1:00 AM, it may only include data through the prior day, not purchases made later that same day. Therefore, the segment refresh at 2:00 AM would not see the most recent purchases until the next CI cycle. The consultant should review the CI's time window definition.

Answer

The segment refresh schedule runs before the CI refresh completes, so it uses stale CI data.

Answer

The CI is not included in the segment's Data Space, so the segment cannot access its results.

Answer

The segment is using a cached version of the CI results and needs to be manually refreshed.

Question 6

A marketer wants to create a segment of High-Value customers based on a Calculated Insight (CI) named 'Customer_Lifetime_Spend_CI'. The CI calculates total spend per individual. When the consultant attempts to add this Calculated Insight as a filter criteria in the Segment Canvas, the CI is not available for selection. What is the most likely cause?

Accepted Answer

The Calculated Insight has not been published or does not include the Individual DMO as a dimension.. Calculated Insights must be published and include the Individual or Profile dimension in order to be used in segmentation. If the CI does not include the primary DMO (like Individual) or has not been successfully processed and published, it will not appear as an attribute in the Segment Canvas.

Answer

Calculated Insights can only be used in segments if they are aggregated over a streaming DMO.

Answer

The user creating the segment lacks permission to view Calculated Insights metadata.

Answer

Calculated Insights must be converted to a Data Graph before they can be referenced in segmentation.

Question 7

A consultant has created a complex segment using multiple related objects (Individual -> Order -> Order Product). When publishing the segment, the job fails with a timeout error. What is the most efficient troubleshooting step to resolve this segment publishing failure?

Accepted Answer

Optimize the segment criteria by reducing unnecessary related object hops and ensuring data model relationships are correctly mapped.. Segment publishing performance can degrade when querying deeply nested or unindexed relationships across massive data volumes. Simplifying the segment criteria, ensuring proper relationships and indexes exist on the underlying DMOs, or breaking the segment into smaller logical parts are recommended troubleshooting steps.

Answer

Rebuild the segment using a Calculated Insight instead of related object filters.

Answer

Convert the segment into a streaming segment to bypass the batch publishing engine.

Answer

Increase the Data Cloud tenant storage limit to allow more memory for processing.

Question 8

An organization requires a segment that updates continuously in real-time as users perform specific clickstream actions on a website. Which limitation must the Data Cloud consultant keep in mind when designing a streaming segment?

Accepted Answer

Streaming segments only support attributes from DMOs enabled for streaming ingestion.. Streaming segments have specific architectural constraints. They evaluate criteria on streaming data and can only include attributes from DMOs that support streaming and are related directly or via specific cardinality paths. They cannot use batch-only dimensions or certain complex cross-object joins that batch segments support.

Answer

Streaming segments cannot contain more than three filter criteria.

Answer

Streaming segments must be published manually every 24 hours.

Answer

Streaming segments cannot be used with Marketing Cloud Engagement activation targets.

Question 9

A Data Cloud user needs to export segment membership to an external AWS S3 bucket for use in a third-party BI tool. Which feature should the consultant configure to achieve this export?

Accepted Answer

Activation Target and Activation. To send segment data to external destinations like Amazon S3, Marketing Cloud, or other activation targets, the consultant must set up an Activation and an Activation Target.

Answer

Calculated Insight

Answer

Streaming Transform

Answer

Data Graph

Question 10

Where in the Data Cloud setup interface should a consultant navigate to create and manage segment definitions?

Accepted Answer

Segments. In Salesforce Data Cloud, segments are managed in the Segment tab/section of the application.

Answer

Data Streams

Answer

Activation Targets

Answer

Calculated Insights

Question 11

A consultant wants to create a Calculated Insight that calculates the total revenue generated by each customer over the last 12 months, using an ANSI SQL expression in Data Cloud. Which syntax rule must be followed when writing the Calculated Insight?

Accepted Answer

The query must include at least one dimension and one aggregate measure using standard ANSI SQL.. Calculated Insights in Data Cloud use ANSI SQL. When writing aggregation queries, measures must be aggregated using standard SQL aggregate functions (like SUM, COUNT, AVG) and grouped by valid dimensions from the Data Model Objects.

Answer

Custom Apex code must be embedded within the SQL block for date calculations.

Answer

Queries must be written in Salesforce Object Query Language (SOQL).

Answer

All table names must reference raw Data Lake Objects (DLOs) rather than Data Model Objects (DMOs).

Question 12

When reviewing the Segment canvas, a consultant notices a metric called 'Publish History'. What information does this metric provide?

Accepted Answer

A log of past segment publication runs, including success/failure status and record counts.. Publish History in Data Cloud provides details on past segment runs, including status (success/failure), row counts, start time, and duration.

Answer

The exact SQL query generated by the segmentation engine.

Answer

The historical changes made to the segment criteria configuration by users.

Answer

The real-time streaming throughput of incoming data stream events.

Question 13

A marketer needs to target customers who have purchased Product A AND Product B, but have NOT purchased Product C. How should the consultant configure this logic within the Segment Canvas containers?

Accepted Answer

Place Product A and Product B in separate inclusion criteria with an 'AND' operator, and place Product C in an exclusion container.. In the Segment Canvas, inclusion and exclusion containers allow complex boolean logic. Product A and Product B would be placed in inclusion criteria (or separate containers depending on whether they are in the same transaction), and Product C would be placed in an exclusion container.

Answer

Use a Calculated Insight with a HAVING clause for all three products.

Answer

Place all three products in a single inclusion container and set the operator to 'NOT EQUAL'.

Answer

Create three separate segments and export them to an external database to perform a SQL EXCEPT operation.

Question 14

An organization wants to target customers who abandoned their cart more than 24 hours ago but have not completed a purchase since then. How should the consultant configure this time-based criteria in the Segment Canvas?

Accepted Answer

Configure relative time filters on the Cart Event object (greater than 24 hours ago) combined with an exclusion of Purchase Events within that same timeframe.. Time-based relative filters (e.g., event occurred greater than X days/hours ago) are configured directly within the attribute filters on related event objects (like Cart Event and Purchase Event) inside the segment container.

Answer

Export cart events to Marketing Cloud and handle the 24-hour delay in Journey Builder.

Answer

Write a custom SQL script in the Segment Setup menu.

Answer

Use a Calculated Insight that runs every minute to evaluate cart abandonment.

Question 15

A consultant needs to create a segment based on customer loyalty tier, which is stored in a Custom Object mapped to the Individual DMO. When building the segment, the loyalty tier attribute is showing as blank for many unified profiles. What should the consultant check first?

Accepted Answer

Verify that the Custom Object is correctly mapped to the Individual DMO via a foreign key and that identity resolution has been run.. If attributes appear blank in segmentation, the consultant should verify identity resolution rules, data mapping, and whether the data was successfully ingested and unified into the Individual DMO.

Answer

Check if the segment needs to be converted to a streaming segment to read custom objects.

Answer

Reinstall the Data Cloud data kit.

Answer

Ensure the segment publish schedule is set to run every 5 minutes.