Free Salesforce Marketing-Cloud-Intelligence Exam Questions

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 assuming that the file is mapped in a GENERIC data stream type with the following mapping: “Day” — Standard “Day” field “Opportunity Key” > Main Generic Entity Key “Opportunity Stage” — Generic Entity key 2 A pivot table was created to present the count of opportunities in each stage. The pivot table is filtered on Jan 7th-11th.Which option reflects the stage(s) the opportunity key 123AA01 is associated with?

Your client provided the following sources: Source 1:

Source 2:

Source 3:

As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from ‘Media Buy Name’ in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:

Which two options will meet the client’s requirement and enable the desired view?