Exam for engine

Q22. Your client is interested in ingesting the below file:

The client decided to upload the file to a new generic data stream type and map ‘Date’ to ‘Day’ and ‘Number of Topics’ to a generic custom metric.
In regards to the fields ‘Meeting Code’ and ‘Meeting Name’, your client is debating several options.
Which two options would you recommend in order to avoid data loss?

Q23. 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
“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
7th – 10th. How many different stages are presented in the table?

Q24. Your client has provided sample files 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
Which action(s) are needed to take place in order to meet the client’s requirement and set Google DV360 as the source of truth for Cost?

Q25. 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?

Q26. Your client is interested in ingested the below file to a new generic data stream type:

The field ‘Meeting Code’ was mapped to the main entity key. ‘How should the ‘Room Number’ be mapped?

Q27. Which three entities and/or functions can be used in an expression when building a calculated dimension?

Q28. Animplementation 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:

Q29. Which two statements are correct regarding LiteConnect?

Q30. A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing insights and cross-channel marketing activity analysis. Below are details regarding the different data sources and the number of data streams required for each source.

What three advantages are gained when using Patterns & Data Classification as the harmonization method for creating the Objective field?

Q31. 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?

Q32. 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;

Q33. An implementation engineer is requested to integrate the following files:
File A:

File B:

The client would like to link the two files in order to view the two KPIS (Tasks Completed’ and ‘tasks Assignmed’) alongside’Employee Name’ and/or ‘Squard’.
A Parent-Child configuration was set between the two.
Which two statements are correct?

Q34. 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?

Q35.

Which option will yield the desiredresult:?

Q36. 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?

Q37. Which three statements describe Overarching Entities? 03m 23s

Q38. A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing insights and cross-channel marketing activity analysis. Below are details regarding the different data sources and the number of data streams required for each source.

When harmonizing the Objective field from within the data stream mapping, which advantage is gained?

Q39. 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?

Q40. 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’?”

Q41. A client’s data consists of three data sources – Facebook Ads, LinkedIn Ads and Google Campaign Manager.
Notes:
* The client is planning on adding an additional 100 Facebook Ads data streams and 50 more LinkedIn Ads data streams.
* The final volume of data in the workspace will be 5M rows
* Each data source has a naming convention and it can be assumed that any additional profile (i.e. Data Stream) from one of these sources will follow the same naming convention.
The client provided the following sample files:
Facebook Ads:


The client would like to create a new harmonization field named “Market,” which will only be coming from Facebook Ads and LinkedIn Ads. The logic for
“Market” is the following:
IF Media Buy Type is equal to “TypeB” or “TypeC” or “TypeD”
Return ‘Europe’
ELSE
Return ‘Rest Of The World’
In order to create the harmonization field Market, the client considers using either Mapping Formula, Calculated Dimension, VLOOKUP or Patterns.
Considering maintenance and scalability, which option is recommended?

Q42. 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?

Q43. Aclient’s data consists of three data streams as follows:

* 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.
Which data stream should be set as a parent?

Q44. An Implementation engineer is requested to create a new harmonization field ‘Offer’ and apply the following logic:

The implementation engineer to use the Harmonization Center. Which of the below actions can help implement the new dimension ‘Offer?

Q45. A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing insights and cross-channel marketing activityanalysis. Below are details regarding the different data sources and the number of data streams required for each source.

What three advantages are gained when using Patterns & Data Classification as the harmonization method for creating the Objective field?