Data 360 Consultant Practice Test 2 — 10 Questions

Question 1

A consultant is troubleshooting an identity resolution implementation where multiple source records from an e-commerce platform are failing to merge with CRM records despite having matching email addresses. Upon investigation, what is the most likely cause?

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

Accepted Answer

The e-commerce email field was mapped to a custom attribute instead of the standard Contact Point Email DMO with proper primary key/foreign key relationships.. If matching fails despite matching data, checking data mapping, data space segregation, or normalization discrepancies is crucial. Specifically, unmapped email fields or mapping to the wrong Contact Point Email type will prevent matching.

Answer

Reconciliation rules were set to Most Recent instead of Source Sequence.

Answer

Data Cloud requires manual SQL triggers to activate e-commerce data streams.

Answer

The Unified Individual DMO is missing an activation target assignment.

Question 2

An administrator observes that after adding a new Fuzzy Email match rule to an existing ruleset, the Identity Resolution batch job fails with a system memory/timeout exception. What is the most appropriate troubleshooting step?

Accepted Answer

Remove or refine the newly added fuzzy match rule to reduce computational complexity and prevent Cartesian explosion during matching.. Fuzzy email matching on massive datasets without proper scoping can cause performance bottlenecks. Reviewing and refining match criteria or breaking down large rulesets is necessary.

Answer

Increase data stream ingestion frequency from hourly to real-time.

Answer

Restart the core Salesforce CRM production server.

Answer

Switch the reconciliation rule to Highest Frequency.

Question 3

What is the function of the Identity Resolution Ruleset wizard in Salesforce Data Cloud?

Accepted Answer

To guide administrators through creating and configuring match and reconciliation rules for unified profiles.. The Identity Resolution Ruleset wizard guides the user step-by-step through selecting match rules, reconciliation rules, and target objects.

Answer

To construct marketing segments and publish them to activation targets.

Answer

To write SQL queries for Calculated Insights.

Answer

To provision new data spaces and assign user licenses.

Question 4

A consultant is designing identity resolution for an organization that receives customer data from both a B2C retail app and a B2B corporate portal. The client wants separate unified profile structures for consumers versus business buyers. How should this be structured in Data Cloud?

Accepted Answer

Partition the B2C and B2B data into separate data spaces and configure dedicated identity resolution rulesets for each space.. Different profile structures or distinct business domains with strict separation requirements should be partitioned into separate data spaces, each housing its own identity resolution ruleset.

Answer

Create a single ruleset with conflicting match rules to automatically separate them.

Answer

Map both B2C and B2B data streams to the same exact unmapped DLO without data transforms.

Answer

Use Calculated Insights to delete B2B profiles from the B2C unified individual table.

Question 5

A consultant creates a custom Data Model Object (DMO) in Data Cloud and attempts to relate it to the standard Individual DMO. The relationship creation fails. What is the most likely reason?

Accepted Answer

The foreign key in the custom DMO does not match the data type and length of the target primary key in the Individual DMO.. Relationships between DMOs require specific cardinality configurations (e.g., 1-to-1, 1-to-many, many-to-many) and must link compatible primary and foreign keys with matching data types.

Answer

The Individual DMO is locked and does not accept outgoing foreign key relationships.

Answer

Custom DMOs cannot have relationships with standard DMOs under any circumstances.

Answer

Standard DMO relationships can only be established using SQL queries in Calculated Insights.

Question 6

Which TWO statements are true regarding Data Model Object (DMO) relationships in Data Cloud? (Choose TWO)

Accepted Answer

Relationships can be established between standard DMOs and custom DMOs.. DMO relationships define how objects connect (e.g., 1-to-many between Individual and Contact Point), and they are configured visually in the Data Model canvas.

Answer

Standard CIM DMO relationships cannot be modified or extended.

Answer

Relationships require Apex code to enforce referential integrity.

Answer

Relationships are automatically created by Identity Resolution without user configuration.

Question 7

An administrator is troubleshooting a failing Salesforce CRM data stream. Which THREE diagnostic steps or checks should the administrator perform in Salesforce Data Cloud? (Choose three.)

Accepted Answer

Verify that the Salesforce CRM connector bundle was successfully deployed and activated.. Troubleshooting CRM data streams involves checking stream run history, connector status, and data model mappings.

Answer

Check the core CRM Apex code coverage for all triggers in the organization.

Answer

Verify that all Data Model Objects have been converted to custom Salesforce objects in Object Manager.

Question 8

An administrator needs to ingest data from an external relational database into Data Cloud using a scheduled batch process. Which connector type is best suited for this requirement?

Accepted Answer

Cloud Storage Connector (e.g., Amazon S3, Google Cloud Storage, Azure Blob Storage). External database ingestion where Salesforce pulls data via batch files or direct connections can utilize Cloud Storage connectors (like S3, Google Cloud Storage, Azure Blob) or standard file upload methods. For scheduled batch file drops, Cloud Storage connectors are standard.

Answer

Marketing Cloud Connector

Answer

Real-Time Interaction Collector

Answer

Salesforce CRM Connector

Question 9

What is the function of the Data Cloud Setup Home page for an administrator?

Accepted Answer

To provide an overview of provisioning status, guided setup steps, and quick links to core configuration tasks.. Data Cloud Setup Home provides a centralized dashboard showing setup progress, key metrics, quick links, and guidance for provisioning and configuring Data Cloud.

Answer

To manage core Salesforce CRM user profiles and permission sets.

Answer

To write SQL queries for Calculated Insights.

Answer

To create marketing segments and activation targets.

Question 10

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.