Salesforce MARKETING-CLOUD-INTELLIGENCE Online Practice Questions and Exam Preparation

Salesforce MARKETING-CLOUD-INTELLIGENCE Online Questions & Answers

• Question 31:

  Your client provided the following sources: Source 1:

  

  Source 2:

  

  Source 3:

  

  As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from `Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:

  

  Which two options will meet the client's requirement and enable the desired view?

  A. Custom Classification: 1 Source 1: Custom Classification key will be populated with the extraction of the Media Buy Name. Source 2: `Product' will be mapped to Custom Classification key and `Product Group' to a Custom Classification level. Exam Timer Source 3: `Product will be mapped to Custom Classification key. Came
  B. Overarching Entities: Source 1: custom classification key will be populated with the extraction of the Media Buy Name. Source 2: `Product' will be mapped to Product field and `Product Group' to Product Name. Source 3: `Product' will be mapped to Product field.
  C. Parent Child: All sources will be uploaded to the same data stream type - Ads. The setup is the following: Source 1: Media Buy Key --- Media Buy Key, extracted product value -- Media Buy Attribute. Source 2: Product -- Media Buy Key, Product Group --- Media Buy Attribute. Source 3: Product -- Media Buy Key.
  D. Harmonization Center: Patterns from sources 1 and 3 generate harmonized dimension `Product'. Data Classification rule, using source 2, is applied on top of the harmonized dimension
  A. Custom Classification: 1 Source 1: Custom Classification key will be populated with the extraction of the Media Buy Name. Source 2: `Product' will be mapped to Custom Classification key and `Product Group' to a Custom Classification level. Exam Timer Source 3: `Product will be mapped to Custom Classification key. Came
  D. Harmonization Center: Patterns from sources 1 and 3 generate harmonized dimension `Product'. Data Classification rule, using source 2, is applied on top of the harmonized dimension

• Question 32:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

• Question 33:

  An implementation engineer is requested to apply the following logic:

  

  To apply the above logic, the engineer used only the Harmonization Center, without any mapping manipulations. What is the minimum amount of Patterns creating both `Platform' and `Line of Business'?"

  A. 2
  B. 3
  C. 5
  D. 4
  B. 3

• Question 34:

  An implementation engineer is requested to extract the second position of the Campaign Name values.

  The Campaign values consist of multiple delimiter types, as can be seen in the following example:

  Campaign Name: Ad15X2wandDelux_wal90

  Desired value: Delux

  Which three harmonization methods will achieve the desired outcome?

  A. Calculated Dimensions
  B. Patterns
  C. Vlookup 0
  D. Data Fusion
  E. Mapping formula
  A. Calculated Dimensions
  B. Patterns
  E. Mapping formula

• Question 35:

  The following file was uploaded into Marketing Cloud Intelligence as a Generic Data Stream type:

  

  The mapping is as follows: Day -- Day web_site_key --> Main Generic Entity Key web_site_name --> Main Generic Entity Name Web_site_source --> Main Generic Entity Attribute 01 Page Views -- Generic Metric 1 How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?

  A. 1
  C. 3
  D. 4
  D. 4

• Question 36:

  Your client has provided sample files of their data from the following data sources: Google Campaign Manager

  

  Below are the requirements from the client and additional information:

  1. The sources are linked to each other by shared Media Buy names.

  2. In addition to the mutual Media Buys, the sources contain campaign and site values. However, the client would like to see the campaign/site values coming from Google CM and not from Google DV360.

  3. The source of truth for cost is Google DV360

  4. Which action(s) are needed to take place in order to meet the client's requirement and set Google DV360 as the source of truth for Cost?

  A. Unmap `Cost' in Google DV360
  B. Set `Inherit Attributes and Hierarchies' as the Data updates Permissions for Google DV360
  C. Set Update Attributes and Hierarchies' as the Data updates Permissions for Google DV360
  D. Unmap `Cost' in Google Campaign Manager
  D. Unmap `Cost' in Google Campaign Manager

• Question 37:

  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 January (entire month). What is the number of opportunities in the Interest stage?

  A. 1
  B. 3
  C. 2
  B. 3

• Question 38:

  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?

  A. An attribute of `Meeting Code'
  B. A custom metric and set aggregation to AUTO
  C. A custom metric and set aggregation to SUM
  D. A separate entity key
  A. An attribute of `Meeting Code'

• Question 39:

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

• Question 40:

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

  

  The data streams should be linked together through a parent-child relationship.

  Out of the three data streams, Data Stream C is considered the source of truth for both the dimensions and measurements.

  The client would like to have a "Site Revenue" measurement.

  This measurement should return the highest revenue value per Site, for example:

  For Site Key `SK_C_2', the "Site Revenue" should be $7.00.

  When aggregated by date, the "Site Revenue" measurement should return the total sum of the results of all sites.

  For example:

  For the date 1 Apr 2020, "Site Revenue" should be $11.00 (sum of Site Revenue for Site Keys `SK_C_1' ($4.00) and `SK_C_2' ($7.00))

  

  Which options will yield the desired result;

  A. Option #1 and Option #4
  B. Option #1 and Option #3
  C. Option #2 and Option #3
  D. Option #2 and Option #4
  D. Option #2 and Option #4