Salesforce Marketing cloud intelligence Exam Dumps

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

2. Which two statements are correct regarding the Parent-Child configuration?

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

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

5. 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’?"

6. An implementation engineer is requested to create the harmonization field - Magician

This field should come from multiple Twitter Ads data streams, and should follow the below logic:





Using the Harmonization Center, the engineer created a single Pattern for Campaign Name.

What other action should the engineer take to meet the requirements?

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

A)





B)





C)





D)

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

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

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

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

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

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

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

15. 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:

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

17. An implementation 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?

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

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

A)





B)





C)





D)

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

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