Online Access Free AP-215 Practice Test

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.Confirmed interest
• B.Confirmed Interest & Registered
• C.interest
• D.Interest & Registered

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

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

Ina workspace that contains one hundred data streams and a lot of data, what is the biggest downside of using calculated dimensions?

• A.Scalability
• B.Ease of maintenance
• C.Ease of setup
• D.Performance

A client's data consists of three data sources - Facebook Ads, LinkedIn Ads and Google Campaign Manager.
Notes:
* The client is planning on adding an additional 100 Facebook Ads data streams and 50 more LinkedIn Ads data streams.
* The final volume of data in the workspace will be 5M rows
* Each data source has a naming convention and it can be assumed that any additional profile (i.e. Data Stream) from one of these sources will follow the same naming convention.
The client provided the following sample files:
Facebook Ads:


The client would like to create a new harmonization field named "Market," which will only be coming from Facebook Ads and LinkedIn Ads. The logic for
"Market" is the following:
IF Media Buy Type is equal to "TypeB" or "TypeC" or "TypeD"
Return 'Europe'
ELSE
Return 'Rest Of The World'
In order to create the harmonization field Market, the client considers using either Mapping Formula, Calculated Dimension, VLOOKUP or Patterns.
Considering maintenance and scalability, which option is recommended?

• A.Mapping Formulas
• B.Calculated Dimension
• C.vLookuP
• D.Patterns

A client's data consists of three data streams as follows:
Data Stream A:

• A.Update Attributes and Hierarchies
• B.It doesn't matter. As long as Data stream A is set as a Parent', the rest of the Data Updates Permissions are irrelevant.
• C.Update Attributes
• D.Inherit Attributes and Hierarchies