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

Question 1

What role does Identity Resolution play in relation to Data Cloud segmentation?

Accepted Answer

Identity Resolution merges multiple source records into unified profiles, ensuring segments target unique individuals rather than fragmented records.. Identity Resolution ties disparate source records together into a single unified Individual profile, which is what segments evaluate against.

Answer

Identity Resolution exports final segment membership lists to external ad platforms.

Answer

Identity Resolution writes the SQL code for Calculated Insights.

Answer

Identity Resolution schedules the automatic refresh time for streaming segments.

Question 2

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?

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 3

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 4

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.. Activation delivery failures are commonly related to invalid activation target credentials, missing attribute mappings, or configuration errors in the activation setup.

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 5

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.. Conditional categorization in ANSI SQL is implemented using CASE expressions, allowing developers to assign labels based on numeric thresholds.

Answer

A Python lambda function embedded in the SELECT clause.

Answer

A Data Graph transform rule.

Answer

A SOQL IF-THEN block.

Question 6

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.. Attributes from the Individual DMO (postal code) and related objects (purchase amount) can be combined within inclusion criteria using standard boolean operators (AND).

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 7

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 8

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 9

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. The Segment Canvas supports inclusion containers, exclusion containers, related object filters, and relative date criteria.

Answer

Embedded Apex trigger logic

Answer

Direct SQL code editing window

Answer

Custom Visualforce pages

Question 10

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 11

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.. Before deleting a segment, a consultant should check for dependent activations and downstream dependencies to ensure no active processes rely on the 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 12

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.. Date/time handling in Calculated Insights requires proper ANSI SQL date functions, correct timezone considerations, and valid timestamp fields.

Answer

Writing custom Java classes to handle leap years.

Answer

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

Question 13

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 14

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 15

A consultant is writing a Calculated Insight that aggregates lifetime spend and needs to filter out records where the transaction amount is null. Which SQL clause should be used in the query to exclude null values?

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