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

Question 1

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?

Accepted Answer

Stage the files from SFTP into a supported cloud storage provider (e.g., Amazon S3) and ingest via a batch data stream.. 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.

Answer

Configure the Salesforce CRM connector to read the SFTP files directly.

Answer

Use manual CSV uploads via Data Explorer every hour.

Answer

Write a custom Apex trigger on the SFTP server to push records directly to Data Source Objects.

Question 2

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

Accepted Answer

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

Answer

Tableau Server connection manager

Answer

Marketing Cloud Engagement administration panel

Answer

Heroku dashboard settings

Question 3

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?

Accepted Answer

Map the nested array to a related child DMO using the parent event primary key as the foreign key.. 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.

Answer

Write a Calculated Insight to unpack the array after ingestion.

Answer

Discard nested arrays because Data Cloud only supports flat tabular data structures.

Answer

Flatten the array into a comma-separated string inside a single text field.

Question 4

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?

Accepted Answer

Trigger a manual refresh or wait for the next scheduled ingestion run.. 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.

Answer

Deactivate the Salesforce CRM connected app and regenerate all OAuth tokens.

Answer

Rebuild the entire Identity Resolution ruleset.

Answer

Export all DSO records to CSV and re-upload manually.

Question 5

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?

Accepted Answer

Use a formula transformation during field mapping with a CASE statement to translate codes into text descriptions.. During field mapping, consultants can use formula functions (such as `CASE` or conditional statements) to transform numeric status codes into readable text strings.

Answer

Store the numbers as integers and write a Tableau dashboard translation table.

Answer

Create a custom Apex class in the ERP system to rewrite codes before export.

Answer

Create a master data stream specifically for status code translation tables.

Question 6

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

Accepted Answer

Establish object relationships and cardinality to support downstream segmentation.. 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.

Answer

Manually configure HTML email templates in Marketing Cloud Engagement.

Answer

Write Apex triggers to manage database indexing on external ERP systems.

Question 7

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

Accepted Answer

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

Answer

Automatically deletes duplicate records in the external source system.

Answer

Replaces the need for batch data stream scheduling.

Answer

Eliminates the need to configure primary keys on custom DMOs.

Question 8

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

Accepted Answer

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

Answer

To design audience segmentation filters

Answer

To configure activation targets and publishing schedules

Answer

To write ANSI SQL queries for Calculated Insights

Question 9

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?

Accepted Answer

Verify that the tracking data bundle or corresponding event data streams were selected and enabled during setup.. 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.

Answer

Restart the Kafka message broker.

Answer

Rewrite all tracking data into CSV format and upload to S3.

Answer

Check the Salesforce CRM Connected App OAuth scopes.

Question 10

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?

Accepted Answer

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

Answer

SQL dump text files (.sql)

Answer

XML files with nested attributes

Answer

Microsoft Word (.docx) documents

Question 11

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

Accepted Answer

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

Answer

Salesforce CRM Bulk API

Answer

Marketing Cloud FTP drop

Answer

Heroku Connect sync trigger

Question 12

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?

Accepted Answer

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

Answer

Calculated Insights aggregation formulas

Answer

Data Action publishing targets

Answer

Segment builder canvas

Question 13

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?

Accepted Answer

Data Cloud automatically sanitizes headers into valid field names, and consultants map them in the mapping canvas.. 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.

Answer

Consultants must manually rename every column in the S3 CSV file before every batch run.

Answer

Special characters are converted into Apex escape sequences.

Answer

Ingestion fails immediately if headers contain spaces or special characters.

Question 14

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

Accepted Answer

To inspect raw and harmonized records stored in DSOs and DMOs. Data Explorer enables users to inspect records within Data Source Objects and Data Model Objects.

Answer

To configure activation targets and publishing schedules

Answer

To execute machine learning model training in Einstein Studio

Answer

To manage user permission sets and security profiles

Question 15

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

Accepted Answer

Implement exponential backoff and retry logic in client applications to handle rate-limiting.. 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.

Answer

Store authentication tokens permanently in client-side JavaScript code.

Answer

Write Apex triggers to process incoming API payloads on the Salesforce CRM platform.