Data 360 Consultant Data Ingestion And Modeling Practice Test 7 — 15 Questions

Question 1

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?

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

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 2

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 3

A Data Cloud Consultant is setting up a batch data stream from an AWS S3 bucket to ingest daily transaction records. During the configuration, the consultant notices that the incoming CSV files contain columns with varying headers across different days. How should the consultant configure the data stream to ensure successful ingestion without breaking the mapping?

Accepted Answer

Ensure that the source CSV files maintain a consistent header row matching the defined Data Source Object schema.. When configuring data streams from cloud storage like AWS S3, the underlying schema must align with the Data Source Object (DSO) definition. In Data Cloud, schema drift can cause ingestion errors, so establishing a strict contract or utilizing a consistent header structure in the source file, or leveraging standard connector parsing rules, is critical. Data Cloud does not automatically remap changing column names.

Answer

Enable dynamic schema evolution in the Data Stream properties.

Answer

Create multiple data streams, one for each variation of the CSV header.

Answer

Map the S3 bucket directly to a Data Model Object using formula fields to handle missing headers.

Question 4

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 5

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 6

A Data Cloud Consultant is configuring a Data Stream from Marketing Cloud Engagement. The consultant notices that data is updating via batch runs. What is the default frequency of batch synchronization for Marketing Cloud Engagement data streams once established?

Accepted Answer

Every 24 hours. Marketing Cloud Engagement data streams in Data Cloud typically sync via scheduled batch processes, with a default frequency of every 24 hours, though certain bundles or configurations can support more frequent intervals.

Answer

Every 15 minutes

Answer

Hourly

Answer

Real-time streaming

Question 7

A consultant has created a custom Data Model Object (DMO) and needs to relate it to the standard Individual DMO. The relationship type chosen is N:1 (Many custom DMO records to One Individual). When configuring this relationship in Data Cloud, what is a mandatory requirement for the foreign key field in the custom DMO?

Accepted Answer

It must have the exact same data type (Text) and precision as the primary key of the parent DMO.. When establishing relationships between DMOs in Data Cloud, the foreign key field in the child object must match the data type and length of the primary key field in the parent object (Individual ID) to ensure successful joins and identity resolution.

Answer

It must be indexed using a SOQL custom index.

Answer

It must be mapped directly to a Data Source Object formula field.

Answer

It must be configured as a measure data type.

Question 8

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 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 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

Question 11

An enterprise is ingesting customer data from two different Salesforce orgs into a single Data Cloud instance. Both orgs contain customer records with overlapping email addresses. What foundational concept ensures that these separate records can be harmonized under a single profile?

Accepted Answer

Mapping to standard Cloud Information Model (CIM) Data Model Objects and running Identity Resolution. Harmonization maps disparate data sources into standard Cloud Information Model (CIM) DMOs, and Identity Resolution subsequently matches and unifies them into Unified Individuals.

Answer

Creating a Calculated Insight to overwrite duplicate keys

Answer

Master Data Streams

Answer

Enabling streaming ingestion on both CRM connectors

Question 12

A consultant is designing a data model in Salesforce Data Cloud and needs to establish relationships between custom Data Model Objects (DMOs). Which TWO rules apply when creating relationships between DMOs in Data Cloud?

Accepted Answer

Relationships can be established as Many-to-One (N:1) or One-to-One (1:1).. When creating relationships in Data Cloud, relationships can be N:1 or 1:1, and the participating fields must share compatible data types and properties to ensure referential integrity during segmentation and querying.

Answer

Standard DMOs cannot participate in relationships with custom DMOs.

Answer

Relationships between DMOs can only be established using SQL queries in Calculated Insights.

Answer

Many-to-Many (N:N) relationships can be created directly between any two DMOs without a junction object.

Question 13

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?

Accepted Answer

Verify that the source data schema has not changed (e.g., modified column names or dropped fields).. 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.

Answer

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

Answer

Manually rewrite the underlying Apache Spark cluster configuration files.

Question 14

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

Accepted Answer

Ensure primary keys and foreign keys are correctly mapped to maintain relational integrity.. 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.

Answer

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

Answer

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

Answer

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

Question 15

A consultant is configuring a Data Stream that ingests customer records from an Amazon S3 bucket into Data Cloud. The source files are full snapshots delivered every night, and the business requires that deleted customer records be removed from the Data Cloud data model after each ingestion. Which Data Stream refresh setting should the consultant configure to meet this requirement?

Accepted Answer

Full Refresh. Because the Amazon S3 source delivers complete nightly snapshots, a full replacement strategy is required so that records missing from the newest file are deleted in Data Cloud. Incremental and upsert strategies only add or update rows, and streaming ingestion does not apply to scheduled batch file drops.

Answer

Incremental Refresh

Answer

Upsert Refresh

Answer

Streaming Refresh