Data 360 Consultant Practice Test 37 — 15 Questions

Question 1

Which TWO actions can an administrator perform from the Identity Resolution setup interface in Data Cloud? Choose 2 options.

Accepted Answer

Create and edit identity resolution rulesets, match rules, and reconciliation rules.. Administrators can create/edit rulesets and trigger manual runs from the Identity Resolution setup interface.

Answer

Write custom Apex triggers for ingestion streams.

Answer

Provision new core CRM user licenses.

Answer

Deploy Marketing Cloud activation targets.

Question 2

Which THREE actions should a consultant take when auditing an identity resolution implementation where records are incorrectly merging across distinct customer households? Choose 3 options.

Accepted Answer

Incorporate high-cardinality unique identifiers like distinct account numbers or verified emails.. Incorrect cross-household merging (over-merging) requires reviewing broad match rules, adding secondary criteria with strict AND logic, and verifying unique identifiers.

Answer

Switch all reconciliation rules from Most Recent to Longest String.

Answer

Delete all unified link records manually via Apex.

Question 3

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?

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 4

Which user permission or role is typically required to create and configure an Identity Resolution ruleset in Salesforce Data Cloud?

Accepted Answer

Data Cloud Admin or Data Cloud Consultant permission set.. Configuring identity resolution requires administrative access within Data Cloud, such as Data Cloud Admin or Data Cloud Consultant permissions.

Answer

System Administrator in core CRM without Data Cloud permission sets.

Answer

Salesforce CRM Read-Only profile.

Answer

Standard Marketing Cloud User permission.

Question 5

Which THREE outcomes occur when source records are successfully matched and linked into a unified profile during Identity Resolution? Choose 3 options.

Accepted Answer

Reconciliation rules evaluate contributing records to populate the attributes on the Unified Individual profile.. Successful linking creates unified link records, populates the unified individual profile using reconciliation rules, and enables unified segmentation.

Answer

Core Salesforce CRM records are automatically overwritten and modified.

Answer

Source records are permanently deleted from the source data streams.

Question 6

Which THREE behaviors characterize how Data Cloud processes reconciliation rules during identity resolution? Choose 3 options.

Accepted Answer

Different reconciliation strategies can be assigned to different attributes (e.g., Most Recent for phone, Source Sequence for name).. Reconciliation rules determine surviving attribute values, operate after record matching occurs, and can be customized per attribute field.

Answer

They automatically overwrite and update records in the source CRM system.

Answer

They determine whether two source records are permitted to match based on email addresses.

Question 7

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?

Accepted Answer

Streaming segments only support attributes from DMOs enabled for streaming ingestion.. Streaming segments have specific architectural constraints. They evaluate criteria on streaming data and can only include attributes from DMOs that support streaming and are related directly or via specific cardinality paths. They cannot use batch-only dimensions or certain complex cross-object joins that batch segments support.

Answer

Streaming segments cannot contain more than three filter criteria.

Answer

Streaming segments must be published manually every 24 hours.

Answer

Streaming segments cannot be used with Marketing Cloud Engagement activation targets.

Question 8

A consultant needs to configure a match rule that compares first names, last names, and postal codes simultaneously. How should this be configured within the Identity Resolution ruleset?

Accepted Answer

Create a single match rule containing multiple criteria attributes (First Name, Last Name, and Postal Code) evaluated together.. Match rules can combine multiple attributes to form composite matching criteria requiring all specified fields to align.

Answer

Create three separate rulesets, one for each attribute.

Answer

Use Calculated Insights to generate a composite key for matching.

Answer

Write an Apex trigger to combine the fields before ingestion.

Question 9

What does a reconciliation rule govern in a Salesforce Data Cloud Identity Resolution ruleset?

Accepted Answer

Which attribute values populate the unified profile fields from the contributing source records.. Reconciliation rules determine how attribute values from multiple matched source records are populated onto the unified profile.

Answer

Which source records are permitted to match based on email addresses.

Answer

How segments are activated to external cloud storage destinations.

Answer

The frequency at which data streams ingest records from Salesforce CRM.

Question 10

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

Accepted Answer

Identity Resolution merges multiple source records into unified profiles, ensuring segments target unique individuals rather than fragmented records.. Identity Resolution ties disparate source records together into a single unified Individual profile, which is what segments evaluate against.

Answer

Identity Resolution exports final segment membership lists to external ad platforms.

Answer

Identity Resolution writes the SQL code for Calculated Insights.

Answer

Identity Resolution schedules the automatic refresh time for streaming segments.

Question 11

An administrator wants to ensure that a specific group of marketing users can only view data associated with the 'EMEA' Data Space. How should the administrator enforce this requirement?

Accepted Answer

Assign the users a permission set that includes access to the 'EMEA' Data Space.. Data Spaces restrict access to data model objects, insights, and segments. Users must be assigned permission sets tied to specific Data Spaces to view data within them.

Answer

Update the organization-wide defaults (OWD) for Data Cloud objects to Private for EMEA.

Answer

Create a custom profile for EMEA users and disable read access to all non-EMEA data streams.

Answer

Configure a sharing set in Data Cloud Setup pointing to the EMEA region.

Question 12

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?

Accepted Answer

Verify the Activation Target connection settings, credentials, and attribute mappings.. Activation delivery failures are commonly related to invalid activation target credentials, missing attribute mappings, or configuration errors in the activation setup.

Answer

Delete all data streams and re-ingest raw data files.

Answer

Recreate the entire Identity Resolution ruleset from scratch.

Answer

Increase the browser timeout limit for the Salesforce administrator.

Question 13

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?

Accepted Answer

A CASE expression with numeric evaluation ranges.. Conditional categorization in ANSI SQL is implemented using CASE expressions, allowing developers to assign labels based on numeric thresholds.

Answer

A Python lambda function embedded in the SELECT clause.

Answer

A Data Graph transform rule.

Answer

A SOQL IF-THEN block.

Question 14

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 and cumulative calculations in ANSI SQL require window functions using the OVER clause with ORDER BY timestamp partitions.

Answer

TOTAL_ACCUMULATOR(amount)

Answer

RUNNING_TOTAL(amount, transaction_date)

Answer

CUMULATIVE_SUM() function without arguments.

Question 15

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

Accepted Answer

Check the segment details page in Data Cloud for total member count and publish history.. Segment metadata, including estimated and total member counts, is visible directly on the Segment details page in Data Cloud.

Answer

Review the Data Stream error log file.

Answer

Open the Identity Resolution match history report.

Answer

Run a SOQL query against the standard Salesforce CRM Account object.