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

Question 1

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?

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

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 2

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 3

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 4

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 5

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

Question 6

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 7

Which TWO file storage providers are natively supported for batch data stream ingestion in Data Cloud? (Choose TWO)

Accepted Answer

Google Cloud Storage. Data Cloud supports native connectors for major cloud storage providers including Amazon S3, Google Cloud Storage, and Azure Blob Storage.

Answer

Personal Dropbox account

Answer

Apple iCloud Drive

Answer

Local Windows file share via SMB

Question 8

What is the primary difference between batch ingestion and streaming ingestion in Data Cloud?

Accepted Answer

Batch ingestion processes data at scheduled intervals, whereas streaming ingestion processes events in near real-time.. Batch ingestion processes data at scheduled intervals in bulk, while streaming ingestion processes records in real-time or near real-time as they arrive.

Answer

Batch ingestion is only used for Salesforce CRM, while streaming is for external systems.

Answer

Batch ingestion supports CSV files, whereas streaming ingestion only supports PDF files.

Answer

Streaming ingestion does not require data mapping, whereas batching does.

Question 9

An administrator is setting up a Salesforce CRM data stream and wants to ensure that data is refreshed every 6 hours. Where is the refresh frequency configured?

Accepted Answer

In the Data Stream schedule configuration settings. Data stream refresh schedules are defined during the data stream creation wizard or edited on the data stream detail page under refresh schedule settings.

Answer

In Salesforce CRM Setup under Scheduled Jobs

Answer

In the Identity Resolution ruleset schedule

Answer

In Marketing Cloud Connect configuration

Question 10

A consultant ingests a custom object from Salesforce CRM containing currency fields. When mapped to a DMO, the currency ISO code and amount need to be handled correctly according to Data Cloud standards. How should currency fields be mapped?

Accepted Answer

Map both the currency amount field and the associated currency ISO code field to the target DMO attributes.. Data Cloud supports currency conversion and multi-currency handling by mapping both the currency amount and its corresponding currency ISO code attribute to the appropriate DMO fields.

Answer

Convert all currency values into text strings before ingestion to avoid parsing errors.

Answer

Use an Apex formula to hardcode exchange rates during the data stream creation step.

Answer

Map only the numerical amount field; Data Cloud automatically defaults to USD.

Question 11

An organization wants to ingest data from an external relational database using a zero-ETL integration approach if possible. Which Salesforce feature integrates external data sources into Data Cloud without heavy ETL pipelines?

Accepted Answer

Zero Copy Data Federation (e.g., Snowflake or Redshift Zero Copy). Zero Copy integrations (such as Snowflake Zero Copy or Amazon Redshift/BigQuery integrations) allow Data Cloud to query external data warehouses directly without duplicating or moving the data physically.

Answer

Manual CSV file export and upload

Answer

Marketing Cloud FTP drops

Answer

Heroku Connect replication triggers

Question 12

Which entity in Data Cloud represents the logical grouping of related data streams from a specific connector instance?

Accepted Answer

Data Source. A Data Source represents the connection to an external system or instance (like a specific Salesforce Org or S3 bucket) from which multiple data streams are created.

Answer

Calculated Insight

Answer

Data Action

Answer

Activation Target

Question 13

A consultant is setting up a streaming data stream using the Ingestion API. The API returns an HTTP 400 Bad Request error. What is the most likely cause of this error?

Accepted Answer

The incoming JSON payload structure violates the defined schema contract or contains invalid JSON syntax.. An HTTP 400 Bad Request from the Ingestion API typically indicates that the incoming payload does not match the defined schema structure or contains malformed JSON.

Answer

The Connected App authentication token has expired and needs to be refreshed.

Answer

The Salesforce Data Cloud org has exceeded its total storage limit.

Answer

The Identity Resolution ruleset is currently locked during a batch run.

Question 14

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 15

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.