Data Ingestion And Modeling

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 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 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?

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?

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

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 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 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?

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

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)

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

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

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

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?

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

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?

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

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?

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

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?

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

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

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

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 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?

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?

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

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?

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

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

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

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?

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?

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

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?

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

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

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?

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

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?

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

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

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?

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

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

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?

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?

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

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

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

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?

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

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?

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

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?

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 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?

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

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?

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

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

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

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 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?

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?

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

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

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

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?

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

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 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?

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?

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

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

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

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?

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?

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

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 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?

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

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

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

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 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 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 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?

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 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 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?

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 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 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?

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?

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 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?

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?

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?

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