Data 360 Consultant Practice Test 22 — 15 Questions

Question 1

An enterprise is ingesting orders from an external ERP system. Each order record contains a status code represented as an integer (e.g., 1 = Pending, 2 = Shipped, 3 = Cancelled). The client wants these numeric codes translated into readable text descriptions during harmonization. How should the consultant achieve this?

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

Accepted Answer

Use a formula transformation during field mapping with a CASE statement to translate codes into text descriptions.. During field mapping, consultants can use formula functions (such as `CASE` or conditional statements) to transform numeric status codes into readable text strings.

Answer

Store the numbers as integers and write a Tableau dashboard translation table.

Answer

Create a custom Apex class in the ERP system to rewrite codes before export.

Answer

Create a master data stream specifically for status code translation tables.

Question 2

A consultant is setting up a data stream from Marketing Cloud Engagement. The data stream successfully ingests subscriber data, but campaign tracking events are not appearing. What should the consultant verify?

Accepted Answer

Verify that the tracking data bundle or corresponding event data streams were selected and enabled during setup.. When configuring Marketing Cloud Engagement data streams, specific data bundles or individual data streams (such as tracking data streams) must be explicitly selected and enabled during setup.

Answer

Restart the Kafka message broker.

Answer

Rewrite all tracking data into CSV format and upload to S3.

Answer

Check the Salesforce CRM Connected App OAuth scopes.

Question 3

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?

Accepted Answer

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

Answer

SQL dump text files (.sql)

Answer

XML files with nested attributes

Answer

Microsoft Word (.docx) documents

Question 4

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 5

What happens to an active segment when the underlying Data Model Object schema is modified by removing a field used in the segment criteria?

Accepted Answer

The segment will fail validation or error during its next publishing cycle.. If a field used in a segment rule is removed or broken in the DMO schema, the segment validation will fail or the segment will error upon refresh.

Answer

Data Cloud automatically replaces the missing field with a null placeholder.

Answer

The segment automatically converts into a static segment.

Answer

The activation target pauses all external data synchronization indefinitely.

Question 6

An organization wants to ingest real-time clickstream events from their mobile application into Salesforce Data Cloud. Which ingestion mechanism should the consultant recommend?

Accepted Answer

Interaction Ingestion API. Real-time streaming data, such as mobile app clickstreams or IoT events, should use the Interaction Ingestion API or mobile SDKs designed for streaming ingestion, rather than batch connectors.

Answer

Google Cloud Storage Connector

Answer

Salesforce CRM Connector

Answer

Amazon S3 Batch Connector

Question 7

A consultant needs to create a segment based on the total number of website visits recorded in the last 7 days. The source web tracking data is stored in an engagement DMO. How should the consultant approach this?

Accepted Answer

Use Segment Canvas related object criteria with a count aggregate on the web visit DMO filtered by the last 7 days.. Using related object attributes with aggregate count functions within the Segment Canvas allows filtering based on engagement frequency.

Answer

Create a static segment and manually import website visitor IDs weekly.

Answer

Configure a Data Action Target to trigger alerts on every web visit.

Answer

Build an Ingestion API to pre-filter website visits before they enter Data Cloud.

Question 8

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 9

A consultant is using a data bundle to ingest data from a connected Salesforce org. What happens immediately after the data bundle is deployed and the data streams are created?

Accepted Answer

Data streams are created along with pre-mapped Data Model Objects, and initial ingestion/sync jobs begin.. When a data bundle is deployed, it creates the underlying Data Source Objects, Data Streams, and pre-mapped Data Model Objects automatically. However, the initial historical backfill or sync must run before data is populated.

Answer

Identity Resolution rules are automatically executed.

Answer

All data is automatically converted into streaming data.

Answer

Data is instantly available in segments without running batch jobs.

Question 10

Which TWO destination types are officially supported for publishing Data Cloud segments via Activation Targets? Choose 2 options.

Accepted Answer

Amazon S3 / Cloud File Storage. Data Cloud supports activations to various marketing platforms, cloud storage providers, and CRM instances.

Answer

Salesforce Classic desktop app shortcuts.

Answer

Local SQLite database files stored on the administrator's desktop.

Answer

Personal email inboxes via SMTP relay.

Question 11

A consultant is mapping a custom Data Source Object (DSO) representing loyalty points to the Individual Data Model Object (DMO) in Salesforce Data Cloud. The DMO requires a primary key, but the loyalty source record only contains a compound loyalty program ID and member ID. What is the recommended best practice to satisfy the primary key requirement during the data mapping process?

Accepted Answer

Use a formula field in Data Streams to concatenate the loyalty program ID and member ID into a unique string, then map that formula field to the DMO primary key.. When mapping data to standard DMOs like Individual where a specific primary key format is expected, or when unique combinations are needed, consultants should use a formula field within the data stream or mapping canvas to concatenate the composite keys into a single unique string identifier.

Answer

Map only the member ID and accept potential record overwrites for members in multiple loyalty programs.

Answer

Map both fields as the primary key simultaneously in the mapping canvas.

Answer

Let Data Cloud automatically generate an internal GUID to act as the primary key.

Question 12

An organization runs daily batch segments that take several hours to compute. To improve performance, the consultant decides to optimize the underlying data model relationships. Which practice should the consultant follow?

Accepted Answer

Ensure proper cardinality (e.g., Many-to-One) and clean foreign key mappings between engagement DMOs and Unified Individual.. Optimizing relationships involves ensuring proper cardinalities and foreign key indexes are maintained between custom DMOs and standard profile DMOs.

Answer

Delete all Identity Resolution rule sets to speed up segment query execution.

Answer

Convert all batch segments into streaming segments to eliminate processing windows.

Answer

Disable data stream refresh schedules during segment publishing windows.

Question 13

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 14

A consultant wants to ensure that a segment only includes profiles where the customer's email address is not null and email opt-in is set to true. Where should these filters be applied?

Accepted Answer

Inside the Segment Canvas profile criteria container.. Profile attribute filters are applied directly inside the Segment Canvas when defining the audience criteria.

Answer

Within the Calculated Insight SQL SELECT clause.

Answer

Inside the Identity Resolution matching rules.

Answer

At the Data Stream field mapping level.

Question 15

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