Salesforce AP-215 actual dump : Marketing Cloud Intelligence Accredited Professional

A client Ingested the following We into Marketing Cloud Intelligence:

The mapping of the above file can be seen below:
Date - Day
Media Buy Key - Media Buy Key
Campaign Name - Campaign Name
Campaign Group -. Campaign Custom Attribute 01
Clicks -> Clicks
Media Cost -> Media Cost
Campaign Planned Clicks -> Delivery Custom Metric 01
The client would like to have a "Campaign Planned Clicks" measurement.
This measurement should return the "Campaign Planned Clicks" value per Campaign, for example:
For Campaign Name 'Campaign AAA", the "Campaign Planned Clicks" should be 2000, rather than 6000 (the total sum by the number of Media Buy keys).
In order to create this measurement, the client considered multiple approaches. Please review the different approaches and answer the following question:

Which two options will yield a false result:

• A. Option 2
• B. Option 3
• C. Option 5
• D. Option 1
• E. Option 4

Source 3:

Via the harmonization Center, the Client has created Patterns and applied a classification rule using source 2.
While performing QA, you have spotted that the final value of clicks for Product Group Ais 10, where it should've been i5.

How can an implementation engineer fix this discrepancy?

• A. Upload both source 1 and 3 to the same data stream type in order to be able to generate Patterns from them.
• B. Toggle the 'Structure Compliant' OFF.
• C. Uncheck the "Case Sensitive" checkbox in the data classification
• D. Leave the "Case Sensitive" checkbox in the data classification unchecked

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'],-,0)
• B. EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)
• C. LEFT(EXTRACT(csv[campaign_name'}/-',1),3)
• D. EXTRACT(csv[campaign_name!;@',1)
• E. LEFT(EXTRACT(csy['campaign_name]],~',0),3)

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?

• A. Populate the logic within a custom measurement. Set Aggregation to AVG.
• B. Populate the logic within a custom measurement. No need to change Aggregation.
• C. Unmap it, as Datorama will calculate it automatically.
• D. Populate the logic within a custom measurement. Set Aggregation to SUM.

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. 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.
• 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. 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.
• D. Upload the two files and create a Parent-Child relationship between them. The Override Media Buy Hierarchy checkbox is checked in Google Analytics.