marks4sure logo
What are two potential reasons for performance issues (when loading a dashboard) when using the CRM data stream type?
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.
The client would like to have a "Site Revenue" measurement.
This measurement should return the highest revenue value per Site, for example:
For Site Key ‘SK_C_2’, the "Site Revenue" should be $7.00.
When aggregated by date, the "Site Revenue" measurement should return the total sum of the results of all sites.
For example:
For the date 1 Apr 2020, "Site Revenue" should be $11.00 (sum of Site Revenue for Site Keys ‘SK_C_1' ($4.00) and ‘SK_C_2’ ($7.00))
Which options will yield the desired result;
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)
An implementation engineer has been provided with 4 different source files: 03m 48s
1. Twitter Ads ~
2. Creative Classification
3. Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:
Creative ID — links back to Creative Key (Twitter Ads)
1st Party Placement Classification by
File structure/headers:
A)
B)
C)
D)
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 4 different source files: 03m 16s
1. Twitter Ads
2. Creative Classification
3. Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:
Creative ID — links back to Creative Key (Twitter Ads)
1st Party Placement Classification &
File structure/headers:
Category — links back to Campaign Category (Twitter Ads)
Which proposed solution meets the client's requirements for the above use case?
A)
B)
C)
D)
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 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” — Main Generic Entity Attribute
“Opportunity Count” — Generic Custom Metric
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 Interest stage?
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?
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?
An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values.
For example:
Campaign Name: AFD@Mulop-1290
Desired outcome: AFD
Other examples:
Which formula will return the desired values?
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?
TESTED 05 Feb 2025
