Data 360 Consultant Data Ingestion And Modeling Practice Test 1 — 15 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?

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

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.