Salesforce Related Exams
Marketing-Cloud-Intelligence Exam
An implementation engineer is requested to apply the following logic:

To apply the above logic, the engineer used only the Harmonization Center, without any mapping manipulations. What is the minimum amount of Patterns creating both ‘Platform’ and ‘Line of Business’?"
An implementation engineer has been asked to perform a QA for a newly created harmonization field, Color, implemented by a client.
The source file that was ingested can be seen below:

The client performed the below standard mapping:

As a final step, the client had created the field ‘Color’. As can be seen, it is extracted from the Creative Name (after the ‘#’ sign).
For QA purposes, you have queried a pivot table, with the following fields:
* Media Buy Key
* Media Buy Name
* In View Impressions
The final pivot is presented below:

Which three entities and/or functions can be used in an expression when building a calculated dimension?