Courseiva

CCNA Data Ingestion And Modeling Questions

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

Practice these questionsDomain overviewAll questions
76
MCQhard

An enterprise has multiple data streams bringing in customer data from different legacy systems. Some systems use 'Customer_ID' while others use 'Cust_Num'. When mapping these to the Individual DMO, how should the consultant ensure proper harmonization?

A.Merge the data streams into a single file in Amazon S3 before ingestion.
B.Map both 'Customer_ID' and 'Cust_Num' to the appropriate identifier attribute in the target Individual DMO.
C.Use an Apex trigger to standardize source schema names during ingestion.
D.Create a calculated insight to rename the fields prior to mapping.
AnswerB

Different source fields can be mapped to the same target attribute in the DMO during the mapping stage.

Why this answer

Harmonization involves mapping disparate fields from different DSOs to the corresponding standard fields (or custom attributes) within the same target DMO so they can be recognized uniformly.

Practice this question →
77
MCQmedium

A Data Cloud consultant needs to ingest clickstream data that updates constantly throughout the day with high volume and low latency requirements. Which ingestion mechanism should be used?

A.Batch Data Stream scheduled every hour
B.Streaming Ingestion via Ingestion API or Interaction SDK
C.Salesforce CRM Connector with changed data capture enabled
D.Manual CSV file upload via the Data Cloud UI
AnswerB

Streaming Ingestion is built for high-volume, real-time event data like clickstreams.

Why this answer

Streaming Ingestion (via Ingestion API or interaction SDKs) is designed for high-frequency, low-latency data streams compared to batch ingestion.

Practice this question →
78
MCQmedium

A Data Cloud consultant is setting up a new S3 data stream for an external system. During the data stream creation wizard, the consultant notices that the date/time fields are not automatically mapping to the correct data type. What is the root cause and the best resolution?

A.AWS S3 does not support date formatting natively, so all dates must be transformed using a formula in Data Cloud after the stream is active.
B.The Cloud Information Model restricts S3 date fields to string data types until harmonization is completed.
C.S3 ingestion treats all incoming CSV columns as Text by default; the user must define and map data types correctly in the DMO mapping step.
D.Data Cloud automatically infers all S3 data types as Text upon initial ingestion, and field types must be manually adjusted in the Data Stream detail page.
AnswerC

CSV data streams from S3 require the user to configure data types during the data stream creation process as they are ingested as strings initially.

Why this answer

Amazon S3 CSV files send all data as strings or unstructured types. The consultant must define or adjust data types either during the data stream creation step or fix the underlying file formatting before ingestion.

Practice this question →
79
MCQmedium

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?

A.Deactivate the Salesforce CRM connected app and regenerate all OAuth tokens.
B.Rebuild the entire Identity Resolution ruleset.
C.Trigger a manual refresh or wait for the next scheduled ingestion run.
D.Export all DSO records to CSV and re-upload manually.
AnswerC

Manual refresh or the next scheduled run will process the stream with the corrected mapping.

Why this answer

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.

Practice this question →
80
MCQmedium

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?

A.Number (Integer or Decimal)
B.DateTime
C.Boolean (True/False)
D.Text (String)
AnswerA

Numeric data types are required for ratings to support mathematical operations and aggregations.

Why this answer

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.

Practice this question →
81
Multi-Selectmedium

Which THREE features are provided by Data Cloud starter data bundles? (Choose THREE)

Select 3 answers
A.Guaranteed zero latency for batch data streams
B.Pre-mapped Data Model Objects aligned with the CIM
C.Accelerated time-to-value by eliminating manual mapping for standard objects
D.Automatic custom Apex code generation for complex business logic
E.Pre-configured Data Streams for standard source objects
AnswersB, C, E

Bundles handle initial mapping to CIM DMOs automatically.

Why this answer

Starter data bundles provide pre-configured data streams, pre-mapped DMOs, and sometimes sample calculated insights or segments for standard connectors like Salesforce CRM or Marketing Cloud.

Practice this question →
82
MCQhard

A consultant needs to ingest a nested JSON file from an external API into Data Cloud. The JSON contains an array of transaction items nested inside a customer profile object. How should the consultant configure the data stream to properly handle this nested structure?

A.Configure the data stream parser to handle complex data types, generating separate Data Source Objects for parent and child nodes linked by keys.
B.Use a Calculated Insight to unnest the array after ingestion.
C.Reject the file, because Data Cloud only accepts flat CSV structures.
D.Flatten the entire JSON into a single flat string field within a single DMO.
AnswerA

Data Cloud supports parsing complex nested JSON by breaking them into relational DSOs that map to parent and child DMOs.

Why this answer

When dealing with nested arrays or JSON structures, Data Cloud allows data stream transformations or the use of multiple related DSOs/DMOs where parent-child relationships are maintained through foreign keys generated during parsing.

Practice this question →
83
Multi-Selectmedium

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

Select 2 answers
A.Data Cloud Interaction SDK (Web and Mobile SDKs)
B.Data Cloud Ingestion API
C.Batch data stream from Amazon S3 scheduled daily
D.Weekly Salesforce CRM data export via Email
E.Manual CSV file upload via Data Explorer
AnswersA, B

Interaction SDKs capture user events in real-time from websites and mobile apps.

Why this answer

Near real-time ingestion in Data Cloud is achieved using the Ingestion API or mobile/web Interaction SDKs.

Practice this question →
84
MCQmedium

A Data Cloud Consultant is configuring a Data Stream from Marketing Cloud Engagement. The consultant notices that data is updating via batch runs. What is the default frequency of batch synchronization for Marketing Cloud Engagement data streams once established?

A.Every 15 minutes
B.Hourly
C.Real-time streaming
D.Every 24 hours
AnswerD

The default sync frequency for Marketing Cloud Engagement data streams is every 24 hours.

Why this answer

Marketing Cloud Engagement data streams in Data Cloud typically sync via scheduled batch processes, with a default frequency of every 24 hours, though certain bundles or configurations can support more frequent intervals.

Practice this question →
85
MCQhard

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?

A.Write an Apex transformation class to replace pipes with commas.
B.Specify the pipe delimiter (`|`) in the file format configuration settings during data stream creation.
C.Rename the file extension from `.csv` to `.pipe` so Data Cloud auto-detects it.
D.Convert all files to JSON because CSV does not support custom delimiters.
AnswerB

Data Cloud's CSV ingestion wizard supports configuring custom delimiters like pipes.

Why this answer

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.

Practice this question →
86
MCQeasy

What is the primary purpose of the Cloud Information Model (CIM) in Data Cloud?

A.To encrypt data at rest in cloud storage buckets
B.To provide a standard data model structure for harmonizing disparate data sources
C.To manage user permissions and access control across Salesforce products
D.To compile Apex code for real-time data transformations
AnswerB

The CIM defines standard DMOs and attributes to harmonize data across disparate sources.

Why this answer

The Cloud Information Model provides a standardized data model structure that enables different data sources to be harmonized into common objects.

Practice this question →
87
MCQhard

A consultant ingests a custom object from Salesforce CRM containing currency fields. When mapped to a DMO, the currency ISO code and amount need to be handled correctly according to Data Cloud standards. How should currency fields be mapped?

A.Convert all currency values into text strings before ingestion to avoid parsing errors.
B.Map both the currency amount field and the associated currency ISO code field to the target DMO attributes.
C.Use an Apex formula to hardcode exchange rates during the data stream creation step.
D.Map only the numerical amount field; Data Cloud automatically defaults to USD.
AnswerB

Proper multi-currency mapping requires both the numeric amount and the ISO currency code attributes.

Why this answer

Data Cloud supports currency conversion and multi-currency handling by mapping both the currency amount and its corresponding currency ISO code attribute to the appropriate DMO fields.

Practice this question →
88
MCQmedium

An enterprise is ingesting customer data from two different Salesforce orgs into a single Data Cloud instance. Both orgs contain customer records with overlapping email addresses. What foundational concept ensures that these separate records can be harmonized under a single profile?

A.Creating a Calculated Insight to overwrite duplicate keys
B.Mapping to standard Cloud Information Model (CIM) Data Model Objects and running Identity Resolution
C.Master Data Streams
D.Enabling streaming ingestion on both CRM connectors
AnswerB

Mapping to standard CIM DMOs standardizes the schema, and Identity Resolution unifies the overlapping profiles.

Why this answer

Harmonization maps disparate data sources into standard Cloud Information Model (CIM) DMOs, and Identity Resolution subsequently matches and unifies them into Unified Individuals.

Practice this question →
89
Multi-Selectmedium

Which THREE characteristics apply to Data Model Objects (DMOs) in Data Cloud? (Choose THREE)

Select 3 answers
A.They are structured based on the Cloud Information Model (CIM).
B.They require Apex code to establish relationships between each other.
C.They can be either standard or custom objects.
D.They are used directly as targets for segmentation and calculated insights.
E.They store raw, unformatted data directly from the source system without modification.
AnswersA, C, D

DMOs follow the CIM standard for harmonization.

Why this answer

DMOs represent harmonized data structured according to the Cloud Information Model, can be standard or custom, and serve as the foundation for segmentation and insights.

Practice this question →
90
MCQeasy

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

A.System Administrator in CRM without Data Cloud licenses
B.Salesforce CRM Standard User
C.Data Cloud Admin or Data Cloud Consultant permission set
D.Marketing Cloud Administrator only
AnswerC

Administrative permissions in Data Cloud are required to build data streams and models.

Why this answer

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

Practice this question →
91
Multi-Selecthard

Which THREE best practices should a consultant follow when configuring streaming ingestion via the Ingestion API? (Choose THREE)

Select 3 answers
A.Implement exponential backoff and retry logic in client applications to handle rate-limiting.
B.Store authentication tokens permanently in client-side JavaScript code.
C.Write Apex triggers to process incoming API payloads on the Salesforce CRM platform.
D.Define a strict JSON schema contract before sending payloads.
E.Ensure every incoming record contains a unique primary key value.
AnswersA, D, E

Handling HTTP 429 rate limits with exponential backoff ensures data delivery reliability.

Why this answer

Best practices for the Ingestion API include defining strict JSON schema contracts, implementing exponential backoff retry logic for 429 errors, and sending payloads with unique primary keys.

Practice this question →
92
Multi-Selecthard

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

Select 2 answers
A.The physical location of the administrator's laptop.
B.Complexity and number of formula transformations applied during mapping.
C.File size and total volume of records in the batch source files.
D.The color scheme configured in the Salesforce CRM user interface.
E.The number of active browser tabs open by the administrator viewing the Data Streams tab.
AnswersB, C

Complex formulas increase CPU processing overhead during ingestion.

Why this answer

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.

Practice this question →
93
Multi-Selectmedium

Which TWO file storage providers are natively supported for batch data stream ingestion in Data Cloud? (Choose TWO)

Select 2 answers
A.Google Cloud Storage
B.Amazon S3
C.Personal Dropbox account
D.Apple iCloud Drive
E.Local Windows file share via SMB
AnswersA, B

Google Cloud Storage is a fully supported native batch ingestion source.

Why this answer

Data Cloud supports native connectors for major cloud storage providers including Amazon S3, Google Cloud Storage, and Azure Blob Storage.

Practice this question →
94
MCQmedium

A Data Cloud Consultant is setting up a batch data stream from an AWS S3 bucket to ingest daily transaction records. During the configuration, the consultant notices that the incoming CSV files contain columns with varying headers across different days. How should the consultant configure the data stream to ensure successful ingestion without breaking the mapping?

A.Enable dynamic schema evolution in the Data Stream properties.
B.Ensure that the source CSV files maintain a consistent header row matching the defined Data Source Object schema.
C.Create multiple data streams, one for each variation of the CSV header.
D.Map the S3 bucket directly to a Data Model Object using formula fields to handle missing headers.
AnswerB

Data streams rely on the DSO schema matching the file structure; inconsistent headers will lead to ingestion failures or unmapped fields.

Why this answer

When configuring data streams from cloud storage like AWS S3, the underlying schema must align with the Data Source Object (DSO) definition. In Data Cloud, schema drift can cause ingestion errors, so establishing a strict contract or utilizing a consistent header structure in the source file, or leveraging standard connector parsing rules, is critical. Data Cloud does not automatically remap changing column names.

Practice this question →
95
MCQeasy

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

A.To encrypt streaming API payloads
B.To ingest and manage core reference data objects like Products, Stores, or Locations
C.To execute daily Apex backups of Salesforce CRM
D.To generate marketing email campaigns
AnswerB

Master data streams handle non-profile reference entities such as products or locations.

Why this answer

Master data streams or master data objects help organize core reference entities like Product, Store, or Geo locations.

Practice this question →
96
MCQeasy

An organization wants to ingest real-time clickstream events from their mobile application into Salesforce Data Cloud. Which ingestion mechanism should the consultant recommend?

A.Google Cloud Storage Connector
B.Interaction Ingestion API
C.Salesforce CRM Connector
D.Amazon S3 Batch Connector
AnswerB

The Interaction Ingestion API is specifically built for high-throughput, low-latency streaming data ingestion like clickstreams.

Why this answer

Real-time streaming data, such as mobile app clickstreams or IoT events, should use the Interaction Ingestion API or mobile SDKs designed for streaming ingestion, rather than batch connectors.

Practice this question →
97
MCQeasy

Which feature allows a Data Cloud Consultant to transform field values, such as concatenating first and last names or changing date formats, during the ingestion process without writing custom code?

A.Data Stream Formula Fields
B.Segment Filter Criteria
C.Identity Resolution Ruleset
D.Calculated Insights
AnswerA

Formula fields in Data Streams enable real-time transformation of fields during ingestion.

Why this answer

Formula fields in Data Streams allow consultants to apply transformations, string manipulations, and mathematical operations on incoming data during the ingestion phase.

Practice this question →
98
MCQhard

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?

A.Write an Apex deduplication trigger before sending payloads to the API.
B.Ensure that a unique primary key is defined in the Ingestion API schema so Data Cloud can upsert records correctly.
C.Enable Identity Resolution match rules specifically for transaction IDs.
D.Set the data stream refresh frequency to real-time batching.
AnswerB

Defining a primary key ensures Data Cloud upserts records instead of creating duplicate entries for the same key.

Why this answer

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.

Practice this question →
99
MCQhard

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?

A.Reject orders not denominated in USD during the S3 batch file upload.
B.Store all monetary amounts as text strings and let SQL queries perform manual string stripping.
C.Ensure both the monetary amount and currency ISO code are mapped to standard DMO attributes to enable currency normalization.
D.Hardcode an exchange rate multiplier in an Apex trigger during ingestion.
AnswerC

Mapping both amount and currency ISO code allows downstream calculations and insights to handle currency conversions properly.

Why this answer

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.

Practice this question →
100
MCQhard

A consultant maps a custom Data Source Object (DSO) field to a standard Individual Data Model Object (DMO) field in Data Cloud. After refreshing the data stream, the identity resolution rules are not picking up the new records. What is the likely cause?

A.Standard DMOs do not support custom DSO fields unless wrapped in a Profile DMO extension.
B.The Identity Resolution ruleset must be manually rerun or has a scheduled frequency that has not yet triggered.
C.The data stream must be deleted and recreated for Identity Resolution to recognize new mapping paths.
D.Harmonization requires an intermediate Master Data Model object before matching can take place.
AnswerB

Identity resolution rulesets run on a schedule or can be triggered manually; new mappings do not instantly re-evaluate existing rulesets without a run.

Why this answer

Identity Resolution Rules in Data Cloud rely on specific reconciliation rules and match rules that must include the mapped fields (e.g., email or phone). If the mapping is incorrect or the fields used in the match rules are unpopulated, identity resolution will fail to link them.

Practice this question →
← PreviousPage 2 of 2 · 100 questions total

Ready to test yourself?

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

Start 20-question session