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

Question 1

Which TWO factors influence the speed and performance of batch data stream ingestion in Data Cloud? (Choose TWO)

Accepted Answer

Complexity and number of formula transformations applied during mapping.. Batch ingestion performance is affected by file size/number of files in cloud storage and the complexity of formula transformations or data types being parsed.

Answer

The physical location of the administrator's laptop.

Answer

The color scheme configured in the Salesforce CRM user interface.

Answer

The number of active browser tabs open by the administrator viewing the Data Streams tab.

Question 2

An administrator is configuring a Google Cloud Storage batch data stream. The data stream runs successfully, but zero records are ingested, and the error log indicates a file permission denial. What must the administrator check in Google Cloud?

Accepted Answer

Verify that the Salesforce service account has correct IAM read permissions on the Google Cloud storage bucket.. Cloud storage integration requires granting appropriate read permissions (IAM roles and service account access) to the Salesforce Data Cloud service principal.

Answer

Check that the Google Cloud storage bucket has public internet access enabled for all IP addresses.

Answer

Rewrite all filenames to remove uppercase letters.

Answer

Switch the ingestion format from CSV to XML.

Question 3

What is the function of the Data Model canvas in Data Cloud?

Accepted Answer

To visually manage Data Model Objects and their relationships. The Data Model canvas provides a visual interface for viewing, creating, and managing relationships between Data Model Objects (DMOs).

Answer

To monitor API call limits and quotas

Answer

To create Lightning Web Components for CRM pages

Answer

To design marketing email templates

Question 4

A consultant is designing an architecture where customer records arrive simultaneously via Salesforce CRM CDC, Marketing Cloud Engagement, and an Ingestion API. To prevent duplicate customer profiles from bloating downstream segments, what core Data Cloud feature must be configured after data modeling?

Accepted Answer

Identity Resolution rulesets. Identity Resolution is required to reconcile and unify multiple customer records arriving from disparate data streams into a single Unified Individual profile.

Answer

Calculated Insights aggregation formulas

Answer

Data Actions export triggers

Answer

Tableau CRM data prep recipes

Question 5

What is the primary purpose of a master data stream in Data Cloud?

Accepted Answer

To ingest and manage core reference data objects like Products, Stores, or Locations. Master data streams or master data objects help organize core reference entities like Product, Store, or Geo locations.

Answer

To encrypt streaming API payloads

Answer

To execute daily Apex backups of Salesforce CRM

Answer

To generate marketing email campaigns

Question 6

Which Salesforce feature provides pre-built data streams and data model mappings for Marketing Cloud Account Engagement (Pardot)?

Accepted Answer

Marketing Cloud Account Engagement Data Bundle. Data Cloud provides standard data bundles for Marketing Cloud Account Engagement to ingest prospects, campaigns, and visitor data automatically.

Answer

Heroku Connect Data Connector

Answer

Salesforce Classic CTI Adapter

Answer

Commerce Cloud Order Management Bundle

Question 7

A consultant wants to verify that records from an Ingestion API stream are successfully landing in the Data Source Object. Which tool should the consultant use?

Accepted Answer

Data Explorer. Data Explorer allows consultants to inspect raw records inside Data Source Objects (DSOs) to verify ingestion success.

Answer

Salesforce CRM Debug Logs

Answer

Segment Canvas preview mode

Answer

Einstein Studio model evaluation tab

Question 8

Which THREE data categories are supported when classifying Data Model Objects in Data Cloud? (Choose THREE)

Accepted Answer

Engagement. Data Cloud categorizes DMOs into specific categories such as Profile, Engagement, and Other (or primarilly Profile and Engagement categories for customer data modeling).

Answer

Apex Controller

Answer

Transactional Trigger

Question 9

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?

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 10

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 11

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 12

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 13

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 14

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 15

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.