Pass with AP-215 Practice Materials 100% for sure

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" - Main Generic Entity Attribute
"Opportunity Count" - Generic Custom Metric
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. 1
• B. 3
• C. 0
• D. 2

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'?"

• A. 5
• B. 4
• C. 3
• D. 2

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. Vlookup 0
• B. Data Fusion
• C. Calculated Dimensions
• D. Mapping formula
• E. Patterns

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:

• A. A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)
• B. An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.
• C. An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.
• D. A Harmonized dimension was created via a pattern over the Creative Name.

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?

• A. Parent Child:
  All sources will be uploaded to the same data stream type - Ads. The setup is the following:
  Source 1: Media Buy Key -- Media Buy Key, extracted product value - Media Buy Attribute.
  Source 2: Product - Media Buy Key, Product Group -- Media Buy Attribute.
  Source 3: Product - Media Buy Key.
• B. Harmonization Center:
  Patterns from sources 1 and 3 generate harmonized dimension 'Product'. Data Classification rule, using source 2, is applied on top of the harmonized dimension
• C. Overarching Entities:
  Source 1: custom classification key will be populated with the extraction of the Media Buy Name.
  Source 2: 'Product' will be mapped to Product field and 'Product Group' to Product Name.
  Source 3: 'Product' will be mapped to Product field.
• D. Custom Classification: 1
  Source 1: Custom Classification key will be populated with the extraction of the Media Buy Name.
  Source 2: 'Product' will be mapped to Custom Classification key and 'Product Group' to a Custom Classification level. Exam Timer Source 3: 'Product will be mapped to Custom Classification key. Came