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

Question 1

A consultant is mapping a Salesforce CRM Contact data stream to the Individual DMO. The client wants to ensure that the contact's phone number is harmonized into the standard contact point phone DMO. How should this be structured?

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

Accepted Answer

Map the phone number to the Contact Point Phone DMO and relate it to the Individual DMO via foreign key.. Contact points (phone, email, address) in the Cloud Information Model are modeled as related child objects to the Individual DMO rather than flat attributes on the Individual DMO.

Answer

Write a Calculated Insight to extract phone numbers into a separate table.

Answer

Map the phone number directly as a custom field on the Individual DMO root object.

Answer

Concatenate all phone numbers into a single text string on the Contact object before ingestion.

Question 2

An enterprise ingests orders from three separate e-commerce platforms. Each platform uses a different currency (USD, EUR, GBP). To aggregate total purchase value accurately in Calculated Insights, what must the consultant do during the harmonization and modeling stage?

Accepted Answer

Ensure both the monetary amount and currency ISO code are mapped to standard DMO attributes to enable currency normalization.. To aggregate multi-currency values, consultants must ingest the currency ISO code along with the amount, map them to standard DMO attributes, or normalize currencies into a common base currency using conversion rates.

Answer

Reject orders not denominated in USD during the S3 batch file upload.

Answer

Store all monetary amounts as text strings and let SQL queries perform manual string stripping.

Answer

Hardcode an exchange rate multiplier in an Apex trigger during ingestion.

Question 3

Which tool provides a visual representation of all data streams, data source objects, data model objects, and their connections in Data Cloud?

Accepted Answer

Data Model Canvas / Data Landscape. The Data Landscape or Data Model visualization canvas provides an end-to-end view of data streams, DSOs, and DMOs.

Answer

Salesforce Optimizer

Answer

Einstein Discovery Dashboard

Answer

Marketing Cloud Journey Builder

Question 4

What is the primary role of Data Source Objects (DSOs) in the Data Cloud architecture?

Accepted Answer

To store unharmonized raw data from connected data streams. DSOs store raw incoming data streams before they are mapped to harmonized Data Model Objects.

Answer

To publish data to external ad networks

Answer

To execute audience segmentation queries

Answer

To build machine learning models in Einstein Studio

Question 5

Which tab in Data Cloud is used to inspect the records inside a Data Model Object (DMO)?

Accepted Answer

Data Explorer. Data Explorer allows users to query and view records across both DSOs and DMOs.

Answer

Calculated Insights tab

Answer

Activation tab

Answer

Segments tab

Question 6

A consultant is configuring a data stream from an Amazon S3 bucket. The source files are updated continuously throughout the day. How should the refresh schedule be configured to capture these updates efficiently?

Accepted Answer

Configure a scheduled batch refresh (e.g., hourly) to match the frequency of file drops in S3.. Batch data streams from cloud storage can be scheduled to run at specific frequencies (e.g., hourly, every 2 hours, or daily) depending on how often new files are dropped into the bucket.

Answer

Use the Salesforce CRM connector to pull files from S3.

Answer

Configure an Apex trigger in S3 to push files instantly via SOAP.

Answer

Manually upload the files every morning using Data Explorer.

Question 7

Which THREE conditions must be met when mapping a custom Data Source Object field to a standard Cloud Information Model attribute? (Choose THREE)

Accepted Answer

The relationship cardinality between objects must be respected.. Mapping requires compatible data types, correct primary key identification, and adherence to structural cardinality between the source and target objects.

Answer

The source field must be encrypted using AES-256 before mapping.

Answer

The source field name must exactly match the CIM attribute name.

Question 8

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?

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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.