Question 1

A client provides the following three files:
File A:

File B:

File C:

File A was uploaded using the Ads data stream type.
The client would like to create this view (data from Files B & C) in Datorama:

Which proposed solution would cause a false connection between the two files?
  • Question 2

    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?
  • Question 3

    What is the relationship between "Media Buy Key" and "Creative Key?
  • Question 4

    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'?"
  • Question 5

    An implementation engineer has been provided with the below dataset:

    *Note: CPC = Cost per Click
    Formula: Cost / Clicks
    Which action should an engineer take to successfully integrate CPC?