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

Question 1

A consultant is troubleshooting a segment where members are appearing multiple times in the activation export file. What is the most likely cause of duplicate profile entries in the activation export?

Accepted Answer

The activation includes related attributes with a 1-to-many relationship, resulting in multiple rows per profile in the export.. Duplicate entries in activation exports often occur if activation enrichment attributes have a 1-to-many relationship with the profile (e.g., multiple phone numbers or orders) and the activation is configured to export all related records without deduplication or proper grain selection.

Answer

The segment was published during off-peak hours.

Answer

The Salesforce CRM license count is too low.

Answer

The segment type is set to streaming instead of batch.

Question 2

An organization requires a Calculated Insight to compute the running total of customer purchases ordered by transaction timestamp. Which SQL analytical clause is required to compute running totals in Data Cloud?

Accepted Answer

SUM(amount) OVER (PARTITION BY individual_id ORDER BY transaction_date). Running totals in SQL are computed with a window function: SUM(amount) OVER (PARTITION BY individual_id ORDER BY transaction_date). The OVER clause with PARTITION BY and ORDER BY creates a cumulative sum per individual as rows are processed in timestamp order. This is standard ANSI SQL and is how Data Cloud Calculated Insights express running totals.

Answer

TOTAL_ACCUMULATOR(amount)

Answer

RUNNING_TOTAL(amount, transaction_date)

Answer

CUMULATIVE_SUM() function without arguments.

Question 3

When configuring a new segment, what is the significance of selecting the 'Individual' DMO as the primary profile object?

Accepted Answer

It ensures the segment evaluates unified customer profiles rather than unmerged source records.. The Individual DMO represents the unified customer profile resulting from Identity Resolution, serving as the central anchor for customer-centric segmentation.

Answer

It automatically converts the segment into a real-time streaming segment.

Answer

It restricts the segment from being used in activations.

Answer

It bypasses the need for Calculated Insights.

Question 4

A consultant is investigating why a batch segment publish job failed with an out-of-memory error. The segment contains multiple nested related object containers querying several years of historical transaction data. What is the best architectural remedy?

Accepted Answer

Refine the segment criteria to narrow historical date ranges and simplify complex multi-level container nesting.. The out-of-memory error in a batch segment publish job is caused by the volume and complexity of the data being processed—specifically, the multi-year historical transaction data and deeply nested related object containers. Option B directly addresses the root cause by narrowing the date range (reducing the number of records) and simplifying the container nesting (reducing the query complexity and memory footprint). This is the best architectural remedy because it optimizes the segment definition itself, leading to more efficient query execution and lower memory usage.

Answer

Switch the segment to run every 1 minute to process smaller chunks.

Answer

Delete all Activation Targets in the tenant.

Answer

Re-map all data streams to use CSV format.

Question 5

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days. Which tool should the consultant use to build this audience?

Accepted Answer

Segment Canvas. Segment Canvas is the dedicated tool in Data Cloud for building audience segments using a drag-and-drop interface. It allows filtering on unified profile data, including purchase history, to create a segment of customers who purchased in the last 30 days. This directly matches the requirement to build an audience based on a time-bound purchase condition.

Answer

Identity Resolution

Answer

Activation Target

Answer

Calculated Insights

Question 6

A consultant is configuring a segment that needs to update hourly to capture real-time high-value cart abandoners. Which segment type supports this requirement?

Accepted Answer

Streaming Segment. Streaming segments evaluate incoming data changes in near real-time, unlike batch segments which run on a scheduled frequency like daily.

Answer

Batch Segment

Answer

Calculated Insight Segment

Answer

Static Segment

Question 7

A marketing team wants to analyze customer lifetime value (LTV) across all business units before segmenting on it. Where should the consultant build this metric?

Accepted Answer

Calculated Insights. Calculated Insights allow users to write SQL-like queries to aggregate metrics like LTV across unified data models.

Answer

Data Streams

Answer

Segment Canvas

Answer

Activation Membership

Question 8

A consultant writes a Calculated Insight using ANSI SQL to calculate total spend per customer. When attempting to save, the system throws an error regarding dimensionality. What is the cause?

Accepted Answer

The query is missing a GROUP BY clause corresponding to the primary key of the target entity.. Calculated Insights in Data 360 require that the SQL query's output be aggregated at the grain of the target entity's primary key. Without a GROUP BY clause matching that primary key, the query returns rows at an undefined grain, which the system cannot map to the entity — hence the dimensionality error. The GROUP BY must align with the entity's primary key to produce a valid metric per entity record.

Answer

Calculated Insights only support Standard SQL, not ANSI SQL.

Answer

The metric name contains spaces or special characters.

Answer

The query references fields from more than three distinct data streams simultaneously.

Question 9

A calculated insight calculating average order value fails during execution with a timeout error. How should the consultant optimize the query?

Accepted Answer

Refactor the query to use incremental processing logic and filter out historical data older than required.. Refactoring the query to use incremental processing and filtering out historical data reduces the volume of data processed, directly addressing the timeout by lowering query execution time. Calculated Insights in Data 360 often time out when scanning large datasets; incremental logic processes only new or changed records. This is the most effective optimization without changing the data source or segment type.

Answer

Increase the batch segment publishing frequency from daily to hourly.

Answer

Convert the Calculated Insight into a streaming segment source.

Answer

Map the calculated insight fields directly to Marketing Cloud Engagement attributes.

Question 10

A consultant needs to schedule a batch segment to refresh every Monday at 6:00 AM. Where is this schedule configured?

Accepted Answer

Segment Refresh Schedule. Batch segments are configured with a refresh schedule directly within the Segment definition interface in Data Cloud.

Answer

Activation Target Publish Schedule

Answer

Identity Resolution Job Schedule

Answer

Data Stream Ingestion Schedule

Question 11

A business unit requires a segment to include individuals who have either browsed a product category or abandoned a cart, but explicitly exclude anyone who purchased in the last 7 days. Which Segment Canvas feature should be used?

Accepted Answer

Containers with include and exclude criteria steps. Segment Canvas supports containers with AND/OR logic and exclusion steps to refine audience membership accurately.

Answer

Data Stream filter criteria

Answer

Identity Resolution suppression lists

Answer

Calculated Insight dimensional filters

Question 12

A consultant creates a segment using a related Engagement Data Model Object (DMO). The segment size is significantly smaller than expected. Upon troubleshooting, the consultant discovers that many records lack a foreign key relationship to the Unified Individual DMO. What architectural mechanism caused this discrepancy?

Accepted Answer

Unresolved identity links or missing foreign key mappings between the engagement DMO and Unified Individual.. Data must be properly mapped through Identity Resolution and relationships to the Unified Individual DMO for related engagement data to link correctly to unified profiles.

Answer

Calculated Insights stripped out historical records older than 90 days.

Answer

Batch segmentation only processes the first 10 million records by default.

Answer

Streaming segments overwrite batch segment membership automatically.

Question 13

An enterprise wants to publish a segment of high-value customers to an external S3 bucket. Which feature must the consultant configure prior to publishing the segment?

Accepted Answer

Activation Target. To publish a segment to an external S3 bucket, you must configure an Activation Target in Data Cloud (Data 360). Activation Targets define the destination for segment activation, such as an S3 bucket, and include the necessary connection details and credentials. This is a prerequisite before you can publish or activate a segment to that external system.

Answer

Data Action Target

Answer

Ingestion API Source

Answer

Connected App Framework

Question 14

A consultant needs to include attributes from a custom Calculated Insight into a segment rule. What requirement must be met before the Calculated Insight can be used in Segment Canvas?

Accepted Answer

The Calculated Insight must have its output mapped to the Unified Individual or relevant profile-level DMO.. Calculated Insights must be configured with specific output profile mapping (such as mapping to Unified Individual) to be usable in segmentation.

Answer

The Calculated Insight must be exported to an external data warehouse first.

Answer

The Calculated Insight must be set to run on a streaming frequency.

Answer

The Calculated Insight must use the SQL COUNT DISTINCT function exclusively.

Question 15

A consultant configures an activation to send segment membership to Marketing Cloud Engagement. When the activation runs, contacts are successfully added to a Data Extension, but some subscriber attributes are missing. What should the consultant verify?

Accepted Answer

Ensure the missing attributes are mapped in the Activation attribute selection screen.. Additional attributes must be explicitly selected as part of the activation's attribute mapping configuration.

Answer

Verify that the Segment Canvas includes the missing fields as filter criteria.

Answer

Rebuild the Calculated Insight with a different aggregation window.

Answer

Check that the Identity Resolution rule set includes the missing attributes as matching rules.