Data-Cloud-Consultant Exam Dumps : Salesforce Certified Data Cloud Consultant (Data-Con-101)

To create a new data stream from a custom Salesforce CRM object, the consultant needs to confirm that the View All object permission is enabled in the source Salesforce CRM org. This permission allows the user to view all records associated with the object, regardless of sharing settings1. Without this permission, the custom object will not be available in the New Data Stream configuration2. References:

Manage Access with Data Cloud Permission Sets

Object Permissions

The issue arises because the activated segment in Marketing Cloud contains orders older than 30 days, despite the segment being defined to include only recent orders. The best solution is to apply a filter to the Purchase Order Date to exclude older orders. Here’s why:

Understanding the Issue

The segment includes related attributes from the purchase order data.

Despite filtering for orders placed in the last 30 days, older orders are appearing in the activation.

Why Apply a Filter to Purchase Order Date?

Root Cause :

The related attributes (e.g., purchase order details) may not be filtered by the same criteria as the segment.

Without a specific filter on the Purchase Order Date , older orders may inadvertently be included.

Solution Approach :

Applying a filter directly to the Purchase Order Date ensures that only orders within the desired timeframe are included in the activation.

Other Options Are Less Suitable :

A. Use data graphs that contain only 30 days of data : Data graphs are not typically used to filter data for activations.

B. Apply a data space filter to exclude orders older than 30 days : Data space filters apply globally and may unintentionally affect other use cases.

D. Use SQL in Marketing Cloud Engagement to remove orders older than 30 days : This is a reactive approach and does not address the root cause in Data Cloud.

Steps to Resolve the Issue

Step 1: Review the Segment Definition

Confirm that the segment filters for orders placed in the last 30 days.

Step 2: Add a Filter to Purchase Order Date

Modify the activation configuration to include a filter on the Purchase Order Date , ensuring only orders within the last 30 days are included.

Step 3: Test the Activation

Publish the segment again and verify that the activation in Marketing Cloud contains only the desired orders.

Conclusion

By applying a filter to the Purchase Order Date , the consultant ensures that only orders placed in the last 30 days are included in the activation, resolving the issue effectively.

The question asks which statement is true about batch ingestions from Salesforce CRM into Salesforce Data Cloud. Batch ingestion refers to the process of periodically syncing data from Salesforce CRM (e.g., Accounts, Contacts, Opportunities) into Data Cloud. The focus is on how the CRM connector handles changes in data structure (e.g., adding or removing columns) and synchronization behavior.

Why A is Correct: "When a column is added or removed, the CRM connector performs a full refresh."

Behavior of the CRM Connector :

The Salesforce CRM connector automatically detects schema changes, such as when a field (column) is added or removed in the source CRM object.

When such changes occur, the CRM connector triggers a full refresh of the data for that object. This ensures that the data model in Data Cloud aligns with the updated schema in Salesforce CRM.

Why a Full Refresh is Necessary :

A full refresh ensures that all records are re-ingested with the updated schema, avoiding inconsistencies or missing data caused by incremental updates.

Incremental updates only capture changes (e.g., new or modified records), so they cannot handle schema changes effectively.

Other Options Are Incorrect :

B. The CRM connector performs an incremental refresh when 600K or more deletion records are detected : This is incorrect because the CRM connector does not switch to incremental refresh based on the number of deletion records. It always performs incremental updates unless a schema change triggers a full refresh.

C. The CRM connector's synchronization times can be customized to up to 15-minute intervals : While synchronization schedules can be customized, the minimum interval is typically 1 hour , not 15 minutes.

D. CRM data cannot be manually refreshed and must wait for the next scheduled synchronization : This is incorrect because users can manually trigger a refresh of CRM data in Data Cloud if needed.

Steps to Understand CRM Connector Behavior

Step 1: Schema Changes Trigger Full Refresh

If a field is added or removed in Salesforce CRM, the CRM connector detects this change and initiates a full refresh of the corresponding object in Data Cloud.

Step 2: Incremental Updates for Regular Syncs

For regular synchronization, the CRM connector performs incremental updates, capturing only new or modified records since the last sync.

Step 3: Manual Refresh Option

Users can manually trigger a refresh in Data Cloud if immediate synchronization is required, bypassing the scheduled sync.

Step 4: Monitor Synchronization Logs

Use the Data Cloud Monitoring tools to track synchronization status, including full refreshes and incremental updates.

Conclusion

The statement "When a column is added or removed, the CRM connector performs a full refresh" is true. This behavior ensures that the data model in Data Cloud remains consistent with the schema in Salesforce CRM, avoiding potential data integrity issues.