Data 360 Consultant Data Ingestion And Modeling — Timed 50 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?

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

Question 11

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

Accepted Answer

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

Answer

Query Editor

Answer

Identity Resolution Monitor

Answer

Segment Canvas

Question 12

Which THREE characteristics apply to Data Model Objects (DMOs) in Data Cloud? (Choose THREE)

Accepted Answer

They are structured based on the Cloud Information Model (CIM).. DMOs represent harmonized data structured according to the Cloud Information Model, can be standard or custom, and serve as the foundation for segmentation and insights.

Answer

They require Apex code to establish relationships between each other.

Answer

They store raw, unformatted data directly from the source system without modification.

Question 13

What is the primary function of a Data Source Object (DSO) in Data Cloud?

Accepted Answer

To store raw, unharmonized data exactly as it arrives from the data source. A Data Source Object (DSO) represents the raw schema and data structure of an ingested data stream before it is mapped to the Cloud Information Model.

Answer

To export audience segments to external advertising platforms

Answer

To unify multiple profiles into a single Unified Individual record

Answer

To calculate real-time customer lifetime value scores

Question 14

A consultant is configuring a data stream from a Salesforce CRM org. The organization wants to ensure that deletes in CRM are reflected in Data Cloud. How does Data Cloud handle deletes from Salesforce CRM data sources?

Accepted Answer

Deletes are automatically synchronized through the standard Salesforce CRM connector synchronization process.. Salesforce CRM data streams support soft deletes and Change Data Capture depending on the object configuration, but standard CRM connectors handle record updates and deletions through periodic synchronization and CDC mechanisms.

Answer

Data Cloud does not support record deletion; deleted records remain permanently in DSOs.

Answer

Deletes require an external Ingestion API call with a delete flag set to true.

Answer

Deletes must be handled manually by running a weekly SQL purge script.

Question 15

What is the primary purpose of the Cloud Information Model (CIM) in Data Cloud?

Accepted Answer

To provide a standard data model structure for harmonizing disparate data sources. The Cloud Information Model provides a standardized data model structure that enables different data sources to be harmonized into common objects.

Answer

To encrypt data at rest in cloud storage buckets

Answer

To manage user permissions and access control across Salesforce products

Answer

To compile Apex code for real-time data transformations

Question 16

An enterprise has multiple data streams bringing in customer data from different legacy systems. Some systems use 'Customer_ID' while others use 'Cust_Num'. When mapping these to the Individual DMO, how should the consultant ensure proper harmonization?

Accepted Answer

Map both 'Customer_ID' and 'Cust_Num' to the appropriate identifier attribute in the target Individual DMO.. Harmonization involves mapping disparate fields from different DSOs to the corresponding standard fields (or custom attributes) within the same target DMO so they can be recognized uniformly.

Answer

Merge the data streams into a single file in Amazon S3 before ingestion.

Answer

Use an Apex trigger to standardize source schema names during ingestion.

Answer

Create a calculated insight to rename the fields prior to mapping.

Question 17

When configuring a batch data stream from an external source, what file formats are natively supported by Data Cloud for ingestion?

Accepted Answer

CSV, JSON, and Parquet. Data Cloud batch ingestion natively supports formats like CSV, JSON, and Parquet from cloud storage providers such as Amazon S3, Google Cloud Storage, and Azure Blob Storage.

Answer

PNG, JPEG, and PDF

Answer

SQL dump files (.sql) only

Answer

XML, XLS, and DOCX

Question 18

A consultant needs to ingest transactional data where each transaction record contains nested line items in a JSON array. How should the consultant configure the data stream to handle this hierarchical structure?

Accepted Answer

Define a hierarchical schema utilizing object and array data types within the data stream configuration.. Data Cloud supports ingestion of nested JSON structures by defining complex data types (objects and arrays of objects) during schema definition in batch or streaming ingestion.

Answer

Flatten the JSON file into a single-level tabular CSV before uploading to cloud storage.

Answer

Write an Apex class to parse the JSON array and insert records into custom DMOs.

Answer

Nested JSON is not supported; line items must be ingested as a completely separate data stream.

Question 19

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

Accepted Answer

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

Answer

Identity Resolution tab

Answer

Activation tab

Answer

Calculated Insights tab

Question 20

An organization has successfully created a data stream, but data is not appearing in the corresponding Data Model Object. What is the most likely step that was missed?

Accepted Answer

Mapping the Data Source Object (DSO) fields to the Data Model Object (DMO). After creating a data stream and establishing the DSO, the consultant must map the DSO fields to the target Data Model Object (DMO) before data flows into the harmonized model.

Answer

Running an activation target publish job

Answer

Configuring an ingestion API token

Answer

Enabling Change Data Capture on the Data Model Object