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

Question 1

A consultant ingests a Salesforce CRM data stream into Data Cloud. The source Contact object has a multi-value picklist field where a contact may have several selected values in one record. The consultant needs each selected value to land as its own row in the Contact Point Email DMO so downstream segmentation can filter on a single value. Which ingestion and modeling approach should the consultant use?

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

Accepted Answer

Use the Data Stream's field mapping to select the multi-value picklist, and enable the option to split multi-value fields into individual records during ingestion.. Splitting multi-value source fields during ingestion is the native mechanism that turns a single source record with several selections into multiple target records. Because the requirement is one row per selected value in Contact Point Email, the consultant must enable that split behavior in the data stream mapping rather than storing concatenated text or applying downstream filters.

Answer

Ingest the Contact object as-is and use a Data Transform to run a SQL query that filters records containing the desired picklist value.

Answer

Create a Formula Field in Data Cloud that concatenates the picklist values and map it to a custom DMO attribute.

Answer

Enable the multi-value picklist as a comma-separated string and store it in a single text field on the Individual DMO.

Question 2

A consultant is mapping a Data Source Object to the standard Sales Order DMO. The source system sends order timestamps in the format 'YYYY-MM-DDTHH:MM:SSZ' and monetary amounts as decimal values with a currency code in a separate field. The consultant wants the Sales Order DMO to correctly store both the order date and the amount with currency context. Which mapping configuration should the consultant apply?

Accepted Answer

Map the timestamp to the Sales Order date field and map the decimal amount to the amount field, then map the currency code to the currency field so amounts are stored with their currency context.. The Sales Order DMO expects date-time values in its date field and numeric values in its amount field, with a companion currency field for context. Mapping the timestamp, the decimal amount, and the currency code to those standard fields preserves precision and enables currency-aware reporting, whereas dropping the currency code or converting types to text breaks aggregation and cross-currency interpretation.

Answer

Create a custom DMO instead of using Sales Order, because standard DMOs cannot store currency codes alongside amounts.

Answer

Convert the timestamp to a date-only string and map the amount as a text field, then create a custom attribute for currency.

Answer

Map the timestamp directly to the Sales Order date field and map the decimal amount to the amount field while ignoring the currency code.

Question 3

A consultant is preparing to ingest data from an external system into Data Cloud using a batch data stream. The source system exposes data through an API that returns paginated JSON responses, and the consultant must configure the connection and ingestion correctly. Which TWO configuration steps are required to ingest this API-based data successfully? (Choose two.)

Accepted Answer

Create a named credential or connected app so Data Cloud can authenticate to the external API.. API-based batch ingestion requires both an authentication mechanism so Data Cloud can call the external endpoint and a schema definition that maps the JSON response into a Data Source Object. Named credentials or connected apps handle secure access, while the schema mapping lets the connector interpret the paginated JSON and produce records for downstream modeling.

Answer

Configure a Salesforce Data Cloud storage provider to persist the raw JSON payload before transformation.

Answer

Enable Change Data Capture on the external system so only modified JSON records are transmitted.

Answer

Manually upload a CSV export of the API response to seed the data stream before scheduling it.

Question 4

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?

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 5

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 6

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 7

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 8

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 9

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 10

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 11

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 12

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

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 15

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.