Data 360 Consultant Data Ingestion And Modeling — Timed 10 Questions

Question 1

A consultant is configuring a Salesforce CRM data stream and wants to include standard Account fields along with custom fields. Where are the fields selected during the Data Cloud data stream creation process?

10 minute time limit — choose an answer to begin.

Accepted Answer

In the Data Stream creation wizard under the Fields selection step. During the Salesforce CRM data stream creation wizard, administrators select the individual objects and then pick the specific fields they wish to ingest.

Answer

By modifying the JSON configuration file of the connector bundle

Answer

In Setup under Object Manager

Answer

In the Data Model Object mapping canvas

Question 2

A Data Cloud consultant is setting up a new S3 data stream for an external system. During the data stream creation wizard, the consultant notices that the date/time fields are not automatically mapping to the correct data type. What is the root cause and the best resolution?

Accepted Answer

S3 ingestion treats all incoming CSV columns as Text by default; the user must define and map data types correctly in the DMO mapping step.. Amazon S3 CSV files send all data as strings or unstructured types. The consultant must define or adjust data types either during the data stream creation step or fix the underlying file formatting before ingestion.

Answer

AWS S3 does not support date formatting natively, so all dates must be transformed using a formula in Data Cloud after the stream is active.

Answer

The Cloud Information Model restricts S3 date fields to string data types until harmonization is completed.

Answer

Data Cloud automatically infers all S3 data types as Text upon initial ingestion, and field types must be manually adjusted in the Data Stream detail page.

Question 3

A Data Cloud consultant needs to ingest clickstream data that updates constantly throughout the day with high volume and low latency requirements. Which ingestion mechanism should be used?

Accepted Answer

Streaming Ingestion via Ingestion API or Interaction SDK. Streaming Ingestion (via Ingestion API or interaction SDKs) is designed for high-frequency, low-latency data streams compared to batch ingestion.

Answer

Batch Data Stream scheduled every hour

Answer

Salesforce CRM Connector with changed data capture enabled

Answer

Manual CSV file upload via the Data Cloud UI

Question 4

An organization is ingesting high-frequency transactional data from a mobile app using the Ingestion API. They notice that records are failing with a validation error regarding primary keys. What must the consultant verify in the Ingestion API payload structure?

Accepted Answer

Verify that the primary key field is explicitly mapped and populated with unique values in every incoming JSON batch object.. The Ingestion API requires a defined primary key in the schema definition payload, and each incoming record must supply a unique value for this designated primary key field to prevent payload rejection.

Answer

Check that the primary key is hashed using MD5 before sending the payload to the Data Cloud endpoint.

Answer

Ensure that the primary key field is designated as nullable within the connected source object schema.

Answer

Confirm that the primary key matches the Salesforce Organization ID.

Question 5

When deploying a Data Cloud Starter Bundle for Marketing, what type of objects are automatically provisioned in Data Cloud?

Accepted Answer

Pre-configured Data Streams and Data Model Objects mapped to the CIM. Data bundles automatically deploy pre-mapped Data Source Objects, Data Model Objects, and sometimes calculated insights or segments depending on the bundle type.

Answer

Marketing Cloud Engagement Journey Builder canvases

Answer

Tableau dashboards and external database connectors

Answer

Custom Apex triggers for real-time validation

Question 6

An administrator needs to ingest data from an external relational database into Data Cloud on a nightly basis. Which ingestion method is best suited for this requirement?

Accepted Answer

Batch Data Stream using cloud file storage (e.g., Amazon S3 or Google Cloud Storage). External databases connected via MuleSoft, Amazon S3, or Google Cloud Storage typically use batch ingestion scheduled at regular intervals (like nightly).

Answer

Real-time Data Action target

Answer

Streaming Ingestion via Interaction SDK

Answer

Manual CSV upload via Data Explorer

Question 7

A consultant maps a custom Data Source Object (DSO) field to a standard Individual Data Model Object (DMO) field in Data Cloud. After refreshing the data stream, the identity resolution rules are not picking up the new records. What is the likely cause?

Accepted Answer

The Identity Resolution ruleset must be manually rerun or has a scheduled frequency that has not yet triggered.. Identity Resolution Rules in Data Cloud rely on specific reconciliation rules and match rules that must include the mapped fields (e.g., email or phone). If the mapping is incorrect or the fields used in the match rules are unpopulated, identity resolution will fail to link them.

Answer

Standard DMOs do not support custom DSO fields unless wrapped in a Profile DMO extension.

Answer

The data stream must be deleted and recreated for Identity Resolution to recognize new mapping paths.

Answer

Harmonization requires an intermediate Master Data Model object before matching can take place.

Question 8

A consultant creates a custom Data Model Object (DMO) in Data Cloud and attempts to relate it to the standard Individual DMO. The relationship creation fails. What is the most likely reason?

Accepted Answer

The foreign key in the custom DMO does not match the data type and length of the target primary key in the Individual DMO.. Relationships between DMOs require specific cardinality configurations (e.g., 1-to-1, 1-to-many, many-to-many) and must link compatible primary and foreign keys with matching data types.

Answer

The Individual DMO is locked and does not accept outgoing foreign key relationships.

Answer

Custom DMOs cannot have relationships with standard DMOs under any circumstances.

Answer

Standard DMO relationships can only be established using SQL queries in Calculated Insights.

Question 9

An organization wants to ingest data from Marketing Cloud Engagement into Data Cloud. Which connector should the consultant configure?

Accepted Answer

Marketing Cloud Engagement Data Bundle. Marketing Cloud Engagement has a dedicated native connector bundle within Data Cloud to ingest subscriber, journey, and tracking data.

Answer

Heroku Connect Ingestion API

Answer

Salesforce CRM Bulk API Connector

Answer

Amazon S3 Batch Connector

Question 10

A Data Cloud consultant is troubleshooting a failing data stream from an external cloud storage bucket. Which TWO steps should the consultant take to diagnose the error? (Choose TWO)

Accepted Answer

Review the Data Stream run history and error logs in the Data Cloud UI.. When cloud storage data streams fail, checking the Data Stream run history for specific error logs and verifying file format compliance against the schema definition are the primary troubleshooting steps.

Answer

Restart the Kafka message broker cluster via the Data Cloud setup menu.

Answer

Rebuild the Identity Resolution ruleset associated with the data stream.

Answer

Check the Apex Debug Logs in Salesforce Setup.