Data 360 Consultant Practice Test 23 — 15 Questions

Question 1

A consultant is building a Calculated Insight that aggregates web session data. The requirement is to compute the rolling 30-day average of session durations per user. Which SQL clause or construct is essential for handling time-window calculations in Data Cloud Calculated Insights?

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

Accepted Answer

Standard ANSI SQL window functions and timestamp filtering expressions.. Calculated Insights in Data Cloud use SQL, and time-window calculations such as rolling 30-day averages require standard ANSI SQL window functions (e.g., AVG() OVER (PARTITION BY user ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW)) combined with timestamp filtering. These constructs are essential for handling time-based aggregations.

Answer

Apex streaming context variables.

Answer

Salesforce SOQL date literals like LAST_N_DAYS:30.

Answer

Data Graph transformation syntax.

Question 2

An organization experiences an issue where an activation targeting Marketing Cloud Engagement stops updating data extensions. Upon investigation, the connected app credentials used by the activation target were recently rotated by the security team. What is the correct remediation step?

Accepted Answer

Update the Activation Target authentication credentials within Data Cloud setup to reflect the new client secret.. When external credentials or connected app secrets are rotated, the corresponding activation target authentication configuration in Data Cloud must be updated to re-establish trust.

Answer

Run a full Identity Resolution rebuild job.

Answer

Recreate all segments associated with the activation target from scratch.

Answer

Restart the Data Cloud instance via Salesforce Core Setup.

Question 3

A consultant is designing segment criteria using related objects. Which THREE of the following capabilities are supported within the Segment Canvas? (Choose three.)

Accepted Answer

Nesting multiple related object criteria to filter based on child object attributes.. The Segment Canvas supports various logical containers and operators, including inclusion, exclusion, related object attribute filters, and date/numeric operators.

Answer

Writing custom Python machine learning scripts directly inside the segment builder.

Answer

Directly modifying underlying raw Data Lake Object schemas from the canvas.

Question 4

Which object relationship is essential when activating attributes alongside a segment in Data Cloud?

Accepted Answer

A valid relationship between the attribute's DMO and the Unified Individual DMO.. To activate attributes alongside a segment, the attribute's DMO must have a valid relationship to the Unified Individual DMO so Data Cloud can join the attribute values to the correct unified profiles. Without that relationship, the activation cannot resolve which individual each attribute value belongs to, and the attribute cannot be included in the activation payload.

Answer

A Tableau CRM dashboard binding string.

Answer

An Apex trigger linking the Data Source Object to the Case object.

Answer

A hardcoded foreign key constraint in the raw CSV ingestion file.

Question 5

How does Data Cloud integrate with Sales Cloud and Service Cloud to provide unified customer context without duplicating core CRM storage?

Accepted Answer

By utilizing zero-copy architecture and native CRM data streams. Data Cloud uses a zero-copy architecture that directly accesses CRM data without duplicating it, and native CRM data streams ingest Sales and Service Cloud objects in real time or batch. This provides unified customer context by combining CRM data with other sources while keeping the CRM as the system of record.

Answer

By synchronizing records via bi-directional CSV FTP transfers

Answer

By routing all CRM queries through an external middleware ESB

Answer

By copying all CRM records into local Salesforce object storage hourly

Question 6

What is the purpose of assigning the 'Data Cloud Admin' permission set to an administrator?

Accepted Answer

To grant full administrative access to configure and manage all Data Cloud features and settings.. The Data Cloud Admin permission set grants full administrative control over Data Cloud features, including setup, connectors, data streams, and data spaces.

Answer

To enable Salesforce CRM platform customization like custom objects and Apex triggers.

Answer

To allow the user to approve marketing email campaigns sent from Marketing Cloud.

Answer

To manage AWS cloud infrastructure settings directly from Salesforce.

Question 7

An organization has multiple business units sharing a single Data Cloud instance. They want to ensure that activation targets and segments created by Marketing Team A are not visible or editable by Marketing Team B. How should the administrator configure this?

Accepted Answer

Utilize Data Spaces and targeted permission sets to isolate segments, activation targets, and data access between teams.. Data Spaces in Data Cloud provide logical isolation of data, segments, and activation targets, and when combined with targeted permission sets, they ensure that Marketing Team A cannot see or edit Team B's assets. This is the native multi-tenant isolation mechanism within a single Data Cloud instance.

Answer

Create separate Salesforce Core orgs for each marketing team and link them via Marketing Cloud Connect.

Answer

Assign all users the Data Cloud Admin permission set and use naming conventions.

Answer

Rely on sharing rules configured on the Salesforce Core Contact object.

Question 8

What is the primary function of an activation membership in Data Cloud?

Accepted Answer

It tracks which profile records qualify for a segment and are included in an activation export.. An activation membership in Data Cloud is the record that links a Unified Individual profile to a specific activation and tracks whether that profile qualified for the segment and was included in the activation export. It is the join between segment membership and activation delivery, enabling tracking of which profiles were sent to which downstream target and when. This is essential for auditing, troubleshooting, and re-activation logic.

Answer

It schedules the batch frequency of data stream refreshes from source systems.

Answer

It defines the structural schema of the Data Model Object used for ingestion.

Answer

It acts as the encryption key for secure cloud storage activation targets.

Question 9

A consultant is designing identity resolution for a global enterprise operating in multiple data spaces. What is a key architectural consideration regarding identity resolution and data spaces?

Accepted Answer

Identity resolution rulesets operate within the boundaries of a single data space and process data contained within that specific space.. Identity resolution rulesets and unified profiles are scoped within a single data space and cannot span across multiple data spaces natively without sharing mechanisms.

Answer

Data spaces replace the need for identity resolution rulesets by automatically merging records on ingestion.

Answer

Configuring identity resolution requires super-user access to the core Salesforce CRM multitenant database.

Answer

A single identity resolution ruleset can automatically merge profiles across multiple disparate data spaces simultaneously.

Question 10

What is the primary benefit of using a Data Action Target over a batch activation target?

Accepted Answer

It enables near real-time, event-driven responses to streaming data events.. A Data Action Target is designed for event-driven, near real-time activation: it subscribes to streaming data events and triggers an action (e.g., a webhook or API call) as soon as a qualifying event arrives. This contrasts with batch activation targets, which process segments on a scheduled cadence (hourly, daily) and are not optimized for sub-minute latency. The primary benefit is therefore the ability to respond to streaming events with minimal delay.

Answer

It allows bulk exporting of millions of records to cloud storage in Parquet format.

Answer

It replaces the need for data stream ingestion schedules.

Answer

It automatically creates Identity Resolution rule sets for unstructured data.

Question 11

A consultant is setting up an activation to Marketing Cloud Engagement and needs to include additional attributes alongside the subscriber key. Where are these attributes configured during the activation creation wizard?

Accepted Answer

In the Attributes selection step of the activation creation wizard. In the Data Cloud activation creation wizard, after selecting the target (e.g., Marketing Cloud Engagement) and the segment, there is an Attributes step where the consultant selects which profile attributes (beyond the subscriber key) to include in the activation payload. This is where additional attributes like first name, email, or custom fields are added to the outbound data.

Answer

Inside the Marketing Cloud Contact Builder attribute group setup

Answer

Directly inside the Data Stream configuration settings

Answer

Within the Identity Resolution ruleset mapping canvas

Question 12

What is required to publish an activation to an ad network like Google Ads or Meta Ads from Data Cloud?

Accepted Answer

An active Activation Target with valid ad network authentication credentials and a published Segment mapped to required identifiers.. Publishing an activation to an ad network requires an Activation Target configured with the ad platform's authentication credentials (OAuth tokens, API keys) and a published Segment whose required identifiers (e.g., hashed email, MAID) are mapped to that target. Data Cloud then pushes the segment membership directly to the ad platform via the target's API. Without a valid target and mapped identifiers, activation cannot be published.

Answer

A manual export of CSV files uploaded via SFTP by a system administrator.

Answer

A custom Apex web service callout written in Salesforce Core.

Answer

An Enterprise license for Salesforce CPQ and Billing.

Question 13

A consultant is creating a segment in Data Cloud based on unified individuals who have both an active subscription and an open support case. When building the segment, which object should the consultant use as the primary base object?

Accepted Answer

Unified Individual DMO. Segments in Data Cloud are built on the Unified Individual DMO because segmentation operates on unified profiles, not raw source records. To find individuals with both an active subscription and an open support case, the consultant starts from Unified Individual and joins to the Subscription and Case DMOs via their relationships to the unified profile. This ensures the segment reflects the unified customer, not duplicate per-source records.

Answer

Calculated Insight DLO

Answer

Activation Target Object

Answer

Case DLO

Question 14

A consultant needs to create an activation target for Meta Ads within Data Cloud. Where should the consultant navigate within the Data Cloud setup to establish this connection?

Accepted Answer

Setup > Data Cloud > Activation Targets. Activation targets in Data Cloud are created and managed from Setup under the Data Cloud settings, specifically the Activation Targets page, where you select the target type (such as Meta Ads) and configure credentials and mappings. This is the canonical navigation path for establishing an outbound activation connection. The other paths either do not exist or belong to unrelated features.

Answer

Data Cloud > Segments > New Target

Answer

Setup > Marketing Cloud > Connected Apps

Answer

Setup > Data Streams > External Connections

Question 15

An enterprise wants to track customer engagement metrics, such as total order amount over the last 90 days, to use as attributes in audience segmentation. Which Data Cloud tool is designed specifically to calculate and store these types of aggregations?

Accepted Answer

Calculated Insights. Calculated Insights is the Data Cloud tool designed specifically to calculate and store aggregations, such as total order amount over the last 90 days, for use in segmentation. It allows you to define metrics using SQL-like expressions that aggregate data from Data Model Objects (DMOs) and then make those metrics available as attributes in audience segmentation.

Answer

Data Model relationship mapping

Answer

Activation Target filters

Answer

Identity Resolution rulesets