Data 360 Consultant Practice Test 26 — 15 Questions

Question 1

A consultant has created a custom Data Model Object and mapped several fields. The client now requests to delete one of the mapped fields from the custom DMO. What prerequisite must the consultant perform before deleting the field?

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

Accepted Answer

Remove all field mappings, Calculated Insights, and segment filters referencing that field.. Before deleting a field from a DMO, any dependencies such as field mappings from DSOs, Calculated Insights, or Segment filters referencing that field must be removed.

Answer

Export all historical data to Amazon S3 as a backup.

Answer

Restart the Kafka broker cluster.

Answer

Deactivate the entire Data Cloud instance for 24 hours.

Question 2

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?

Accepted Answer

Use Segment Canvas related object criteria with a count aggregate on the web visit DMO filtered by the last 7 days.. Using related object attributes with aggregate count functions within the Segment Canvas allows filtering based on engagement frequency.

Answer

Create a static segment and manually import website visitor IDs weekly.

Answer

Configure a Data Action Target to trigger alerts on every web visit.

Answer

Build an Ingestion API to pre-filter website visits before they enter Data Cloud.

Question 3

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 4

What happens when a segment is recalculated in Data Cloud regarding its associated activations?

Accepted Answer

Associated activations update their membership list based on the newly recalculated segment during their next scheduled run.. When a segment is recalculated, existing activations associated with that segment reflect the updated audience membership upon their next scheduled activation run.

Answer

The activation target loses its authentication credentials.

Answer

Activations are published immediately in real-time regardless of their schedule.

Answer

Associated activations are automatically deleted and must be recreated from scratch.

Question 5

When creating an activation for an advertising platform like Google Ads, what is the primary purpose of defining Contact Points within the activation?

Accepted Answer

To map identifiers like hashed emails or phone numbers required by the ad network for matching.. Contact points (such as hashed email addresses or phone numbers) are required by ad platforms for identity resolution and matching user profiles.

Answer

To define the geographic region where ads will be displayed.

Answer

To store billing information for the ad spend.

Answer

To determine how often the ad platform refreshes the audience.

Question 6

A consultant is creating an activation for an advertising network that requires phone numbers in E.164 format. The raw data in Data Cloud has various phone number formats. Where should the consultant address this formatting requirement?

Accepted Answer

Use Data Transforms during the ingestion and data modeling phase to standardize phone numbers into E.164 format.. Data cleansing, transformation, and standardization should occur upstream using Data Transforms during ingestion or via Calculated Insights before segment creation and activation.

Answer

Rely on the ad network to automatically parse and format messy phone numbers.

Answer

Write an activation-level formula field using unsupported custom SQL.

Answer

Configure a formatting mask in the Activation Target properties menu.

Question 7

When configuring Data Actions and Data Action Targets, which THREE settings or properties must be defined? (Choose three.)

Accepted Answer

The Data Action Target endpoint URL and authentication parameters.. Option B is correct because a Data Action Target must specify the external endpoint URL it calls and the authentication parameters (such as credentials or tokens) needed to reach that endpoint securely. Option D is correct because Data Actions require payload field mappings and/or filters that define which data is sent and the conditions under which the action fires. Option E is correct because a Data Action must be tied to a triggering Source Event or Data Stream/Transform that supplies the data and initiates the action. Option A is not required, since Data Actions are event-driven rather than defined by a scheduled batch refresh frequency. Option C is not required, as Identity Resolution match rule thresholds belong to identity resolution setup, not to Data Action or Data Action Target configuration.

Answer

The scheduled batch refresh frequency (e.g., nightly at midnight).

Answer

The Identity Resolution match rule threshold percentage.

Question 8

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?

Accepted Answer

Place postal code criteria and purchase amount criteria in the same inclusion container with an 'AND' operator.. In Segment Canvas, combining different attribute types (like postal code from a profile and purchase amount from a transaction) requires placing both criteria in the same inclusion container with an AND operator. This ensures the segment includes only customers who satisfy both conditions simultaneously.

Answer

Write a custom Apex trigger to evaluate postal codes against order totals.

Answer

Build two separate segments and export them to Excel to find the intersection.

Answer

Use an exclusion container for the postal codes and an inclusion container for the purchases.

Question 9

Which TWO objects are core components directly involved in the output of an Identity Resolution ruleset in Salesforce Data Cloud? Choose 2 options.

Accepted Answer

Unified Link Individual object. The Identity Resolution ruleset's output is materialized in the Unified Individual DMO (option D), which stores the consolidated, golden-record profile built from matched source profiles, and in the Unified Link Individual object (option B), which stores the match/relationship links between the unified profile and the individual source records that were reconciled into it. These two objects are the direct artifacts produced when the ruleset runs, enabling downstream segmentation and activation on a single resolved identity. The Activation Target object (option A) is a downstream activation configuration, not an output of identity resolution, and the Ingestion Data Stream object (option C) is an input source of data feeding Data Cloud. The Calculated Insight definition table (option E) is a separate analytics/derived-metric construct and is not generated by the identity resolution ruleset.

Answer

Activation Target object

Answer

Ingestion Data Stream object

Answer

Calculated Insight definition table

Question 10

Which THREE configuration options must be validated when setting up a Source Sequence reconciliation rule? Choose 3 options.

Accepted Answer

Ensuring participating data sources are correctly identified and mapped in the ruleset scope.. Option C is correct because a Source Sequence rule only works when the participating data sources are properly identified and mapped within the ruleset scope, so the engine knows which sources contribute to the attribute. Option D is correct because the Source Sequence reconciliation rule must be explicitly selected for the specific attribute being reconciled; otherwise the attribute will use a different reconciliation strategy. Option E is correct because Source Sequence relies on a defined priority order of the contributing data sources, which determines which source's value wins when values conflict. Option A is not required, since Source Sequence does not depend on custom SQL string-length calculations. Option B is not required, because OAuth token configuration for external S3 buckets is unrelated to defining a Source Sequence reconciliation rule.

Answer

Writing a custom SQL query to calculate string lengths.

Answer

Configuring OAuth authentication tokens for external S3 buckets.

Question 11

An organization uses Data Cloud to manage customer activations across multiple cloud storage buckets and marketing platforms. They need to audit which user published a specific activation and when. Where can an administrator find this detailed audit trail?

Accepted Answer

Salesforce Event Monitoring and Data Cloud audit event logs.. Salesforce Event Monitoring captures Data Cloud audit events, including activation publish actions, and records the user, timestamp, and details of the operation. Administrators can query these events via Event Monitoring's log files or the Data Cloud audit event logs to determine who published a specific activation and when. This is the authoritative audit trail for user-initiated actions in Data Cloud.

Answer

The Identity Resolution match rules summary report.

Answer

The Data Stream refresh history dashboard.

Answer

The Connected App access token expiration log.

Question 12

Which THREE symptoms or error logs indicate an issue with an activation target connection or authentication? (Choose three.)

Accepted Answer

Connection timeout errors when attempting to reach the external endpoint.. Option B is correct because connection timeout errors when attempting to reach the external endpoint directly indicate that the activation target cannot establish a network connection, which is a classic symptom of a connectivity problem between the platform and the destination. Option C is correct because HTTP 401 Unauthorized and HTTP 403 Forbidden responses in the activation history log are explicit authentication and authorization failures returned by the external endpoint, showing that credentials are missing, invalid, or lack permission. Option E is correct because invalid OAuth token or expired Client Secret notifications are direct authentication errors indicating that the credentials used to authenticate to the activation target are no longer valid and must be refreshed. Option A does not belong because Identity Resolution match rule confidence scores relate to data stitching and identity graph quality, not to outbound activation connectivity or authentication. Option D does not belong because slow segment recalculation due to large record counts is a processing performance issue, not a connection or authentication failure with an activation target.

Answer

Identity Resolution match rule confidence score falling below threshold.

Answer

Segment recalculation taking longer than expected due to large record counts.

Question 13

A financial services company needs to trigger a real-time webhook when a customer's fraud risk score exceeds a specific threshold in Data Cloud. Which feature should the consultant configure to achieve this?

Accepted Answer

Data Action and Data Action Target. Data Actions in Data Cloud are designed to trigger real-time, event-driven workflows when specific conditions are met, such as a fraud risk score exceeding a threshold. A Data Action Target defines the external endpoint (e.g., a webhook URL) to which the action sends data. Together, they enable immediate, automated responses without batch delays.

Answer

Calculated Insights batch job with an automated email alert

Answer

Segment Activation to Marketing Cloud Engagement

Answer

Salesforce Flow triggered by a scheduled report export

Question 14

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?

Accepted Answer

Segment Canvas. Segment Canvas is the dedicated tool in Data Cloud for building audience segments using a drag-and-drop interface. It allows filtering on unified profile data, including purchase history, to create a segment of customers who purchased in the last 30 days. This directly matches the requirement to build an audience based on a time-bound purchase condition.

Answer

Identity Resolution

Answer

Activation Target

Answer

Calculated Insights

Question 15

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?

Accepted Answer

SUM(amount) OVER (PARTITION BY individual_id ORDER BY transaction_date). Running totals in SQL are computed with a window function: SUM(amount) OVER (PARTITION BY individual_id ORDER BY transaction_date). The OVER clause with PARTITION BY and ORDER BY creates a cumulative sum per individual as rows are processed in timestamp order. This is standard ANSI SQL and is how Data Cloud Calculated Insights express running totals.

Answer

TOTAL_ACCUMULATOR(amount)

Answer

RUNNING_TOTAL(amount, transaction_date)

Answer

CUMULATIVE_SUM() function without arguments.