Dumpsbuddy logo
Client has provided sample flies of their data from the following data sources:
Google Campaign Manager
Below are the requirements from the client and additional information:
• The sources are linked to each other by shared Media Buy names.
• In addition-to the mutual Media Buys, the sources contain campaign and site values. However, the client would like to see the campaign/site values coming from Google CM and not from Google DV360.
• The source of truth for cost is Google DV360.
As a first step, a Parent-Child relationship was created between the two files, and the following mapping was performed, within both data streams:
Please note:
• All other measurements were mapped as well to the appropriate fields.
• No other mapping manipulations or formulas were implemented.
How many records will the merged table hold?
An implementation engineer has been asked by a client for assistance with the following problem:
The below dataset was ingested:
However, when performing QA and querying a pivot table with Campaign Category and Clicks, the value for Type’ is 4.
What could be the reason for this discrepancy?
A client has integrated data from Facebook Ads, Twitter Ads, and Google Ads in Marketing Cloud Intelligence. For each data source, the data
follows a naming convention as shown below:
Facebook Ads Naming Convention - Campaign Name:
Camp|D_CampName#Market_Objective#TargetAge_TargetGender
Twitter Ads Naming Convention - Media Buy Name:
Market|TargetAge|Objective|OrderID
' Google Ads Naming Convention - Media Buy Name:
Buying Type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization ‘Center.
In addition to the previous details, the client provides the following data sample:
Logic specification:
If a value is not present in the Validation List, return “Not Valid”
If a value is not present in the Classification File, return “Unclassified”.
If the Harmonization center is used to harmonize the above data and files, what table will show the final output?
A)
B)
C)
D)
Which three entities and/or functions can be used in an expression when building a calculated dimension?
A client’s data consists of three data streams as follows:
Data Stream A:
* 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.
Assuming the data was ingested properly and the Parent Child was created correctly according to the client's requirements, what is the total
Impressions value for Campaign Key ‘CK_3’?
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?
The following file was uploaded into Marketing Cloud Intelligence as a Generic Data Stream type:
The mapping is as follows:
Day — Day
web_site_key —> Main Generic Entity Key
web_site_name —> Main Generic Entity Name
Web_site_source —> Main Generic Entity Attribute 01
Page Views — Generic Metric 1
How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?
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?
A client has integrated data from Facebook Ads. Twitter ads, and Google ads in marketing Cloud intelligence. For each data source, the source, the data follows a naming convensions as …
Facebook Ads Naming Convention - Campaign Name:
CampID_CampName#Market_Object#object#targetAge_TargetGender
Twitter Ads Naming Convention- Media Buy Name
MarketTargeAgeObjectiveOrderID
Google ads Naming Convention-Media Buy Name:
Buying_type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization Center. Given the above information, which statement is correct regarding the ability to implement this request?
wet Me - Given the above information, which statement i 's Correct regarding the ability to implement this request?
A client's data consists of three data streams as follows:
Data Stream A:
* 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.
* Data Stream C was set as a ‘Parent’, and the ‘Override Media Buy Hierarchy’ checkbox is checked
What should the Data Updates Permissions be set to for Data Stream B?
Ina workspace that contains one hundred data streams and a lot of data, what is the biggest downside of using calculated dimensions?
An implementation engineer is requested to extract the second position
of the Campaign Name values.
The Campaign values consist of multiple delimiter types, as can be
seen in the following example:
Campaign Name: Ad15X2w&Delux_wal90
Desired value: Delux
Which three harmonization methods will achieve the desired outcome?
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:
TESTED 01 Dec 2025
