Courseiva

CCNA Data Ingestion And Modeling Questions

75 of 100 questions · Page 1/2 · Data Ingestion And Modeling · Answers revealed

Practice these questionsDomain overviewAll questions
1
MCQmedium

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?

A.In Salesforce CRM Setup under Scheduled Jobs
B.In the Data Stream schedule configuration settings
C.In the Identity Resolution ruleset schedule
D.In Marketing Cloud Connect configuration
AnswerB

Refresh frequency is configured directly within the data stream schedule settings.

Why this answer

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

Practice this question →
2
MCQmedium

A consultant is configuring a data stream from a Salesforce CRM org. The organization wants to ensure that deletes in CRM are reflected in Data Cloud. How does Data Cloud handle deletes from Salesforce CRM data sources?

A.Data Cloud does not support record deletion; deleted records remain permanently in DSOs.
B.Deletes require an external Ingestion API call with a delete flag set to true.
C.Deletes are automatically synchronized through the standard Salesforce CRM connector synchronization process.
D.Deletes must be handled manually by running a weekly SQL purge script.
AnswerC

The Salesforce CRM connector periodically syncs and reflects record deletions in Data Cloud.

Why this answer

Salesforce CRM data streams support soft deletes and Change Data Capture depending on the object configuration, but standard CRM connectors handle record updates and deletions through periodic synchronization and CDC mechanisms.

Practice this question →
3
MCQhard

An organization is using the Ingestion API to push real-time web events into Data Cloud. During peak traffic hours, some API calls are throttled with HTTP 429 Too Many Requests. What is the recommended architectural response?

A.Implement exponential backoff and retry logic in the client application calling the Ingestion API.
B.Disable Identity Resolution during peak hours to free up processing capacity.
C.Switch the streaming endpoint to a batch CSV upload via Amazon S3.
D.Increase the batch size limit in Salesforce CRM Setup under API limits.
AnswerA

Exponential backoff and retry mechanisms handle rate-limiting (HTTP 429) gracefully by spacing out burst requests.

Why this answer

HTTP 429 Too Many Requests indicates rate limiting. The client application sending the data must implement exponential backoff and retry logic, or requests should be batched appropriately.

Practice this question →
4
Multi-Selecthard

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

Select 3 answers
A.Establish object relationships and cardinality to support downstream segmentation.
B.Manually configure HTML email templates in Marketing Cloud Engagement.
C.Write Apex triggers to manage database indexing on external ERP systems.
D.Design custom Data Model Objects and map unharmonized DSOs to the CIM.
E.Determine whether batch or streaming ingestion is required based on source latency needs.
AnswersA, D, E

Correct modeling relationships are essential for accurate segmentation queries.

Why this answer

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.

Practice this question →
5
Multi-Selecthard

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

Select 3 answers
A.The source field must be encrypted using AES-256 before mapping.
B.The relationship cardinality between objects must be respected.
C.The source field name must exactly match the CIM attribute name.
D.The primary key of the DSO must be correctly identified and mapped.
E.The data type of the source field must be compatible with the target DMO attribute.
AnswersB, D, E

Cardinality rules ensure proper relational mapping between parent and child objects.

Why this answer

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

Practice this question →
6
MCQeasy

What is the primary function of the Data Streams tab in Data Cloud?

A.To design audience segmentation filters
B.To configure activation targets and publishing schedules
C.To create, configure, and monitor data streams from connected sources
D.To write ANSI SQL queries for Calculated Insights
AnswerC

The Data Streams tab manages the lifecycle of data ingestion streams.

Why this answer

The Data Streams tab is where administrators create, configure, edit, and monitor data streams from various connected sources.

Practice this question →
7
MCQeasy

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

A.To publish data to external ad networks
B.To execute audience segmentation queries
C.To build machine learning models in Einstein Studio
D.To store unharmonized raw data from connected data streams
AnswerD

DSOs hold the raw source schema and data.

Why this answer

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

Practice this question →
8
Multi-Selecthard

Which THREE actions can a consultant perform when mapping a Data Source Object (DSO) to a Data Model Object (DMO)? (Choose THREE)

Select 3 answers
A.Map DSO fields to standard or custom attributes on the target DMO.
B.Establish object relationships between the mapped DMO and other DMOs.
C.Delete source records directly from the external connected system.
D.Modify the underlying primary key structure of standard CIM DMOs.
E.Apply formula fields to transform data values during the mapping process.
AnswersA, B, E

Mapping connects source fields to target DMO attributes.

Why this answer

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.

Practice this question →
9
MCQmedium

A consultant is using a data bundle to ingest data from a connected Salesforce org. What happens immediately after the data bundle is deployed and the data streams are created?

A.Data streams are created along with pre-mapped Data Model Objects, and initial ingestion/sync jobs begin.
B.Identity Resolution rules are automatically executed.
C.All data is automatically converted into streaming data.
D.Data is instantly available in segments without running batch jobs.
AnswerA

Data bundles automate both data stream creation and pre-mapping to CIM DMOs, triggering initial ingestion.

Why this answer

When a data bundle is deployed, it creates the underlying Data Source Objects, Data Streams, and pre-mapped Data Model Objects automatically. However, the initial historical backfill or sync must run before data is populated.

Practice this question →
10
MCQmedium

A consultant is mapping a date field from an external CSV data stream to the Individual DMO. The source date format is 'DD/MM/YYYY', but Data Cloud expects 'YYYY-MM-DD'. How should the consultant resolve this?

A.Delete the data stream and recreate it using a Parquet file format.
B.Rewrite the source system's database schema to output ISO dates.
C.Apply a formula transformation during the field mapping step to reformat the date string.
D.Change the global timezone setting in Data Cloud Setup.
AnswerC

Mapping formulas allow consultants to transform date formats on the fly during the mapping process.

Why this answer

Data Cloud mapping allows the use of formula transformations (such as date parsing functions) during the mapping step to convert source formats into standard ISO date formats.

Practice this question →
11
MCQeasy

What is the primary function of Data Explorer in Data Cloud?

A.To inspect raw and harmonized records stored in DSOs and DMOs
B.To configure activation targets and publishing schedules
C.To execute machine learning model training in Einstein Studio
D.To manage user permission sets and security profiles
AnswerA

Data Explorer provides visibility into ingested and harmonized record data.

Why this answer

Data Explorer enables users to inspect records within Data Source Objects and Data Model Objects.

Practice this question →
12
Multi-Selectmedium

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

Select 2 answers
A.Automatically deletes duplicate records in the external source system.
B.Allows compatibility with pre-built starter bundles, calculated insights, and segmentation templates.
C.Replaces the need for batch data stream scheduling.
D.Eliminates the need to configure primary keys on custom DMOs.
E.Enables cross-source profile unification via Identity Resolution.
AnswersB, E

Standard CIM mapping ensures out-of-the-box compatibility with bundles and templates.

Why this answer

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

Practice this question →
13
MCQmedium

An administrator needs to ingest data from an external relational database into Data Cloud on a nightly basis. Which ingestion method is best suited for this requirement?

A.Real-time Data Action target
B.Batch Data Stream using cloud file storage (e.g., Amazon S3 or Google Cloud Storage)
C.Streaming Ingestion via Interaction SDK
D.Manual CSV upload via Data Explorer
AnswerB

Batch data streams via cloud storage are standard for scheduled bulk data ingestion from external databases.

Why this answer

External databases connected via MuleSoft, Amazon S3, or Google Cloud Storage typically use batch ingestion scheduled at regular intervals (like nightly).

Practice this question →
14
MCQhard

A consultant creates a custom Data Model Object (DMO) in Data Cloud and attempts to relate it to the standard Individual DMO. The relationship creation fails. What is the most likely reason?

A.The Individual DMO is locked and does not accept outgoing foreign key relationships.
B.Custom DMOs cannot have relationships with standard DMOs under any circumstances.
C.Standard DMO relationships can only be established using SQL queries in Calculated Insights.
D.The foreign key in the custom DMO does not match the data type and length of the target primary key in the Individual DMO.
AnswerD

Data type and length mismatches between primary and foreign keys will prevent relationship creation in the Data Model.

Why this answer

Relationships between DMOs require specific cardinality configurations (e.g., 1-to-1, 1-to-many, many-to-many) and must link compatible primary and foreign keys with matching data types.

Practice this question →
15
Multi-Selectmedium

Which TWO best practices should a consultant follow when naming and structuring custom Data Model Objects (DMOs)? (Choose TWO)

Select 2 answers
A.Define clear primary and foreign key relationships with appropriate cardinality.
B.Ingest raw CSV files directly into custom DMOs without creating DSOs.
C.Ensure every custom DMO has at least 50 primary key fields.
D.Check if a standard CIM DMO already exists before creating a custom DMO.
E.Prefix all custom DMO names with 'Apex_' to ensure system compatibility.
AnswersA, D

Proper relationships are essential for accurate segmentation and querying.

Why this answer

When creating custom DMOs, consultants should follow clear naming conventions, avoid duplicate concepts already covered by standard CIM DMOs, and ensure proper relationship cardinality.

Practice this question →
16
Multi-Selecthard

Which THREE types of data objects are available in the Data Cloud data model architecture? (Choose THREE)

Select 3 answers
A.Data Model Objects (DMOs)
B.Apex Trigger Objects
C.Insight Objects
D.Data Source Objects (DSOs)
E.Visualforce Page Objects
AnswersA, C, D

DMOs represent harmonized data structured against the CIM.

Why this answer

Data Cloud data model architecture includes Data Source Objects (DSOs), Data Model Objects (Dmos) - which can be standard or custom - and Insight Objects.

Practice this question →
17
Multi-Selectmedium

Which TWO types of schema definitions are required or supported when setting up a batch data stream from Amazon S3? (Choose TWO)

Select 2 answers
A.Field data types and primary key designations.
B.Tableau workbook connection strings.
C.Apex class definitions for data transformation.
D.File format and delimiter specifications (e.g., CSV, comma or pipe delimited).
E.Marketing Cloud Journey Builder canvas IDs.
AnswersA, D

Defining field types and primary keys ensures accurate schema creation in the DSO.

Why this answer

S3 batch data streams require file format definitions (like CSV delimiters) and schema field definitions (data types and primary keys).

Practice this question →
18
MCQeasy

When configuring a Salesforce CRM data stream, which user profile permissions are typically required for the connected integration user in Salesforce CRM?

A.Manage Users and Authorize Apex
B.Manage Data Cloud Administration permission only
C.API Enabled and Read access to objects and fields being ingested
D.Modify All Data and View Setup and Configuration
AnswerC

The integration user needs API access and read permissions on all source objects and fields.

Why this answer

The integration user connecting Salesforce CRM to Data Cloud requires specific permissions such as 'Api Enabled' and read access to all objects and fields being ingested.

Practice this question →
19
MCQhard

A consultant is mapping a custom Data Source Object (DSO) representing loyalty points to the Individual Data Model Object (DMO) in Salesforce Data Cloud. The DMO requires a primary key, but the loyalty source record only contains a compound loyalty program ID and member ID. What is the recommended best practice to satisfy the primary key requirement during the data mapping process?

A.Map only the member ID and accept potential record overwrites for members in multiple loyalty programs.
B.Map both fields as the primary key simultaneously in the mapping canvas.
C.Let Data Cloud automatically generate an internal GUID to act as the primary key.
D.Use a formula field in Data Streams to concatenate the loyalty program ID and member ID into a unique string, then map that formula field to the DMO primary key.
AnswerD

Creating a formula field during ingestion or mapping allows the combination of fields to form a valid, unique primary key.

Why this answer

When mapping data to standard DMOs like Individual where a specific primary key format is expected, or when unique combinations are needed, consultants should use a formula field within the data stream or mapping canvas to concatenate the composite keys into a single unique string identifier.

Practice this question →
20
MCQhard

An enterprise ingests high-frequency clickstream data using the Interaction SDK. The client notices that event timestamps are recorded in local browser time rather than UTC, causing chronological misalignment in sequence analysis. How should the consultant address this?

A.Rebuild the Identity Resolution ruleset to auto-correct timestamps.
B.Change the timezone setting of the Salesforce CRM administrator user.
C.Configure the Interaction SDK payload script to transmit timestamps in UTC or include the explicit ISO 8601 offset.
D.Switch from the Interaction SDK to an Amazon S3 batch CSV upload.
AnswerC

Ensuring timestamps include UTC offsets or are normalized to UTC in the SDK payload resolves chronological misalignment.

Why this answer

When capturing web/mobile events via the Interaction SDK, the consultant must configure the event payload script to capture and transmit ISO 8601 timestamps with explicit UTC offset or convert them to UTC before submission.

Practice this question →
21
MCQeasy

When deploying a Data Cloud Starter Bundle for Marketing, what type of objects are automatically provisioned in Data Cloud?

A.Marketing Cloud Engagement Journey Builder canvases
B.Tableau dashboards and external database connectors
C.Custom Apex triggers for real-time validation
D.Pre-configured Data Streams and Data Model Objects mapped to the CIM
AnswerD

Starter bundles include pre-built data streams and pre-mapped DMOs based on the Cloud Information Model.

Why this answer

Data bundles automatically deploy pre-mapped Data Source Objects, Data Model Objects, and sometimes calculated insights or segments depending on the bundle type.

Practice this question →
22
Multi-Selecthard

A Data Cloud consultant is troubleshooting a failing data stream from an external cloud storage bucket. Which TWO steps should the consultant take to diagnose the error? (Choose TWO)

Select 2 answers
A.Review the Data Stream run history and error logs in the Data Cloud UI.
B.Restart the Kafka message broker cluster via the Data Cloud setup menu.
C.Rebuild the Identity Resolution ruleset associated with the data stream.
D.Inspect the source files in the storage bucket for schema and delimiter conformity.
E.Check the Apex Debug Logs in Salesforce Setup.
AnswersA, D

Run history and error logs provide granular details on why ingestion failed.

Why this answer

When cloud storage data streams fail, checking the Data Stream run history for specific error logs and verifying file format compliance against the schema definition are the primary troubleshooting steps.

Practice this question →
23
MCQeasy

What is the primary function of a Data Source Object (DSO) in Data Cloud?

A.To export audience segments to external advertising platforms
B.To unify multiple profiles into a single Unified Individual record
C.To store raw, unharmonized data exactly as it arrives from the data source
D.To calculate real-time customer lifetime value scores
AnswerC

DSOs store the raw structure and data of an incoming data stream.

Why this answer

A Data Source Object (DSO) represents the raw schema and data structure of an ingested data stream before it is mapped to the Cloud Information Model.

Practice this question →
24
MCQeasy

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

A.To visually manage Data Model Objects and their relationships
B.To monitor API call limits and quotas
C.To create Lightning Web Components for CRM pages
D.To design marketing email templates
AnswerA

The Data Model canvas is used for viewing and editing DMO relationships and structure.

Why this answer

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

Practice this question →
25
MCQhard

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?

A.Identity Resolution rulesets
B.Calculated Insights aggregation formulas
C.Data Actions export triggers
D.Tableau CRM data prep recipes
AnswerA

Identity Resolution matches and unifies disparate source records into Unified Individuals.

Why this answer

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

Practice this question →
26
MCQmedium

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?

A.Map the phone number to the Contact Point Phone DMO and relate it to the Individual DMO via foreign key.
B.Write a Calculated Insight to extract phone numbers into a separate table.
C.Map the phone number directly as a custom field on the Individual DMO root object.
D.Concatenate all phone numbers into a single text string on the Contact object before ingestion.
AnswerA

Contact points are modeled as separate DMOs related to the Individual DMO.

Why this answer

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.

Practice this question →
27
MCQmedium

When configuring a batch data stream from an external source, what file formats are natively supported by Data Cloud for ingestion?

A.PNG, JPEG, and PDF
B.SQL dump files (.sql) only
C.XML, XLS, and DOCX
D.CSV, JSON, and Parquet
AnswerD

Data Cloud supports CSV, JSON, and Parquet file formats for batch ingestion.

Why this answer

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.

Practice this question →
28
Multi-Selectmedium

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

Select 2 answers
A.Relationships can be established between standard DMOs and custom DMOs.
B.Relationship cardinality (such as 1-to-many) must be defined when creating the relationship.
C.Standard CIM DMO relationships cannot be modified or extended.
D.Relationships require Apex code to enforce referential integrity.
E.Relationships are automatically created by Identity Resolution without user configuration.
AnswersA, B

Custom DMOs can be linked to standard CIM DMOs via foreign key relationships.

Why this answer

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.

Practice this question →
29
MCQhard

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?

A.The Salesforce CRM user profile timezone setting is incorrect.
B.The Amazon S3 batch schedule is conflicting with the API stream.
C.Identity Resolution rulesets are altering the time values during reconciliation.
D.The incoming JSON payload timestamps lack proper timezone offset indicators or are not in UTC.
AnswerD

Timestamps without timezone offsets default incorrectly, resulting in time shifts.

Why this answer

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.

Practice this question →
30
Multi-Selectmedium

A Data Cloud Consultant is configuring batch ingestion from an external cloud storage provider (Amazon S3). Which THREE configurations are required to successfully set up this data stream?

Select 3 answers
A.File format (e.g., CSV, JSON, Parquet)
B.S3 Bucket Name and object path/prefix
C.Salesforce Marketing Cloud Business Unit ID
D.Pre-built Tableau dashboard ID
E.Authentication credentials (such as AWS IAM access keys or IAM role ARN)
AnswersA, B, E

Defining the file format is essential so the parser knows how to read the incoming files.

Why this answer

Setting up an S3 data stream requires specifying the file format, providing authentication credentials/connection details, and selecting the object structure or folder path to locate the source files.

Practice this question →
31
MCQeasy

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

A.Salesforce Optimizer
B.Einstein Discovery Dashboard
C.Data Model Canvas / Data Landscape
D.Marketing Cloud Journey Builder
AnswerC

The Data Model canvas visually displays objects and data stream pathways.

Why this answer

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

Practice this question →
32
Multi-Selectmedium

When mapping Data Source Objects (DSOs) to Data Model Objects (DMOs) in Salesforce Data Cloud, which TWO best practices should a consultant follow?

Select 2 answers
A.Always map every single source field from the DSO, regardless of whether it is needed.
B.Bypass mapping DSOs entirely and map Data Streams straight to Activation Targets.
C.Ensure primary keys and foreign keys are correctly mapped to maintain relational integrity.
D.Create a separate custom DMO for every individual attribute column in the source file.
E.Map to standard Cloud Information Model (CIM) DMOs whenever possible before resorting to custom DMOs.
AnswersC, E

Accurate key mapping is critical for building correct relationships and enabling downstream features.

Why this answer

Best practices for data mapping include mapping required primary and foreign keys accurately and utilizing standard Cloud Information Model (CIM) objects whenever applicable before creating custom DMOs.

Practice this question →
33
Multi-Selecthard

A consultant is reviewing data streams in Data Cloud and notices that a specific batch data stream has failed consecutive runs. Which THREE troubleshooting steps should the consultant take to diagnose and resolve the issue?

Select 3 answers
A.Restart the entire Data Cloud tenant instance from the Setup menu.
B.Verify that the source data schema has not changed (e.g., modified column names or dropped fields).
C.Manually rewrite the underlying Apache Spark cluster configuration files.
D.Check external connector authentication, access permissions, or expired security tokens.
E.Review the Ingestion History and error logs associated with the data stream.
AnswersB, D, E

Schema mismatches between the source file and the DSO definition frequently cause ingestion failures.

Why this answer

When troubleshooting data stream failures, checking the ingestion logs/error messages, verifying source schema/file structure changes, and ensuring cloud storage permissions or connector tokens are valid are standard practices.

Practice this question →
34
MCQeasy

Which tool in Data Cloud allows a consultant to view raw records inside a Data Source Object (DSO) to verify successful ingestion before mapping?

A.Query Editor
B.Identity Resolution Monitor
C.Data Explorer
D.Segment Canvas
AnswerC

Data Explorer is used to inspect records within Data Source Objects and Data Model Objects.

Why this answer

Data Explorer allows users to inspect raw data inside DSOs as well as harmonized data inside DMOs.

Practice this question →
35
MCQeasy

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

A.Batch ingestion is only used for Salesforce CRM, while streaming is for external systems.
B.Batch ingestion supports CSV files, whereas streaming ingestion only supports PDF files.
C.Streaming ingestion does not require data mapping, whereas batching does.
D.Batch ingestion processes data at scheduled intervals, whereas streaming ingestion processes events in near real-time.
AnswerD

Batch runs on schedules (e.g., hourly, daily), while streaming handles continuous real-time data flows.

Why this answer

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

Practice this question →
36
MCQhard

An enterprise is planning to ingest 500 million transaction records daily from an external data warehouse using cloud storage. To optimize ingestion performance and query speed in Data Cloud, which file format should the consultant recommend for batch export to Amazon S3?

A.SQL dump text files (.sql)
B.XML files with nested attributes
C.Microsoft Word (.docx) documents
D.Apache Parquet format
AnswerD

Parquet is a compressed columnar format optimized for large-scale data ingestion and querying.

Why this answer

Parquet is a columnar storage file format optimized for high-performance analytics, compression, and rapid batch ingestion in big data platforms like Data Cloud.

Practice this question →
37
MCQeasy

Which user interface area in Data Cloud is used to manage and create data streams?

A.Identity Resolution tab
B.Activation tab
C.Calculated Insights tab
D.Data Streams tab
AnswerD

The Data Streams tab provides the interface for setting up and managing data streams.

Why this answer

The Data Streams tab in Data Cloud is where administrators create, configure, and monitor data streams from various sources.

Practice this question →
38
MCQeasy

Which Data Cloud feature enables real-time event streaming from web and mobile applications directly into Data Source Objects?

A.Salesforce CRM Bulk API
B.Marketing Cloud FTP drop
C.Interaction SDK (Web and Mobile SDKs)
D.Heroku Connect sync trigger
AnswerC

Interaction SDKs capture real-time clickstream and event data from web and mobile apps.

Why this answer

The Data Cloud Interaction SDK (Web and Mobile SDKs) captures visitor events in real-time.

Practice this question →
39
MCQeasy

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

A.Data Explorer
B.Calculated Insights tab
C.Activation tab
D.Segments tab
AnswerA

Data Explorer is the designated tool for viewing DSO and DMO records.

Why this answer

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

Practice this question →
40
Multi-Selecthard

Which THREE methods can be used to monitor data stream health and troubleshoot ingestion errors in Data Cloud? (Choose THREE)

Select 3 answers
A.Inspecting raw records using Data Explorer.
B.Reviewing the Run History tab on individual Data Stream detail pages.
C.Analyzing Salesforce CRM Apex Debug logs.
D.Running a SOQL query in Developer Console to query DSO tables.
E.Checking data stream metrics and status indicators in the Data Cloud workspace.
AnswersA, B, E

Data Explorer verifies whether data successfully arrived in the DSO.

Why this answer

Consultants can use the Data Stream run history logs, Data Explorer to verify ingested records, and workspace monitoring tools to check system health.

Practice this question →
41
MCQmedium

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?

A.Data Explorer
B.Salesforce CRM Debug Logs
C.Segment Canvas preview mode
D.Einstein Studio model evaluation tab
AnswerA

Data Explorer lets users view raw DSO records directly.

Why this answer

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

Practice this question →
42
Multi-Selecthard

Which TWO considerations are critical when designing custom Data Model Objects (Dmos) to support large-scale segmentation in Data Cloud? (Choose TWO)

Select 2 answers
A.Store all attributes as text strings to prevent data type conversion errors.
B.Write custom Apex triggers on the DMOs to optimize database indexing.
C.Establish correct cardinality (e.g., 1-to-many) on all object relationships.
D.Ensure every custom DMO has a properly defined primary key.
E.Bypass the Cloud Information Model entirely by using raw DSOs for segmentation.
AnswersC, D

Correct cardinality ensures segmentation queries execute efficiently without performance degradation.

Why this answer

Designing DMOs for scale requires defining proper primary keys and indexing, as well as establishing correct relationship cardinalities to avoid Cartesian products during segmentation queries.

Practice this question →
43
MCQeasy

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

A.Harmonization
B.Segmentation
C.Ingestion
D.Activation
AnswerA

Harmonization standardizes data attributes across different sources into common DMOs.

Why this answer

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

Practice this question →
44
MCQhard

A consultant is configuring a data stream from Amazon S3. The source CSV files contain headers with spaces and special characters. When mapping these fields in Data Cloud, how does Data Cloud handle field names derived from CSV headers?

A.Data Cloud automatically sanitizes headers into valid field names, and consultants map them in the mapping canvas.
B.Consultants must manually rename every column in the S3 CSV file before every batch run.
C.Special characters are converted into Apex escape sequences.
D.Ingestion fails immediately if headers contain spaces or special characters.
AnswerA

Data Cloud normalizes header names during ingestion, and consultants map them during the mapping step.

Why this answer

Data Cloud automatically sanitizes CSV headers during ingestion to create valid API field names (removing spaces and special characters), while allowing consultants to map them cleanly.

Practice this question →
45
MCQmedium

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?

A.Configure the Salesforce CRM connector to read the SFTP files directly.
B.Stage the files from SFTP into a supported cloud storage provider (e.g., Amazon S3) and ingest via a batch data stream.
C.Use manual CSV uploads via Data Explorer every hour.
D.Write a custom Apex trigger on the SFTP server to push records directly to Data Source Objects.
AnswerB

Staging files in S3 or GCS allows batch data streams to ingest files from non-native direct endpoints.

Why this answer

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.

Practice this question →
46
MCQmedium

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?

A.Use the Salesforce CRM connector to pull files from S3.
B.Configure an Apex trigger in S3 to push files instantly via SOAP.
C.Configure a scheduled batch refresh (e.g., hourly) to match the frequency of file drops in S3.
D.Manually upload the files every morning using Data Explorer.
AnswerC

Scheduled batch frequencies ensure new files in S3 are ingested regularly.

Why this answer

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.

Practice this question →
47
MCQmedium

A consultant has created a custom Data Model Object and mapped several fields. The client now requests to delete one of the mapped fields from the custom DMO. What prerequisite must the consultant perform before deleting the field?

A.Export all historical data to Amazon S3 as a backup.
B.Restart the Kafka broker cluster.
C.Remove all field mappings, Calculated Insights, and segment filters referencing that field.
D.Deactivate the entire Data Cloud instance for 24 hours.
AnswerC

Dependent mappings and references must be removed before a field can be deleted from a DMO.

Why this answer

Before deleting a field from a DMO, any dependencies such as field mappings from DSOs, Calculated Insights, or Segment filters referencing that field must be removed.

Practice this question →
48
MCQeasy

Which component of Salesforce Data Cloud is responsible for organizing ingested raw data into a standardized structure based on the Cloud Information Model (CIM)?

A.Activation Targets
B.Data Model Objects (DMOs)
C.Calculated Insights
D.Data Source Objects (DSOs)
AnswerB

DMOs represent the harmonized data mapped to the Cloud Information Model (CIM).

Why this answer

Data Model Objects (DMOs) and the Data Mapping canvas are used to map raw Data Source Objects (DSOs) into the standardized Cloud Information Model (CIM).

Practice this question →
49
MCQmedium

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?

A.In Marketing Cloud Connect settings
B.In Salesforce CRM Setup under Connected Apps
C.In the Identity Resolution ruleset configuration
D.In the Salesforce CRM Data Stream creation wizard object selection step
AnswerD

Object selection happens directly in the data stream setup wizard.

Why this answer

During the creation wizard of a Salesforce CRM data stream, administrators select the specific objects and fields they wish to include.

Practice this question →
50
Multi-Selecthard

A consultant is designing a data model in Salesforce Data Cloud and needs to establish relationships between custom Data Model Objects (DMOs). Which TWO rules apply when creating relationships between DMOs in Data Cloud?

Select 2 answers
A.Relationships can be established as Many-to-One (N:1) or One-to-One (1:1).
B.Standard DMOs cannot participate in relationships with custom DMOs.
C.Relationships between DMOs can only be established using SQL queries in Calculated Insights.
D.Many-to-Many (N:N) relationships can be created directly between any two DMOs without a junction object.
E.The foreign key in the child object must match the data type of the primary key in the parent object.
AnswersA, E

Data Cloud supports N:1 and 1:1 relationships between DMOs.

Why this answer

When creating relationships in Data Cloud, relationships can be N:1 or 1:1, and the participating fields must share compatible data types and properties to ensure referential integrity during segmentation and querying.

Practice this question →
51
MCQhard

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?

A.Unix Epoch timestamp integer (e.g., 1698000000)
B.ISO 8601 format (e.g., YYYY-MM-DDTHH:MM:SS.sssZ)
C.RFC 2822 email date format
D.US Standard format (MM/DD/YYYY HH:MM AM/PM)
AnswerB

ISO 8601 is the mandatory timestamp format for streaming and batch ingestion in Data Cloud.

Why this answer

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

Practice this question →
52
MCQmedium

An organization wants to ingest data from Marketing Cloud Engagement into Data Cloud. Which connector should the consultant configure?

A.Heroku Connect Ingestion API
B.Marketing Cloud Engagement Data Bundle
C.Salesforce CRM Bulk API Connector
D.Amazon S3 Batch Connector
AnswerB

The Marketing Cloud Engagement bundle provides native connectors for subscriber and tracking data.

Why this answer

Marketing Cloud Engagement has a dedicated native connector bundle within Data Cloud to ingest subscriber, journey, and tracking data.

Practice this question →
53
MCQeasy

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

A.Calculated Insight
B.Data Action
C.Activation Target
D.Data Source
AnswerD

A Data Source represents the connected external system or instance.

Why this answer

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.

Practice this question →
54
MCQmedium

A consultant has mapped multiple Salesforce CRM Account records to the Account DMO. The client notices that records are duplicated because different regional systems created accounts with slightly different names. What tool should be used to consolidate these accounts?

A.Calculated Insights aggregation formulas
B.Data Action publishing targets
C.Identity Resolution rulesets
D.Segment builder canvas
AnswerC

Identity Resolution matches and unifies duplicate records based on configured match rules.

Why this answer

Identity Resolution in Data Cloud provides rulesets with match and reconciliation rules to unify duplicate profile and account records into unified entities.

Practice this question →
55
MCQmedium

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?

A.Write a segment in Data Cloud to exclude closed cases.
B.Apply a filter condition (WHERE clause) during the Salesforce CRM data stream configuration wizard.
C.Create an automated Apex trigger in CRM to delete closed cases before sync.
D.Use a Calculated Insight to drop closed cases from the DMO.
AnswerB

Data stream filters allow administrators to restrict ingested records by specifying criteria during setup.

Why this answer

Salesforce CRM data streams support data filtering (where clauses) during the data stream creation wizard to restrict which records are ingested based on criteria.

Practice this question →
56
MCQhard

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?

A.Store the numbers as integers and write a Tableau dashboard translation table.
B.Create a custom Apex class in the ERP system to rewrite codes before export.
C.Use a formula transformation during field mapping with a CASE statement to translate codes into text descriptions.
D.Create a master data stream specifically for status code translation tables.
AnswerC

Mapping formulas support conditional functions like CASE to translate codes on the fly.

Why this answer

During field mapping, consultants can use formula functions (such as `CASE` or conditional statements) to transform numeric status codes into readable text strings.

Practice this question →
57
MCQeasy

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

A.Data Action
B.Activation Target
C.Data Bundle
D.Calculated Insight
AnswerC

Data bundles provide pre-packaged streams and mappings for specific sources.

Why this answer

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

Practice this question →
58
MCQeasy

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

A.Tableau Server connection manager
B.Marketing Cloud Engagement administration panel
C.Heroku dashboard settings
D.Data Cloud Setup in Salesforce CRM Setup menu
AnswerD

Data Cloud Setup is accessed directly through Salesforce CRM Setup.

Why this answer

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

Practice this question →
59
MCQeasy

A consultant is configuring a Salesforce CRM data stream and wants to include standard Account fields along with custom fields. Where are the fields selected during the Data Cloud data stream creation process?

A.By modifying the JSON configuration file of the connector bundle
B.In Setup under Object Manager
C.In the Data Model Object mapping canvas
D.In the Data Stream creation wizard under the Fields selection step
AnswerD

Field selection for Salesforce CRM data streams happens directly within the data stream configuration wizard.

Why this answer

During the Salesforce CRM data stream creation wizard, administrators select the individual objects and then pick the specific fields they wish to ingest.

Practice this question →
60
MCQhard

An organization is ingesting high-frequency transactional data from a mobile app using the Ingestion API. They notice that records are failing with a validation error regarding primary keys. What must the consultant verify in the Ingestion API payload structure?

A.Check that the primary key is hashed using MD5 before sending the payload to the Data Cloud endpoint.
B.Ensure that the primary key field is designated as nullable within the connected source object schema.
C.Confirm that the primary key matches the Salesforce Organization ID.
D.Verify that the primary key field is explicitly mapped and populated with unique values in every incoming JSON batch object.
AnswerD

The Ingestion API payload must contain unique values for the primary key specified in the connector schema to process successfully.

Why this answer

The Ingestion API requires a defined primary key in the schema definition payload, and each incoming record must supply a unique value for this designated primary key field to prevent payload rejection.

Practice this question →
61
MCQhard

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?

A.The Connected App authentication token has expired and needs to be refreshed.
B.The incoming JSON payload structure violates the defined schema contract or contains invalid JSON syntax.
C.The Salesforce Data Cloud org has exceeded its total storage limit.
D.The Identity Resolution ruleset is currently locked during a batch run.
AnswerB

Schema validation failures or malformed JSON syntax generate 400 Bad Request errors.

Why this answer

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.

Practice this question →
62
Multi-Selecthard

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

Select 3 answers
A.Execute complex SOQL queries against external database servers.
B.Concatenate first and last name fields into a single full name attribute.
C.Transform date string formats into standard ISO date types.
D.Convert text strings to uppercase or lowercase.
E.Deploy custom Apex classes to handle business logic execution.
AnswersB, C, D

String concatenation formulas combine multiple source fields into a single target attribute.

Why this answer

Mapping formulas support string manipulation (concatenation, uppercase/lowercase), date parsing, and arithmetic calculations during ingestion mapping.

Practice this question →
63
Multi-Selectmedium

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

Select 2 answers
A.The source bucket path and file format specifications (e.g., CSV, delimiter).
B.An active Apex trigger class deployed in Google Cloud.
C.A pre-built Marketing Cloud journey canvas.
D.Authentication credentials / IAM configuration linking Google Cloud to Data Cloud.
E.A physical SFTP server bridge.
AnswersA, D

Specifying the bucket path and file format tells Data Cloud where and how to read the files.

Why this answer

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.

Practice this question →
64
MCQhard

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?

A.Write a Calculated Insight to unpack the array after ingestion.
B.Discard nested arrays because Data Cloud only supports flat tabular data structures.
C.Flatten the array into a comma-separated string inside a single text field.
D.Map the nested array to a related child DMO using the parent event primary key as the foreign key.
AnswerD

Nested arrays are mapped to related child DMOs linked via foreign keys to the parent event.

Why this answer

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.

Practice this question →
65
MCQmedium

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?

A.Verify that the Salesforce service account has correct IAM read permissions on the Google Cloud storage bucket.
B.Check that the Google Cloud storage bucket has public internet access enabled for all IP addresses.
C.Rewrite all filenames to remove uppercase letters.
D.Switch the ingestion format from CSV to XML.
AnswerA

Permission denials are caused by incorrect IAM roles or bucket access policies preventing Data Cloud from reading the files.

Why this answer

Cloud storage integration requires granting appropriate read permissions (IAM roles and service account access) to the Salesforce Data Cloud service principal.

Practice this question →
66
MCQmedium

A consultant is configuring a data stream from a Salesforce CRM org. The client requests that records older than 2 years be excluded from ingestion to conserve storage. Where should this filter be applied?

A.Apply a filter criterion in the Salesforce CRM data stream configuration wizard.
B.Modify the global retention policy in Salesforce CRM Setup.
C.Write a nightly Apex batch job in CRM to delete historical records.
D.Configure a Calculated Insight to drop old records from the DMO.
AnswerA

Data stream configuration wizards allow criteria-based filtering during ingestion setup.

Why this answer

Salesforce CRM data streams support filter criteria (WHERE clauses) during data stream setup to restrict ingestion based on date or field conditions.

Practice this question →
67
Multi-Selectmedium

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

Select 3 answers
A.Engagement
B.Apex Controller
C.Profile
D.Transactional Trigger
E.Other
AnswersA, C, E

Engagement objects represent time-series interactions like web clicks, purchases, or emails.

Why this answer

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

Practice this question →
68
MCQmedium

A consultant is setting up a data stream from Marketing Cloud Engagement. The data stream successfully ingests subscriber data, but campaign tracking events are not appearing. What should the consultant verify?

A.Restart the Kafka message broker.
B.Rewrite all tracking data into CSV format and upload to S3.
C.Check the Salesforce CRM Connected App OAuth scopes.
D.Verify that the tracking data bundle or corresponding event data streams were selected and enabled during setup.
AnswerD

Marketing Cloud Engagement requires individual tracking streams to be enabled alongside subscriber streams.

Why this answer

When configuring Marketing Cloud Engagement data streams, specific data bundles or individual data streams (such as tracking data streams) must be explicitly selected and enabled during setup.

Practice this question →
69
MCQeasy

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

A.Heroku Connect Data Connector
B.Salesforce Classic CTI Adapter
C.Commerce Cloud Order Management Bundle
D.Marketing Cloud Account Engagement Data Bundle
AnswerD

The Account Engagement bundle provides pre-built streams and mappings.

Why this answer

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

Practice this question →
70
MCQhard

A consultant has created a custom Data Model Object (DMO) and needs to relate it to the standard Individual DMO. The relationship type chosen is N:1 (Many custom DMO records to One Individual). When configuring this relationship in Data Cloud, what is a mandatory requirement for the foreign key field in the custom DMO?

A.It must be indexed using a SOQL custom index.
B.It must be mapped directly to a Data Source Object formula field.
C.It must be configured as a measure data type.
D.It must have the exact same data type (Text) and precision as the primary key of the parent DMO.
AnswerD

Foreign keys must match the parent primary key's data type and attributes for relational integrity.

Why this answer

When establishing relationships between DMOs in Data Cloud, the foreign key field in the child object must match the data type and length of the primary key field in the parent object (Individual ID) to ensure successful joins and identity resolution.

Practice this question →
71
MCQmedium

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?

A.Zero Copy Data Federation (e.g., Snowflake or Redshift Zero Copy)
B.Manual CSV file export and upload
C.Marketing Cloud FTP drops
D.Heroku Connect replication triggers
AnswerA

Zero Copy allows Data Cloud to query external data stores directly without traditional ETL batch loads.

Why this answer

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.

Practice this question →
72
MCQmedium

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?

A.Edit the data stream configuration to select and add the newly created fields.
B.Delete the entire data stream and recreate it from scratch.
C.Write a SOQL query in Data Cloud Query Editor to pull the new fields.
D.New fields are automatically detected and ingested without any administrative action.
AnswerA

Data streams must be updated manually or via schema refresh actions to include newly added source fields.

Why this answer

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

Practice this question →
73
MCQeasy

Where can a consultant review the status and details of ongoing data stream ingestion runs in Data Cloud?

A.Data Stream Detail page under the Run History tab
B.Salesforce CRM Setup Audit Trail
C.Marketing Cloud Connect dashboard
D.Tableau Server connection manager
AnswerA

Run History on the Data Stream detail page provides job status and metrics.

Why this answer

The Data Stream detail page provides a run history tab showing the status, record counts, and error details of each ingestion job.

Practice this question →
74
MCQmedium

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?

A.Mapping the Data Source Object (DSO) fields to the Data Model Object (DMO)
B.Running an activation target publish job
C.Configuring an ingestion API token
D.Enabling Change Data Capture on the Data Model Object
AnswerA

Data streaming creates the DSO, but data does not populate the DMO until mapping is completed.

Why this answer

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.

Practice this question →
75
MCQhard

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?

A.Flatten the JSON file into a single-level tabular CSV before uploading to cloud storage.
B.Write an Apex class to parse the JSON array and insert records into custom DMOs.
C.Define a hierarchical schema utilizing object and array data types within the data stream configuration.
D.Nested JSON is not supported; line items must be ingested as a completely separate data stream.
AnswerC

Data Cloud supports hierarchical JSON parsing by defining nested object and array types in the schema.

Why this answer

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.

Practice this question →
Page 1 of 2 · 100 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Data Ingestion And Modeling questions.

Start 20-question session