Most Recent Salesforce Marketing-Cloud-Intelligence Exam Questions & Answers

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)

Show Answer Hide Answer

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:

Show Answer Hide Answer

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?

Show Answer Hide Answer

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?

Show Answer Hide Answer

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?

Show Answer Hide Answer