Segmentation And Insights

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?

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?

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

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?

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?

Which TWO benefits does a Calculated Insight provide in Data Cloud? Choose 2 options.

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?

Which THREE actions can a consultant perform when configuring segment publishing in Data Cloud? (Choose three.)

A consultant is designing a segment that requires filtering based on a Calculated Insight metric (e.g., Total Spend > 500). What type of attribute is used in the Segment Canvas to achieve this?

A consultant is asked to create a segment of customers who live in specific postal codes AND have made a purchase exceeding $100. How should the consultant build this logic in Segment Canvas?

A consultant wants to create a Calculated Insight that calculates the total revenue generated by each customer over the last 12 months, using an ANSI SQL expression in Data Cloud. Which syntax rule must be followed when writing the Calculated Insight?

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?

A consultant has created a complex segment using multiple related objects (Individual -> Order -> Order Product). When publishing the segment, the job fails with a timeout error. What is the most efficient troubleshooting step to resolve this segment publishing failure?

A consultant is troubleshooting a Calculated Insight that aggregates total purchases per customer over the last year. The metric returns incorrect values for several customers. Which THREE factors should the consultant investigate? (Choose three.)

A Data Cloud user needs to export segment membership to an external AWS S3 bucket for use in a third-party BI tool. Which feature should the consultant configure to achieve this export?

A consultant wants to ensure that a segment only includes profiles where the customer's email address is not null and email opt-in is set to true. Where should these filters be applied?

A consultant is preparing to publish a segment to an external SFTP server. The segment contains 500,000 profiles. The consultant needs to ensure the activation is successful and the data is delivered correctly. Which two actions should the consultant take before scheduling the activation? (Choose two.)

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?

Which TWO actions can a consultant perform within the Segment Canvas interface? Choose 2 options.

A marketer needs to target customers who have purchased Product A AND Product B, but have NOT purchased Product C. How should the consultant configure this logic within the Segment Canvas containers?

A consultant is designing a Calculated Insight to track the number of distinct product categories a customer has purchased from over the last 90 days. Which SQL function should be used to count unique categories correctly in Data Cloud?

A consultant is building a segment in Data Cloud that should include only customers whose total lifetime spend exceeds $500. The spend is computed daily by a Calculated Insight named 'Total_Spend_CI'. The consultant notices that when they try to add this Calculated Insight as a filter in the Segment Builder, it is not appearing in the list of available attributes. What is the most likely reason the Calculated Insight is not available?

A consultant needs to create a segment based on customer loyalty tier, which is stored in a Custom Object mapped to the Individual DMO. When building the segment, the loyalty tier attribute is showing as blank for many unified profiles. What should the consultant check first?

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

A marketer needs to target high-value customers in Data Cloud whose total lifetime spend calculated via a Calculated Insight exceeds $10,000. The segment needs to be evaluated continuously as transactions stream into the platform. What is the key limitation the consultant must consider when building this segment?

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

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?

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?

A consultant is designing a segment that should include customers who have spent more than $500 in the last 30 days. The transaction data is stored in a Data Cloud Data Model Object that is updated daily. The consultant wants the segment to refresh every hour to capture recent high-value spenders. Which statement about segment refresh and data latency is accurate?

A consultant is managing segment publishing schedules. Which THREE factors influence when and how batch segments publish? Choose 3 options.

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

A consultant is asked to provide a list of all customers who have opted out of marketing emails. The consultant needs to create a segment that excludes these customers from all future marketing activations. Where should the consultant define the opt-out criteria to ensure it is applied consistently across all segments?

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

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

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?

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

When reviewing the Segment canvas, a consultant notices a metric called 'Publish History'. What information does this metric provide?

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?

Which object type serves as the primary source for building audience segments in Salesforce Data Cloud?

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

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

A consultant needs to create a segment that includes customers who have purchased a product from the 'Electronics' category and also purchased a product from the 'Apparel' category, but these purchases must have occurred within the same calendar month. The purchase data is stored in a single data stream with fields for CustomerId, ProductCategory, and PurchaseDate. How should the consultant model the segment criteria to achieve this?

A Data Cloud Consultant is designing a batch segment that needs to run daily. Which TWO best practices should the consultant follow to ensure optimal performance and avoid processing timeouts? (Choose two.)

A marketing team wants to analyze how many customers are in a segment before publishing it to a downstream system. Where in Data Cloud can the consultant find the segment's member count?

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

A consultant is configuring an activation to Meta (Facebook) Ads. The activation fails because matching criteria require hashed email addresses. How should the consultant resolve this?

A Data Cloud Consultant is building a Calculated Insight using ANSI SQL to calculate the average order value (AOV) per customer. When attempting to save the Calculated Insight, the system throws a validation error regarding the dimensions. What is the most likely cause of this error?

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?

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

A consultant needs to deliver segment membership data to an SFTP server daily. Which component must be configured alongside the segment and activation?

An organization requires a segment that updates continuously in real-time as users perform specific clickstream actions on a website. Which limitation must the Data Cloud consultant keep in mind when designing a streaming segment?

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?

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?

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

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

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

A consultant is setting up batch segments in Salesforce Data Cloud. Which TWO characteristics are true regarding batch segments? Choose 2 options.

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.)

An organization wants to target customers who abandoned their cart more than 24 hours ago but have not completed a purchase since then. How should the consultant configure this time-based criteria in the Segment Canvas?

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?

A consultant needs to troubleshoot a Calculated Insight that is not returning expected results. Which TWO areas should the consultant check? Choose 2 options.

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

An administrator notices that segment counts fluctuate wildly between consecutive batch runs. Which THREE potential root causes should the consultant investigate? Choose 3 options.

A consultant needs to create a segment that includes customers who have not made a purchase in the last 90 days. The purchase data is in the 'Purchase History' DMO. Which approach should the consultant use?

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

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

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

A consultant is designing a segment that needs to include customers who have purchased a specific product in the last 30 days AND have not opened any marketing email in the last 60 days. The email engagement data is stored in a Data Cloud data stream that is mapped to the profile, and purchase data is in another mapped stream. The consultant wants to ensure the segment refreshes daily to reflect the most recent data. Which segment type should the consultant use?

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?

A consultant is auditing an enterprise Data Cloud deployment and finds performance bottlenecks during segment publishing. Which THREE architectural adjustments can help resolve performance issues? Choose 3 options.

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?

When configuring a streaming segment in Data Cloud, which THREE limitations or considerations must a consultant keep in mind? Choose 3 options.

An enterprise has millions of unified profiles. A complex segment with multiple nested criteria and calculated insights takes an excessively long time to publish. What is a recommended best practice to improve publishing performance?

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?

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

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 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?

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 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 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 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?

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

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

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 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?

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

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.

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

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

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

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?