Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Salesforce Marketing-Cloud-Intelligence Practice Exam with Questions & Answers

Questions 1

A client has integrated data from Facebook Ads. Twitter ads, and Google ads in marketing Cloud intelligence. For each data source, the source, the data follows a naming convensions as …

Facebook Ads Naming Convention - Campaign Name:

CampID_CampName#Market_Object#object#targetAge_TargetGender

Twitter Ads Naming Convention- Media Buy Name

MarketTargeAgeObjectiveOrderID

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. Given the above information, which statement is correct regarding the ability to implement this request?

wet Me - Given the above information, which statement i 's Correct regarding the ability to implement this request?

Options:
A.

The client Wi-Fi be able to harmonize only Google Ads and Twitter Ads, as Facebook Ads naming convention contains mufti delimiters.

B.

it is not possible to do this, as the naming conventions are different

C.

This is not possible as the naming conventions are in different fields (Campaign Name and Placement Name)

D.

The client will be able to do this and it will require building three patterns.

Salesforce Marketing-Cloud-Intelligence Premium Access
Questions 2

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

Options:
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

Questions 3

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:

Marketing-Cloud-Intelligence Question 3

From looking at the table, what are the aggregation settings for each one of the newly created KPIs?

A)

Marketing-Cloud-Intelligence Question 3

B)

Marketing-Cloud-Intelligence Question 3

C)

Marketing-Cloud-Intelligence Question 3

D)

Marketing-Cloud-Intelligence Question 3

Options:
A.

Option A

B.

Option B

C.

Option C

D.

Option D

Questions 4

An implementation engineer has been asked by a client for assistance with the following problem:

The below dataset was ingested:

Marketing-Cloud-Intelligence Question 4

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?

Options:
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

Questions 5

Your client has provided sample files of their data from the following data sources:

Google Campaign Manager

Marketing-Cloud-Intelligence Question 5

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

Which action(s) are needed to take place in order to meet the client’s requirement and set Google DV360 as the source of truth for Cost?

Options:
A.

Unmap ‘Cost' in Google DV360

B.

Set ‘Inherit Attributes and Hierarchies’ as the Data updates Permissions for Google DV360

C.

Set Update Attributes and Hierarchies’ as the Data updates Permissions for Google DV360

D.

Unmap ‘Cost’ in Google Campaign Manager

Questions 6

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:

Marketing-Cloud-Intelligence Question 6

The client performed the below standard mapping:

Marketing-Cloud-Intelligence Question 6

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:

Marketing-Cloud-Intelligence Question 6

Options:
A.

A Harmonized dimension was created via a pattern over the Creative Name.

B.

A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)

C.

An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.

D.

An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.

Questions 7

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.

Marketing-Cloud-Intelligence Question 7

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?

Options:
A.

2

B.

1

C.

3

D.

0

Questions 8

Your client is interested in ingested the below file to a new generic data stream type:

Marketing-Cloud-Intelligence Question 8

The field ‘Meeting Code’ was mapped to the main entity key. ‘How should the ‘Room Number’ be mapped?

Options:
A.

An attribute of ‘Meeting Code’

B.

A custom metric and set aggregation to AUTO

C.

A custom metric and set aggregation to SUM

D.

A separate entity key

Questions 9

Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence’s data model?

Options:
A.

These dimensions are stored at the workspace level

B.

Variable Dimensions hold a Many-to-Many relationship with its main entity

C.

All variables exist in every data set type, hence are considered as overarching dimensions

D.

These are stand alone dimensions that pertain to the data set itself rather than to a specific entity

Questions 10

Client has provided sample flies of their data from the following data sources:

Google Campaign Manager

Marketing-Cloud-Intelligence Question 10

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:

Marketing-Cloud-Intelligence Question 10

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?

Options:
A.

4

B.

8

C.

3

D.

Depends on the Data Updates Permissions

Certification Provider: Salesforce
Exam Name: Marketing Cloud Intelligence Accredited Professional Exam
Last Update: Jul 13, 2025
Questions: 63
PDF + Testing Engine
$164.99
$57.75
Testing Engine
$124.99
$43.75
PDF (Q&A)
$104.99
$36.75

Salesforce Related Exams

How to pass Salesforce Financial-Services-Cloud - Salesforce Financial Services Cloud (FSC) Accredited Professional (AP) Exam (SP25) Exam
How to pass Salesforce Advanced-Cross-Channel - Salesforce Advanced Cross Channel Accredited Professional Exam Exam
How to pass Salesforce Marketing-Cloud-Personalization - Marketing Cloud Personalization Accredited Professional Exam (SP25) Exam
How to pass Salesforce Manufacturing-Cloud-Professional - Manufacturing Cloud Accredited Professional Exam (SP25) Exam
How to pass Salesforce Security-and-Privacy-Accredited-Professional - Salesforce Security & Privacy Accredited Professional Exam Exam
How to pass Salesforce Salesforce-Net-Zero-Cloud - Salesforce Net Zero Cloud Accredited Professional Exam Exam
How to pass Salesforce Public-Sector-Solutions - Salesforce Public Sector Solutions Accredited Professional (SP25) Exam
How to pass Salesforce Salesforce-Communications-Cloud - Salesforce Communications Cloud Accredited Professional (AP) Exam Exam
How to pass Salesforce Energy-and-Utilities-Cloud - Salesforce Energy and Utilities Cloud Accredited Professional Exam Exam
How to pass Salesforce Salesforce-Contact-Center - Salesforce Contact Center Accredited Professional Exam Exam
How to pass Salesforce Marketing-Cloud-Advanced-Cross-Channel - SalesforceMarketing Cloud Advanced Cross ChannelExam Exam
How to pass Salesforce Salesforce-Media-Cloud - Salesforce Media Cloud Accredited Professional (AP) Exam Exam

Salesforce Free Exams

Salesforce Free Exams
Examstrack provides free Salesforce exam prep materials and practice tests to support your Salesforce certification goals.