Free Salesforce AP-215 Exam Dumps Questions & Answers

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?

• A. 
• B. 
• C. 
• D. 

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:

• A. 
• B. 
• C. 
• D. 

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?

• A.  Create a second Pattern for Media Buy Name
• B.  Create a second Pattern for Media Buy Name and apply two Classification Rules (one for 'Messi' and another for Ronaldo') for the final Harmonized Dimension.
• C.  Create a second Pattern for Media Buy Name and apply a Classification Rule (with the two values) for the final Harmonized Dimension
• D.  Create a second Pattern for Media Buy Name and add a validation list (with the two values) for the final Harmonized Dimension.

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

• A.  Many-to-many
• B.  One-to-one
• C.  One-to-many (one Media Buy ley has many Creative Key)
• D.  Many-to-one (one Creative Key has many Media Buy Keys)

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?

• A.  EXTRACT(csv[campaign_name!;@',1)
• B.  EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)
• C.  LEFT(EXTRACT(csv[campaign_name'}/-',1),3)
• D.  LEFT(EXTRACT(csy['campaign_name]],~',0),3)
• E.  EXTRACT(csv[campaign_name'],-,0)