Salesforce Marketing Cloud Intelligence Accredited Professional - AP-215 Exam Practice Test
Question 1
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?
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?
Correct Answer: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 2
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:
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:
Correct Answer: D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 3
A client provides the following two data streams:
Data Stream 1:
The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020.
Which mapping options should the client apply to obtain the expected result?
Data Stream 1:
The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020.
Which mapping options should the client apply to obtain the expected result?
Correct Answer: B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 4
Your client provided the following sources:
Source 1:
Source 2:
Source 3:
As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from 'Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:
Which two options will meet the client's requirement and enable the desired view?
Source 1:
Source 2:
Source 3:
As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from 'Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:
Which two options will meet the client's requirement and enable the desired view?
Correct Answer: C,D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 5
Your client is interested in ingesting the below file:
The client decided to upload the file to a new generic data stream type and map 'Date' to 'Day' and 'Number of Topics' to a generic custom metric.
In regards to the fields 'Meeting Code' and 'Meeting Name', your client is debating several options.
Which two options would you recommend in order to avoid data loss?
The client decided to upload the file to a new generic data stream type and map 'Date' to 'Day' and 'Number of Topics' to a generic custom metric.
In regards to the fields 'Meeting Code' and 'Meeting Name', your client is debating several options.
Which two options would you recommend in order to avoid data loss?
Correct Answer: C,D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 6
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?
*Note: CPC = Cost per Click
Formula: Cost / Clicks
Which action should an engineer take to successfully integrate CPC?
Correct Answer: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 7
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?
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?
Correct Answer: C
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
