Salesforce Marketing Cloud Intelligence Accredited Professional Sample Questions:

1. 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)

2. An Implementation engineer is requested to create a new harmonization field 'Offer' and apply the following logic:

The implementation engineer to use the Harmonization Center. Which of the below actions can help implement the new dimension 'Offer?

A) Two separate patterns (filtered by Linkedin or AdRoll sources)
Within Google Analytics' mapping: A formula that reflects the logic above will be populated within a Campaign custom attribute.
Another pattern to be created for the newly campaign attribute (filtered by Google Analytics source).
A total of 3 patterns
B) Two separate patterns (filtered by Linkedin or AdRoll sources).
Another single pattern for Campaign Name (filtered by Google Analytics source).
A total of 3 patterns.
C) Two separate patterns (filtered by Linkedln or AdRoll sources).
Another single pattern for Web Analytics Site Source (filtered by Google Analytics source), extracting all three positions A total of 3 patterns.
D) Two separate patterns (filtered by Linkedin or AdRoll sources)
Within Google Analytics' mapping A formula that reflects the logic above will be populated within a Web Analytics Site custom attribute Another pattern to be created for the newly Web Analytics Site custom attribute (filtered by Google Analytics source).
A total of 3 patterns.

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?

A) Patterns
B) Mapping formula
C) Vlookup 0
D) Calculated Dimensions
E) Data Fusion

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

A) 8
B) 4
C) Depends on the Data Updates Permissions
D) 3

5. A client's data consists of three data streams as follows:

* 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.
Which data stream should be set as a parent?

A) Data Stream A
B) Any of the data streams can technically be the parent
C) Data Stream C
D) Data Stream B

Solutions: