Get Prepared for Your Marketing-Cloud-Intelligence Exam With Actual 64 Questions [Q17-Q41]

NO.17 A client would like to integrate the following two sources:
Google Campaign Manager:

IAS:

After configuring a Parent-Child relationship between the files, which query should an implementation engineer run in order to QA the setup?

NO.18 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 Confirmed Interest stage?

NO.19 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:

NO.20 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?

NO.21 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?

NO.22 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?

NO.23 Which Marketing Cloud Intelligence field is considered an attribute and not a “variable”?

NO.24 A client’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?

NO.25 Your client would like to create a new harmonization field – Exam Topic.
The below table represents the harmonization logic from each source.

As can be seen from the table there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that where an Exam ID is found -a single Exam Topic value is associated with it.
The Client has a requirement to be able to view measurements from all data sources sliced by Exam Topic values as seen in the following example:

Which harmonization feature should an Implementation engineer use to meet the client’s requirement?

NO.26 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?

NO.27 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?

NO.28 A client has provided you with sample files of their data from the following data sources:
1.Google Analytics
2.Salesforce Marketing Cloud
The link between these sources is on the following two fields:
Message Send Key
A portion of: web_site_source_key
Below is the logic the client would like to have implemented in Datorama:
For ‘web site medium’ values containing the word “email” (in all of its forms), the section after the “_” delimiter in ‘web_site_source_key’ is a 4 digit number, which matches the ‘Message Send Key’ values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in the following table:
Google Analytics:

Salesforce Marketing Cloud:

The client’s objective is to visualize the mutual key values alongside measurements from both files in a table.

In order to achieve this, what steps should be taken?

NO.29 What is the relationship between “Media Buy Key” and “Campaign Key”?

NO.30 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;

NO.31 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?

NO.32 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?

NO.33 Which three statements accurately describe the different data stream types in Marketing Cloud intelligence?

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

NO.35 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?

NO.36 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?

NO.37 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?

NO.38 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?

NO.39 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?

NO.40 A client created a new KPI: CPS (Cost per Sign-up).
The new KIP is mapped within the data stream mapping, and is populated with the following logic: (Media Cost) / Sign-ups) As can be seen in the table below, CPS was created twice and was set with two different aggregations:

From looking at the table, what are the aggregation settings for each one of the newly created KPIs?

NO.41 A client has provided you with sample files of their data from the following data sources:
1.Google Analytics
2.Salesforce Marketing Cloud
The link between these sources is on the following two fields:
Message Send Key
A portion of: web_site_source_key
Below is the logic the client would like to have implemented in Datorama:
For ‘web site medium’ values containing the word “email” (in all of its forms), the section after the “_” delimiter in ‘web_site_source_key’ is a 4 digit number, which matches the ‘Message Send Key’ values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in the following table:
Google Analytics:

Salesforce Marketing Cloud:

The client’s objective is to visualize the mutual key values alongside measurements from both files in a table.

In order to achieve this, what steps should be taken?