Courseiva

CCNA Segmentation And Insights Questions

16 of 91 questions · Page 2/2 · Segmentation And Insights topic · Answers revealed

Practice these questionsExam hubAll questions
76
MCQhard

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?

A.Calculated Insights can only be used in segments if they are aggregated over a streaming DMO.
B.The Calculated Insight has not been published or does not include the Individual DMO as a dimension.
C.The user creating the segment lacks permission to view Calculated Insights metadata.
D.Calculated Insights must be converted to a Data Graph before they can be referenced in segmentation.
AnswerB

Segment filters can only reference published Calculated Insights built on the Individual DMO. An unpublished CI, or one lacking Individual as a dimension, cannot be selected in the Segment Canvas, explaining why Customer_Lifetime_Spend_CI is unavailable.

Why this answer

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.

Practice this question →
77
MCQmedium

A consultant needs to create a segment based on the total number of website visits recorded in the last 7 days. The source web tracking data is stored in an engagement DMO. How should the consultant approach this?

A.Use Segment Canvas related object criteria with a count aggregate on the web visit DMO filtered by the last 7 days.
B.Create a static segment and manually import website visitor IDs weekly.
C.Configure a Data Action Target to trigger alerts on every web visit.
D.Build an Ingestion API to pre-filter website visits before they enter Data Cloud.
AnswerA

Segment Canvas related-object criteria support count aggregates across a related DMO, so counting web visit records in the engagement DMO filtered to the last 7 days satisfies the rolling-window requirement directly. This avoids precomputing totals in Data Cloud, since the aggregate is evaluated against related records at segment refresh.

Why this answer

Using related object attributes with aggregate count functions within the Segment Canvas allows filtering based on engagement frequency.

Practice this question →
78
MCQhard

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?

A.Change the activation target connector type.
B.Switch the segment type from batch to streaming.
C.Review the Calculated Insight SQL query logic, aggregation filters, and date boundaries to ensure profiles are not being inadvertently filtered out.
D.Double the number of Data Streams in the tenant.
AnswerC

Calculated Insight metrics depend on SQL logic, aggregation filters, and date boundaries; if any inadvertently excludes profiles, the published segment silently drops members. Reviewing that query logic identifies why the audience count is lower than expected.

Why this answer

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.

Practice this question →
79
MCQhard

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?

A.CASE statements are not supported in Data Cloud Calculated Insights; IF-THEN functions must be used instead.
B.CASE statements can only reference dimensions, never measures.
C.CASE statements must be wrapped inside an aggregate function like SUM() or COUNT().
D.CASE statements must include valid ANSI SQL syntax with all mandatory clauses such as WHEN, THEN, ELSE, and END.
AnswerD

Calculated Insights enforce standard ANSI SQL rules, requiring correct structure including the terminating END keyword for CASE expressions.

Why this answer

Calculated Insights use ANSI SQL. CASE statements must follow standard ANSI SQL syntax, including all necessary WHEN, THEN, ELSE, and END keywords.

Practice this question →
80
MCQmedium

A consultant has created a segment in Data Cloud that identifies high-value customers. The segment is activated to a Marketing Cloud Engagement activation target. After the activation runs, the consultant notices that the segment count in Data Cloud is 10,000, but only 8,000 records were sent to Marketing Cloud Engagement. What is the most likely cause of the discrepancy?

A.The activation target has a filter that excludes some records.
B.Data Cloud only sends records that have a valid email address.
C.Marketing Cloud Engagement deduplicates records based on email address.
D.The segment was refreshed after the activation, causing a temporary mismatch.
AnswerA

Activation targets can have filters applied to limit the data sent. If a filter is configured, it will reduce the number of records transmitted. This explains why fewer records arrived than the segment count. The consultant should review the activation target's filter settings to understand the exclusion criteria.

Why this answer

Activation targets in Data Cloud can have filters that restrict which segment members are sent. These filters are applied at activation time and can significantly reduce the number of records. The consultant should check the activation target configuration to see if any filters are active.

This is a common reason for a mismatch between segment count and activated records.

Exam trap

The trap here is assuming that all segment members are always sent to the activation target, overlooking the possibility of filters on the activation that exclude certain records.

Practice this question →
81
MCQmedium

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?

A.The segment was published during off-peak hours.
B.The Salesforce CRM license count is too low.
C.The activation includes related attributes with a 1-to-many relationship, resulting in multiple rows per profile in the export.
D.The segment type is set to streaming instead of batch.
AnswerC

A one-to-many related attribute produces one export row per related value, so a single profile appears repeatedly. The profile itself is not duplicated; the join fans out rows. Deduplicating or aggregating related attributes resolves the repeated entries.

Why this answer

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.

Practice this question →
82
MCQeasy

How can a consultant verify how many profiles currently qualify for a published segment?

A.Review the Data Stream error log file.
B.Check the segment details page in Data Cloud for total member count and publish history.
C.Open the Identity Resolution match history report.
D.Run a SOQL query against the standard Salesforce CRM Account object.
AnswerB

The segment details page surfaces the current total member count alongside publish history, giving the consultant an authoritative view of how many profiles qualify for the published segment without building a separate query or report.

Why this answer

In Data Cloud, the segment details page displays the total member count, publish history, and refresh status for a published segment. This is the authoritative UI location to verify how many profiles currently qualify, because it reflects the last successful segment publish and its resulting membership.

Exam trap

Data 360 Consultant often tests whether candidates know that segment membership lives in Data Cloud DMOs and is surfaced on the segment details page — candidates incorrectly assume CRM SOQL or identity resolution reports can answer segment population questions.

How to eliminate wrong answers

Option A is wrong because Data Stream error logs track ingestion failures and connector issues, not segment membership counts. Option C is wrong because Identity Resolution match history reports show how profiles were unified into unified individuals, not which profiles qualify for a specific segment. Option D is wrong because SOQL queries against the CRM Account object return CRM records, not Data Cloud segment membership — segments operate on Data Cloud Data Model Objects (DMOs), not standard CRM objects.

Practice this question →
83
Multi-Selectmedium

A consultant is preparing to publish a segment to an Activation Target. Which THREE prerequisites must be verified before activation? Choose 3 options.

Select 3 answers
A.Required attribute mappings for the activation are defined.
B.The Data Cloud instance is disconnected from the CRM org.
C.An Activation Target is configured and successfully authenticated with the destination system.
D.The segment has successfully calculated and contains member records.
E.All Data Streams are paused to prevent data modification during publishing.
AnswersA, C, D

Attribute mappings translate segment member data into the destination's expected schema, so activation cannot publish members without them. Verifying these mappings satisfies the prerequisite that the target's required fields are populated before the segment is activated.

Why this answer

Option A is correct because activation requires that the required attribute mappings (the fields/attributes sent to the destination) are defined for the activation; without them the segment data cannot be correctly formatted and delivered. Option C is correct because an Activation Target must be configured and successfully authenticated with the destination system, otherwise Data Cloud cannot establish the connection to publish the segment. Option D is correct because the segment must have successfully calculated and contain member records; an uncalculated or empty segment has no audience to activate.

Option B is incorrect because Data Cloud must be connected to the CRM org (not disconnected) to activate to CRM-based targets. Option E is incorrect because pausing all Data Streams is not a prerequisite; ingestion can continue and pausing streams is not required to publish a segment.

Exam trap

Data 360 Consultant exams often test whether candidates confuse 'prerequisites for activation' with 'operational cautions' — options like pausing streams or disconnecting the CRM sound plausible but are the opposite of what is required.

Practice this question →
84
MCQeasy

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

A.Estimates are only available after the segment has finished its first full publish.
B.Estimated profile counts are displayed directly on the Segment Canvas as criteria are configured.
C.In the Data Cloud Home dashboard metrics widget.
D.In the activation summary report after export.
AnswerB

The Segment Canvas evaluates criteria as configured and surfaces estimated profile counts in real time, letting the consultant gauge audience size before publishing. This satisfies the requirement to preview the estimate without activating the segment, since counts refresh as each rule is added.

Why this answer

The Segment Canvas provides estimated profile counts as criteria are added and modified.

Practice this question →
85
MCQhard

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?

A.Place both Electronics and Apparel filters inside a single related object container for the Order Item object.
B.Use an exclusion container to subtract customers who only bought one category.
C.Write a Calculated Insight because the Segment Canvas cannot evaluate multiple categories per transaction.
D.Place Electronics in one container and Apparel in a separate container, then use an 'AND' operator between the containers.
AnswerA

A single related-object container on Order Item applies both category filters to the same order transaction, so a customer qualifies only when one order contains both Electronics and Apparel items. Separate containers would match purchases across different orders, failing the same-transaction constraint.

Why this answer

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.

Practice this question →
86
MCQeasy

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

A.Data Streams
B.Activation Targets
C.Calculated Insights
D.Segments
AnswerD

Segment definitions are created and managed under the Segments area of Data Cloud Setup, satisfying the stem's requirement to locate the correct setup interface location. This workspace provides the definition builder, publishing controls and membership criteria configuration, letting the consultant author and maintain segments without leaving the setup interface.

Why this answer

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

Practice this question →
87
Multi-Selecthard

A consultant needs to design a Calculated Insight that evaluates customer churn risk based on purchase frequency and support ticket volume. Which THREE best practices should the consultant apply? Choose 3 options.

Select 3 answers
A.Configure the Calculated Insight to stream data updates every second.
B.Leverage incremental processing considerations when writing complex queries to maintain performance.
C.Ensure proper entity relationships and foreign keys are established between the purchase and support DMOs.
D.Map the Calculated Insight directly to an Activation Target without using profile objects.
E.Use ANSI SQL aggregate functions (such as COUNT, SUM, MAX) appropriate for the metrics being evaluated.
AnswersB, C, E

Incremental processing recalculates only changed records rather than reprocessing the full dataset, which directly satisfies the performance constraint for complex churn queries aggregating purchase frequency and support ticket volume. Writing queries with this in mind prevents full recomputation on every run, keeping the Calculated Insight responsive as data volumes grow.

Why this answer

Option B is correct because Calculated Insights in Data Cloud process large volumes of data, so writing complex queries with incremental processing in mind (avoiding full recomputes and unnecessary joins) preserves performance and keeps refresh times acceptable. Option C is correct because the churn-risk calculation must combine purchase frequency and support ticket volume, which requires well-defined entity relationships and foreign keys between the purchase and support DMOs so the query can correctly correlate records per customer. Option E is correct because ANSI SQL aggregate functions such as COUNT, SUM, and MAX are the standard way to compute metrics like purchase frequency and ticket volume within the Calculated Insight's SQL definition.

Option A is not appropriate because streaming updates every second is unnecessary and would create excessive processing overhead for a churn-risk metric that does not need real-time granularity. Option D is not appropriate because Calculated Insights results are typically surfaced through profile objects or data model objects before activation, and mapping directly to an Activation Target bypasses the required data model and identity resolution steps.

Exam trap

Data 360 Consultant exams often test the misconception that Calculated Insights should stream in real time or bypass profile objects, when the correct approach is scheduled/incremental processing with proper DMO relationships and ANSI SQL aggregates.

Practice this question →
88
Multi-Selecthard

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

Select 3 answers
A.Referencing valid timestamp attributes from the mapped DMOs.
B.Accounting for timezone differences when evaluating event timestamps across global regions.
C.Writing custom Java classes to handle leap years.
D.Hardcoding all dates to January 1st of the current year.
E.Using standard ANSI SQL date and timestamp functions supported by the platform.
AnswersA, B, E

Referencing valid timestamp attributes from mapped DMOs ensures date/time functions operate on properly typed, populated fields rather than nulls or strings, satisfying the requirement for accurate metric generation. Invalid or unmapped timestamps cause silent calculation failures or skewed aggregations, so validating the source attribute directly underpins reliable Calculated Insight output.

Why this answer

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.

Exam trap

Data 360 Consultant often tests the misconception that custom code (Java) or hardcoded dates can be used in Calculated Insights, when the platform requires standard ANSI SQL functions over valid DMO timestamp attributes with proper timezone handling.

Practice this question →
89
MCQmedium

A consultant wants to schedule a segment to refresh and publish automatically every day at 2:00 AM. Where is this schedule configured?

A.In the segment publishing schedule options on the Segment details page.
B.In Salesforce CRM Setup under Apex Jobs.
C.In the Identity Resolution ruleset configuration.
D.In the Activation Target settings configuration page.
AnswerA

Scheduling lives on the Segment details page under publishing schedule options, where you set the daily 2:00 AM recurrence and activate automatic refresh and publish. This satisfies the stem's requirement for unattended daily regeneration without manual intervention, since Data 360 handles both the refresh and the publish step from that single schedule.

Why this answer

Segment refresh schedules are configured directly within the Segment details and publishing settings upon creation or by editing an existing segment.

Practice this question →
90
MCQeasy

What happens to an active segment when the underlying Data Model Object schema is modified by removing a field used in the segment criteria?

A.Data Cloud automatically replaces the missing field with a null placeholder.
B.The segment automatically converts into a static segment.
C.The activation target pauses all external data synchronization indefinitely.
D.The segment will fail validation or error during its next publishing cycle.
AnswerD

Removing a field referenced by segment criteria invalidates the segment definition, so the next publishing cycle fails validation and errors. This satisfies the stem's scenario directly: the segment cannot evaluate criteria against a Data Model Object attribute that no longer exists.

Why this answer

If a field used in a segment rule is removed or broken in the DMO schema, the segment validation will fail or the segment will error upon refresh.

Practice this question →
91
MCQhard

An organization runs daily batch segments that take several hours to compute. To improve performance, the consultant decides to optimize the underlying data model relationships. Which practice should the consultant follow?

A.Delete all Identity Resolution rule sets to speed up segment query execution.
B.Ensure proper cardinality (e.g., Many-to-One) and clean foreign key mappings between engagement DMOs and Unified Individual.
C.Convert all batch segments into streaming segments to eliminate processing windows.
D.Disable data stream refresh schedules during segment publishing windows.
AnswerB

Many-to-One cardinality with clean foreign keys between engagement DMOs and Unified Individual lets Data 360 resolve relationships efficiently, cutting the join cost that inflates those multi-hour batch segment runs. Poor cardinality or mismatched keys force expensive lookups, so fixing them directly addresses the performance constraint.

Why this answer

Optimizing relationships involves ensuring proper cardinalities and foreign key indexes are maintained between custom DMOs and standard profile DMOs.

Practice this question →
← PreviousPage 2 of 2 · 91 questions total

Ready to test yourself?

Try a timed practice session using only Segmentation And Insights questions.

Start 20-question session