Salesforce Certified Data Cloud Consultant (Data 360 Consultant) (Data 360 Consultant) Data 360 Consultant Questions 151–225 | Page 3/7

151

Multi-Selectmedium

When mapping Data Source Objects (DSOs) to Data Model Objects (DMOs) in Salesforce Data Cloud, which TWO best practices should a consultant follow?

Select 2 answers

A.Always map every single source field from the DSO, regardless of whether it is needed.

B.Bypass mapping DSOs entirely and map Data Streams straight to Activation Targets.

C.Ensure primary keys and foreign keys are correctly mapped to maintain relational integrity.

D.Create a separate custom DMO for every individual attribute column in the source file.

E.Map to standard Cloud Information Model (CIM) DMOs whenever possible before resorting to custom DMOs.

AnswersC, E

Accurate key mapping is critical for building correct relationships and enabling downstream features.

Why this answer

Best practices for data mapping include mapping required primary and foreign keys accurately and utilizing standard Cloud Information Model (CIM) objects whenever applicable before creating custom DMOs.

Full explanation →

152

Multi-Selecthard

A consultant is reviewing data streams in Data Cloud and notices that a specific batch data stream has failed consecutive runs. Which THREE troubleshooting steps should the consultant take to diagnose and resolve the issue?

Select 3 answers

A.Restart the entire Data Cloud tenant instance from the Setup menu.

B.Verify that the source data schema has not changed (e.g., modified column names or dropped fields).

C.Manually rewrite the underlying Apache Spark cluster configuration files.

D.Check external connector authentication, access permissions, or expired security tokens.

E.Review the Ingestion History and error logs associated with the data stream.

AnswersB, D, E

Schema mismatches between the source file and the DSO definition frequently cause ingestion failures.

Why this answer

When troubleshooting data stream failures, checking the ingestion logs/error messages, verifying source schema/file structure changes, and ensuring cloud storage permissions or connector tokens are valid are standard practices.

Full explanation →

153

MCQeasy

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

A.Query Editor

B.Identity Resolution Monitor

C.Data Explorer

D.Segment Canvas

AnswerC

Data Explorer is used to inspect records within Data Source Objects and Data Model Objects.

Why this answer

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

Full explanation →

154

MCQeasy

What is the primary difference between batch ingestion and streaming ingestion in Data Cloud?

A.Batch ingestion is only used for Salesforce CRM, while streaming is for external systems.

B.Batch ingestion supports CSV files, whereas streaming ingestion only supports PDF files.

C.Streaming ingestion does not require data mapping, whereas batching does.

D.Batch ingestion processes data at scheduled intervals, whereas streaming ingestion processes events in near real-time.

AnswerD

Batch runs on schedules (e.g., hourly, daily), while streaming handles continuous real-time data flows.

Why this answer

Batch ingestion processes data at scheduled intervals in bulk, while streaming ingestion processes records in real-time or near real-time as they arrive.

Full explanation →

155

MCQhard

An enterprise is planning to ingest 500 million transaction records daily from an external data warehouse using cloud storage. To optimize ingestion performance and query speed in Data Cloud, which file format should the consultant recommend for batch export to Amazon S3?

A.SQL dump text files (.sql)

B.XML files with nested attributes

C.Microsoft Word (.docx) documents

D.Apache Parquet format

AnswerD

Parquet is a compressed columnar format optimized for large-scale data ingestion and querying.

Why this answer

Parquet is a columnar storage file format optimized for high-performance analytics, compression, and rapid batch ingestion in big data platforms like Data Cloud.

Full explanation →

156

MCQeasy

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

A.Identity Resolution tab

B.Activation tab

C.Calculated Insights tab

D.Data Streams tab

AnswerD

The Data Streams tab provides the interface for setting up and managing data streams.

Why this answer

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

Full explanation →

157

MCQmedium

A consultant wants to ensure that when identity resolution executes, address fields are populated from the system with the highest data quality score, which is stored as a custom attribute. How should the consultant approach this?

A.Disable Identity Resolution and use data transform queries.

B.Use the Highest Frequency rule to select the most common address.

C.Configure the Source Sequence reconciliation rule and prioritize the data sources according to the data quality hierarchy.

D.Write a Calculated Insight to overwrite the address field with SQL CASE statements.

AnswerC

Source Sequence allows ranking data sources so that the highest quality source dictates attribute survivorship.

Why this answer

Since custom data quality rankings dictate precedence, Source Sequence is the appropriate reconciliation rule when configured with a prioritized source order representing data quality tiers.

Full explanation →

158

MCQeasy

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

A.Salesforce CRM Bulk API

B.Marketing Cloud FTP drop

C.Interaction SDK (Web and Mobile SDKs)

D.Heroku Connect sync trigger

AnswerC

Interaction SDKs capture real-time clickstream and event data from web and mobile apps.

Why this answer

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

Full explanation →

159

MCQhard

An administrator is setting up the Amazon S3 connector to ingest CSV files into Data Cloud. During the configuration of the data stream, which prerequisite must be verified in the Amazon S3 bucket settings?

A.The files must be compressed in ZIP format prior to ingestion.

B.The S3 bucket must have public read access enabled for all files.

C.The IAM user or role used for connection must have ListBucket and GetObject permissions on the target bucket.

D.The S3 bucket must be hosted in the exact same geographic AWS region as the Salesforce CRM core instance.

AnswerC

Salesforce Data Cloud requires the connecting AWS identity to have permissions to list and read objects in the specified bucket.

Why this answer

To connect Amazon S3 to Data Cloud, the S3 bucket must have proper bucket policies, access keys or IAM roles configured, and appropriate CORS or network access if required by Salesforce IP ranges.

Full explanation →

160

MCQmedium

A consultant wants to create a segment of customers who have not opened any marketing emails in the last 6 months. Which segmentation container type should be used?

A.A Data Graph transform rule.

B.An inclusion container with an 'EQUAL TO 0' email open count calculated via Calculated Insight.

C.A streaming segment with zero refresh intervals.

D.An exclusion container configured to exclude profiles with email open events in the last 6 months.

AnswerD

Exclusion containers successfully remove profiles that match specific negative criteria.

Why this answer

To identify customers who did not perform an action (like opening an email), the consultant should use an exclusion container or filter profiles where email open events are absent within the specified timeframe.

Full explanation →

161

MCQhard

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?

A.DISTINCT_SUM()

B.GROUP_CONCAT()

C.COUNT(DISTINCT category_id)

D.UNIQUE_COUNT()

AnswerC

COUNT(DISTINCT ...) is the standard ANSI SQL aggregate function used to calculate distinct counts in Data Cloud Calculated Insights.

Why this answer

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

Full explanation →

162

MCQmedium

A Data Cloud Consultant is configuring a segment of high-value customers who made a purchase in the last 30 days. The marketing team requires this segment to be updated and pushed to an external advertising platform every 15 minutes. How should the consultant configure this activation?

A.Configure a Calculated Insight to trigger the activation webhook instantly.

B.Set the segment publish frequency to manual export.

C.Use a Salesforce Flow triggered by Data Actions.

D.Set the activation schedule to run on a streaming or frequent schedule supported by the target.

AnswerD

Depending on the activation target, segments can be refreshed frequently to meet near real-time requirements.

Why this answer

Streaming activations or frequent batch activations support near real-time publishing of segments to supported activation targets.

Full explanation →

163

MCQeasy

Which user permission is required to create and publish audience segments in Data Cloud?

A.Manage Activation Targets

B.Modify All Data on Data Streams

C.Manage Segments permission

D.Configure Identity Resolution

AnswerC

The 'Manage Segments' permission grants users the ability to create, edit, and publish segments.

Why this answer

Specific permissions such as Data Cloud Segment Admin or equivalent user permissions are required to manage segments.

Full explanation →

164

Multi-Selectmedium

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

Select 2 answers

A.Define complex SQL segment criteria directly inside the target configuration.

B.Establish Cloud Storage targets like Amazon S3 buckets for file exports.

C.Configure Identity Resolution rulesets for merging customer profiles.

D.Configure connection parameters to Marketing Cloud Engagement accounts.

E.Set up batch ingestion data streams from external relational databases.

AnswersB, D

Cloud storage buckets are standard activation targets for file-based exports.

Why this answer

Activation targets allow configuring destinations such as Marketing Cloud Engagement and Cloud Storage locations.

Full explanation →

165

MCQmedium

A consultant is configuring an activation for a Meta Ads activation target. When mapping fields, the consultant notices that standard identifiers like hashed email are required. Why does Data Cloud enforce these specific identifier mappings for ad targets?

A.Ad platforms require specific hashed contact points to perform secure audience matching and identity resolution on their side.

B.Salesforce requires all ad activations to be encrypted with AES-256 before transit.

C.It enables Marketing Cloud Engagement to send push notifications.

D.It prevents the segment from exceeding 100,000 records.

AnswerA

Hashed emails and phone numbers are mandatory for ad network matching algorithms.

Why this answer

Ad platforms require standardized hashed identifiers for secure matching against their user graphs.

Full explanation →

166

MCQhard

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?

A.The Salesforce CRM connector bundle was not deployed or activated during the connector setup wizard.

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

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

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

AnswerA

When setting up the Salesforce CRM connector, administrators must deploy and activate data bundles (like Sales and Service bundles) to create the corresponding data streams.

Why this answer

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.

Full explanation →

167

MCQeasy

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

A.System Administrator in core CRM without Data Cloud permission sets.

B.Data Cloud Admin or Data Cloud Consultant permission set.

C.Salesforce CRM Read-Only profile.

D.Standard Marketing Cloud User permission.

AnswerB

Administrative permissions in Data Cloud are required to configure identity resolution rulesets.

Why this answer

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

Full explanation →

168

Multi-Selecthard

A consultant is troubleshooting an activation that is failing to publish records to a cloud storage activation target. Which TWO areas should the consultant check during the investigation? (Choose two.)

Select 2 answers

A.Verify that the IAM role or storage bucket permissions allow Data Cloud to write files.

B.Confirm that the Tableau CRM license is active for all segment users.

C.Ensure that the CRM user has System Administrator profile assigned.

D.Check activation run logs and error messages in Data Cloud for specific failure codes.

E.Check if the Marketing Cloud connector package is paused.

AnswersA, D

Insufficient storage permissions will cause export failures.

Why this answer

Troubleshooting cloud storage publishing failures requires verifying target bucket permissions and connection status.

Full explanation →

169

MCQeasy

Which tab in Data Cloud is used to inspect the records inside a Data Model Object (DMO)?

A.Data Explorer

B.Calculated Insights tab

C.Activation tab

D.Segments tab

AnswerA

Data Explorer is the designated tool for viewing DSO and DMO records.

Why this answer

Data Explorer allows users to query and view records across both DSOs and DMOs.

Full explanation →

170

Multi-Selecthard

A consultant is designing an architecture where Salesforce Service Cloud cases need to trigger immediate actions in Data Cloud. Which TWO mechanisms can be used to stream or ingest Service Cloud data into Data Cloud? (Choose two.)

Select 2 answers

A.Printing physical case summaries and scanning them via OCR data streams

B.Manual weekly export of cases to an external hard drive and courier delivery

C.Standard Salesforce CRM Connector with streaming enabled

D.Salesforce Platform Events and Change Data Capture (CDC) integrated via Data Cloud streaming connectors

E.Direct SQL queries executed from Data Cloud against the Service Cloud production database

AnswersC, D

The standard CRM connector supports near-real-time streaming of CRM objects using Change Data Capture.

Why this answer

Service Cloud data can be ingested into Data Cloud via the standard CRM connector (batch/near-real-time streaming enabled) and Platform Events / Change Data Capture (CDC).

Full explanation →

171

MCQmedium

A consultant needs to create a segment based on customer loyalty tier, which is stored in a Custom Object mapped to the Individual DMO. When building the segment, the loyalty tier attribute is showing as blank for many unified profiles. What should the consultant check first?

A.Verify that the Custom Object is correctly mapped to the Individual DMO via a foreign key and that identity resolution has been run.

B.Check if the segment needs to be converted to a streaming segment to read custom objects.

C.Reinstall the Data Cloud data kit.

D.Ensure the segment publish schedule is set to run every 5 minutes.

AnswerA

Data must be correctly mapped to the data model and unified through identity resolution so that profile attributes correctly populate on the unified Individual profile.

Why this answer

If attributes appear blank in segmentation, the consultant should verify identity resolution rules, data mapping, and whether the data was successfully ingested and unified into the Individual DMO.

Full explanation →

172

Multi-Selectmedium

Which THREE attributes or details are typically required when setting up an Activation for an advertising platform (e.g., Meta Ads or Google Ads)? (Choose three.)

Select 3 answers

A.A custom Apex controller class for payload generation

B.Contact Point identifiers (such as hashed email or phone)

C.An active published Segment

D.An Advertising Activation Target

E.A Marketing Cloud Engagement journey canvas ID

AnswersB, C, D

Ad networks require matching identifiers like hashed emails.

Why this answer

Advertising activations require selecting a segment, mapping contact point identifiers, and linking an ad activation target.

Full explanation →

173

MCQeasy

When configuring a new segment, what is the significance of selecting the 'Individual' DMO as the primary profile object?

A.It automatically converts the segment into a real-time streaming segment.

B.It restricts the segment from being used in activations.

C.It bypasses the need for Calculated Insights.

D.It ensures the segment evaluates unified customer profiles rather than unmerged source records.

AnswerD

Choosing the Individual DMO targets unified customer profiles created by Identity Resolution.

Why this answer

The Individual DMO represents the unified customer profile resulting from Identity Resolution, serving as the central anchor for customer-centric segmentation.

Full explanation →

174

MCQmedium

A marketer needs to target high-value customers in Data Cloud whose total lifetime spend calculated via a Calculated Insight exceeds $10,000. The segment needs to be evaluated continuously as transactions stream into the platform. What is the key limitation the consultant must consider when building this segment?

A.Calculated Insights require manual execution before every segment publish.

B.Calculated Insights cannot be referenced in any segment definition in Data Cloud.

C.Streaming segments do not support criteria based on Calculated Insights.

D.Calculated Insights only refresh once per month, preventing timely segmentation.

AnswerC

Streaming segments only support streaming data models and profile attributes, not batch-processed Calculated Insights.

Why this answer

Streaming segments do not support Calculated Insights as part of their criteria rules; Calculated Insights are typically used in batch or scheduled segments.

Full explanation →

175

MCQeasy

Which of the following is a valid activation platform natively supported by Data Cloud?

A.Meta Ads

B.Custom On-Premises Oracle Database

C.Local Excel CSV file viewer

D.Legacy desktop email client

AnswerA

Meta Ads is a fully supported native activation platform in Data Cloud.

Why this answer

Meta Ads is one of the native ad platform activation targets supported out-of-the-box in Data Cloud.

Full explanation →

176

Multi-Selecthard

Which TWO factors directly impact the performance of Identity Resolution?

Select 2 answers

A.The number of activation targets

B.The total volume of records in the profile

C.The number of segments created

D.The frequency of data stream refreshes

E.The complexity of the matching ruleset

AnswersB, E

Volume directly correlates to processing time.

Why this answer

The number of records and the complexity of the rulesets (matching logic) significantly impact resolution speed.

Full explanation →

177

MCQmedium

A marketer wants to include attributes from a related Related Data Object (e.g., Total Lifetime Spend from Orders) in an activation destined for an ad network. How should the consultant configure this?

A.Include the attributes as Additional Attributes (Activation Attributes) within the Activation configuration.

B.Create a new Segment for every possible spending bracket.

C.Export the raw data via Data Share and write a custom script on the ad network side.

D.Write a custom Apex trigger on the Unified Individual object to push attributes to the ad network API.

AnswerA

Activation attributes allow marketers to append related DMO attributes (like order totals or preferred store) to the segment export.

Why this answer

Contact points and additional attributes can be added as activation attributes directly within the Activation creation wizard, drawing from related DMOs linked to the Unified Individual.

Full explanation →

178

Multi-Selecthard

An architect is planning the identity resolution strategy for a global retail brand combining data from e-commerce, retail POS, and loyalty applications. Which THREE elements should the architect consider when designing match rules and reconciliation rules? (Choose three.)

Select 3 answers

A.The specific order in which match rules are evaluated in the ruleset

B.Reconciliation rule strategies (e.g., Most Recent, Most Frequent) for selecting attribute values

C.Tableau Pulse dashboard refresh intervals

D.Data hygiene and standardization of matching fields (e.g., trimming whitespace, lowercasing emails)

E.The physical location of the cloud data warehouse underlying the source system

AnswersA, B, D

Match rules execute sequentially; rule order directly impacts unification results.

Why this answer

Identity resolution design requires careful selection of match rule criteria (e.g., email, phone), ordering of match rules, and choosing reconciliation rules (e.g., most recent, most frequent) for profile attributes.

Full explanation →

179

MCQeasy

A consultant needs to create a segment based on a specific product category purchased by customers. Which Data Cloud feature allows the consultant to traverse from the Unified Individual object down to the Sales Order and Product objects to define this criteria?

A.Segmentation Canvas Container and Related Attributes

B.Identity Resolution Ruleset

C.Calculated Insights Builder

D.Activation Target Mapper

AnswerA

The segmentation canvas allows traversal across related objects using containers.

Why this answer

Segmentation canvas allows users to navigate related Data Model Objects using relationship paths to build container criteria.

Full explanation →

180

MCQhard

An administrator has configured a data stream from a CSV file in Amazon S3. After running the stream, records are failing validation because of date format discrepancies. Where can the administrator inspect the exact error logs for individual failing records?

A.Setup > Data Integration Rules > Error Reports.

B.Data Cloud Setup > Data Manager > Data Streams > select stream > Run History / Monitor.

C.Amazon S3 Console > CloudWatch logs integrated with Salesforce.

D.Setup > Monitoring > Debug Logs with Data Cloud trace flags.

AnswerB

The Data Streams monitor and run history provide insights into row-level errors, parsing failures, and success counts.

Why this answer

Data Cloud provides detailed error logs and run history at the data stream level in Data Manager to troubleshoot parsing and validation failures.

Full explanation →

181

MCQeasy

Where in Salesforce Setup can an administrator view the status of Data Cloud background jobs and queue metrics?

A.Setup > Environments > Scheduled Jobs

B.Data Cloud Setup > Monitoring > Background Jobs (or Data Manager monitor)

C.Setup > Company Information > Job Queues

D.Data Cloud Setup > System Logs > Async Queue

AnswerB

Background jobs, ingestion runs, and processing queues are monitored within Data Cloud Setup / Data Manager interfaces.

Why this answer

Data Cloud provides monitoring tools within Data Cloud Setup and Data Manager.

Full explanation →

182

MCQeasy

What is the primary function of an Activation in Salesforce Data Cloud?

A.To execute Identity Resolution matching rules.

B.To ingest raw data files from Amazon S3.

C.To publish segment member lists and associated attributes to connected activation targets.

D.To write Calculated Insight ANSI SQL queries.

AnswerC

Activations deliver segment data to external destinations.

Why this answer

An Activation takes segment membership lists and publishes them along with selected attributes to configured activation targets.

Full explanation →

183

Multi-Selecthard

An enterprise organization is planning its Data Cloud deployment and needs to understand how Data Spaces and Data Governance features assist with compliance and data segregation. Which TWO capabilities do Data Spaces provide? (Choose two.)

Select 2 answers

A.Logical separation of data streams, segments, and insights for different business units or regions.

B.Automatic physical deletion of data across all global data centers within 1 second of a consent revocation.

C.Elimination of all credit consumption limits within partitioned environments.

D.Automatic generation of encryption keys for HIPAA compliance.

E.Scoped access control ensuring users only see data and segments associated with their assigned Data Space.

AnswersA, E

Data Spaces provide logical partitioning to isolate data assets between business units or regions.

Why this answer

Data Spaces partition data streams, segments, and insights, and allow organizations to scope access for different business units or geographic regions.

Full explanation →

184

MCQhard

A Data Cloud Consultant is troubleshooting a scheduled batch activation to an Amazon S3 activation target. The activation job completes with partial success, and some records are missing from the destination file. Where should the consultant check to diagnose the root cause of the export failure?

A.Review the Apex Job Queue for batch processing failures.

B.Examine the Streaming Ingestion monitor in Data Cloud.

C.Review the Activation History and related run details in the Data Cloud Setup UI for specific error logs and record-level failures.

D.Check the Setup Audit Trail in the core Salesforce CRM org.

AnswerC

Correct. Activation History provides detailed status logs for each activation run, showing records processed and failure reasons.

Why this answer

Data Cloud provides monitoring tools such as the Activation History and History logs within the platform setup to view execution status, error messages, and metrics on exported records.

Full explanation →

185

MCQhard

A consultant is writing a Calculated Insight that aggregates lifetime spend and needs to filter out records where the transaction amount is null. Which SQL clause should be used in the query to exclude null values?

A.FILTER NULL VALUES

B.EXCLUDE NULLS

C.HAVING amount NOT EQUAL TO NULL

D.WHERE amount IS NOT NULL

AnswerD

The IS NOT NULL operator in the WHERE clause correctly filters out null transaction amounts.

Why this answer

In ANSI SQL, filtering out null values from an aggregation or dataset is performed using the WHERE clause with the IS NOT NULL operator.

Full explanation →

186

MCQhard

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?

A.A Python lambda function embedded in the SELECT clause.

B.A CASE expression with numeric evaluation ranges.

C.A Data Graph transform rule.

D.A SOQL IF-THEN block.

AnswerB

CASE expressions provide clean conditional logic in SQL queries to categorize metric outputs.

Why this answer

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

Full explanation →

187

MCQeasy

What role do Activation Mappings play in Data Cloud?

A.They map machine learning model predictions to Einstein Studio endpoints.

B.They map Data Cloud profile and attribute fields to the corresponding fields expected by the activation target.

C.They map raw source data streams to the Customer 360 Data Model.

D.They map user permissions to specific Salesforce CRM roles.

AnswerB

Activation mappings ensure data fields align correctly with the target platform's schema expectations.

Why this answer

Activation Mappings define how attributes from the Unified Profile and related DMOs map to the fields required by the external activation target schema.

Full explanation →

188

MCQhard

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?

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

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

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

D.Utilize Data Spaces and targeted permission sets to isolate segments, activation targets, and data access between teams.

AnswerD

Data Spaces provide logical partitioning of data, segments, and activations within a single Data Cloud instance.

Why this answer

Data Cloud leverages Data Space access controls and permission sets to partition data, segments, and activation targets between different business units or teams.

Full explanation →

189

Multi-Selectmedium

A consultant is managing segment publishing schedules. Which THREE factors influence when and how batch segments publish? Choose 3 options.

Select 3 answers

A.The configured segment refresh frequency (e.g., daily, weekly).

B.Manual triggers to publish or recalculate a segment on demand.

C.The physical geographical location of the Activation Target server.

D.Upstream Data Stream completion and Identity Resolution job runs.

E.The real-time clickstream event rate exceeding 100,000 events per second.

AnswersA, B, D

Refresh frequency dictates the recurring schedule of segment evaluation.

Why this answer

Batch segment publishing is governed by segment refresh schedules, upstream data freshness, and manual triggers.

Full explanation →

190

MCQmedium

A company is utilizing Service Cloud as its primary customer support platform and has integrated it into Data Cloud. The support team wants to trigger real-time alerts in an external system whenever a high-priority case is created for a VIP customer. Which Data Cloud feature enables this capability?

A.Activation Targets

B.Batch Segmentation

C.Calculated Insights

D.Data Actions

AnswerC, D

Calculated Insights run on a schedule and are not real-time event triggers.

Why this answer

Data Actions allow organizations to trigger real-time streaming events and actions (such as sending a webhook or creating a task) based on data entering Data Cloud.

Full explanation →

191

Multi-Selecthard

An organization is designing an activation strategy using Data Cloud to reach audiences across multiple channels. Which THREE destination types are supported natively as Activation Targets in Data Cloud? (Choose three.)

Select 3 answers

A.Cloud File Storage (e.g., Amazon S3)

B.Direct Access to Salesforce CRM standard object tables without synchronization

C.Local on-premise tape backup drives

D.Advertising networks like Meta and Google Ads (via Advertising/Audience connectors)

E.Marketing Cloud Engagement

AnswersA, D, E

Cloud File Storage is supported as an activation target for file-based segment exports.

Why this answer

Data Cloud supports various native activation targets including Marketing Cloud Engagement, advertising platforms (Meta, Google), and cloud storage buckets or webhook endpoints.

Full explanation →

192

MCQmedium

When configuring a data stream from an external S3 bucket, what file format is mandatory for the file to be ingested successfully?

A.CSV or Parquet

B.JSON

C.XML

D.Excel (XLSX)

AnswerA

CSV and Parquet are the standard supported formats.

Why this answer

Data Cloud requires files to be in CSV or Parquet format for S3 ingestion.

Full explanation →

193

MCQhard

A calculated insight calculating average order value fails during execution with a timeout error. How should the consultant optimize the query?

A.Increase the batch segment publishing frequency from daily to hourly.

B.Convert the Calculated Insight into a streaming segment source.

C.Map the calculated insight fields directly to Marketing Cloud Engagement attributes.

D.Refactor the query to use incremental processing logic and filter out historical data older than required.

AnswerD

Filtering unneeded historical data and optimizing queries reduces resource consumption and prevents timeouts.

Why this answer

Optimizing Calculated Insights involves reducing scan sizes, avoiding overly complex self-joins, and leveraging indexed fields where possible.

Full explanation →

194

MCQeasy

A multinational enterprise is provisioning Salesforce Data Cloud and needs to ensure that data residing in the APAC regional operational silo is strictly partitioned from the EMEA region, restricting administrative visibility and data stream ingestion per region. Which Salesforce Data Cloud core feature should the consultant configure to achieve this isolation?

A.Data Spaces

B.Business Units

C.Data Streams

D.Permission Sets

AnswerA

Data Spaces are specifically designed to segment data, identity resolution, insights, and activations within a single tenant to meet regional or business unit boundaries.

Why this answer

Data Spaces in Salesforce Data Cloud allow organizations to partition data and metadata within a single Data Cloud instance, enabling logical separation for different regions, business units, or brands.

Full explanation →

195

MCQeasy

What happens to an active segment when its underlying Data Model Object receives updated data during a scheduled batch ingestion?

A.During its next scheduled publish run, the segment evaluates the updated data and refreshes its audience membership.

B.The data updates are ignored until the yearly platform upgrade occurs.

C.The segment automatically deletes itself and must be rebuilt from scratch.

D.The segment pauses all publishing until an administrator manually re-approves the rules.

AnswerA

Scheduled batch segments refresh their membership based on the latest data available during each publish run.

Why this answer

When a batch segment runs according to its publishing schedule, it evaluates against the latest data available in the Data Model Objects.

Full explanation →

196

Multi-Selecthard

Which THREE methods can be used to monitor data stream health and troubleshoot ingestion errors in Data Cloud? (Choose THREE)

Select 3 answers

A.Inspecting raw records using Data Explorer.

B.Reviewing the Run History tab on individual Data Stream detail pages.

C.Analyzing Salesforce CRM Apex Debug logs.

D.Running a SOQL query in Developer Console to query DSO tables.

E.Checking data stream metrics and status indicators in the Data Cloud workspace.

AnswersA, B, E

Data Explorer verifies whether data successfully arrived in the DSO.

Why this answer

Consultants can use the Data Stream run history logs, Data Explorer to verify ingested records, and workspace monitoring tools to check system health.

Full explanation →

197

Multi-Selecthard

An enterprise architect is evaluating Data Cloud licensing and consumption models. Which TWO components directly contribute to Data Cloud credit consumption? (Choose two.)

Select 2 answers

A.Creation of custom Lightning record page layouts in Sales Cloud

B.Number of standard Salesforce CRM user licenses assigned in Sales Cloud

C.Identity Resolution processing jobs and segmentation runs

D.Data Ingestion volume (number of records and file sizes processed)

E.Number of Salesforce reports created in the CRM reporting tab

AnswersC, D

Running identity resolution and evaluating segments consumes processing credits.

Why this answer

Data Cloud consumption is driven by data ingestion volume, storage, identity resolution processing, segmentation runs, and query executions.

Full explanation →

198

Multi-Selectmedium

Which TWO capabilities are provided by Data Spaces within Data Cloud? (Choose two.)

Select 2 answers

A.Built-in machine learning model training pipelines

B.Physical isolation of data centers across different global continents

C.Scoped access control for segments, activations, and calculated insights

D.Logical partitioning of data, metadata, and insights within a single Data Cloud instance

E.Automatic bidirectional data synchronization with external relational databases

AnswersC, D

Data Spaces enforce scoping for downstream items like segments and insights.

Why this answer

Data Spaces partition data and metadata logically and allow administrators to scope user access, segments, and insights within a multi-tenant or multi-BU enterprise.

Full explanation →

199

Multi-Selecteasy

Which TWO ad platforms are natively supported as activation targets in Data Cloud? (Choose two.)

Select 2 answers

A.Local Desktop CSV Spreadsheet Viewer

B.Legacy On-Premises Email Server

C.Google Ads

D.Meta Ads

E.Standalone Word Processor Application

AnswersC, D

Google Ads is a native activation target supporting customer match integrations.

Why this answer

Meta Ads and Google Ads are prominent advertising platforms natively supported as activation targets in Data Cloud.

Full explanation →

200

MCQmedium

An administrator has added a new custom field to a Data Model Object (DMO) in Data Cloud. However, users are complaining that they cannot see the new field when building segments. What is the likely cause?

A.Calculated insights must be rebuilt before a DMO field is available for segmentation.

B.The field must also be mapped from a Data Source Object (DSO) to the DMO field for data to populate.

C.Data Cloud requires a manual restart of the segment job engine to recognize schema changes.

D.The custom field must be explicitly added to the Identity Resolution ruleset configuration.

AnswerB

Creating a field on a DMO is only the first step; data will not flow into it until the corresponding DSO field is mapped to the new DMO field.

Why this answer

After modifying a DMO or mapping, administrators must ensure the field is mapped properly and that users have the correct field-level security or permission set updates if applicable. Also, segments rely on mapped fields in Data Model Objects.

Full explanation →

201

MCQeasy

Where in Salesforce Data Cloud does a consultant navigate to create and manage Identity Resolution rulesets?

A.Data Cloud Setup > Activation Targets

B.Data Cloud Setup > Identity Resolution

C.Setup > Security Controls > Identity Management

D.Data Cloud Setup > Calculated Insights

AnswerB

Identity Resolution is located directly under Data Cloud Setup.

Why this answer

Identity Resolution rulesets are created and managed within the Identity Resolution tab under Data Cloud setup.

Full explanation →

202

MCQmedium

A consultant is creating a Calculated Insight to track the Lifetime Value (LTV) of customers. In which interface is the logic for this aggregation built?

A.Segment Builder

B.Activation Target configuration

C.Data Mapping canvas

D.Calculated Insights Builder

AnswerD

The builder is the dedicated workspace for CI creation.

Why this answer

Calculated Insights are built using the 'Calculated Insights' builder interface which supports both UI-based point-and-click or SQL.

Full explanation →

203

MCQeasy

An administrator needs to assign permission sets to users who will manage data streams and ingestion in Salesforce Data Cloud. Which permission set license must be assigned to the users first?

A.Data Cloud User Permission Set License

B.Data Cloud Streaming API License

C.Customer Data Platform Integration License

D.Salesforce CRM Integration License

AnswerA

This is the correct base license required for users to access Data Cloud features and be assigned Data Cloud permission sets.

Why this answer

Data Cloud requires specific permission set licenses to be assigned before users can be granted functional permission sets like Data Cloud Admin or Data Cloud Marketing Specialist. The Data Cloud Admin or Data Cloud Use permission set license grants access to the core features.

Full explanation →

204

MCQeasy

Which feature must be enabled in a Salesforce org before provisioning Data Cloud if the organization plans to ingest data from multiple Salesforce CRM orgs into a single Data Cloud tenant?

A.Platform Encryption

B.Enterprise Territory Management

C.Salesforce CRM Connector

D.Enhanced Domains

AnswerC

The Salesforce CRM connector is the native tool used to connect one or more CRM orgs to Data Cloud.

Why this answer

Multi-org connector setup requires specific org configurations, but standard Data Cloud provisioning allows CRM connection via the Salesforce CRM connector.

Full explanation →

205

MCQmedium

An enterprise marketing team wants to publish audience segments to Meta Ads via Data Cloud. When setting up the Activation Target for Meta, what specific identifier type must be mapped from the Data Cloud profile space to successfully match and target users on the ad platform?

A.Hashed email address or hashed phone number

B.Device Advertising ID (IDFA or GAID) exclusively

C.Data Cloud Unified Individual ID

D.Salesforce CRM Contact ID

AnswerA

Meta Ads requires hashed PII (SHA-256) to securely match customer lists for custom audience activation.

Why this answer

Meta Ads activation targets require hashed identifiers such as hashed email addresses or hashed phone numbers to perform deterministic matching against user profiles on the platform.

Full explanation →

206

MCQeasy

A Data Cloud Consultant needs to create a segment of customers who have made a purchase in the last 30 days. Which type of segment should be used to ensure the membership updates automatically on a scheduled basis?

A.Scheduled Segment

B.Ad-hoc Segment

C.Streaming Segment

D.Static Segment

AnswerA

Scheduled segments refresh membership automatically based on a set frequency like daily or hourly.

Why this answer

A scheduled segment evaluates criteria on a recurring frequency (hourly, daily) to refresh the segment membership.

Full explanation →

207

Multi-Selecthard

Which TWO of the following statements are accurate regarding streaming segments in Data Cloud? (Choose two.)

Select 2 answers

A.Streaming segments require all source DMOs to be enabled for streaming ingestion.

B.Streaming segments do not support activation to any external targets.

C.Streaming segments can utilize any batch DMO or custom object without streaming enablement.

D.Streaming segments evaluate profile membership in near real-time as streaming data events arrive.

E.Streaming segments must be manually published every hour by an administrator.

AnswersA, D

Source objects used in streaming segments must support streaming ingestion.

Why this answer

Streaming segments evaluate criteria continuously as data flows into streaming DMOs. They require streaming-enabled data sources and have specific structural rules compared to batch segments.

Full explanation →

208

MCQmedium

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?

A.Inside the Marketing Cloud Contact Builder attribute group setup

B.Directly inside the Data Stream configuration settings

C.In the Attributes selection step of the activation creation wizard

D.Within the Identity Resolution ruleset mapping canvas

AnswerC

Additional profile or related attributes are added in the Attributes section of the activation workflow.

Why this answer

Activation attributes are selected in the Attributes step of the Activation creation workflow after selecting the segment and activation target.

Full explanation →

209

MCQeasy

What is the primary purpose of an Activation in Salesforce Data Cloud?

A.To merge duplicate customer records into unified profiles.

B.To publish segment membership data and attributes to destination activation targets.

C.To calculate aggregated business metrics across engagement history.

D.To ingest raw data files from external cloud storage.

AnswerB

Activations push segment audiences to external marketing channels or storage locations.

Why this answer

Activations publish segment membership data to downstream destination targets for marketing and engagement.

Full explanation →

210

MCQmedium

A marketing team needs to deliver daily targeted campaigns to Google Ads using a Data Cloud segment. The ad platform requires the audience file to be refreshed every 24 hours. How should the consultant configure the activation schedule?

A.Rely on manual activation republishing triggered by an administrator every morning.

B.Set the Activation to stream in real-time to Google Ads using webhooks.

C.Configure the Data Stream refresh rate to 24 hours.

D.Configure the Activation schedule to run daily, immediately following the Segment refresh schedule.

AnswerD

Aligning the activation schedule to run after the segment refresh ensures the ad network receives the most up-to-date audience daily.

Why this answer

Activation schedules can be configured to run daily or at specific intervals following the segment publish schedule to ensure timely delivery to the target platform.

Full explanation →

211

MCQhard

A consultant is writing a Calculated Insight that requires joining two separate Data Model Objects: Sales__dlm (sales transactions) and Product__dlm (product catalog). What is required for this join to execute successfully in a Calculated Insight?

A.Joins must be pre-configured in an external ETL tool before ingestion into Data Cloud.

B.The join must be executed using Salesforce SOQL relationship traversal syntax.

C.The tables must be joined using standard ANSI SQL JOIN syntax referencing valid DMO fields and relationship keys.

D.Joins between different DMOs are prohibited; all metrics must be derived from a single DMO.

AnswerC

Calculated Insights use standard ANSI SQL JOIN constructs referencing mapped DMO fields.

Why this answer

Calculated Insights join DMOs using standard ANSI SQL JOIN syntax, relying on correctly established relationships and primary/foreign key mappings in the Data Model.

Full explanation →

212

MCQhard

An enterprise organization is activating segment data to an external S3 bucket via an Activation Target. The downstream analytics team reports that files are missing or incomplete when processing runs immediately after segment publication. What is the most likely cause of this issue?

A.The S3 bucket IAM role lacks write permissions for Data Cloud.

B.The downstream system is attempting to consume data before the activation export job has finished publishing all chunks.

C.Data Cloud only supports JSON format, while S3 requires Parquet.

D.The segment criteria evaluated evaluated too many records, causing Data Cloud to abort the export.

AnswerB

Downstream systems must account for timing dependencies where activation files are generated asynchronously.

Why this answer

Timing dependencies between segment publication and activation completion mean that downstream consumers must wait for the activation publishing job to fully finish writing all files to the target.

Full explanation →

213

Multi-Selectmedium

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

Select 3 answers

A.Nesting multiple related object criteria to filter based on child object attributes.

B.Adding exclusion containers to remove profiles that match specific criteria.

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

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

E.Using relative date filters such as 'in the last X days'.

AnswersA, B, E

Practitioners can drill down into related objects (e.g., Orders, Cases) to filter audience membership.

Why this answer

The Segment Canvas supports various logical containers and operators, including inclusion, exclusion, related object attribute filters, and date/numeric operators.

Full explanation →

214

MCQmedium

A consultant wants to verify that records from an Ingestion API stream are successfully landing in the Data Source Object. Which tool should the consultant use?

A.Data Explorer

B.Salesforce CRM Debug Logs

C.Segment Canvas preview mode

D.Einstein Studio model evaluation tab

AnswerA

Data Explorer lets users view raw DSO records directly.

Why this answer

Data Explorer allows consultants to inspect raw records inside Data Source Objects (DSOs) to verify ingestion success.

Full explanation →

215

Multi-Selecthard

Which TWO considerations are critical when designing custom Data Model Objects (Dmos) to support large-scale segmentation in Data Cloud? (Choose TWO)

Select 2 answers

A.Store all attributes as text strings to prevent data type conversion errors.

B.Write custom Apex triggers on the DMOs to optimize database indexing.

C.Establish correct cardinality (e.g., 1-to-many) on all object relationships.

D.Ensure every custom DMO has a properly defined primary key.

E.Bypass the Cloud Information Model entirely by using raw DSOs for segmentation.

AnswersC, D

Correct cardinality ensures segmentation queries execute efficiently without performance degradation.

Why this answer

Designing DMOs for scale requires defining proper primary keys and indexing, as well as establishing correct relationship cardinalities to avoid Cartesian products during segmentation queries.

Full explanation →

216

MCQeasy

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

A.A Tableau CRM dashboard binding string.

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

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

D.A valid relationship between the attribute's DMO and the Unified Individual DMO.

AnswerD

Data Cloud requires a defined path back to the Unified Individual to associate attributes with the segment audience.

Why this answer

Activation attributes must be related to the Unified Individual object either directly or via related Data Model Objects (DMOs) linked by foreign keys.

Full explanation →

217

Multi-Selectmedium

An administrator is setting up a new Salesforce Data Cloud org and needs to configure user access securely. Which TWO steps are required to grant a user access to Data Cloud administrative features? (Choose two.)

Select 2 answers

A.Add the user to the Salesforce CRM Administrator public group.

B.Assign the Data Cloud Admin permission set to the user.

C.Assign the Data Cloud User permission set license to the user.

D.Grant the user the 'Customize Application' permission on their core Salesforce profile.

E.Enable the user as a Marketing Cloud administrator in Engagement setup.

AnswersB, C

The Data Cloud Admin permission set grants administrative rights over data streams, connectors, and configuration.

Why this answer

Assigning administrative access in Data Cloud requires assigning the base permission set license followed by the appropriate administrative permission set (e.g., Data Cloud Admin).

Full explanation →

218

MCQeasy

When reviewing the Segment canvas, a consultant notices a metric called 'Publish History'. What information does this metric provide?

A.The exact SQL query generated by the segmentation engine.

B.The historical changes made to the segment criteria configuration by users.

C.A log of past segment publication runs, including success/failure status and record counts.

D.The real-time streaming throughput of incoming data stream events.

AnswerC

Publish History records historical execution details of segment refreshes and activations.

Why this answer

Publish History in Data Cloud provides details on past segment runs, including status (success/failure), row counts, start time, and duration.

Full explanation →

219

MCQeasy

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?

A.Data Action Target

B.Ingestion API Source

C.Connected App Framework

D.Activation Target

AnswerD

An Activation Target is required to configure the connection to Amazon S3.

Why this answer

An Activation Target defines the destination system and authentication parameters required to publish segments externally.

Full explanation →

220

MCQmedium

A consultant is setting up an activation for Google Ads. The marketing team wants to verify how many user records were successfully matched by Google during the audience upload. Where can the consultant review this match rate information?

A.In the Salesforce Core CRM Campaign Statistics report.

B.In the destination ad platform's audience manager interface (e.g., Google Ads UI), as match rates are calculated post-upload by the platform.

C.In the Data Stream ingestion health dashboard.

D.In the Data Cloud Activation Monitor audit log under 'Match Rate Percentage'.

AnswerB

Ad platforms calculate match rates after receiving the customer list, displaying the match percentage in their native UI.

Why this answer

While Data Cloud reports successful export publication, detailed match rate statistics (how many records matched platform user bases) are typically viewed within the ad platform's audience manager dashboard (e.g., Google Ads UI).

Full explanation →

221

Multi-Selectmedium

Which TWO factors should a consultant consider when designing match rules to prevent over-merging of customer profiles? Choose 2 options.

Select 2 answers

A.Running identity resolution jobs only once per year.

B.Combining multiple attributes (e.g., First Name AND Last Name AND Postal Code) within a single match rule.

C.Using high-cardinality, unique identifiers like email addresses or specific party IDs.

D.Disabling all contact point email mappings in the data model.

E.Setting the reconciliation rule to Most Recent across all attributes.

AnswersB, C

Combining attributes increases precision and reduces false positive matches.

Why this answer

Preventing over-merging involves using high-specificity criteria and combining multiple attributes with AND logic.

Full explanation →

222

Multi-Selectmedium

An administrator is planning to ingest real-time event data into Data Cloud. Which TWO methods or connectors can be utilized for streaming ingestion? (Choose two.)

Select 2 answers

A.Scheduled nightly CSV batch drops via Amazon S3

B.Salesforce CRM nightly change data capture bundle

C.Web and Mobile SDK (Interaction Data Streams)

D.Data Cloud Ingestion API

E.Manual file upload via Data Cloud Setup every 12 hours

AnswersC, D

Web and Mobile SDKs capture real-time visitor behavior and stream events directly into Data Cloud.

Why this answer

Real-time ingestion is supported via the Ingestion API and Web/Mobile SDKs (Interaction Studio / Web & Mobile streams).

Full explanation →

223

MCQeasy

Which object type serves as the primary source for building audience segments in Salesforce Data Cloud?

A.Data Lake Object (DLO)

B.Activation Target Object

C.Unified Individual DMO

D.Calculated Insight Source Object

AnswerC

The Unified Individual Data Model Object is the core entity used for profile segmentation.

Why this answer

Unified Individual is the primary profile object used for audience segmentation in Data Cloud.

Full explanation →

224

Multi-Selecthard

An administrator is configuring Identity Resolution in Data Cloud. Which THREE components must be defined as part of an Identity Resolution ruleset? (Choose three.)

Select 3 answers

A.Reconciliation Rules (e.g., precedence rules for selecting attribute values for unified profiles)

B.Apex trigger validation scripts for custom match scoring

C.Target Unified Data Model Objects (e.g., Unified Individual)

D.Core Salesforce duplicate management rules from CRM Setup

E.Match Rules (e.g., matching on email, phone, or name)

AnswersA, C, E

Reconciliation rules define which source attribute values populate the unified profile (e.g., most recent, most frequent).

Why this answer

Identity resolution rulesets require match rules, reconciliation rules, and target objects (Unified Individual/Contact).

Full explanation →

225

MCQeasy

What is the term for mapping unharmonized Data Source Object attributes to standardized Cloud Information Model attributes?

A.Harmonization

B.Segmentation

C.Ingestion

D.Activation

AnswerA

Harmonization standardizes data attributes across different sources into common DMOs.

Why this answer

Harmonization is the process of mapping disparate data sources to standard Data Model Objects based on the Cloud Information Model.

Full explanation →

Salesforce Certified Data Cloud Consultant (Data 360 Consultant) (Data 360 Consultant) (Data 360 Consultant) — Questions 151–225