Data 360 Consultant Data Ingestion And Modeling — Timed 40 Questions

Question 1

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?

40 minute time limit — choose an answer to begin.

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 2

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 3

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 4

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 5

Which THREE actions can a consultant perform when mapping a Data Source Object (DSO) to a Data Model Object (DMO)? (Choose THREE)

Accepted Answer

Map DSO fields to standard or custom attributes on the target DMO.. During mapping, consultants can map source fields to standard or custom DMO attributes, create relationships between mapped objects, and apply data transformations or formulas if supported.

Answer

Delete source records directly from the external connected system.

Answer

Modify the underlying primary key structure of standard CIM DMOs.

Question 6

Which THREE types of data objects are available in the Data Cloud data model architecture? (Choose THREE)

Accepted Answer

Data Model Objects (DMOs). Data Cloud data model architecture includes Data Source Objects (DSOs), Data Model Objects (Dmos) - which can be standard or custom - and Insight Objects.

Answer

Apex Trigger Objects

Answer

Visualforce Page Objects

Question 7

Which TWO best practices should a consultant follow when naming and structuring custom Data Model Objects (DMOs)? (Choose TWO)

Accepted Answer

Define clear primary and foreign key relationships with appropriate cardinality.. When creating custom DMOs, consultants should follow clear naming conventions, avoid duplicate concepts already covered by standard CIM DMOs, and ensure proper relationship cardinality.

Answer

Ingest raw CSV files directly into custom DMOs without creating DSOs.

Answer

Ensure every custom DMO has at least 50 primary key fields.

Answer

Prefix all custom DMO names with 'Apex_' to ensure system compatibility.

Question 8

An organization is using the Ingestion API to push real-time web events into Data Cloud. During peak traffic hours, some API calls are throttled with HTTP 429 Too Many Requests. What is the recommended architectural response?

Accepted Answer

Implement exponential backoff and retry logic in the client application calling the Ingestion API.. HTTP 429 Too Many Requests indicates rate limiting. The client application sending the data must implement exponential backoff and retry logic, or requests should be batched appropriately.

Answer

Disable Identity Resolution during peak hours to free up processing capacity.

Answer

Switch the streaming endpoint to a batch CSV upload via Amazon S3.

Answer

Increase the batch size limit in Salesforce CRM Setup under API limits.

Question 9

Which THREE features are provided by Data Cloud starter data bundles? (Choose THREE)

Accepted Answer

Pre-mapped Data Model Objects aligned with the CIM. Starter data bundles provide pre-configured data streams, pre-mapped DMOs, and sometimes sample calculated insights or segments for standard connectors like Salesforce CRM or Marketing Cloud.

Answer

Guaranteed zero latency for batch data streams

Answer

Automatic custom Apex code generation for complex business logic

Question 10

Which TWO considerations are critical when designing custom Data Model Objects (Dmos) to support large-scale segmentation in Data Cloud? (Choose TWO)

Accepted Answer

Establish correct cardinality (e.g., 1-to-many) on all object relationships.. Designing DMOs for scale requires defining proper primary keys and indexing, as well as establishing correct relationship cardinalities to avoid Cartesian products during segmentation queries.

Answer

Store all attributes as text strings to prevent data type conversion errors.

Answer

Write custom Apex triggers on the DMOs to optimize database indexing.

Answer

Bypass the Cloud Information Model entirely by using raw DSOs for segmentation.

Question 11

Which THREE methods can be used to monitor data stream health and troubleshoot ingestion errors in Data Cloud? (Choose THREE)

Accepted Answer

Inspecting raw records using Data Explorer.. Consultants can use the Data Stream run history logs, Data Explorer to verify ingested records, and workspace monitoring tools to check system health.

Answer

Analyzing Salesforce CRM Apex Debug logs.

Answer

Running a SOQL query in Developer Console to query DSO tables.

Question 12

Which TWO types of schema definitions are required or supported when setting up a batch data stream from Amazon S3? (Choose TWO)

Accepted Answer

Field data types and primary key designations.. S3 batch data streams require file format definitions (like CSV delimiters) and schema field definitions (data types and primary keys).

Answer

Tableau workbook connection strings.

Answer

Apex class definitions for data transformation.

Answer

Marketing Cloud Journey Builder canvas IDs.

Question 13

A consultant needs to ingest a nested JSON file from an external API into Data Cloud. The JSON contains an array of transaction items nested inside a customer profile object. How should the consultant configure the data stream to properly handle this nested structure?

Accepted Answer

Configure the data stream parser to handle complex data types, generating separate Data Source Objects for parent and child nodes linked by keys.. When dealing with nested arrays or JSON structures, Data Cloud allows data stream transformations or the use of multiple related DSOs/DMOs where parent-child relationships are maintained through foreign keys generated during parsing.

Answer

Use a Calculated Insight to unnest the array after ingestion.

Answer

Reject the file, because Data Cloud only accepts flat CSV structures.

Answer

Flatten the entire JSON into a single flat string field within a single DMO.

Question 14

A Data Cloud Consultant is configuring batch ingestion from an external cloud storage provider (Amazon S3). Which THREE configurations are required to successfully set up this data stream?

Accepted Answer

File format (e.g., CSV, JSON, Parquet). Setting up an S3 data stream requires specifying the file format, providing authentication credentials/connection details, and selecting the object structure or folder path to locate the source files.

Answer

Salesforce Marketing Cloud Business Unit ID

Answer

Pre-built Tableau dashboard ID

Question 15

A consultant is designing a custom Data Model Object (DMO) to store point-of-sale transactions for a high-volume retailer, with billions of rows expected. The DMO must support segmentation on customer identifier and transaction date, and it will be joined to the Individual DMO. Which design decision best supports query performance at this scale?

Accepted Answer

Define the customer identifier as the primary key and include the transaction date as a standard field used in segmentation filters.. For a very large transaction DMO, the primary key should be the field used to join to Individual, and commonly filtered fields like transaction date should remain discrete attributes. Surrogate keys, concatenated fields, and object fragmentation all undermine join efficiency and filter performance instead of improving them.

Answer

Use an auto-generated sequential row number as the primary key to guarantee uniqueness across billions of rows.

Answer

Store the customer identifier and transaction date concatenated into a single composite text field to reduce the number of attributes.

Answer

Model each transaction as a separate custom DMO so that segmentation queries scan smaller objects.

Question 16

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?

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 17

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 18

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 19

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 20

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