Data 360 Consultant Segmentation And Insights — All Questions With Answers

Question 1mediummultiple choice

Read the full Segmentation And Insights explanation →

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days and have an active subscription. However, the purchase data updates in real time via streaming ingestion, while the subscription data is batch-loaded nightly. Which segment type and refresh strategy should the consultant configure?

Question 2hardmultiple choice

Read the full Segmentation And Insights explanation →

An enterprise is running multiple batch segments that refresh daily. Due to downstream dependency requirements, Segment B must only evaluate after Segment A has finished its publishing run. How should the consultant orchestrate this dependency in Data Cloud?

Question 3hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 4mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 5hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 6mediummultiple choice

Read the full Segmentation And Insights explanation →

A consultant wants to share audience segment data with an external marketing system that requires real-time API lookups rather than bulk file exports. Which Data Cloud feature should the consultant leverage alongside segmentation?

Question 7mediummultiple choice

Read the full Segmentation And Insights explanation →

A consultant wants to create a segment of customers who have not opened any marketing emails in the last 6 months. Which segmentation container type should be used?

Question 8hardmultiple choice

Read the full Segmentation And Insights explanation →

An administrator notices that a streaming segment is failing to publish updates despite new data flowing into the underlying Data Lake Object. What is the most likely cause?

Question 9easymultiple choice

Read the full Segmentation And Insights explanation →

Which user permission is required to create and publish audience segments in Data Cloud?

Question 10hardmultiple choice

Read the full Segmentation And Insights explanation →

A multinational company needs segments to evaluate rules based on local time zones rather than UTC. How should the consultant configure date-based segment criteria to account for time zone differences?

Question 11easymulti select

Read the full Segmentation And Insights explanation →

Which TWO destination types are officially supported for publishing Data Cloud segments via Activation Targets? Choose 2 options.

Question 12mediummulti select

Read the full Segmentation And Insights explanation →

A consultant needs to segment customers based on whether they have purchased specific product categories. The data model includes Unified Individual, Unified Contact Point, Sales Order DMO, and Product DMO. Which THREE strategies should the consultant employ? Choose 2 options. (Wait, prompt says THREE for half, let's provide 3 correct options). Choose 3 options.

Question 13easymultiple choice

Read the full Segmentation And Insights explanation →

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days. Which type of segment should be used to ensure the membership updates automatically on a scheduled basis?

Question 14mediummultiple choice

Read the full Segmentation And Insights explanation →

An organization has configured a segment that includes unified individuals with an open support case. The segment is set to publish daily. However, support agents report that customers who resolved their cases hours before the scheduled publish are still receiving targeted marketing campaigns. How should the consultant redesign this segmentation approach?

Question 15hardmultiple choice

Read the full Segmentation And Insights explanation →

An enterprise marketing team needs to publish a segment containing 50 million profiles to an external activation target every morning at 6:00 AM. The data activation job consistently fails due to timeout errors. Which architectural adjustment should the consultant implement?

Question 16mediummultiple choice

Read the full Segmentation And Insights explanation →

A consultant is creating a segment that targets individuals who belong to either 'Segment A' or 'Segment B', but explicitly excludes members of 'Segment C'. How should this be constructed on the Segmentation Canvas?

Question 17easymultiple choice

Read the full Segmentation And Insights explanation →

A consultant needs to create a segment based on a specific product category purchased by customers. Which Data Cloud feature allows the consultant to traverse from the Unified Individual object down to the Sales Order and Product objects to define this criteria?

Question 18hardmulti select

Read the full Segmentation And Insights explanation →

A consultant needs to create a segment that identifies customers who have purchased both 'Electronics' and 'Apparel' categories in the last 30 days. The purchase data is stored in a single DMO with a Category field. Which two approaches are valid for building this segment in Data Cloud? (Choose two.)

Question 19hardmultiple choice

Read the full Segmentation And Insights explanation →

A consultant needs to create a segment that identifies customers who have purchased both 'Premium' and 'Basic' subscription tiers in the last 12 months. The data model includes a unified individual profile linked to multiple subscription records via a related object. The consultant wants to ensure the segment includes only customers who have at least one Premium subscription and at least one Basic subscription within the same 12-month period. Which approach should the consultant use?

Question 20hardmultiple choice

Read the full Segmentation And Insights explanation →

A consultant is building a segment that uses a Calculated Insight (CI) named 'Total_Spend_CI' which aggregates purchase amounts per customer. The CI is scheduled to refresh daily at 1:00 AM. The segment is scheduled to refresh daily at 2:00 AM. The consultant notices that the segment's member count does not reflect the latest purchases from the previous day. What is the most likely reason?

Question 21hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 22hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 23mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 24easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 25easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 26mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 27easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 28mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 29mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 30mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 31hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 32mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 33easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 34hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 35mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 36hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 37easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 38hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 39mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 40hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 41hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 42mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 43mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 44mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 45easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 46hardmultiple choice

Read the full Segmentation And Insights explanation →

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

Question 47easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 48mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 49hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 50mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 51easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 52hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 53mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 54hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 55mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 56hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 57mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 58mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 59hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 60easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 61mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 62hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 63easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 64hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 65easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 66mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 67easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 68mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 69hardmultiple choice

Read the full Segmentation And Insights explanation →

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

Question 70easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 71mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 72hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 73easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 74mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 75hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 76easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 77mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 78hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 79easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 80mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 81mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 82hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 83easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 84easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 85mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 86hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 87mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 88easymulti select

Read the full Segmentation And Insights explanation →

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

Question 89mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 90hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 91easymulti select

Read the full Segmentation And Insights explanation →

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

Question 92mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 93easymulti select

Read the full Segmentation And Insights explanation →

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

Question 94hardmulti select

Read the full Segmentation And Insights explanation →

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.

Question 95mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 96hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 97hardmulti select

Read the full Segmentation And Insights explanation →

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.

Question 98mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 99hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 100mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 101hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 102easymulti select

Read the full Segmentation And Insights explanation →

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

Question 103mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 104hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 105easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 106mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 107hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 108mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 109easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 110mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 111mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 1mediummultiple choice

Read the full Segmentation And Insights explanation →

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days and have an active subscription. However, the purchase data updates in real time via streaming ingestion, while the subscription data is batch-loaded nightly. Which segment type and refresh strategy should the consultant configure?

Question 2hardmultiple choice

Read the full Segmentation And Insights explanation →

An enterprise is running multiple batch segments that refresh daily. Due to downstream dependency requirements, Segment B must only evaluate after Segment A has finished its publishing run. How should the consultant orchestrate this dependency in Data Cloud?

Question 3hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 4mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 5hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 6mediummultiple choice

Read the full Segmentation And Insights explanation →

A consultant wants to share audience segment data with an external marketing system that requires real-time API lookups rather than bulk file exports. Which Data Cloud feature should the consultant leverage alongside segmentation?

Question 7mediummultiple choice

Read the full Segmentation And Insights explanation →

A consultant wants to create a segment of customers who have not opened any marketing emails in the last 6 months. Which segmentation container type should be used?

Question 8hardmultiple choice

Read the full Segmentation And Insights explanation →

An administrator notices that a streaming segment is failing to publish updates despite new data flowing into the underlying Data Lake Object. What is the most likely cause?

Question 9easymultiple choice

Read the full Segmentation And Insights explanation →

Which user permission is required to create and publish audience segments in Data Cloud?

Question 10hardmultiple choice

Read the full Segmentation And Insights explanation →

A multinational company needs segments to evaluate rules based on local time zones rather than UTC. How should the consultant configure date-based segment criteria to account for time zone differences?

Question 11easymulti select

Read the full Segmentation And Insights explanation →

Which TWO destination types are officially supported for publishing Data Cloud segments via Activation Targets? Choose 2 options.

Question 12mediummulti select

Read the full Segmentation And Insights explanation →

A consultant needs to segment customers based on whether they have purchased specific product categories. The data model includes Unified Individual, Unified Contact Point, Sales Order DMO, and Product DMO. Which THREE strategies should the consultant employ? Choose 2 options. (Wait, prompt says THREE for half, let's provide 3 correct options). Choose 3 options.

Question 13easymultiple choice

Read the full Segmentation And Insights explanation →

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days. Which type of segment should be used to ensure the membership updates automatically on a scheduled basis?

Question 14mediummultiple choice

Read the full Segmentation And Insights explanation →

An organization has configured a segment that includes unified individuals with an open support case. The segment is set to publish daily. However, support agents report that customers who resolved their cases hours before the scheduled publish are still receiving targeted marketing campaigns. How should the consultant redesign this segmentation approach?

Question 15hardmultiple choice

Read the full Segmentation And Insights explanation →

An enterprise marketing team needs to publish a segment containing 50 million profiles to an external activation target every morning at 6:00 AM. The data activation job consistently fails due to timeout errors. Which architectural adjustment should the consultant implement?

Question 16mediummultiple choice

Read the full Segmentation And Insights explanation →

A consultant is creating a segment that targets individuals who belong to either 'Segment A' or 'Segment B', but explicitly excludes members of 'Segment C'. How should this be constructed on the Segmentation Canvas?

Question 17easymultiple choice

Read the full Segmentation And Insights explanation →

A consultant needs to create a segment based on a specific product category purchased by customers. Which Data Cloud feature allows the consultant to traverse from the Unified Individual object down to the Sales Order and Product objects to define this criteria?

Question 18hardmulti select

Read the full Segmentation And Insights explanation →

A consultant needs to create a segment that identifies customers who have purchased both 'Electronics' and 'Apparel' categories in the last 30 days. The purchase data is stored in a single DMO with a Category field. Which two approaches are valid for building this segment in Data Cloud? (Choose two.)

Question 19hardmultiple choice

Read the full Segmentation And Insights explanation →

A consultant needs to create a segment that identifies customers who have purchased both 'Premium' and 'Basic' subscription tiers in the last 12 months. The data model includes a unified individual profile linked to multiple subscription records via a related object. The consultant wants to ensure the segment includes only customers who have at least one Premium subscription and at least one Basic subscription within the same 12-month period. Which approach should the consultant use?

Question 20hardmultiple choice

Read the full Segmentation And Insights explanation →

A consultant is building a segment that uses a Calculated Insight (CI) named 'Total_Spend_CI' which aggregates purchase amounts per customer. The CI is scheduled to refresh daily at 1:00 AM. The segment is scheduled to refresh daily at 2:00 AM. The consultant notices that the segment's member count does not reflect the latest purchases from the previous day. What is the most likely reason?

Question 21hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 22hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 23mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 24easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 25easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 26mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 27easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 28mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 29mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 30mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 31hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 32mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 33easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 34hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 35mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 36hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 37easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 38hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 39mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 40hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 41hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 42mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 43mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 44mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 45easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 46hardmultiple choice

Read the full Segmentation And Insights explanation →

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

Question 47easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 48mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 49hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 50mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 51easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 52hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 53mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 54hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 55mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 56hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 57mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 58mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 59hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 60easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 61mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 62hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 63easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 64hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 65easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 66mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 67easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 68mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 69hardmultiple choice

Read the full Segmentation And Insights explanation →

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

Question 70easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 71mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 72hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 73easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 74mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 75hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 76easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 77mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 78hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 79easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 80mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 81mediummultiple choice

Read the full Segmentation And Insights explanation →

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

Question 82hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 83easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 84easymultiple choice

Read the full Segmentation And Insights explanation →

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

Question 85mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 86hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 87mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 88easymulti select

Read the full Segmentation And Insights explanation →

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

Question 89mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 90hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 91easymulti select

Read the full Segmentation And Insights explanation →

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

Question 92mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 93easymulti select

Read the full Segmentation And Insights explanation →

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

Question 94hardmulti select

Read the full Segmentation And Insights explanation →

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.

Question 95mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 96hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 97hardmulti select

Read the full Segmentation And Insights explanation →

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.

Question 98mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 99hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 100mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 101hardmulti select

Read the full Segmentation And Insights explanation →

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

Question 102easymulti select

Read the full Segmentation And Insights explanation →

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

Question 103mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 104hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 105easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 106mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 107hardmultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 108mediummulti select

Read the full Segmentation And Insights explanation →

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

Question 109easymultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 110mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Question 111mediummultiple choice

Read the full Segmentation And Insights explanation →

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?

Data 360 Consultant Segmentation And Insights — All Questions With Answers

An enterprise is running multiple batch segments that refresh daily. Due to downstream dependency requirements, Segment B must only evaluate after Segment A has finished its publishing run. How should the consultant orchestrate this dependency in Data Cloud?

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

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

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

A consultant wants to share audience segment data with an external marketing system that requires real-time API lookups rather than bulk file exports. Which Data Cloud feature should the consultant leverage alongside segmentation?

A consultant wants to create a segment of customers who have not opened any marketing emails in the last 6 months. Which segmentation container type should be used?

An administrator notices that a streaming segment is failing to publish updates despite new data flowing into the underlying Data Lake Object. What is the most likely cause?

Which user permission is required to create and publish audience segments in Data Cloud?

A multinational company needs segments to evaluate rules based on local time zones rather than UTC. How should the consultant configure date-based segment criteria to account for time zone differences?

Which TWO destination types are officially supported for publishing Data Cloud segments via Activation Targets? Choose 2 options.

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days. Which type of segment should be used to ensure the membership updates automatically on a scheduled basis?

An enterprise marketing team needs to publish a segment containing 50 million profiles to an external activation target every morning at 6:00 AM. The data activation job consistently fails due to timeout errors. Which architectural adjustment should the consultant implement?

A consultant is creating a segment that targets individuals who belong to either 'Segment A' or 'Segment B', but explicitly excludes members of 'Segment C'. How should this be constructed on the Segmentation Canvas?

A consultant needs to create a segment based on a specific product category purchased by customers. Which Data Cloud feature allows the consultant to traverse from the Unified Individual object down to the Sales Order and Product objects to define this criteria?

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?

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

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

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?

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

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?

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

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 wants to schedule a segment to refresh and publish automatically every day at 2:00 AM. Where is this schedule configured?

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

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

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

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

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

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

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

Which TWO statements are true regarding segment publishing schedules? (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?

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

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?

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

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?

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?

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

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

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

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?

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

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

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

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

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?

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

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?

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?

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

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?

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?

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?

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?

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?

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

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

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?

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?

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?

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?

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

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

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 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 needs to deliver segment membership data to an SFTP server daily. Which component must be configured alongside the segment and activation?

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?

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

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

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 configuring an activation to Meta (Facebook) Ads. The activation fails because matching criteria require hashed email addresses. How should the consultant resolve this?

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 setting up batch segments in Salesforce Data Cloud. Which TWO characteristics are true regarding batch segments? Choose 2 options.

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