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

Question 1

A consultant is writing a Calculated Insight that requires joining two separate Data Model Objects: Sales__dlm (sales transactions) and Product__dlm (product catalog). What is required for this join to execute successfully in a Calculated Insight?

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

Accepted Answer

The tables must be joined using standard ANSI SQL JOIN syntax referencing valid DMO fields and relationship keys.. Calculated Insights join DMOs using standard ANSI SQL JOIN syntax, relying on correctly established relationships and primary/foreign key mappings in the Data Model.

Answer

Joins must be pre-configured in an external ETL tool before ingestion into Data Cloud.

Answer

The join must be executed using Salesforce SOQL relationship traversal syntax.

Answer

Joins between different DMOs are prohibited; all metrics must be derived from a single DMO.

Question 2

What is the primary benefit of using containers in the Segment Canvas?

Accepted Answer

They allow practitioners to group and organize complex inclusion, exclusion, and related object criteria with clear logical relationships.. Containers in the Segment Canvas allow practitioners to group inclusion, exclusion, and related object criteria together to build sophisticated audience definitions with precise boolean logic.

Answer

They generate API tokens for external developers.

Answer

They automatically encrypt customer PII before activation.

Answer

They convert batch segments into streaming segments instantly.

Question 3

An organization notices that an activation associated with a segment is failing to deliver data to an external marketing platform. What should the consultant check first?

Accepted Answer

Verify the Activation Target connection settings, credentials, and attribute mappings.. When an activation fails to deliver data to an external platform, the most common root causes are misconfigured activation target connection settings, expired or incorrect credentials, and incorrect attribute mappings between the segment's schema and the destination's expected fields. These are the first things a consultant should inspect because they are the direct interface between the platform and the external system.

Answer

Delete all data streams and re-ingest raw data files.

Answer

Recreate the entire Identity Resolution ruleset from scratch.

Answer

Increase the browser timeout limit for the Salesforce administrator.

Question 4

A consultant is designing a Calculated Insight to evaluate customer purchase frequency. The business wants to classify customers as 'Frequent', 'Occasional', or 'Rare' based on total order count. Which ANSI SQL construct is best suited for implementing this conditional categorization in the Calculated Insight?

Accepted Answer

A CASE expression with numeric evaluation ranges.. A CASE expression is the ANSI SQL construct designed for conditional categorization within a query, allowing you to map numeric ranges (e.g., order count) to labels like 'Frequent', 'Occasional', or 'Rare'. It is portable, declarative, and evaluated row-by-row in the SELECT clause, making it ideal for Calculated Insights that derive categorical attributes.

Answer

A Python lambda function embedded in the SELECT clause.

Answer

A Data Graph transform rule.

Answer

A SOQL IF-THEN block.

Question 5

A consultant needs to create a segment of customers who live in specific postal codes AND have made a purchase of over $100. How should these two different types of attributes be combined in the Segment Canvas?

Accepted Answer

Place postal code criteria and purchase amount criteria in the same inclusion container with an 'AND' operator.. In Segment Canvas, combining different attribute types (like postal code from a profile and purchase amount from a transaction) requires placing both criteria in the same inclusion container with an AND operator. This ensures the segment includes only customers who satisfy both conditions simultaneously.

Answer

Write a custom Apex trigger to evaluate postal codes against order totals.

Answer

Build two separate segments and export them to Excel to find the intersection.

Answer

Use an exclusion container for the postal codes and an inclusion container for the purchases.

Question 6

What happens to an active segment when its underlying Data Model Object receives updated data during a scheduled batch ingestion?

Accepted Answer

During its next scheduled publish run, the segment evaluates the updated data and refreshes its audience membership.. When a batch segment runs according to its publishing schedule, it evaluates against the latest data available in the Data Model Objects.

Answer

The data updates are ignored until the yearly platform upgrade occurs.

Answer

The segment automatically deletes itself and must be rebuilt from scratch.

Answer

The segment pauses all publishing until an administrator manually re-approves the rules.

Question 7

Which THREE of the following statements are true regarding Calculated Insights in Data Cloud? (Choose three.)

Accepted Answer

Calculated Insights can aggregate data across multiple related Data Model Objects.. Calculated Insights use ANSI SQL, support aggregate functions and dimensions, require publishing, and can be used in segmentation.

Answer

Calculated Insights automatically modify raw DLO records during execution.

Answer

Calculated Insights require real-time streaming event handlers for every calculation.

Question 8

Which TWO features or components can be leveraged when building complex audience criteria in the Segment Canvas? (Choose two.)

Accepted Answer

Inclusion and exclusion containers. In the Segment Canvas, complex audience criteria are built by combining containers that include or exclude records, so option A (Inclusion and exclusion containers) is correct because these containers let you group and logically combine filter criteria to precisely define who enters or is removed from a segment. Option C (Related object attributes and filters) is also correct because the Segment Canvas supports traversing relationships to related objects and applying attributes/filters from those related records, which is essential for building nuanced, multi-object audience criteria. Option B (Embedded Apex trigger logic) is not part of the Segment Canvas criteria-building UI, as Apex triggers are code-level automation and not a declarative canvas component. Option D (Direct SQL code editing window) is incorrect because the Segment Canvas is a declarative, point-and-click tool and does not expose raw SQL editing. Option E (Custom Visualforce pages) is incorrect because Visualforce is a UI development framework and is not a criteria component within the Segment Canvas.

Answer

Embedded Apex trigger logic

Answer

Direct SQL code editing window

Answer

Custom Visualforce pages

Question 9

An organization has configured a segment that includes a Calculated Insight metric. When the segment publishes, it completes successfully, but the resulting audience count is unexpectedly lower than expected. What is a recommended investigative step?

Accepted Answer

Review the Calculated Insight SQL query logic, aggregation filters, and date boundaries to ensure profiles are not being inadvertently filtered out.. When segment counts using CIs are lower than expected, the consultant should check the CI's publication status, verify the date ranges or aggregation filters in the CI SQL, and review the join conditions between the CI and the Individual DMO.

Answer

Change the activation target connector type.

Answer

Switch the segment type from batch to streaming.

Answer

Double the number of Data Streams in the tenant.

Question 10

Which TWO actions should a consultant take when preparing to delete a segment that is no longer needed? (Choose two.)

Accepted Answer

Check for and remove any associated active activations that rely on the segment.. Option A is correct because an active activation that references the segment will continue to publish audiences to its destination, so the consultant must first locate and remove or deactivate those activations to avoid broken activation jobs and orphaned audience data. Option C is correct because segments often feed downstream processes such as Data Cloud data streams, flows, or external reporting tools, and deleting the segment without verifying those dependencies would break those consumers and cause data gaps. Options B, D, and E do not belong: rebooting Salesforce CRM servers is irrelevant to segment lifecycle management, converting a segment to a Calculated Insight is not a prerequisite for deletion, and exporting a segment schema via Apex Data Loader is not a required or standard step before deleting a segment.

Answer

Reboot all Salesforce CRM servers.

Answer

Convert the segment into a Calculated Insight prior to deletion.

Answer

Export the segment schema to a local CSV file using Apex Data Loader.

Question 11

When designing Calculated Insights that involve date/time functions, which THREE practices ensure accurate metric generation in Data Cloud? (Choose three.)

Accepted Answer

Referencing valid timestamp attributes from the mapped DMOs.. Option A is correct because Calculated Insights are built on the Data Cloud semantic layer, so date/time functions must reference valid timestamp or date attributes from mapped DMOs (Data Model Objects) to resolve properly and produce accurate metrics. Option B is correct because Data Cloud stores and processes timestamps in UTC, so when events originate from multiple global regions you must account for timezone offsets (e.g., using timezone conversion functions) to avoid misattributing events to the wrong day or period. Option E is correct because Calculated Insights use Data Cloud's SQL-based expression engine, which supports standard ANSI SQL date and timestamp functions (such as CURRENT_DATE, DATE_ADD, and EXTRACT), ensuring portable and platform-supported metric logic. Option C is not correct because Calculated Insights do not allow custom Java classes; leap-year handling is already provided by the platform's built-in date functions. Option D is not correct because hardcoding dates to January 1st would produce meaningless, non-dynamic metrics rather than accurate time-based calculations.

Answer

Writing custom Java classes to handle leap years.

Answer

Hardcoding all dates to January 1st of the current year.

Question 12

Which TWO attributes are typically tracked in the Segment Publish History log? (Choose two.)

Accepted Answer

Job status (e.g., Success, Failed). Publish History logs track execution status, timestamps, record counts, and error details for segment runs.

Answer

The Wi-Fi network strength of the user

Answer

Marketing Cloud email open rates

Answer

The administrator's login IP address

Question 13

A consultant wants to ensure that a segment refreshes every Monday morning before the weekly marketing email campaign launches. How should this be scheduled?

Accepted Answer

Configure a weekly segment publish schedule set to run on Monday prior to the campaign start time.. Batch segments support flexible recurrence schedules, including weekly schedules on specific days and times.

Answer

Rely on streaming ingestion to automatically schedule the batch run.

Answer

Manual execution is the only option; weekly schedules are not supported.

Answer

Configure an API callout script that triggers every minute on Monday.

Question 14

A consultant is writing a Calculated Insight that requires joining two separate Data Model Objects: Sales__dlm (sales transactions) and Product__dlm (product catalog). What is required for this join to execute successfully in a Calculated Insight?

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

Accepted Answer

WHERE amount IS NOT NULL. In ANSI SQL, filtering out null values from an aggregation or dataset is performed using the WHERE clause with the IS NOT NULL operator.

Answer

FILTER NULL VALUES

Answer

EXCLUDE NULLS

Answer

HAVING amount NOT EQUAL TO NULL

Question 15

What is the primary function of an Activation in Salesforce Data Cloud?

Accepted Answer

To publish segment member lists and associated attributes to connected activation targets.. An Activation in Salesforce Data Cloud publishes the members of a segment, along with their associated attributes, to a connected activation target such as Marketing Cloud, Advertising Studio, or an external platform. It is the mechanism that turns a computed segment into actionable data downstream. Activation is the final step after data ingestion, harmonization, identity resolution, and segmentation.

Answer

To execute Identity Resolution matching rules.

Answer

To ingest raw data files from Amazon S3.

Answer

To write Calculated Insight ANSI SQL queries.