IT Certification Exam Questions & Answers

QUESTION 17
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?

QUESTION 18
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 19
Animplementation 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?

QUESTION 20
Which two statements are correct regarding LiteConnect?

QUESTION 21
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:

The client suggested to create, without any mapping manipulations, several patterns via the harmonization center that will generate two Harmonized Dimensions:
Exam ID
Exam Topic
Given the above information, which statement is correct regarding the ability to implement this request with the above suggestion?

QUESTION 22
A client has integrated 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 Assigned) alongside ‘Employee Name’ and/or
‘Squad’.
The client set the following properties:
+ File A is set as the Parent data stream
* Both files were uploaded to a generic data stream type.
* Override Media Buy Hierarchies is checked for file A.
* The ‘Data Updates Permissions’ set for file B is ‘Update Attributes and Hierarchy’.
When filtering on the entire date range (1-30/8), and querying employee ID, Name and Squad with the two measurements – what will the result look like?

QUESTION 23
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;

QUESTION 24
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?

QUESTION 25
Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence’s data model?

QUESTION 26
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 27
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?

QUESTION 28
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.
How should the “Override Media Buy Hierarchies” checkbox be set in order to meet the client’s requirements?

QUESTION 29
What Is a disadvantage of using a Vlookup formula?

QUESTION 30
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?

QUESTION 31
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 32
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.
How should the “Override Media Buy Hierarchies” checkbox be set in order to meet the client’s requirements?

QUESTION 33
Source 3:

Via the harmonization Center, the Client has created Patterns and applied a classification rule using source 2.
While performing QA, you have spotted that the final value of clicks for Product Group Ais 10, where it should’ve been i5.

How can an implementation engineer fix this discrepancy?

QUESTION 34
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?