Data 360 Consultant Practice Test 12 — 15 Questions

Question 1

Which TWO actions are required when setting up an Activation Target for Marketing Cloud Engagement? (Choose two.)

Accepted Answer

Configure an installed package in Marketing Cloud Engagement providing Client ID, Client Secret, and Authentication URI.. Option C is correct because setting up an Activation Target for Marketing Cloud Engagement requires an installed package in Marketing Cloud Engagement that supplies the Client ID, Client Secret, and Authentication URI used for the OAuth connection between the systems. Option E is correct because the Activation Target configuration must specify the target Business Unit in Marketing Cloud Engagement where the data extensions and audiences will be published. Option A is not required, since Calculated Insights are optional analytics constructs and are not part of the Activation Target setup. Option B is not required, as SSL certificates are not uploaded directly on the activation target screen; secure connectivity is handled through the installed package and authentication settings. Option D is not required, because no custom Apex REST service in Salesforce Core CRM is needed to bridge the connection.

Answer

Define a Calculated Insight to aggregate messaging metrics.

Answer

Upload an SSL private key certificate directly into the activation target screen.

Answer

Write a custom Apex REST service in Salesforce Core CRM to bridge the connection.

Question 2

An organization experiences performance degradation and timeout errors whenever their scheduled Identity Resolution ruleset executes. Upon reviewing the setup, the consultant finds that the ruleset contains five broad fuzzy match rules running against 50 million records without any pre-filtering. What is the recommended architectural remedy?

Accepted Answer

Restructure the match rules to prioritize high-confidence exact matches first, followed by selective secondary rules, and remove overly broad fuzzy combinations.. Reducing unnecessary broad fuzzy rules and structuring match rules hierarchically (from exact high-confidence matches to broader fuzzy matches) optimizes performance.

Answer

Change all reconciliation rules from Most Recent to Longest String.

Answer

Increase the Salesforce CRM API polling frequency to every 5 minutes.

Answer

Delete all contact point email records older than 30 days.

Question 3

Universal Containers wants to implement Data Cloud to unify customer data from multiple sources across Sales Cloud, Marketing Cloud Engagement, and an external legacy order management system. Which architectural component should the consultant recommend as the foundational layer to ingest and normalize this data?

Accepted Answer

Data Streams. Data Streams are the foundational ingestion layer in Data Cloud. They connect to source systems (Sales Cloud, Marketing Cloud Engagement, external systems via S3, Snowflake, etc.) and bring raw data into Data Lake Objects (DLOs), which are then mapped and transformed into Data Model Objects (DMOs). Without Data Streams, no data enters Data Cloud, so they are the correct foundational component for ingesting and normalizing multi-source data.

Answer

Activation Targets

Answer

Data Spaces

Answer

Calculated Insights

Question 4

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 in Data 360 require that the SQL query's output be aggregated at the grain of the target entity's primary key. Without a GROUP BY clause matching that primary key, the query returns rows at an undefined grain, which the system cannot map to the entity — hence the dimensionality error. The GROUP BY must align with the entity's primary key to produce a valid metric per entity record.

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 5

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. To publish a segment to an external S3 bucket, you must configure an Activation Target in Data Cloud (Data 360). Activation Targets define the destination for segment activation, such as an S3 bucket, and include the necessary connection details and credentials. This is a prerequisite before you can publish or activate a segment to that external system.

Answer

Data Action Target

Answer

Ingestion API Source

Answer

Connected App Framework

Question 6

Which feature allows a Data Cloud Consultant to transform field values, such as concatenating first and last names or changing date formats, during the ingestion process without writing custom code?

Accepted Answer

Data Stream Formula Fields. Formula fields in Data Streams allow consultants to apply transformations, string manipulations, and mathematical operations on incoming data during the ingestion phase.

Answer

Segment Filter Criteria

Answer

Identity Resolution Ruleset

Answer

Calculated Insights

Question 7

A Data Cloud Consultant is configuring real-time data ingestion using the Ingestion API. Which artifact must be created and published in Data Cloud before sending payload data from an external web application?

Accepted Answer

An Inbound Streaming Data Source and associated Data Stream schema. The Ingestion API requires a pre-configured Inbound Streaming Data Source and its associated Data Stream schema to define the endpoint and structure for incoming real-time payloads. This artifact acts as the contract that validates and maps the JSON data sent from the external web application into Data Cloud. Without it, the API has no target schema or connection point to accept the data.

Answer

A Salesforce CRM Custom Object with Change Data Capture enabled

Answer

A standard Marketing Cloud Data Extension

Answer

A Tableau Hyper file upload definition

Question 8

An enterprise ingests high-frequency clickstream data using the Interaction SDK. The client notices that event timestamps are recorded in local browser time rather than UTC, causing chronological misalignment in sequence analysis. How should the consultant address this?

Accepted Answer

Configure the Interaction SDK payload script to transmit timestamps in UTC or include the explicit ISO 8601 offset.. When capturing web/mobile events via the Interaction SDK, the consultant must configure the event payload script to capture and transmit ISO 8601 timestamps with explicit UTC offset or convert them to UTC before submission.

Answer

Rebuild the Identity Resolution ruleset to auto-correct timestamps.

Answer

Change the timezone setting of the Salesforce CRM administrator user.

Answer

Switch from the Interaction SDK to an Amazon S3 batch CSV upload.

Question 9

An administrator has set up a new Data Cloud org and wants to verify that the out-of-the-box Data Model mappings for the Salesforce CRM Sales bundle are correct. Where should the administrator navigate in Data Cloud Setup?

Accepted Answer

Data Cloud Setup > Data Manager > Data Canvas. Mapping data from Data Source Objects to Data Model Objects is managed under the Data Manager section in Data Cloud.

Answer

Setup > Platform Tools > Data Mapping

Answer

Data Cloud Setup > Object Manager

Answer

Data Cloud Setup > Data Streams > Mappings

Question 10

A Data Cloud Consultant is designing an architecture where a high-volume transactional event stream triggers real-time personalization in an external system. Which combination of Data Cloud features should be utilized?

Accepted Answer

Streaming Data Transforms, Data Actions, and Data Action Targets configured as webhooks.. Real-time personalization triggered by a high-volume event stream requires streaming ingestion and outbound actions. Streaming Data Transforms process events in near real-time, Data Actions define the outbound payload and logic, and Data Action Targets configured as webhooks push the data to the external system. This combination delivers low-latency, event-driven personalization.

Answer

Inference Models in Einstein Studio and Tableau CRM Dashboard bindings.

Answer

Batch Data Streams, Segments, and Marketing Cloud Activation Targets.

Answer

Identity Resolution Rule Sets, Calculated Insights, and Cloud Storage Activations.

Question 11

An organization is ingesting high-volume transaction data via the Ingestion API. During testing, they notice that duplicate transaction IDs are being ingested as separate records into the DSO. What mechanism ensures idempotency or prevents unwanted duplicates in Data Cloud ingestion?

Accepted Answer

Ensure that a unique primary key is defined in the Ingestion API schema so Data Cloud can upsert records correctly.. Data Cloud ingestion relies on primary keys defined in the schema. If incoming records share the same primary key, Data Cloud performs an upsert based on the primary key to prevent duplicate records in the DSO.

Answer

Write an Apex deduplication trigger before sending payloads to the API.

Answer

Enable Identity Resolution match rules specifically for transaction IDs.

Answer

Set the data stream refresh frequency to real-time batching.

Question 12

When configuring match rules in Data Cloud, which match method should a consultant select to match records where the email addresses are identical after standard formatting?

Accepted Answer

Exact Email. Exact Email is the correct match method because it matches records where email addresses are identical after normalization (e.g., lowercasing, trimming). This is a deterministic match rule designed specifically for email fields.

Answer

Fuzzy Name

Answer

Exact Phone

Answer

Party Identification

Question 13

A consultant needs to include attributes from a custom Calculated Insight into a segment rule. What requirement must be met before the Calculated Insight can be used in Segment Canvas?

Accepted Answer

The Calculated Insight must have its output mapped to the Unified Individual or relevant profile-level DMO.. Calculated Insights must be configured with specific output profile mapping (such as mapping to Unified Individual) to be usable in segmentation.

Answer

The Calculated Insight must be exported to an external data warehouse first.

Answer

The Calculated Insight must be set to run on a streaming frequency.

Answer

The Calculated Insight must use the SQL COUNT DISTINCT function exclusively.

Question 14

Which Salesforce feature provides pre-built data streams and data model mappings for Marketing Cloud Account Engagement (Pardot)?

Accepted Answer

Marketing Cloud Account Engagement Data Bundle. Data Cloud provides standard data bundles for Marketing Cloud Account Engagement to ingest prospects, campaigns, and visitor data automatically.

Answer

Heroku Connect Data Connector

Answer

Salesforce Classic CTI Adapter

Answer

Commerce Cloud Order Management Bundle

Question 15

During the data harmonization phase in Salesforce Data Cloud, a consultant notices that incoming contact records from Sales Cloud and Commerce Cloud use different field names for email addresses. Where should the consultant map these disparate source fields to a unified enterprise data model field?

Accepted Answer

Data Stream Field Mapping canvas. The Data Stream Field Mapping canvas is where source fields from ingested DLOs are mapped to target DMO fields in the Customer 360 data model. This is the harmonization step that unifies disparate source schemas (e.g., Sales Cloud's Email vs. Commerce Cloud's EmailAddress) into a single canonical field like Contact Point Email. Mapping happens after ingestion and before Identity Resolution or segmentation.

Answer

Identity Resolution Ruleset configuration

Answer

Calculated Insights SQL editor

Answer

Activation Target configuration panel