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

Question 1

What is the primary purpose of a Segment in Salesforce Data Cloud?

Accepted Answer

To group unified profiles based on specific criteria for activation to marketing and engagement channels.. Segments group unified customer profiles based on demographic, behavioral, and calculated criteria to enable targeted marketing, sales, and service activations.

Answer

To calculate real-time machine learning propensity scores.

Answer

To transform raw data files into standardized Data Lake Objects.

Answer

To resolve duplicate customer records into a single unified profile.

Question 2

A consultant is troubleshooting a Calculated Insight that fails upon publication with a syntax error. The query uses a CASE statement to categorize customer spend. What is a key syntax requirement for CASE statements in Data Cloud Calculated Insights?

Accepted Answer

CASE statements must include valid ANSI SQL syntax with all mandatory clauses such as WHEN, THEN, ELSE, and END.. Calculated Insights use ANSI SQL. CASE statements must follow standard ANSI SQL syntax, including all necessary WHEN, THEN, ELSE, and END keywords.

Answer

CASE statements are not supported in Data Cloud Calculated Insights; IF-THEN functions must be used instead.

Answer

CASE statements can only reference dimensions, never measures.

Answer

CASE statements must be wrapped inside an aggregate function like SUM() or COUNT().

Question 3

A marketer notices that after updating a segment's criteria, the segment member count drops to zero upon the next publish. What is the most likely reason?

Accepted Answer

The new filter criteria are overly restrictive or contain conflicting logic that matches zero profiles.. A member count dropping to zero usually indicates overly restrictive criteria, conflicting filter conditions (e.g., an impossible AND condition), or mapping/data availability issues for the newly added attributes.

Answer

Segments automatically lock and prevent modifications after three edits.

Answer

The activation target was disconnected.

Answer

The segment has exceeded its maximum lifetime publication limit.

Question 4

A consultant needs to create a segment that identifies customers who purchased items from both 'Electronics' and 'Apparel' categories in the same single order transaction. How should this be structured in the Segment Canvas?

Accepted Answer

Place both Electronics and Apparel filters inside a single related object container for the Order Item object.. To ensure conditions happen within the same related record (the same order), the consultant must place both category filters inside the same related object container (Order -> Order Item) rather than separate top-level containers.

Answer

Use an exclusion container to subtract customers who only bought one category.

Answer

Write a Calculated Insight because the Segment Canvas cannot evaluate multiple categories per transaction.

Answer

Place Electronics in one container and Apparel in a separate container, then use an 'AND' operator between the containers.

Question 5

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

Accepted Answer

Streaming segments require all source DMOs to be enabled for streaming ingestion.. Streaming segments evaluate criteria continuously as data flows into streaming DMOs. They require streaming-enabled data sources and have specific structural rules compared to batch segments.

Answer

Streaming segments do not support activation to any external targets.

Answer

Streaming segments can utilize any batch DMO or custom object without streaming enablement.

Answer

Streaming segments must be manually published every hour by an administrator.

Question 6

When designing a segment, a consultant wants to see an estimate of the audience size before publishing. Where can this estimated count be viewed?

Accepted Answer

Estimated profile counts are displayed directly on the Segment Canvas as criteria are configured.. The Segment Canvas provides estimated profile counts as criteria are added and modified.

Answer

Estimates are only available after the segment has finished its first full publish.

Answer

In the Data Cloud Home dashboard metrics widget.

Answer

In the activation summary report after export.

Question 7

A consultant is building a Calculated Insight that aggregates web session data. The requirement is to compute the rolling 30-day average of session durations per user. Which SQL clause or construct is essential for handling time-window calculations in Data Cloud Calculated Insights?

Accepted Answer

Standard ANSI SQL window functions and timestamp filtering expressions.. Data Cloud Calculated Insights support window functions and time-based aggregation constructs in ANSI SQL to calculate rolling averages, ranks, and partitioned metrics over time.

Answer

Apex streaming context variables.

Answer

Salesforce SOQL date literals like LAST_N_DAYS:30.

Answer

Data Graph transformation syntax.

Question 8

A consultant is designing segment criteria using related objects. Which THREE of the following capabilities are supported within the Segment Canvas? (Choose three.)

Accepted Answer

Nesting multiple related object criteria to filter based on child object attributes.. The Segment Canvas supports various logical containers and operators, including inclusion, exclusion, related object attribute filters, and date/numeric operators.

Answer

Writing custom Python machine learning scripts directly inside the segment builder.

Answer

Directly modifying underlying raw Data Lake Object schemas from the canvas.

Question 9

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

Accepted Answer

The total volume of records in the source Data Model Objects.. Batch segment performance is influenced by data volume scale, complexity of multi-object relationship hops, and frequency or concurrent job load.

Answer

The color theme selected for the Salesforce user interface.

Answer

The brand of the computer monitor used by the consultant creating the segment.

Answer

The number of active Salesforce CRM user licenses in the org.

Question 10

Which THREE of the following best practices should a consultant follow when building Calculated Insights to ensure optimal performance? (Choose three.)

Accepted Answer

Test and validate the SQL query logic using smaller datasets before scheduling full CI runs.. Calculated Insight performance depends on efficient SQL writing, proper selection of dimensions, avoiding overly complex nested subqueries where possible, and leveraging appropriate DMO relationships.

Answer

Embed REST API callouts inside the CI SQL to fetch external enrichment data.

Answer

Write queries against raw DLO files instead of normalized DMOs for faster execution.

Question 11

A consultant is configuring segment activation for a batch segment. Which TWO settings or options must be configured when setting up the activation? (Choose two.)

Accepted Answer

The specific contact attributes and enrichment fields to include in the activation payload.. When creating an activation, the consultant must select the target destination (Activation Target) and choose which profile attributes to include as enrichment alongside the segment membership list.

Answer

The underlying raw SQL query used to create the Activation Target.

Answer

The Apex trigger class that will process the activation file.

Answer

The CRM profile password for authentication.

Question 12

Which TWO methods can a consultant use to monitor the status and health of segment publishing jobs in Data Cloud? (Choose two.)

Accepted Answer

Checking the Data Cloud Home dashboard and monitor tools for system-wide job status.. Consultants can monitor segment publishing using the Publish History tab within the segment detail page and via system monitoring tools / Data Cloud dashboards.

Answer

Checking the browser's JavaScript console logs while logged into Salesforce.

Answer

Reviewing the Email Deliverability report in Marketing Cloud.

Answer

Running a SOQL query against the standard User object in Salesforce CRM.

Question 13

Which TWO statements are true regarding segment publishing schedules? (Choose two.)

Accepted Answer

Segments can be published manually on-demand by a user with proper permissions.. Segments can be configured with scheduled batch refreshes (e.g., daily, weekly) or published manually as needed.

Answer

All segments in Data Cloud are forced to refresh simultaneously every 60 seconds.

Answer

Segment publishing schedules are managed exclusively via external REST API calls.

Answer

Segment schedules are permanently locked and cannot be modified after initial creation.

Question 14

A consultant is building a segment and needs to exclude employees whose email addresses end with '@company.com'. Where should this condition be applied?

Accepted Answer

In an exclusion container using the Individual email attribute with the operator 'Ends With' equal to '@company.com'.. Excluding specific profile attributes (like internal employee email domains) is achieved by adding an exclusion container or an exclusion filter based on email attributes on the Individual DMO.

Answer

By deleting the employee records from the Data Lake Object ingestion stream.

Answer

By modifying the Identity Resolution ruleset match keys.

Answer

By writing an Apex trigger in Salesforce CRM.

Question 15

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

Accepted Answer

The Calculated Insight must include the Individual or Profile dimension to link to unified profiles.. Calculated Insights used in segmentation must be published, must include profile dimensions, and participate in batch evaluation schedules.

Answer

Calculated Insights update instantly in real time during segment canvas configuration without prior batch processing.

Answer

Calculated Insights automatically override and delete underlying Data Lake Objects.