Data 360 Consultant Practice Test 29 — 15 Questions

Question 1

Northern Trail Outfitters needs to ingest customer profile updates from Sales Cloud in near real-time. Which connector type should the consultant configure to achieve this requirement?

Accepted Answer

Salesforce CRM Data Stream using Change Data Capture. A Salesforce CRM Data Stream configured with Change Data Capture (CDC) delivers near real-time updates from Sales Cloud to Data Cloud. CDC emits change events as records are created or modified in Salesforce, and the Data Cloud connector ingests those events with minimal latency, satisfying the near real-time requirement.

Answer

Ingestion API with manual hourly triggers

Answer

Google Cloud Storage bucket integration

Answer

Marketing Cloud Connect batch sync

Question 2

What is the function of the Data Model canvas in Data Cloud?

Accepted Answer

To visually manage Data Model Objects and their relationships. The Data Model canvas provides a visual interface for viewing, creating, and managing relationships between Data Model Objects (DMOs).

Answer

To monitor API call limits and quotas

Answer

To create Lightning Web Components for CRM pages

Answer

To design marketing email templates

Question 3

A consultant is designing an architecture where customer records arrive simultaneously via Salesforce CRM CDC, Marketing Cloud Engagement, and an Ingestion API. To prevent duplicate customer profiles from bloating downstream segments, what core Data Cloud feature must be configured after data modeling?

Accepted Answer

Identity Resolution rulesets. Identity Resolution is required to reconcile and unify multiple customer records arriving from disparate data streams into a single Unified Individual profile.

Answer

Calculated Insights aggregation formulas

Answer

Data Actions export triggers

Answer

Tableau CRM data prep recipes

Question 4

A consultant is mapping a Salesforce CRM Contact data stream to the Individual DMO. The client wants to ensure that the contact's phone number is harmonized into the standard contact point phone DMO. How should this be structured?

Accepted Answer

Map the phone number to the Contact Point Phone DMO and relate it to the Individual DMO via foreign key.. Contact points (phone, email, address) in the Cloud Information Model are modeled as related child objects to the Individual DMO rather than flat attributes on the Individual DMO.

Answer

Write a Calculated Insight to extract phone numbers into a separate table.

Answer

Map the phone number directly as a custom field on the Individual DMO root object.

Answer

Concatenate all phone numbers into a single text string on the Contact object before ingestion.

Question 5

When configuring a batch data stream from an external source, what file formats are natively supported by Data Cloud for ingestion?

Accepted Answer

CSV, JSON, and Parquet. Data Cloud batch ingestion natively supports formats like CSV, JSON, and Parquet from cloud storage providers such as Amazon S3, Google Cloud Storage, and Azure Blob Storage.

Answer

PNG, JPEG, and PDF

Answer

SQL dump files (.sql) only

Answer

XML, XLS, and DOCX

Question 6

A consultant wants to ensure that a data action triggers immediately when a fraud detection flag is set on an individual in Data Cloud. Which type of target should be configured to handle this near-real-time event streaming?

Accepted Answer

Data Action Target configured for Amazon EventBridge or Webhook. Data Action Targets are the Data Cloud mechanism for near-real-time, event-driven outbound messaging. Configuring a Data Action Target with Amazon EventBridge or a Webhook endpoint allows Data Cloud to push a payload immediately when a triggering event (like a fraud flag) is set on an individual, enabling downstream systems to react in seconds. This is the correct target type for streaming, event-based activation rather than batch segment activation.

Answer

Advertising Platform Activation Target

Answer

Marketing Cloud Engagement Activation Target

Answer

Cloud Storage Activation Target

Question 7

A consulting firm is setting up Data Cloud for a multinational enterprise with distinct business units in North America and Europe. The enterprise requires strict data governance and logical separation of customer data between these two regions within a single Data Cloud instance. What should the consultant implement?

Accepted Answer

Data Spaces. Data Spaces provide logical partitioning of data, metadata, and user access within a single Data Cloud instance, which is exactly what is needed to separate North American and European business units while maintaining governance. They isolate data streams, DMOs, and segments per space and let administrators assign users to specific spaces. This satisfies the requirement for strict governance and logical separation without deploying multiple instances.

Answer

Individual Data Model Objects with custom formula fields

Answer

Permission Sets limiting object visibility

Answer

Multiple Data Cloud instances with Marketing Cloud Connect

Question 8

Which administrative tool allows an administrator to view a history of configuration changes made within Data Cloud Setup?

Accepted Answer

Salesforce Setup Audit Trail. The Salesforce Setup Audit Trail is the administrative tool that records configuration changes made in Setup, including changes made within Data Cloud Setup. Because Data Cloud Setup is part of the Salesforce Setup menu, its configuration changes (e.g., data streams, data spaces, permissions) are captured in the Setup Audit Trail, which shows who made the change, when, and what was changed.

Answer

Data Manager Activity History

Answer

Salesforce Optimizer Change Log

Answer

Data Cloud System Log Viewer

Question 9

Which of the following describes a Data Action Target type?

Accepted Answer

REST Webhook. A REST Webhook is a supported Data Action Target type in Data Cloud, allowing real-time outbound calls to external systems when a data action is triggered (e.g., a customer enters a segment). It is used for event-driven integrations like notifying a loyalty system or a custom app. The other options are unrelated Salesforce products or components.

Answer

Salesforce CPQ Quote Line Editor

Answer

Marketing Cloud Engagement Data Extension

Answer

Tableau CRM Dashboard Component

Question 10

Which tool in Data Cloud allows a consultant to view raw records inside a Data Source Object (DSO) to verify successful ingestion before mapping?

Accepted Answer

Data Explorer. Data Explorer allows users to inspect raw data inside DSOs as well as harmonized data inside DMOs.

Answer

Query Editor

Answer

Identity Resolution Monitor

Answer

Segment Canvas

Question 11

Which user interface area in Data Cloud is used to manage and create data streams?

Accepted Answer

Data Streams tab. The Data Streams tab in Data Cloud is where administrators create, configure, and monitor data streams from various sources.

Answer

Identity Resolution tab

Answer

Activation tab

Answer

Calculated Insights tab

Question 12

Which Data Cloud feature enables real-time event streaming from web and mobile applications directly into Data Source Objects?

Accepted Answer

Interaction SDK (Web and Mobile SDKs). The Data Cloud Interaction SDK (Web and Mobile SDKs) captures visitor events in real-time.

Answer

Salesforce CRM Bulk API

Answer

Marketing Cloud FTP drop

Answer

Heroku Connect sync trigger

Question 13

A consultant is designing a Calculated Insight to track the number of distinct product categories a customer has purchased from over the last 90 days. Which SQL function should be used to count unique categories correctly in Data Cloud?

Accepted Answer

COUNT(DISTINCT category_id). Calculated Insights support standard ANSI SQL functions, including COUNT(DISTINCT column_name) for calculating unique counts across dimensions.

Answer

DISTINCT_SUM()

Answer

GROUP_CONCAT()

Answer

UNIQUE_COUNT()

Question 14

An administrator is troubleshooting a failing Salesforce CRM data stream where standard objects (such as Contact and Account) are not syncing. What is the most likely configuration issue in the CRM connector setup?

Accepted Answer

The Salesforce CRM connector bundle was not deployed or activated during the connector setup wizard.. The Salesforce CRM connector relies on specific integration users and automatic bundle creation. If CRM objects fail to sync, permissions or bundle activation status are the primary culprits.

Answer

Standard CRM objects must be manually recreated as custom Data Source Objects before streaming.

Answer

The connected CRM org's API version is set higher than Data Cloud supports.

Answer

The Salesforce CRM connector requires manual Apex trigger creation for every object to be streamed.

Question 15

Which TWO actions can a Data Cloud consultant perform when configuring an Activation Target? (Choose two.)

Accepted Answer

Establish Cloud Storage targets like Amazon S3 buckets for file exports.. Option B is correct because an Activation Target in Data Cloud can be a Cloud Storage destination, allowing the consultant to configure an Amazon S3 bucket (or similar object storage) as the endpoint for exporting activation files. Option D is correct because Marketing Cloud Engagement is a supported activation destination, so the consultant configures the connection parameters (such as the Marketing Cloud account/business unit credentials) to send segments and attributes to it. Option A is not part of Activation Target configuration, since segment criteria are defined in Data Cloud segments (via the segment builder/SQL), not in the target. Option C is unrelated because Identity Resolution rulesets are configured in Data Cloud's Identity Resolution setup, not in an Activation Target. Option E is also unrelated because batch ingestion data streams are configured in Data Streams/Data Ingestion, not in an Activation Target.

Answer

Define complex SQL segment criteria directly inside the target configuration.

Answer

Configure Identity Resolution rulesets for merging customer profiles.

Answer

Set up batch ingestion data streams from external relational databases.