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

Question 1

What is the term for mapping unharmonized Data Source Object attributes to standardized Cloud Information Model attributes?

Accepted Answer

Harmonization. Harmonization is the process of mapping disparate data sources to standard Data Model Objects based on the Cloud Information Model.

Answer

Segmentation

Answer

Ingestion

Answer

Activation

Question 2

Which role or permission set is generally required to configure data streams and data models in Data Cloud?

Accepted Answer

Data Cloud Admin or Data Cloud Consultant permission set. Data Cloud Administration or specific Data Cloud user permission sets are required to configure data streams, mappings, and data models.

Answer

System Administrator in CRM without Data Cloud licenses

Answer

Salesforce CRM Standard User

Answer

Marketing Cloud Administrator only

Question 3

An enterprise has streaming interaction data arriving via the Ingestion API. The consultant notices that records are populating the DSO, but the timestamps on the records are off by several hours. What is the most likely cause?

Accepted Answer

The incoming JSON payload timestamps lack proper timezone offset indicators or are not in UTC.. Streaming timestamps must be provided in UTC or include proper timezone offset indicators in ISO 8601 format. If timestamps are submitted without timezone context, Data Cloud may misinterpret them relative to GMT/UTC.

Answer

The Salesforce CRM user profile timezone setting is incorrect.

Answer

The Amazon S3 batch schedule is conflicting with the API stream.

Answer

Identity Resolution rulesets are altering the time values during reconciliation.

Question 4

A consultant is setting up a Salesforce CRM data stream for the Case object. The client wants to filter out closed cases so they are never ingested into Data Cloud. Where should this filter be applied?

Accepted Answer

Apply a filter condition (WHERE clause) during the Salesforce CRM data stream configuration wizard.. Salesforce CRM data streams support data filtering (where clauses) during the data stream creation wizard to restrict which records are ingested based on criteria.

Answer

Write a segment in Data Cloud to exclude closed cases.

Answer

Create an automated Apex trigger in CRM to delete closed cases before sync.

Answer

Use a Calculated Insight to drop closed cases from the DMO.

Question 5

An organization is ingesting high-volume transaction data via the Ingestion API. During testing, they notice that duplicate transaction IDs are being ingested as separate records into the DSO. What mechanism ensures idempotency or prevents unwanted duplicates in Data Cloud ingestion?

Accepted Answer

Ensure that a unique primary key is defined in the Ingestion API schema so Data Cloud can upsert records correctly.. Data Cloud ingestion relies on primary keys defined in the schema. If incoming records share the same primary key, Data Cloud performs an upsert based on the primary key to prevent duplicate records in the DSO.

Answer

Write an Apex deduplication trigger before sending payloads to the API.

Answer

Enable Identity Resolution match rules specifically for transaction IDs.

Answer

Set the data stream refresh frequency to real-time batching.

Question 6

Which TWO statements are true regarding Data Model Object (DMO) relationships in Data Cloud? (Choose TWO)

Accepted Answer

Relationships can be established between standard DMOs and custom DMOs.. DMO relationships define how objects connect (e.g., 1-to-many between Individual and Contact Point), and they are configured visually in the Data Model canvas.

Answer

Standard CIM DMO relationships cannot be modified or extended.

Answer

Relationships require Apex code to enforce referential integrity.

Answer

Relationships are automatically created by Identity Resolution without user configuration.

Question 7

Which THREE actions can be performed when utilizing formula functions during field mapping in Data Cloud? (Choose THREE)

Accepted Answer

Concatenate first and last name fields into a single full name attribute.. Mapping formulas support string manipulation (concatenation, uppercase/lowercase), date parsing, and arithmetic calculations during ingestion mapping.

Answer

Execute complex SOQL queries against external database servers.

Answer

Deploy custom Apex classes to handle business logic execution.

Question 8

What is the term for a pre-packaged collection of data streams, data model mappings, and insights designed for a specific Salesforce application?

Accepted Answer

Data Bundle. Data bundles are pre-packaged sets of metadata and configuration that accelerate onboarding for specific data sources.

Answer

Data Action

Answer

Activation Target

Answer

Calculated Insight

Question 9

A consultant needs to ingest data from an SFTP server into Data Cloud. How should this be architected if Data Cloud does not have a direct native SFTP batch connector?

Accepted Answer

Stage the files from SFTP into a supported cloud storage provider (e.g., Amazon S3) and ingest via a batch data stream.. When direct native connectors like SFTP are not available, data is typically staged in a supported cloud storage provider (like Amazon S3 or Google Cloud Storage) using an automated ETL tool or middleware like MuleSoft, and then ingested via a batch data stream.

Answer

Configure the Salesforce CRM connector to read the SFTP files directly.

Answer

Use manual CSV uploads via Data Explorer every hour.

Answer

Write a custom Apex trigger on the SFTP server to push records directly to Data Source Objects.

Question 10

Which Salesforce product icon or menu item leads administrators to the Data Cloud setup and configuration landing page?

Accepted Answer

Data Cloud Setup in Salesforce CRM Setup menu. In Salesforce CRM Setup, administrators can search for 'Data Cloud Setup' to access the core administration landing page.

Answer

Tableau Server connection manager

Answer

Marketing Cloud Engagement administration panel

Answer

Heroku dashboard settings

Question 11

An enterprise is ingesting web tracking events via the Interaction SDK. Some event payloads contain nested arrays of product interactions. During mapping, the consultant needs to ensure these nested items are correctly associated with the parent event DMO. How is this handled?

Accepted Answer

Map the nested array to a related child DMO using the parent event primary key as the foreign key.. Nested arrays in streaming or batch ingestion are mapped to related child DMOs using defined foreign key relationships between the parent event and child item DMOs.

Answer

Write a Calculated Insight to unpack the array after ingestion.

Answer

Discard nested arrays because Data Cloud only supports flat tabular data structures.

Answer

Flatten the array into a comma-separated string inside a single text field.

Question 12

A consultant has set up a Salesforce CRM data stream. The data stream shows a status of 'Error' due to an invalid field mapping. After correcting the mapping in the UI, what action should the consultant take to resume data flow?

Accepted Answer

Trigger a manual refresh or wait for the next scheduled ingestion run.. After fixing mapping or configuration errors on a data stream, the consultant can trigger a manual refresh or wait for the next scheduled run to resume ingestion.

Answer

Deactivate the Salesforce CRM connected app and regenerate all OAuth tokens.

Answer

Rebuild the entire Identity Resolution ruleset.

Answer

Export all DSO records to CSV and re-upload manually.

Question 13

An enterprise is ingesting orders from an external ERP system. Each order record contains a status code represented as an integer (e.g., 1 = Pending, 2 = Shipped, 3 = Cancelled). The client wants these numeric codes translated into readable text descriptions during harmonization. How should the consultant achieve this?

Accepted Answer

Use a formula transformation during field mapping with a CASE statement to translate codes into text descriptions.. During field mapping, consultants can use formula functions (such as `CASE` or conditional statements) to transform numeric status codes into readable text strings.

Answer

Store the numbers as integers and write a Tableau dashboard translation table.

Answer

Create a custom Apex class in the ERP system to rewrite codes before export.

Answer

Create a master data stream specifically for status code translation tables.

Question 14

Which THREE key responsibilities does a Data Cloud consultant have when designing the data ingestion and modeling strategy? (Choose THREE)

Accepted Answer

Establish object relationships and cardinality to support downstream segmentation.. Consultants must identify source systems and choose appropriate ingestion methods, design scalable data model objects adhering to the CIM, and establish correct relationships between DMOs.

Answer

Manually configure HTML email templates in Marketing Cloud Engagement.

Answer

Write Apex triggers to manage database indexing on external ERP systems.

Question 15

Which TWO benefits are provided by mapping Data Source Objects (DSOs) to standard Cloud Information Model (CIM) DMOs? (Choose TWO)

Accepted Answer

Allows compatibility with pre-built starter bundles, calculated insights, and segmentation templates.. Harmonization to standard CIM DMOs enables pre-built segment templates, calculated insights compatibility, and cross-source profile unification.

Answer

Automatically deletes duplicate records in the external source system.

Answer

Replaces the need for batch data stream scheduling.

Answer

Eliminates the need to configure primary keys on custom DMOs.