Data Ingestion And Modeling

A consultant is preparing to ingest a high-volume clickstream feed into Data 360 and must decide how to model the incoming events before they are used for segmentation and analytics. Which two modeling decisions should the consultant make to support this feed effectively? (Choose two.)

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 is configuring a data stream from an external REST API that returns JSON payloads. The API uses OAuth 2.0 with a client credentials grant. The consultant needs to set up the connection in Data Cloud. Which authentication method should the consultant select when creating the data stream connection?

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

A consultant is configuring a Data Stream that ingests customer records from an Amazon S3 bucket into Data Cloud. The source files are full snapshots delivered every night, and the business requires that deleted customer records be removed from the Data Cloud data model after each ingestion. Which Data Stream refresh setting should the consultant configure to meet this requirement?

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

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

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

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

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

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

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 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 consultant is creating a Data Stream from a Salesforce CRM connector to bring Account records into Data Cloud. During field mapping, the consultant needs to map the source Account object to the standard Account Data Model Object (DMO). Which mapping approach should the consultant use to align the source fields with the standard DMO attributes?

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

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 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 an Amazon S3 bucket that contains 40,000 JSON files, each under 200 KB, delivered continuously throughout the day. The business requires that newly landed files be visible for segmentation within minutes rather than hours. Which ingestion configuration should the consultant choose for this data stream?

A consultant ingests order line items from an external system into a custom Data Model Object. Each source row contains an order number and a product SKU, and a single order can contain many line items. The consultant maps both fields as standard text attributes and links the DMO to the Individual DMO. During segmentation, counts of line items per customer are drastically inflated. What is the most likely cause?

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

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)

What is the primary function of a Data Source Object (DSO) in Data 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?

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?

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

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

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?

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

A consultant has ingested data into a Data Lake Object and now needs to map it to a Data Model Object so that the data can be used in segmentation and activation. The consultant opens the Data Lake Object and begins the mapping process. Which statement correctly describes what happens when a Data Lake Object is mapped to a Data Model Object?

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

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?

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

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

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 user interface area in Data Cloud is used to manage and create data streams?

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

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

A consultant is ingesting web event data through the Web and Mobile App connector. The events include a timestamp field generated in the visitor's local time zone without any offset information. The business wants the Unified Individual profile to reflect event times consistently for segmentation across regions. What should the consultant do during data stream configuration?

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?

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

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 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 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 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 component of Salesforce Data Cloud is responsible for organizing ingested raw data into a standardized structure based on the Cloud Information Model (CIM)?

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

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

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

A consultant ingests a high-volume transactional data stream into Data Cloud and maps it to a custom Data Model Object that will be joined to the standard Individual DMO for segmentation. The source records include a customer identifier that occasionally has leading zeros stripped by the upstream system. The consultant notices that some records fail to match Individual records during segmentation. Which action should the consultant take to resolve the matching issue?

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

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

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

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?

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 consultant is ingesting order records from an external system via an S3 bucket data stream. Each order has a Customer_Email__c field in the source, but the Order DMO in Data Cloud must link to the Individual DMO using the standard Party Identification (Party Identification DMO) relationship rather than a direct email field. Which approach should the consultant take to establish the relationship between Order and Individual in the data model?

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 actions can be performed when utilizing formula functions during field mapping in Data Cloud? (Choose THREE)

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

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?

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

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

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?

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

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?

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 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 consultant is building a data stream from Salesforce CRM using the CRM connector. The source object Account has a field AnnualRevenue that is a currency field with values in different currencies depending on the record. The consultant needs to ensure that revenue values are consistently comparable in the Unified Individual DMO for segmentation. What should the consultant do during data stream configuration and mapping?

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

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

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 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 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 consultant ingests a nightly batch of customer records into the Individual data model object. The source system sends a full snapshot each night, including customers who have not changed. The consultant wants to avoid creating duplicate individuals while ensuring changed records are reflected. Which approach should the consultant take?

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?

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

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

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

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 consultant is mapping a Data Source Object (DSO) from an external e-commerce system to Data Model Objects (DMOs) in Data Cloud. The source has fields for order ID, customer ID, order date, and order total. The consultant needs to ensure the mapping supports identity resolution and segmentation. Which TWO actions should the consultant take when mapping the DSO to DMOs? (Choose two.)

A consultant is onboarding a new source system and needs to create the data stream, map its fields to the data model, and then verify that the mappings produced the expected objects. Which sequence of Data 360 capabilities should the consultant follow?

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?

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

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

A consultant has ingested a large volume of web event data into Data Cloud using the Web SDK connector. The events include page views, clicks, and custom events. The consultant needs to model this data so that it can be used for segmentation and activation, and also joined with the Individual DMO. Which DMO should the consultant map the web event data to, and how should the relationship to Individual be established?

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

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

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?

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

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

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

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?