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

Salesforce MARKETING-CLOUD-INTELLIGENCE Online Questions & Answers

• Question 11:

  After uploading a standard file into Marketing Cloud intelligence via total Connect, you noticed that the number of rows uploaded (to the specific data stream) is NOT equal to the number of rows present in the source file. What are two resource that may cause this gap?

  A. All mapped Measurements for a given row have values equal to zero
  B. Main entity is not mapped
  C. The source file does not contain the media Buy entity
  D. The file does not contain any measurements (dimension only)
  A. All mapped Measurements for a given row have values equal to zero
  B. Main entity is not mapped

• Question 12:

  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:

  1. "Day" -- "Created Date"

  2. "Opportunity Key" + Opportunity Key

  3. "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. 2
  B. 1
  C. 3
  D

• Question 13:

  Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence's data model?

  A. These dimensions are stored at the workspace level
  B. Variable Dimensions hold a Many-to-Many relationship with its main entity
  C. All variables exist in every data set type, hence are considered as overarching dimensions
  D. These are stand alone dimensions that pertain to the data set itself rather than to a specific entity
  A. These dimensions are stored at the workspace level
  B. Variable Dimensions hold a Many-to-Many relationship with its main entity

• 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 "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
  C. 3

• Question 15:

  What are two potential reasons for performance issues (when loading a dashboard) when using the CRM data stream type?

  A. When a data stream type ''CRM - Leads' is created, another complementary 'CRM - Opportunity' is created automatically.
  B. Pacing - daily rows are being created for every lead and opportunity keys
  C. No mappable measurements - all measurements are calculated
  D. The data is stored at the workspace level.
  B. Pacing - daily rows are being created for every lead and opportunity keys
  C. No mappable measurements - all measurements are calculated

• Question 16:

  A client's data consists of three data sources - Facebook Ads, LinkedIn Ads and Google Campaign Manager. Notes:

  1. The client is planning on adding an additional 100 Facebook Ads data streams and 50 more LinkedIn Ads data streams.

  2. The final volume of data in the workspace will be 5M rows

  3. Each data source has a naming convention and it can be assumed that any additional profile (i.e. Data Stream) from one of these sources will follow the same naming convention.

  The client provided the following sample files:

  Facebook Ads:

  

  The client would like to create a new harmonization field named "Market," which will only be coming from Facebook Ads and LinkedIn Ads. The logic for "Market" is the following:

  IF Media Buy Type is equal to "TypeB" or "TypeC" or "TypeD"

  Return `Europe'

  ELSE

  Return 'Rest Of The World'

  In order to create the harmonization field Market, the client considers using either Mapping Formula, Calculated Dimension, VLOOKUP or Patterns.

  Considering maintenance and scalability, which option is recommended?

  A. Mapping Formulas
  B. Calculated Dimension
  C. Patterns
  D. vLookuP
  C. Patterns

• Question 17:

  An implementation engineer has been asked to perform QA for a standard file ingestion, done by the client. The source file that was ingested can be seen below:

  

  The number of rows added to this data stream is 3. What could have led to this discrepancy?

  A. All fields are mapped except for the Media Buy Key.
  B. All fields are mapped except for the Creative Name
  C. All fields are mapped except for the Media Buy Name.
  D. All fields are mapped except for the Campaign Key
  D. All fields are mapped except for the Campaign Key

• Question 18:

  Which two statements are correct regarding LiteConnect?

  A. It does not require any identification of entities, keys or any other categorization.
  B. The dataset does not conform to the standard data model
  C. All of the dimensions mapped within a LiteConnect data stream are considered overarching entities.
  D. Data coming from LiteConnect cannot be harmonized with the rest of the workspace data via the harmonization center at a later step.
  A. It does not require any identification of entities, keys or any other categorization.
  B. The dataset does not conform to the standard data model

• Question 19:

  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. 3
  B. 1
  D. 2
  C

• Question 20:

  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 and C) in Datorama:

  

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

  A. Custom classification
  B. Vlookup will return "Day" and "Installs"
  C. Vlookup will return "MB Name"
  D. VLOOKUP in Data Stream
  C. Vlookup will return "MB Name"