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

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. What is the amount of clicks for “MBK A” ?

Options :

A : 10

B : We cannot know as it depends on which data stream runs first

C : v

D : N/A

Answer: D

Question 3

What type of data can you return from a VLOOKUP in Datorama?

Options :

A : Dimensions

B : Measurements

C : Calculated Measurements

D : Calculated Dimensions

Answer: A

Question 4

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 5

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

Table B

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. What is the amount of clicks for “MBK A” ?

Options :

A : 10

B : We cannot know as it depends on which data stream runs first

C : v

D : N/A

Answer: D

Free Marketing-Cloud-Intelligence Mock Exam – Practice Online Confidently

Buying Options: