EMT Practice Test

1. Question Content...

---

Question1: 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?

Question2: 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?

Question3: Which Marketing Cloud Intelligence field is considered an attribute and not a "variable"?

Question4: 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?

Question5: 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?

Question6: Your client provided the following sources:
Source 1:

Source 2:

Source 3:

As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from 'Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:

Which two options will meet the client's requirement and enable the desired view?

Question7: What are two potential reasons for performance issues (when loading a dashboard) when using the CRM data stream type?

Question8: 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.
Assuming the data was ingested properly and the Parent Child was created correctly according to the client's requirements, what is the total Impressions value for Campaign Key 'CK_3'?

Question9: 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?

Question10: 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?

Question11: What areunstable measurements?

Question12: A client's data consists of three data streams as follows:
Data Stream A:

Question13: 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?

Question14: 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?

Question15: 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?

Question16: An implementation engineer has been asked to perform QA for a standard file ingestion, done by the client.
The source file that was ingested can be seen below:

The number of rows added to this data stream is 3. What could have led to this discrepancy?

Question17: What Is a disadvantage of using a Vlookup formula?

Question18: 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?

Question19: A client provides the following two data streams:
Data Stream 1:

The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020.
Which mapping options should the client apply to obtain the expected result?

Question20: Which three statements describe Overarching Entities? 03m 23s

Question21: Which two statements are correct regarding LiteConnect?

Question22: Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence's data model?

Question23: 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?

Question24: 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;

Question25: 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?

Question26: What is the relationship between "Media Buy Key" and "Creative Key?

Question27: Ina workspace that contains one hundred data streams and a lot of data, what is the biggest downside of using calculated dimensions?

Question28: 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?

Question29: After uploading a standard file into Marketing Cloud intelligence via totalConnect, you noticed that the number of rows uploaded (to the specific data stream) is NOT equal to the number of rows present in the source file. What are two resource that may cause thisgap?

Question30: 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?