Question 1

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:

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:

Options :

A : A Harmonized dimension was created via a pattern over the Creative Name.

B : A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)

C : An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.

D : An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.

Answer: D

Question 2

Which of the following statements is incorrect?

Options :

A : When using Custom Classification and/or Parent-Child the values are stored in the database, which is an advantage from a performance perspective

B :

Data Fusion is considered a scalable solution. If Data Fusion is set between field A and field B, future data streams containing values of field A will be automatically linked with field B, without any further action

C : In use-cases with many data streams, Custom Classification is considered a scalable solution. This is because if the logic of the Custom Classification Key changes, you only need to update it in one data stream and the key in the rest of the data streams will automatically be updated and follow this new logic

D : Calculated Dimension final values and Data Fusion queries are both calculated on the fly which can have an impact on performance when high volume of data is involved

Answer: C

Question 3

Which is NOT a reason in the Build vs. Buy conversation for why a customer should choose Datorama?

Options :

A : It has no upfront API development time for the IT department

B :

It takes no engineers to maintain

C : It is a company that has a lot of amazing employees

D : It does not require you to focus the majority of your time on data management

Answer: C

Question 4

Table A is the first one e B the second

Data Stream A has the following properties:

Override Media Buy Hierarchies - Yes

It is considered as the Source of truth for Impressions

The mapping of dimensions for Data Stream A is as follows:

Media Buy Key is mapped to Media Buy Key

Media Buy Name is mapped to Media Buy Name

Data Stream B has the following properties:

Override Media Buy Hierarchies - No

The mapping of dimensions for Data Stream B is as follows:

Media Buy Name is mapped to Media Buy Name

Table A

2022-09-27-20-33-31-c69c2c8175dbb38f8558ca89f5c911a5

Table B

2022-09-27-20-33-31-8999fd07f93132f7f6de60870458da95

After creating a Parent-Child relationship between the two files as follows: Table B is set as a Child, with Data Updates Permission: Inherit Attributes and Hierarchy. How many records will the merged table hold?

Options :

A : 3

B : 5

C : 2

D : 4

Answer: B

Question 5

Your client is interested in ingested the below file to a new generic data stream type:

The field ‘Meeting Code’ was mapped to the main entity key. ‘How should the ‘Room Number’ be mapped?

Options :

A :

An attribute of ‘Meeting Code’A custom metric and set aggregation to AUTO

B : A custom metric and set aggregation to AUTO

C : A custom metric and set aggregation to SUM

D : A separate entity key

Answer: A

Confidently Practice Online with Free AP-215 Exam Cram

Buying Options: