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
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 . 4
- B . 8
- C . 3
- D . Depends on the Data Updates Permissions
What Is a disadvantage of using a Vlookup formula?
- A . Can return values only from the same data stream type
- B . It cannot be used more than once from the same data stream.
- C . Could extend processing time of data streams.
- D . It allows classifying data only on a basis of mutual entity keys.
What is the relationship between “Media Buy Key” and “Campaign Key”?
- A . Many-to-one (one Campaign Key has many Media Buy Keys)
- B . Many-to-many
- C . One-to-many (one Media Buy Key has many Campaign Keys)
- D . One-to-one
A client’s data consists of three data streams as follows:
Data Stream A:

- A . Update Attributes
- B . Inherit Attributes and Hierarchies
- C . Update Attributes and Hierarchies
- D . It doesn’t matter. As long as Data stream A is set as a Parent’, the rest of the Data Updates Permissions are irrelevant.
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?
- A . 1
- B . 3
- C . 2
- D . 0
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?
- A . Populate the logic within a custom measurement. No need to change Aggregation.
- B . Unmap it, as Datorama will calculate it automatically.
- C . Populate the logic within a custom measurement. Set Aggregation to AVG.
- D . Populate the logic within a custom measurement. Set Aggregation to SUM.
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 . Calculated Dimensions
- B . Patterns
- C . Vlookup 0
- D . Data Fusion
- E . Mapping formula
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?
- A . Interest & Registered
- B . Confirmed interest
- C . interest
- D . Confirmed Interest & Registered
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?
- A . It should be checked in Data Stream C
- B . It should not be checked in any of the three Data Streams.
- C . It should be checked in Data Stream B
- D . It should be checked in Data Stream A
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?
- A . It should be checked in Data Stream C
- B . It should not be checked in any of the three Data Streams.
- C . It should be checked in Data Stream B
- D . It should be checked in Data Stream A