Salesforce Related Exams
Marketing-Cloud-Intelligence Exam
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:

A client's data consists of three data streams as follows:

* The data streams should be linked together through a parent-child relationship.
* Out of the three data streams, Data Stream C is considered the source of truth for both the dimensions and measurements.
Which data stream should be set as a parent?
After uploading a standard file into Marketing Cloud intelligence via total Connect, you noticed that the number of rows uploaded (to the specific data stream) is NOT equal to the number of rows present in the source file. What are two resource that may cause this gap?