Data 360 Consultant Practice Test 2 — 30 Questions

Question 1

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?

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

Accepted Answer

Simplify container hierarchies, pre-compute complex aggregations via Calculated Insights, and avoid excessive nested OR conditions.. Simplifying container logic, reducing unnecessary nested sub-queries, and leveraging pre-computed Calculated Insights efficiently speeds up batch publishing.

Answer

Delete and recreate the Activation Target daily.

Answer

Switch the segment from batch to streaming mode.

Answer

Disable all data stream schema validation rules.

Question 2

A company needs to isolate data ingestion, segmentation, and activation for two distinct business units (Retail and B2B) within a single Data Cloud instance to ensure data governance and security. Which feature should the consultant implement?

Accepted Answer

Data Spaces. Data Spaces allow you to partition data, metadata, and activation targets within a single Data Cloud instance to ensure logical separation for different business units.

Answer

Identity Resolution Rulesets

Answer

Data Streams

Answer

Permission Sets

Question 3

Which THREE components are necessary to successfully configure and publish a batch segment activation in Data Cloud? (Choose three.)

Accepted Answer

A published Segment defining the audience criteria.. Option B is correct because a batch segment activation must be based on a published Segment that defines the audience criteria; without a published segment there is no audience to activate. Option D is correct because an active Activation Target is required to store the destination and authentication details (such as the external platform endpoint and credentials) that the activation will use. Option E is correct because Contact Point mapping ensures the required communication identifiers (for example email address or phone number) are included in the activation payload so the destination can reach the individuals. Option A is not required, since an Einstein Studio predictive scoring model is only needed when the segment relies on predictive scores, not for every batch activation. Option C is not required, because a real-time Data Action Target with a webhook URL is used for real-time streaming activations, not for batch segment activation.

Answer

An active Einstein Studio predictive scoring model.

Answer

A real-time Data Action Target configured with a webhook URL.

Question 4

A consultant is setting up a data stream from Marketing Cloud Engagement. The data stream successfully ingests subscriber data, but campaign tracking events are not appearing. What should the consultant verify?

Accepted Answer

Verify that the tracking data bundle or corresponding event data streams were selected and enabled during setup.. When configuring Marketing Cloud Engagement data streams, specific data bundles or individual data streams (such as tracking data streams) must be explicitly selected and enabled during setup.

Answer

Restart the Kafka message broker.

Answer

Rewrite all tracking data into CSV format and upload to S3.

Answer

Check the Salesforce CRM Connected App OAuth scopes.

Question 5

What is the primary function of the Identity Resolution Ruleset run history in Salesforce Data Cloud?

Accepted Answer

To view execution status, timestamps, record counts, and logs for past ruleset runs.. Run history provides visibility into execution status, timestamps, record counts, and error logs for identity resolution jobs.

Answer

To deploy segmentation activation targets.

Answer

To configure OAuth credentials for Marketing Cloud.

Answer

To manually edit source SQL queries for data stream transformations.

Question 6

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?

Accepted Answer

Configure relative time filters on the Cart Event object (greater than 24 hours ago) combined with an exclusion of Purchase Events within that same timeframe.. Time-based relative filters (e.g., event occurred greater than X days/hours ago) are configured directly within the attribute filters on related event objects (like Cart Event and Purchase Event) inside the segment container.

Answer

Export cart events to Marketing Cloud and handle the 24-hour delay in Journey Builder.

Answer

Write a custom SQL script in the Segment Setup menu.

Answer

Use a Calculated Insight that runs every minute to evaluate cart abandonment.

Question 7

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

Accepted Answer

Configure a weekly segment publish schedule set to run on Monday prior to the campaign start time.. Batch segments support flexible recurrence schedules, including weekly schedules on specific days and times.

Answer

Rely on streaming ingestion to automatically schedule the batch run.

Answer

Manual execution is the only option; weekly schedules are not supported.

Answer

Configure an API callout script that triggers every minute on Monday.

Question 8

Which THREE best practices should a consultant follow when troubleshooting an identity resolution implementation where unified profile counts appear unexpectedly inflated? Choose 3 options.

Accepted Answer

Review match rule criteria to ensure that necessary matching attributes (like email or phone) are not omitted or unmapped.. Inflated profile counts often indicate under-merging caused by missing match rules, unmapped attributes, or overly restrictive matching criteria.

Answer

Switch all reconciliation rules from Source Sequence to Longest String.

Answer

Delete all data spaces and restart the entire Salesforce CRM instance.

Question 9

A Data Cloud consultant needs to ingest clickstream data that updates constantly throughout the day with high volume and low latency requirements. Which ingestion mechanism should be used?

Accepted Answer

Streaming Ingestion via Ingestion API or Interaction SDK. Streaming Ingestion (via Ingestion API or interaction SDKs) is designed for high-frequency, low-latency data streams compared to batch ingestion.

Answer

Batch Data Stream scheduled every hour

Answer

Salesforce CRM Connector with changed data capture enabled

Answer

Manual CSV file upload via the Data Cloud UI

Question 10

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

Accepted Answer

Limit the number of nested related attribute containers to reduce query complexity.. Best practices for batch segmentation include avoiding overly complex nested containers and limiting unnecessary attributes.

Answer

Use streaming segments exclusively for all segments regardless of size.

Answer

Include all available profile attributes in the segment output to maximize downstream usability.

Answer

Schedule all segments to run simultaneously at midnight to align with data refreshes.

Question 11

An administrator notices that after a scheduled identity resolution ruleset refresh, several unified profiles split into multiple separate profiles even though no match rules were altered. What is the most likely reason for this occurrence?

Accepted Answer

Source records were updated to remove or modify the shared matching attribute values, breaking the linkage.. If records lose their matching attribute values (e.g., an email address is cleared or updated to null in the source system), the bridge connecting them in the Unified Link object is severed, causing profiles to split upon refresh.

Answer

The reconciliation rule changed from Source Sequence to Most Recent.

Answer

Data Cloud automatically splits profiles every 30 days for data hygiene.

Answer

Calculated insights purged the Unified Link Individual table.

Question 12

An administrator is configuring a Web and Mobile data stream in Data Cloud to track user behavior. Which prerequisite code or SDK must be implemented on the website to feed data into this stream?

Accepted Answer

Data Cloud Web SDK / Interaction SDK. Web and Mobile data streams rely on the Interaction SDK or tracking code snippets provided during stream creation in Data Cloud.

Answer

Salesforce Lightning Component Bundle

Answer

Marketing Cloud Server-Side JavaScript (SSJS)

Answer

Salesforce Mobile SDK for iOS/Android core apps only

Question 13

Which THREE features are available within the Data Cloud Segment Builder?

Accepted Answer

Applying filters based on engagement history. Option B is correct because the Data Cloud Segment Builder lets you filter a segment population using engagement history data, such as email opens, clicks, and web or mobile events, so you can target profiles based on prior interactions. Option D is correct because the Segment Builder supports including related profile attributes from related (linked) Data Model Objects, allowing attributes from related entities to be pulled into the segment definition. Option E is correct because the Segment Builder can filter on calculated insights, which are computed metrics stored as Calculated Insight objects in Data Cloud, enabling segmentation on derived values like lifetime value or engagement scores. Option A is not correct because the Segment Builder is a point-and-click UI for defining segments, not a tool for writing cross-database SQL join queries; that capability belongs to Data Cloud SQL/Query Editor or Data Cloud SQL workbenches. Option C is not correct because the Segment Builder only defines and publishes segments; triggering real-time email sends is handled by activation targets such as Marketing Cloud or Data Cloud activations, not by the Segment Builder itself.

Answer

Cross-database SQL join queries

Answer

Triggering real-time email sends

Question 14

A consultant is configuring a match rule using Exact Name and Exact Email. How does Data Cloud evaluate multiple rules within the same ruleset?

Accepted Answer

Multiple match rules within a ruleset are evaluated with OR logic, meaning records matching any of the active match rules will be linked.. Within an identity resolution ruleset, multiple match rules are evaluated using an OR condition logic (if a record matches Rule A OR Rule B, they are linked into the same cluster).

Answer

Multiple match rules require strict AND logic, meaning all rules must match simultaneously for records to link.

Answer

Match rules execute sequentially where failing the first rule deletes the record.

Answer

Only the first match rule in the list is executed; subsequent rules are ignored.

Question 15

An organization is ingesting high-frequency transactional data from a mobile app using the Ingestion API. They notice that records are failing with a validation error regarding primary keys. What must the consultant verify in the Ingestion API payload structure?

Accepted Answer

Verify that the primary key field is explicitly mapped and populated with unique values in every incoming JSON batch object.. The Ingestion API requires a defined primary key in the schema definition payload, and each incoming record must supply a unique value for this designated primary key field to prevent payload rejection.

Answer

Check that the primary key is hashed using MD5 before sending the payload to the Data Cloud endpoint.

Answer

Ensure that the primary key field is designated as nullable within the connected source object schema.

Answer

Confirm that the primary key matches the Salesforce Organization ID.

Question 16

An architect is reviewing an identity resolution ruleset where customer records from a legacy billing system are frequently failing to link with CRM records because the legacy system stores names in ALL CAPS while CRM uses Title Case. What is the best way to handle this?

Accepted Answer

Ensure data streams map to standard DMO fields, as Data Cloud automatically applies normalization rules (such as case insensitivity and whitespace stripping) during matching.. Data Cloud's Identity Resolution engine normalizes data during matching — it applies case-insensitivity, whitespace trimming, and standard formatting to fields like names before comparing them. As long as the legacy billing stream maps to the standard Individual/Contact DMO name fields, the ALL CAPS vs Title Case difference will not prevent matching.

Answer

Write a custom SQL data transform to convert all legacy billing names to lowercase before ingestion.

Answer

Create a calculated insight to concatenate legacy billing names with CRM names.

Answer

Disable fuzzy matching and switch to Exact Name matching.

Question 17

An administrator needs to ensure that historical data ingestion for a large Salesforce CRM data stream does not impact peak system usage hours. How can the administrator manage the ingestion schedule?

Accepted Answer

Configure the refresh schedule on the Data Stream properties to run during off-peak hours.. Data streams created from Salesforce CRM allow administrators to set ingestion frequency and schedules (e.g., hourly, daily) during creation or by editing stream properties.

Answer

Set up a Flow in core CRM to pause Data Cloud sync jobs when CPU load is high.

Answer

Enable asynchronous batch locking in Data Cloud Setup > Performance.

Answer

Use Salesforce Governor Limits Setup to throttle API calls during peak hours.

Question 18

An organization uses Data Cloud to segment high-value customers and activates them to an ad network. The marketing team notices that after a profile is updated in CRM, it takes several hours for the ad network audience to reflect the change. What is the best way to explain this latency to the stakeholders?

Accepted Answer

The latency is governed by the combined schedule intervals of segment refreshes and batch activation publishing jobs.. The latency is due to the scheduled intervals of segment refreshes and batch activation publishing jobs. Data Cloud segments are refreshed on a schedule (e.g., hourly or daily), and activations to external platforms like ad networks are typically batch processes that run at set intervals, causing delays.

Answer

Identity resolution rules only execute once per week, delaying profile updates.

Answer

Data Cloud streaming data ingestion has a default 24-hour buffer window before activation.

Answer

Ad networks enforce a strict 48-hour API rate limit freeze on incoming customer updates.

Question 19

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 20

A consultant has created a custom Data Model Object (DMO) and needs to relate it to the standard Individual DMO. The relationship type chosen is N:1 (Many custom DMO records to One Individual). When configuring this relationship in Data Cloud, what is a mandatory requirement for the foreign key field in the custom DMO?

Accepted Answer

It must have the exact same data type (Text) and precision as the primary key of the parent DMO.. When establishing relationships between DMOs in Data Cloud, the foreign key field in the child object must match the data type and length of the primary key field in the parent object (Individual ID) to ensure successful joins and identity resolution.

Answer

It must be indexed using a SOQL custom index.

Answer

It must be mapped directly to a Data Source Object formula field.

Answer

It must be configured as a measure data type.