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:
Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence’s data model?
A technical architect is provided with the logic and Opportunity file shown below:
The opportunity status logic is as follows:
For the opportunity stages “Interest”, “Confirmed Interest” and “Registered”, the status should be “Open”.
For the opportunity stage “Closed”, the opportunity status should be closed Otherwise, return null for the opportunity status.
Given the above file and logic and assume that the file is mapped in the OPPORTUNITIES Data Stream type with the following mapping:
“Day” — “Created Date”
“Opportunity Key” + Opportunity Key
“Opportunity Stage” — Opportunity Stage
A pivot table was created to present the count of opportunities in each stage. The pivot table is filtered on Jan 11th. What is the number of ‘opportunities in the Confirmed Interest stage?