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

Question 1

What Is a disadvantage of using a Vlookup formula?

ACan return values only from the same data stream type

BIt cannot be used more than once from the same data stream.

CCould extend processing time of data streams.

DIt allows classifying data only on a basis of mutual entity keys.

Answer : C

The use of VLOOKUP formulas can increase the processing time of data streams because it requires a lookup operation for each row in the data set. When large volumes of data are involved, or when multiple VLOOKUPs are used, this can significantly impact processing time due to the complexity and computational requirements of matching and retrieving the data.

Question 2

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 3

An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values.

For example:

Campaign Name: AFD@Mulop-1290

Desired outcome: AFD

Other examples:

Which formula will return the desired values?

ALEFT(EXTRACT(csy['campaign_name]],~',0),3)

BEXTRACT(csv[campaign_name!;@',1)

CEXTRACT(csv[campaign_name'],---,0)

DEXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)

ELEFT(EXTRACT(csv[campaign_name'}/---',1),3)

Answer : B

The EXTRACT function is used to split a string based on a delimiter and return the segment at the specified position. The campaign names are structured with the segment of interest followed by an '@' sign. Therefore, the formula needs to extract the segment before the '@'.

The correct formula is: EXTRACT(csv['campaign_name']; '@', 1). This will take the 'campaign_name' field, split it at the '@' sign, and return the first segment (position 1), which is the three-letter code that is required. The other options are incorrect because they do not properly specify the delimiter and the segment position in the way needed to achieve the desired outcome.

Question 4

An implementation engineer has been provided with 4 different source files: 03m 48s

1. Twitter Ads ~

2. Creative Classification

3. 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:

AOption A

BOption B

COption C

DOption D

Answer : A

In Salesforce Marketing Cloud Intelligence, connections between source files and classification files are established through common keys that link data records. For this scenario:

The '1st Party Creative Classification' file has a 'Creative ID' field which corresponds to the 'Creative Key' in the 'Twitter Ads' data. This link enables enrichment of Twitter Ads data with creative classification details.

The '1st Party Placement Classification' file will contain a 'Placement ID' that connects to a corresponding field in the 'Twitter Ads' data, enabling the enrichment of placement classification details.

Option A appears to accurately depict this setup where data streams for 'Creative Classification' and 'Placement Classification' are connected to the 'Twitter Ads' data stream using the 'Creative ID' and 'Placement ID', respectively. This structure allows for the enhancement of the main Twitter Ads data with additional classification information.

Question 5

Your client has provided sample files 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

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?

AUnmap 'Cost' in Google DV360

BSet 'Inherit Attributes and Hierarchies' as the Data updates Permissions for Google DV360

CSet Update Attributes and Hierarchies' as the Data updates Permissions for Google DV360

DUnmap 'Cost' in Google Campaign Manager

Answer : D

To set Google DV360 as the source of truth for cost:

The cost data from Google DV360 should be prioritized, which means ensuring that the 'Cost' field in Google Campaign Manager is not mapped or is mapped with less priority compared to Google DV360.

Given that DV360 is to be the source of truth, you do not want competing cost data from Campaign Manager. Unmapping 'Cost' in Google Campaign Manager prevents conflicting data between the two sources and upholds the integrity of the cost data coming from Google DV360.

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

The client performed the below standard mapping:

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:

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

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

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

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

Answer : D

Given that the 'Color' field is extracted from the 'Creative Name' field and appears to be part of the creative-level data, the most logical method would be to create an EXTRACT formula and map it to a Creative custom attribute. This allows the 'Color' value to be associated directly with each creative entry. In Salesforce Marketing Cloud Intelligence, the EXTRACT formula can be used to parse and segment text strings within a field, and this process is used for harmonizing data by creating new dimensions or attributes based on existing data, which is what's described here. This answer is consistent with Salesforce Marketing Cloud Intelligence features that enable data transformation and harmonization through formulaic mapping, as per the official Salesforce documentation on data harmonization and transformation.

Question 7

The following file was uploaded into Marketing Cloud Intelligence as a Generic Data Stream type:

The mapping is as follows:

Day --- Day

web_site_key ---> Main Generic Entity Key

web_site_name ---> Main Generic Entity Name

Web_site_source ---> Main Generic Entity Attribute 01

Page Views --- Generic Metric 1

How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?

Answer : D

With the uploaded file mapped as a Generic Data Stream type, the unique identifier for a row is the combination of 'Day', 'web_site_key', 'web_site_name', and 'Web_site_source'. As 'Day' is mapped to 'Day', 'web_site_key' to 'Main Generic Entity Key', 'web_site_name' to 'Main Generic Entity Name', and 'Web_site_source' to 'Main Generic Entity Attribute 01', each unique combination of these fields will constitute a separate row.

The provided file has 4 unique combinations of 'Day', 'web_site_key', 'web_site_name', and 'Web_site_source', as each line has a unique 'web_site_key' and 'web_site_name'. Consequently, Marketing Cloud Intelligence will store 4 rows, one for each unique combination.