Data 360 Consultant Practice Test 25 — 15 Questions

Question 1

An administrator is setting up a new Salesforce CRM data stream and wants to filter out inactive contacts during the ingestion process to save storage. Where can the administrator configure data filtering?

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

Accepted Answer

Apply filter criteria during the Data Stream creation wizard under the filter step.. Data streams support filter criteria during the data stream creation wizard or configuration, allowing administrators to filter records before ingestion.

Answer

Create a Sharing Rule in CRM to block inactive contacts from syncing.

Answer

Write an Apex trigger on the Data Model Object after ingestion.

Answer

Configure a validation rule in Salesforce CRM Setup.

Question 2

An administrator needs to ensure that users across different regions can only access segments created within their designated Data Space. How should the administrator configure segment creation?

Accepted Answer

Create the segments while logged into the specific Data Space context.. Segments are created within the context of a specific Data Space. Administrators and users must select the appropriate Data Space when building segments.

Answer

Assign the Global Segment Administrator permission set to all users.

Answer

Apply a global filter in the Segment canvas referencing the user's region profile.

Answer

Configure sharing rules on the Segment DMO in Object Manager.

Question 3

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?

Accepted Answer

Refine the segment criteria to narrow historical date ranges and simplify complex multi-level container nesting.. When segments hit resource limits due to extreme complexity and historical data scope, optimizing the criteria by shortening date ranges (e.g., focusing on active recent windows) and simplifying container nesting prevents memory exhaustion.

Answer

Switch the segment to run every 1 minute to process smaller chunks.

Answer

Delete all Activation Targets in the tenant.

Answer

Re-map all data streams to use CSV format.

Question 4

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 used to build audience segments based on profile, engagement, and related object attributes in Data Cloud.

Answer

Identity Resolution

Answer

Activation Target

Answer

Calculated Insights

Question 5

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?

Accepted Answer

The query is missing a GROUP BY clause corresponding to the primary key of the target entity.. Calculated Insights require proper grouping and aggregation matching the primary key of the target data model object, such as Unified Individual.

Answer

Calculated Insights only support Standard SQL, not ANSI SQL.

Answer

The metric name contains spaces or special characters.

Answer

The query references fields from more than three distinct data streams simultaneously.

Question 6

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?

Accepted Answer

Activation Target. An Activation Target defines the destination system and authentication parameters required to publish segments externally.

Answer

Data Action Target

Answer

Ingestion API Source

Answer

Connected App Framework

Question 7

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

Accepted Answer

SFTP Activation Target. An SFTP Activation Target must be configured with connection details, credentials, and file format settings to deliver segment files.

Answer

Ingestion API SFTP Endpoint

Answer

Data Action SFTP Connector

Answer

Marketing Cloud FTP Bridge

Question 8

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

Accepted Answer

To publish segment membership data and attributes to destination activation targets.. Activations publish segment membership data to downstream destination targets for marketing and engagement.

Answer

To merge duplicate customer records into unified profiles.

Answer

To calculate aggregated business metrics across engagement history.

Answer

To ingest raw data files from external cloud storage.

Question 9

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?

Accepted Answer

Ensure the activation mapping utilizes supported identifier fields (such as hashed emails) or leverage transformation features required by the destination platform.. Data Cloud supports transforming or mapping attributes, or utilizing calculated insights/standard activation features to ensure hashed identifiers are supplied to ad platforms like Meta.

Answer

Create a static CSV file and upload it manually via Email Studio.

Answer

Delete all Identity Resolution rules so raw unhashed emails are transmitted.

Answer

Convert the segment into a streaming segment to bypass Meta's validation requirements.

Question 10

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

Accepted Answer

They evaluate all unified profiles against the defined criteria during each run.. Batch segments evaluate criteria across all unified profiles on a scheduled recurring basis.

Answer

They update audience membership in near real-time as individual events stream in.

Answer

They cannot be used with Activation Targets.

Answer

They are restricted to a maximum of 1,000 profiles per segment.

Question 11

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

Accepted Answer

Ensure the Calculated Insight output is mapped to the appropriate profile data model objects if used for segmentation.. Troubleshooting Calculated Insights involves validating SQL syntax/aggregations and ensuring correct profile mappings.

Answer

Verify that the Activation Target authorization token is active.

Answer

Check that the underlying Data Stream ingestion schedule is set to streaming mode.

Answer

Confirm that the Segment Canvas refresh schedule matches the Calculated Insight run time.

Question 12

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

Accepted Answer

Streaming segments have limitations on complex multi-object joins and certain SQL operators compared to batch segments.. Streaming segments have specific criteria limitations, rely on streaming-enabled data streams, and support specific operators compared to batch segments.

Answer

Streaming segments are restricted to a maximum refresh frequency of once every 24 hours.

Answer

Streaming segments can only be published to Marketing Cloud Engagement and no other targets.

Question 13

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

Accepted Answer

Required attribute mappings for the activation are defined.. Successful activation requires an active target connection, mapped attributes, and a published segment.

Answer

The Data Cloud instance is disconnected from the CRM org.

Answer

All Data Streams are paused to prevent data modification during publishing.

Question 14

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.

Accepted Answer

Leverage incremental processing considerations when writing complex queries to maintain performance.. Designing robust Calculated Insights involves proper metric definitions, efficient SQL writing, and appropriate object selection.

Answer

Configure the Calculated Insight to stream data updates every second.

Answer

Map the Calculated Insight directly to an Activation Target without using profile objects.

Question 15

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

Accepted Answer

The configured segment refresh frequency (e.g., daily, weekly).. Batch segment publishing is governed by segment refresh schedules, upstream data freshness, and manual triggers.

Answer

The physical geographical location of the Activation Target server.

Answer

The real-time clickstream event rate exceeding 100,000 events per second.