Salesforce marketing cloud intelligence Practice Exams
Last updated on Nov 16,2026- Exam Code: marketing cloud intelligence
- Exam Name: Marketing Cloud Intelligence Accredited Professional Exam
- Certification Provider: Salesforce
- Latest update: Nov 16,2026
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?
A)

B)

C)
![]()
D)
![]()
- A . Option A
- B . Option B
- C . Option C
- D . Option D
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?
A)

B)

C)
![]()
D)
![]()
- A . Option A
- B . Option B
- C . Option C
- D . Option D
A client provides the following three files:
File A:

File B:

File C:

File A was uploaded using the Ads data stream type.
The client would like to create this view (data from Files B & C) in Datorama:

Which proposed solution would cause a false connection between the two files?
- A . Custom classification
- B . Data Classification
- C . VLOOKUP in Data Stream
- D . Vlookup will return “Day” and “Installs”
- E . VLOOKUP in Data Stream
- F . Vlookup will return "MB Name”
A client provides the following three files:
File A:

File B:

File C:

File A was uploaded using the Ads data stream type.
The client would like to create this view (data from Files B & C) in Datorama:

Which proposed solution would cause a false connection between the two files?
- A . Custom classification
- B . Data Classification
- C . VLOOKUP in Data Stream
- D . Vlookup will return “Day” and “Installs”
- E . VLOOKUP in Data Stream
- F . Vlookup will return "MB Name”
Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:
![]()
Creative ID ― links back to Creative Key (Twitter Ads)
1st Party Placement Classification by
File structure/headers:
![]()
A)

B)

C)

D)

- A . Option A
- B . Option B
- C . Option C
- D . Option D
Which option will yield the desired result:?

- A . Option 1
- B . Option 4
- C . Option 2
- D . Option 3
A client provides the following two data streams:
Data Stream 1:

Question-
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?
A)

B)

C)

D)

- A . Option A
- B . Option B
- C . Option C
- D . Option D
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?
- A . The measurement ‘Clicks’ is set as a percentage.
- B . A mapping formula was populated, indicating not to bring Type! values.
- C . The aggregation function is set as AVG
- D . The aggregation function is set as LIFETIME
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?
- A . There is no difference, all permissions will have a similar effect given the scenario.
- B . Update Attributes and Hierarchies
- C . Update Attributes
- D . Inherit Attributes and Hierarchies
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?
- A . There is no difference, all permissions will have a similar effect given the scenario.
- B . Update Attributes and Hierarchies
- C . Update Attributes
- D . Inherit Attributes and Hierarchies