Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam Questions Instant Access

Question 1

Which Marketing Cloud Intelligence field is considered an attribute and not a ''variable''?

ACampaign Category

BDevice Category

CDevice Browser

DGeo Location

Answer : B

In Marketing Cloud Intelligence, attributes refer to characteristics of the data that describe the environment or context but do not change within the scope of the data being analyzed. 'Device Category' is typically an attribute as it describes a characteristic of the device used and doesn't vary within a given session or user interaction. In contrast, variables are typically metrics or dimensions that can change value or be measured.

Question 2

A client's data consists of three data sources - Facebook Ads, LinkedIn Ads and Google Campaign Manager.

Notes:

* The client is planning on adding an additional 100 Facebook Ads data streams and 50 more LinkedIn Ads data streams.

* The final volume of data in the workspace will be 5M rows

* Each data source has a naming convention and it can be assumed that any additional profile (i.e. Data Stream) from one of these sources will follow the same naming convention.

The client provided the following sample files:

Facebook Ads:

The client would like to create a new harmonization field named "Market," which will only be coming from Facebook Ads and LinkedIn Ads. The logic for

"Market" is the following:

IF Media Buy Type is equal to "TypeB" or "TypeC" or "TypeD"

Return 'Europe'

ELSE

Return 'Rest Of The World'

In order to create the harmonization field Market, the client considers using either Mapping Formula, Calculated Dimension, VLOOKUP or Patterns.

Considering maintenance and scalability, which option is recommended?

AMapping Formulas

BCalculated Dimension

CPatterns

DvLookuP

Answer : C

Patterns are the best approach in this scenario because:

Scalability: Patterns are highly scalable and can easily handle the addition of 100 more Facebook Ads and 50 more LinkedIn Ads streams. You can define pattern-matching rules that automatically apply to new data streams based on the naming conventions.

Flexibility and Maintenance: Patterns allow you to maintain and adjust logic easily. Since the logic for determining 'Market' is based on a defined naming convention (e.g., Media Buy Type), Patterns can handle these rules effectively without requiring manual updates or static tables.

Efficient Harmonization: Patterns automatically classify data based on defined rules, reducing the need for ongoing manual maintenance compared to approaches like VLOOKUP or Mapping Formulas, which might require frequent updates as data changes.

Why not other options?

Mapping Formulas: While Mapping Formulas work well for static mappings, they are not as scalable or maintainable when the dataset grows or changes frequently.

Calculated Dimension: This option is valid for simple logic but is less maintainable for large-scale datasets, especially when new data streams are added.

VLOOKUP: This method is manual and not scalable. It would require you to update lookup tables for each new data stream, which is inefficient given the expected growth of the data.

Question 3

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

''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?

Answer : C

Based on the Opportunity file and considering the filter dates from January 7th to 10th, the different stages presented are 'Interest', 'Confirmed Interest', and 'Registered'. This makes a total of 3 different stages that would be presented in the pivot table. Salesforce Marketing Cloud Intelligence allows for the creation of pivot tables that can display counts of entities across different dimensions, in this case, Opportunity Stages. Reference to Salesforce Marketing Cloud Intelligence documentation that covers data mapping and pivot table creation would support this conclusion.

Question 4

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?

APopulate the logic within a custom measurement. No need to change Aggregation.

BUnmap it, as Datorama will calculate it automatically.

CPopulate the logic within a custom measurement. Set Aggregation to AVG.

DPopulate the logic within a custom measurement. Set Aggregation to SUM.

Answer : A

CPC (Cost per Click) is a calculated metric that should be created using a custom measurement based on the formula provided (Cost / Clicks). This calculation does not require a change in the aggregation setting because it is derived from other base metrics that are already aggregated appropriately. In Salesforce Marketing Cloud Intelligence, custom measurements are used to create new metrics from existing data points, and the system will use the underlying data's aggregation to perform the calculation. Reference: Salesforce Marketing Cloud Intelligence documentation on creating custom measurements and calculated metrics.

Question 5

What is the relationship between "Media Buy Key" and "Creative Key?

AOne-to-many (one Media Buy ley has many Creative Key)

BOne-to-one

CMany-to-many

DMany-to-one (one Creative Key has many Media Buy Keys)

Answer : A

In Marketing Cloud Intelligence, the 'Media Buy Key' is typically associated with the purchase details of a media campaign, such as the platform, audience, and budget. The 'Creative Key' relates to the specific creative asset used within a campaign, like an image, video, or text. A single media buy can have multiple creative variations to test performance or to target different audiences, leading to a one-to-many relationship.

Question 6

An implementation engineer is requested to create the harmonization field - Magician

This field should come from multiple Twitter Ads data streams, and should follow the below logic:

Using the Harmonization Center, the engineer created a single Pattern for Campaign Name. What other action should the engineer take to meet the requirements?

ACreate a second Pattern for Media Buy Name and apply two Classification Rules (one for 'Messi' and another for Ronaldo') for the final Harmonized
Dimension.

BCreate a second Pattern for Media Buy Name

CCreate a second Pattern for Media Buy Name and add a validation list (with the two values) for the final Harmonized Dimension.

DCreate a second Pattern for Media Buy Name and apply a Classification Rule (with the two values) for the final Harmonized Dimension

Answer : A

For the field 'Magician', the engineer is required to follow a logic that extracts a value from 'Campaign Name' and checks against a validation list for specific values ('Messi' or 'Ronaldo'). If those values are not found, it should instead extract from 'Media Buy Name'. To accomplish this, the engineer should:

Use the created Pattern for 'Campaign Name'.

Create a second Pattern for 'Media Buy Name' to capture the fallback values.

Apply two Classification Rules to the Harmonized Dimension: one for the value 'Messi' and another for 'Ronaldo'. This is to check the extracted 'Campaign Name' against these specific values.

These steps ensure that the 'Magician' field will be populated with the correct values from the respective data streams following the specified logic.

Question 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.

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?

ARegistered

BInterest & Registered

CConfirmed Interest & Registered

DInterest

EConfirmed Interest

Answer : B

Analyzing the Opportunity file with a filter set from January 7th to 11th, Opportunity Key '123AA01' appears under 'Interest' on January 6th and 8th, and under 'Registered' on January 10th. Therefore, during the specified date range, Opportunity Key '123AA01' is associated with both 'Interest' and 'Registered' stages. Salesforce Marketing Cloud Intelligence provides the capability to map and track opportunity stages over time, allowing for historical stage tracking and reporting. This answer aligns with the ability to use pivot tables to filter and display data by specific attributes and timeframes, as outlined in the Salesforce Marketing Cloud Intelligence documentation.