Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

Marketing-Cloud-Intelligence Questions and Answers

Question # 6

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 Interest stage?

A.

1

B.

3

C.

2

D.

0

Full Access
Question # 7

A client created a new KPI: CPS (Cost per Sign-up).

The new KIP is mapped within the data stream mapping, and is populated with the following logic: (Media Cost) / Sign-ups)

As can be seen in the table below, CPS was created twice and was set with two different aggregations:

From looking at the table, what are the aggregation settings for each one of the newly created KPIs?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 8

Your client would like to create a new harmonization field - Exam Topic.

The below table represents the harmonization logic from each source.

As can be seen from the table, there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that

where an Exam ID is found - a single Exam Topic value is associated with it.

The client has a requirement to be able to view measurements from all data sources sliced by Exam Topic values, as seen in the following

example:

The client suggested to create, without any mapping manipulations, several patterns via the harmonization center that will generate two

Harmonized Dimensions:

Exam ID

Exam Topic

Given the above information, which statement is correct regarding the ability to implement this request with the above suggestion?

A.

The above Patterns setup will not work for this use case.

B.

The solution will work - the client will be able to view Exam Topic with Email Sends.

C.

Only if 5 different Patterns are created, from 5 different fields - the solution will work.

D.

The Harmonized field for Exam ID is redundant. One Harmonized dimension for Exam Topic is enough for a sustainable and working solution

Full Access
Question # 9

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.

Registered

B.

Interest & Registered

C.

Confirmed Interest & Registered

D.

Interest

E.

Confirmed Interest

Full Access
Question # 10

A client has integrated data from Facebook Ads. Twitter ads, and Google ads in marketing Cloud intelligence. For each data source, the source, the data follows a naming convensions as …

Facebook Ads Naming Convention - Campaign Name:

CampID_CampName#Market_Object#object#targetAge_TargetGender

Twitter Ads Naming Convention- Media Buy Name

MarketTargeAgeObjectiveOrderID

Google ads Naming Convention-Media Buy Name:

Buying_type_Market_Objective

The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization Center. Given the above information, which statement is correct regarding the ability to implement this request?

wet Me - Given the above information, which statement i 's Correct regarding the ability to implement this request?

A.

The clientWi-Fibe able to harmonize only Google Ads and Twitter Ads, as Facebook Ads naming convention contains mufti delimiters.

B.

it is not possible to do this, as the naming conventions are different

C.

This is not possible as the naming conventions are in different fields (Campaign Name and Placement Name)

D.

The client will be able to do this and it will require building three patterns.

Full Access
Question # 11

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

A.

One-to-many (one Media Buy ley has many Creative Key)

B.

One-to-one

C.

Many-to-many

D.

Many-to-one (one Creative Key has many Media Buy Keys)

Full Access
Question # 12

The following file was uploaded into Marketing Cloud Intelligence as a generic dataset type:

The mapping is as follows:

Day — Day

Web_site_source — Main Generic Entity Attribute 01

Page Views — Generic Metric 1

*Note that ‘web_site_key’ and ‘web_site_name’ are NOT mapped.

How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?

A.

4

B.

0

C.

1

D.

3

Full Access
Question # 13

Aclient has integrated the following files:

File A:

File B:

The client would like to link the two files in order to view the two KPIs (‘Tasks Completed’ and ‘Tasks Assigned) alongside ‘Employee Name’ and/or

‘Squad’.

The client set the following properties:

+ File Ais set as the Parent data stream

* Both files were uploaded to a generic data stream type.

* Override Media Buy Hierarchies is checked for file A.

* The ‘Data Updates Permissions’ set for file B is ‘Update Attributes and Hierarchy’.

When filtering on the entire date range (1-30/8), and querying employee ID, Name and Squad with the two measurements - what will the result look like?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 14

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.

Interest & Registered

B.

Confirmed interest

C.

interest

D.

Confirmed Interest & Registered

Full Access
Question # 15

Which two statements are correct regarding the Parent-Child configuration?

A.

Parent-Child configurations can cause performances issues

B.

A Parent-Child cannot be configured between an Ads data stream type and a Conversion Tag one.

C.

Parent-Child links different tables based on shared key values

D.

Parent-Child allows sharing both dimensions and measurements

Full Access
Question # 16

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

“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 7th - 10th. How many different stages are presented in the table?

A.

2

B.

1

C.

3

D.

0

Full Access
Question # 17

A client provides the following three files:

File A:

File B:

File C:

File A was uploaded using the Ads data stream type.

The client would like to create this view (data from Files B & C) in Datorama:

Which proposed solution would cause a false connection between the two files?

A.

Custom classification

B.

Data Classification

C.

VLOOKUP in Data Stream B. Vlookup will return “Day” and “Installs”

D.

VLOOKUP in Data Stream C. Vlookup will return "MB Name”

Full Access
Question # 18

What is the relationship between “Media Buy Key” and “Campaign Key”?

A.

Many-to-one (one Campaign Key has many Media Buy Keys)

B.

Many-to-many

C.

One-to-many (one Media Buy Key has many Campaign Keys)

D.

One-to-one

Full Access