Free certification test prep

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

QUESTION 11
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 12
Animplementation 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?

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

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

QUESTION 15
A client’s data consists of three data streams as follows:
Data Stream A:

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

QUESTION 17
Which two statements are correct regarding LiteConnect?

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

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

QUESTION 20
A client’s data consists of three data streams as follows:
Data Stream A:

QUESTION 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.

Which three advantages does a client gain from using Calculated Dimensions as the harmonization method for creating the Objective field?

QUESTION 22
The following file was uploaded into Marketing Cloud Intelligence as a generic dataset type:

The mapping is as follows:
Day – Day
Web_site_source – Main Generic Entity Attribute 01
Page Views – Generic Metric 1
*Note that ‘web_site_key’ and ‘web_site_name’ are NOT mapped.
How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?

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

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
What areunstable measurements?

QUESTION 26
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’?”

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

QUESTION 28
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 29
Which three statements describe Overarching Entities? 03m 23s

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

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