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

Question 1

A consultant is troubleshooting a streaming ingestion pipeline where incoming JSON payloads are failing validation. The error message states that a required timestamp field is in an invalid format. What ISO standard format does Data Cloud require for timestamp fields?

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

Accepted Answer

ISO 8601 format (e.g., YYYY-MM-DDTHH:MM:SS.sssZ). Data Cloud requires timestamps to be in ISO 8601 format (e.g., YYYY-MM-DDTHH:MM:SS.sssZ) for accurate time-series processing.

Answer

Unix Epoch timestamp integer (e.g., 1698000000)

Answer

RFC 2822 email date format

Answer

US Standard format (MM/DD/YYYY HH:MM AM/PM)

Question 2

Which TWO methods can be used to ingest data into Data Cloud in near real-time? (Choose TWO)

Accepted Answer

Data Cloud Interaction SDK (Web and Mobile SDKs). Near real-time ingestion in Data Cloud is achieved using the Ingestion API or mobile/web Interaction SDKs.

Answer

Batch data stream from Amazon S3 scheduled daily

Answer

Weekly Salesforce CRM data export via Email

Answer

Manual CSV file upload via Data Explorer

Question 3

An administrator is setting up a data stream from a Salesforce CRM org. They want to ensure that only specific objects (Account, Contact, Case) are ingested. Where is this filtering or selection performed?

Accepted Answer

In the Salesforce CRM Data Stream creation wizard object selection step. During the creation wizard of a Salesforce CRM data stream, administrators select the specific objects and fields they wish to include.

Answer

In Marketing Cloud Connect settings

Answer

In Salesforce CRM Setup under Connected Apps

Answer

In the Identity Resolution ruleset configuration

Question 4

An administrator needs to ingest customer feedback ratings stored as numeric values from 1 to 5. When mapping this field to a custom DMO attribute, which data type should the administrator select?

Accepted Answer

Number (Integer or Decimal). Numeric ratings (like 1 to 5) should be mapped to a Number (Integer or Decimal) data type in the DMO to allow calculations and aggregations.

Answer

DateTime

Answer

Boolean (True/False)

Answer

Text (String)

Question 5

A consultant is setting up a data stream from an external database via Amazon S3. The source system generates CSV files with custom delimiters (pipes `|` instead of commas `,`). How should the consultant configure this in Data Cloud?

Accepted Answer

Specify the pipe delimiter (`|`) in the file format configuration settings during data stream creation.. During the S3 data stream creation wizard, Data Cloud allows administrators to specify custom delimiters (such as pipes, tabs, or semicolons) for CSV file parsing.

Answer

Write an Apex transformation class to replace pipes with commas.

Answer

Rename the file extension from `.csv` to `.pipe` so Data Cloud auto-detects it.

Answer

Convert all files to JSON because CSV does not support custom delimiters.

Question 6

A consultant creates a data stream from a custom Salesforce CRM object. After activation, the client adds new custom fields to the source object in Salesforce CRM. How can the consultant ensure these new fields are ingested into Data Cloud?

Accepted Answer

Edit the data stream configuration to select and add the newly created fields.. When source schema changes occur in connected CRM objects, the consultant must edit the data stream configuration to include the newly added fields.

Answer

Delete the entire data stream and recreate it from scratch.

Answer

Write a SOQL query in Data Cloud Query Editor to pull the new fields.

Answer

New fields are automatically detected and ingested without any administrative action.

Question 7

Which TWO key components are required when defining a batch data stream from Google Cloud Storage? (Choose TWO)

Accepted Answer

The source bucket path and file format specifications (e.g., CSV, delimiter).. Configuring a GCS data stream requires authenticating with cloud storage credentials (or IAM) and specifying the file location/bucket path along with file format settings.

Answer

An active Apex trigger class deployed in Google Cloud.

Answer

A pre-built Marketing Cloud journey canvas.

Answer

A physical SFTP server bridge.

Question 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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