Data 360 Consultant Practice Test 23 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Use relative date filters or calculated insights that normalize timestamps to local time before evaluation.. When evaluating date/time attributes in segments, understanding how Data Cloud stores timestamps in UTC and configuring appropriate relative date filters is crucial.

Answer

Configure Activation Targets to automatically shift timestamps by the recipient's UTC offset.

Answer

Modify the Data Lake Object primary key data type from Timestamp to Text.

Answer

Change the Data Cloud instance timezone setting in Setup.

Question 2

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

Accepted Answer

Manage Segments permission. Specific permissions such as Data Cloud Segment Admin or equivalent user permissions are required to manage segments.

Answer

Manage Activation Targets

Answer

Modify All Data on Data Streams

Answer

Configure Identity Resolution

Question 3

A consultant is designing a data model in Salesforce Data Cloud and needs to establish relationships between custom Data Model Objects (DMOs). Which TWO rules apply when creating relationships between DMOs in Data Cloud?

Accepted Answer

Relationships can be established as Many-to-One (N:1) or One-to-One (1:1).. When creating relationships in Data Cloud, relationships can be N:1 or 1:1, and the participating fields must share compatible data types and properties to ensure referential integrity during segmentation and querying.

Answer

Standard DMOs cannot participate in relationships with custom DMOs.

Answer

Relationships between DMOs can only be established using SQL queries in Calculated Insights.

Answer

Many-to-Many (N:N) relationships can be created directly between any two DMOs without a junction object.

Question 4

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

Accepted Answer

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

Answer

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

Answer

CASE statements can only reference dimensions, never measures.

Answer

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

Question 5

When mapping Data Source Objects (DSOs) to Data Model Objects (DMOs) in Salesforce Data Cloud, which TWO best practices should a consultant follow?

Accepted Answer

Ensure primary keys and foreign keys are correctly mapped to maintain relational integrity.. Best practices for data mapping include mapping required primary and foreign keys accurately and utilizing standard Cloud Information Model (CIM) objects whenever applicable before creating custom DMOs.

Answer

Always map every single source field from the DSO, regardless of whether it is needed.

Answer

Bypass mapping DSOs entirely and map Data Streams straight to Activation Targets.

Answer

Create a separate custom DMO for every individual attribute column in the source file.

Question 6

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

Accepted Answer

Incorporate related engagement attributes and calculated insights into segment rules.. Segment Canvas allows users to build audience segments by combining profile attributes, engagement data, and exclusion rules.

Answer

Establish real-time API connections to external advertising platforms.

Answer

Configure Identity Resolution matching rules and precedence settings.

Answer

Create and schedule raw Data Lake Object ingestion jobs.

Question 7

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?

Accepted Answer

Calculated Insight attributes related to the Unified Individual.. Calculated Insight objects appear as related attributes or direct attributes on the Unified Individual once mapped, allowing them to be dragged into segment containers.

Answer

Identity Resolution rule set parameters.

Answer

Activation Target schema fields.

Answer

Data Lake Object raw event logs.

Question 8

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?

Accepted Answer

Streaming segments do not support criteria based on Calculated Insights.. Streaming segments do not support Calculated Insights as part of their criteria rules; Calculated Insights are typically used in batch or scheduled segments.

Answer

Calculated Insights require manual execution before every segment publish.

Answer

Calculated Insights cannot be referenced in any segment definition in Data Cloud.

Answer

Calculated Insights only refresh once per month, preventing timely segmentation.

Question 9

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

Accepted Answer

During its next scheduled publish run, the segment evaluates the updated data and refreshes its audience membership.. When a batch segment runs according to its publishing schedule, it evaluates against the latest data available in the Data Model Objects.

Answer

The data updates are ignored until the yearly platform upgrade occurs.

Answer

The segment automatically deletes itself and must be rebuilt from scratch.

Answer

The segment pauses all publishing until an administrator manually re-approves the rules.

Question 10

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?

Accepted Answer

Configure activation publishing with partial batch processing and optimize the segment criteria to reduce unnecessary attribute retrieval.. For large activation volumes, segment publishing can be optimized by reviewing activation membership criteria, chunking activations, or ensuring proper indexing and segment design.

Answer

Change the Data Model relationships from Inner Join to Outer Join on the segment criteria.

Answer

Convert the segment into a static file export executed manually via API.

Answer

Switch the segment to a streaming segment to distribute the activation load throughout the day.

Question 11

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

Accepted Answer

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

Answer

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

Answer

By modifying the Identity Resolution ruleset match keys.

Answer

By writing an Apex trigger in Salesforce CRM.

Question 12

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?

Accepted Answer

The query includes a dimension that is not part of the Profile DMO space or properly related via a foreign key.. Calculated Insights require dimensions to be mapped correctly using primary and foreign keys from the Data Model, and mixing unaggregated non-measure fields without proper GROUP BY clauses will cause validation failures.

Answer

Calculated Insights only support Standard SQL and do not permit aggregate functions like AVG().

Answer

The AOV result is stored as a text field instead of a numerical measure.

Answer

The query references a streaming data model object directly without a time window.

Question 13

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?

Accepted Answer

Optimize the segment criteria by reducing unnecessary related object hops and ensuring data model relationships are correctly mapped.. Segment publishing performance can degrade when querying deeply nested or unindexed relationships across massive data volumes. Simplifying the segment criteria, ensuring proper relationships and indexes exist on the underlying DMOs, or breaking the segment into smaller logical parts are recommended troubleshooting steps.

Answer

Rebuild the segment using a Calculated Insight instead of related object filters.

Answer

Convert the segment into a streaming segment to bypass the batch publishing engine.

Answer

Increase the Data Cloud tenant storage limit to allow more memory for processing.

Question 14

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?

Accepted Answer

The Calculated Insight has not been published or does not include the Individual DMO as a dimension.. Calculated Insights must be published and include the Individual or Profile dimension in order to be used in segmentation. If the CI does not include the primary DMO (like Individual) or has not been successfully processed and published, it will not appear as an attribute in the Segment Canvas.

Answer

Calculated Insights can only be used in segments if they are aggregated over a streaming DMO.

Answer

The user creating the segment lacks permission to view Calculated Insights metadata.

Answer

Calculated Insights must be converted to a Data Graph before they can be referenced in segmentation.

Question 15

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

Accepted Answer

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

Answer

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

Answer

Calculated Insights automatically override and delete underlying Data Lake Objects.