Marketing-Cloud-Intelligence Exam Dumps : Marketing Cloud Intelligence Accredited Professional (AP-215)

Since Data Stream C is considered the source of truth for both dimensions and measurements, it should be set as the parent data stream. This is because the parent data stream is used as the primary source for hierarchical and attribute data within a parent-child relationship setup. As the source of truth, Data Stream C will provide the foundational data upon which the other streams can be aligned and will ensure consistency and accuracy across the linked data.

Scalability: Using Calculated Dimensions allows the client to apply the same harmonization logic to future data streams, ensuring consistency and reducing the need for individual adjustments.

Ease of Maintenance: With the logic centralized in Calculated Dimensions, any adjustments or updates are applied in one place, simplifying ongoing management.

Performance: Calculated Dimensions can improve dashboard performance because their values are pre-computed and stored, reducing the need for real-time calculations when loading dashboards.

Given that the 'Color' field is extracted from the 'Creative Name' field and appears to be part of the creative-level data, the most logical method would be to create an EXTRACT formula and map it to a Creative custom attribute. This allows the 'Color' value to be associated directly with each creative entry. In Salesforce Marketing Cloud Intelligence, the EXTRACT formula can be used to parse and segment text strings within a field, and this process is used for harmonizing data by creating new dimensions or attributes based on existing data, which is what's described here. This answer is consistent with Salesforce Marketing Cloud Intelligence features that enable data transformation and harmonization through formulaic mapping, as per the official Salesforce documentation on data harmonization and transformation.