Salesforce : AP-215 Questions & Answers

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?

• A. Create a Web Analytics Site custom attribute and populate it with the extraction logic. Create a Data Fusion between the newly created attribute and the Message Send Key.
• B. Create a Web Analytics Site Source custom attribute and populate it with the extraction logic. Create a Data Fusion between the newly created attribute and the Message Send Key.
• C. Upload the two files and create a Parent-Child relationship between them. The Override Media Buy Hierarchy checkbox is checked in Google Analytics.
• D. Within both files, map the desired value to Custom Classification Key as follows Salesforce Marketing Cloud: map entire Message Key to Custom Classification Key.
  Google Analytics: map the extraction logic to Custom Classification Key.

An implementation engineer has been asked to perform QA for a standard file ingestion, done by the client.
The source file that was ingested can be seen below:

The number of rows added to this data stream is 3. What could have led to this discrepancy?

• A. All fields are mapped except for the Media Buy Name.
• B. All fields are mapped except for the Campaign Key
• C. All fields are mapped except for the Media Buy Key.
• D. All fields are mapped except for the Creative Name

After uploading a standard file into Marketing Cloud intelligence via total Connect, you noticed that the number of rows uploaded (to the specific data stream) is NOT equal to the number of rows present in the source file. What are two resource that may cause this gap?

• A. All mapped Measurements for a given row have values equal to zero
• B. Main entity is not mapped
• C. The source file does not contain the media Buy entity
• D. The file does not contain any measurements (dimension only)

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?

• A. Interest & Registered
• B. Confirmed Interest & Registered
• C. interest
• D. Confirmed interest

A client provides the following three files:
File A:

File B:

File C:

File A was uploaded using the Ads data stream type.
The client would like to create this view (data from Files B & C) in Datorama:

Which proposed solution would cause a false connection between the two files?

• A. VLOOKUP in Data Stream C. Vlookup will return "MB Name"
• B. VLOOKUP in Data Stream B. Vlookup will return "Day" and "Installs"
• C. Custom classification
• D. Data Classification