Salesforce AP-215 Actual Free Exam Questions & Community Discussion

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?

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 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 assume that the file is mapped in the OPPORTUNITIES Data Stream type with the following mapping:
"Day" - "Created Date"
"Opportunity Key" + Opportunity Key
"Opportunity Stage" - Opportunity Stage
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 Confirmed Interest stage?

A client has integrated data from Facebook Ads, Twitter Ads, and Google Ads in Marketing Cloud Intelligence. For each data source, the data follows a naming convention as shown below:
Facebook Ads Naming Convention - Campaign Name:
Camp|D_CampName#Market_Objective#TargetAge_TargetGender
Twitter Ads Naming Convention - Media Buy Name:
Market|TargetAge|Objective|OrderID
' 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.
In addition to the previous details, the client provides the following data sample:


Logic specification:
If a value is not present in the Validation List, return "Not Valid"
If a value is not present in the Classification File, return "Unclassified".
If the Harmonization center is used to harmonize the above data and files, what table will show the final output?

A client has provided you with sample files of their data from the following data sources:
1.Google Analytics
2.Salesforce Marketing Cloud
The link between these sources is on the following two fields:
Message Send Key
A portion of: web_site_source_key
Below is the logic the client would like to have implemented in Datorama:
For 'web site medium' values containing the word "email" (in all of its forms), the section after the "_" delimiter in 'web_site_source_key' is a 4 digit number, which matches the 'Message Send Key' values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in the following table:
Google Analytics:

Salesforce Marketing Cloud:

The client's objective is to visualize the mutual key values alongside measurements from both files in a table.

In order to achieve this, what steps should be taken?

Ina workspace that contains one hundred data streams and a lot of data, what is the biggest downside of using calculated dimensions?

An implementation engineer is requested to apply the following logic:

To apply the above logic, the engineer used only the Harmonization Center, without any mapping manipulations. What is the minimum amount of Patterns creating both 'Platform' and 'Line of Business'?"