Salesforce Certified Marketing Cloud Intelligence Accredited Professional Practice Test - Questions Answers, Page 2

An implementation engineer is requested to create the harmonization field - Magician

This field should come from multiple Twitter Ads data streams, and should follow the below logic:

Using the Harmonization Center, the engineer created a single Pattern for Campaign Name. What other action should the engineer take to meet the requirements?

A client has integrated data from Facebook Ads, Twitter Ads, and Google Ads in Marketing Cloud Intelligence. For each data source, the data follows a naming convention as shown below:

Facebook Ads Naming Convention - Campaign Name:

Camp|D_CampName#Market_Objective#TargetAge_TargetGender

Twitter Ads Naming Convention - Media Buy Name:

Market|TargetAge|Objective|OrderID

' 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.

In addition to the previous details, the client provides the following data sample:

Logic specification:

If a value is not present in the Validation List, return ''Not Valid''

If a value is not present in the Classification File, return ''Unclassified''.

If the Harmonization center is used to harmonize the above data and files, what table will show the final output?

A)

B)

C)

D)

Which Marketing Cloud Intelligence field is considered an attribute and not a ''variable''?

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

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 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 assume that the file is mapped in the OPPORTUNITIES Data Stream type with the following mapping:

''Day'' --- ''Created Date''

''Opportunity Key'' + Opportunity Key

''Opportunity Stage'' --- Opportunity Stage

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