Data 360 Consultant Practice Test 22 — 15 Questions

Question 1

A consultant is investigating why a batch segment publish job failed with an out-of-memory error. The segment contains multiple nested related object containers querying several years of historical transaction data. What is the best architectural remedy?

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

Accepted Answer

Refine the segment criteria to narrow historical date ranges and simplify complex multi-level container nesting.. The out-of-memory error in a batch segment publish job is caused by the volume and complexity of the data being processed—specifically, the multi-year historical transaction data and deeply nested related object containers. Option B directly addresses the root cause by narrowing the date range (reducing the number of records) and simplifying the container nesting (reducing the query complexity and memory footprint). This is the best architectural remedy because it optimizes the segment definition itself, leading to more efficient query execution and lower memory usage.

Answer

Switch the segment to run every 1 minute to process smaller chunks.

Answer

Delete all Activation Targets in the tenant.

Answer

Re-map all data streams to use CSV format.

Question 2

Which TWO statements accurately describe the role and function of Calculated Insights in Data Cloud? (Choose two.)

Accepted Answer

They can be utilized as attributes during audience segmentation.. Calculated Insights allow users to aggregate metrics using SQL or a builder, and these metrics become available as attributes in segmentation.

Answer

They are used exclusively for raw data stream parsing before data mapping.

Answer

They automatically update source systems in Salesforce CRM via real-time webhooks.

Answer

They replace the need for Identity Resolution rulesets entirely.

Question 3

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?

Accepted Answer

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

Answer

FILTER NULL VALUES

Answer

EXCLUDE NULLS

Answer

HAVING amount NOT EQUAL TO NULL

Question 4

An enterprise organization needs to schedule activations so that they run immediately after the daily Identity Resolution rules complete and the segment membership is updated. How should the Data Cloud Consultant configure the activation timing?

Accepted Answer

Configure the activation frequency to match or follow the segment refresh schedule so it triggers upon segment completion.. Activations in Data Cloud are dependent on segment publication. By default, segments refresh based on a schedule. To run an activation immediately following segment refresh, the activation must be tied to the segment schedule, or the segment must be refreshed right before the activation window.

Answer

Set up an external REST API webhook in Data Actions to trigger the activation once Identity Resolution finishes.

Answer

Configure a Cloud File Storage target with an hourly batch polling interval.

Answer

Write an Apex trigger on the Activation DMO to execute the export job asynchronously.

Question 5

Which THREE data categories are supported when classifying Data Model Objects in Data Cloud? (Choose THREE)

Accepted Answer

Engagement. Data Cloud categorizes DMOs into specific categories such as Profile, Engagement, and Other (or primarilly Profile and Engagement categories for customer data modeling).

Answer

Apex Controller

Answer

Transactional Trigger

Question 6

A consultant is configuring a data stream from a Salesforce CRM org. The client requests that records older than 2 years be excluded from ingestion to conserve storage. Where should this filter be applied?

Accepted Answer

Apply a filter criterion in the Salesforce CRM data stream configuration wizard.. Salesforce CRM data streams support filter criteria (WHERE clauses) during data stream setup to restrict ingestion based on date or field conditions.

Answer

Modify the global retention policy in Salesforce CRM Setup.

Answer

Write a nightly Apex batch job in CRM to delete historical records.

Answer

Configure a Calculated Insight to drop old records from the DMO.

Question 7

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

Accepted Answer

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

Answer

Data Cloud Setup > Activation Targets

Answer

Setup > Security Controls > Identity Management

Answer

Data Cloud Setup > Calculated Insights

Question 8

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?

Accepted Answer

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

Answer

Segment Builder

Answer

Activation Target configuration

Answer

Data Mapping canvas

Question 9

An administrator is setting up user access in Data Cloud and notices that a user with the 'Data Cloud User' permission set cannot view calculated insights. What is the reason for this?

Accepted Answer

The 'Data Cloud User' permission set only grants base access; specific Calculated Insight viewing/managing permissions or Data Space assignments are required.. Calculated insights require specific functional permissions (such as Data Cloud Admin or specific insight viewing permissions) and access to the corresponding Data Space.

Answer

The user must have a Salesforce CRM Administrator profile to view calculated insights.

Answer

Calculated insights must be manually published to the user's Chatter feed.

Answer

Calculated insights are automatically encrypted and require Platform Encryption keys assigned to the user.

Question 10

An organization wants to ingest data from an external relational database using a zero-ETL integration approach if possible. Which Salesforce feature integrates external data sources into Data Cloud without heavy ETL pipelines?

Accepted Answer

Zero Copy Data Federation (e.g., Snowflake or Redshift Zero Copy). Zero Copy integrations (such as Snowflake Zero Copy or Amazon Redshift/BigQuery integrations) allow Data Cloud to query external data warehouses directly without duplicating or moving the data physically.

Answer

Manual CSV file export and upload

Answer

Marketing Cloud FTP drops

Answer

Heroku Connect replication triggers

Question 11

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

Accepted Answer

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

Answer

Data Lake Object (DLO)

Answer

Activation Target Object

Answer

Calculated Insight Source Object

Question 12

Which component of Salesforce Data Cloud is responsible for organizing ingested raw data into a standardized structure based on the Cloud Information Model (CIM)?

Accepted Answer

Data Model Objects (DMOs). Data Model Objects (DMOs) and the Data Mapping canvas are used to map raw Data Source Objects (DSOs) into the standardized Cloud Information Model (CIM).

Answer

Activation Targets

Answer

Calculated Insights

Answer

Data Source Objects (DSOs)

Question 13

A consultant needs to schedule a batch segment to refresh every Monday at 6:00 AM. Where is this schedule configured?

Accepted Answer

Segment Refresh Schedule. Batch segments are configured with a refresh schedule directly within the Segment definition interface in Data Cloud.

Answer

Activation Target Publish Schedule

Answer

Identity Resolution Job Schedule

Answer

Data Stream Ingestion Schedule

Question 14

A consultant is troubleshooting a streaming ingestion pipeline where incoming JSON payloads are failing validation. The error message states that a required timestamp field is in an invalid format. What ISO standard format does Data Cloud require for timestamp fields?

Accepted Answer

ISO 8601 format (e.g., YYYY-MM-DDTHH:MM:SS.sssZ). Data Cloud requires timestamps to be in ISO 8601 format (e.g., YYYY-MM-DDTHH:MM:SS.sssZ) for accurate time-series processing.

Answer

Unix Epoch timestamp integer (e.g., 1698000000)

Answer

RFC 2822 email date format

Answer

US Standard format (MM/DD/YYYY HH:MM AM/PM)

Question 15

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

Accepted Answer

Scoped access control for segments, activations, and calculated insights. Data Spaces in Data Cloud provide logical partitioning of data, metadata, and insights within a single Data Cloud instance (D), allowing teams to organize and segregate their data assets without deploying separate orgs or instances. They also enable scoped access control for segments, activations, and calculated insights (C), so administrators can restrict which users or business units can view or use specific data space resources. Options A, B, and E are incorrect because Data Spaces do not include built-in ML model training pipelines, do not physically isolate data centers by continent, and do not automatically perform bidirectional synchronization with external relational databases.

Answer

Built-in machine learning model training pipelines

Answer

Physical isolation of data centers across different global continents

Answer

Automatic bidirectional data synchronization with external relational databases