Home / Salesforce / Certified Marketing Cloud Intelligence Accredited Professional

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

Question list

List of questions

Question 31

(0)

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 &

Question 32

(0)

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 extract

Question 33

(0)

What are unstable measurements?

Question 34

(0)

A client provides the following two data streams: Data Stream 1: Question- The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020. Whic

Question 35

(0)

What Is a disadvantage of using a Vlookup formula?

Question 36

(0)

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?

Question 37

(0)

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

Question 38

(0)

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 d

Question 39

(0)

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 pre

Question 40

(0)

Which three entities and/or functions can be used in an expression when building a calculated dimension?

Related questions

An implementation engineer has been provided with the below dataset: *Note: CPC = Cost per Click Formula: Cost / Clicks Which action should an engineer take to successfully integrate CPC?

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

An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values. For example: Campaign Name: AFD@Mulop-1290 Desired outcome: AFD Other examples: Which formula will return the desired values?

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. Assuming the data was ingested properly and the Parent Child was created correctly according to the client's requirements, what is the total Impressions value for Campaign Key 'CK_3'?

An implementation engineer is requested to integrate 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 Assignmed') alongside'Employee Name' and/or 'Squard'. A Parent-Child configuration was set between the two. Which two statements are correct?

An implementation engineer has been provided with 4 different source files: 03m 16s 1. Twitter Ads 2. Creative Classification 3. Placement Classification 4, Campaign Category Classification The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it. The connections between the files are described as follows: 1st Party Creative Classification File structure/headers: Creative ID --- links back to Creative Key (Twitter Ads) 1st Party Placement Classification & File structure/headers: Category --- links back to Campaign Category (Twitter Ads) Which proposed solution meets the client's requirements for the above use case? A) B) C) D)

A client provides the following two data streams: Data Stream 1: Question- The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020. Which mapping options should the client apply to obtain the expected result? A) B) D)

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

A client has provided you with sample files of their data from the following data sources: 1.Google Analytics 2.Salesforce Marketing Cloud The link between these sources is on the following two fields: Message Send Key A portion of: web_site_source_key Below is the logic the client would like to have implemented in Datorama: For 'web site medium' values containing the word ''email'' (in all of its forms), the section after the ''_'' delimiter in 'web_site_source_key' is a 4 digit number, which matches the 'Message Send Key' values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in the following table: Google Analytics: Salesforce Marketing Cloud: The client's objective is to visualize the mutual key values alongside measurements from both files in a table. In order to achieve this, what steps should be taken?

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?

Question 31

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?

Custom classification

Data Classification

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

VLOOKUP in Data Stream C. Vlookup will return 'MB Name''

Show Answer Comment (0)

Question 32

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?

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

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.

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.

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

Show Answer Comment (0)

Question 33

What are unstable measurements?

Measurements for which Aggregation Settings are set as 'Auto' and Granularity is set as 'None'.

Measurements that are set with the LIFETIME aggregation function

Measurements for which Aggregation Settings are set as 'Not Auto' and Granularity is set as 'None'.

Measurements for which Aggregation Settings are set as 'Not Auto' and Granularity is set as 'Not Empty'.

Show Answer Comment (0)

Question 34

A client provides the following two data streams:

Data Stream 1:

Question-

The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020. Which mapping options should the client apply to obtain the expected result?

Option A

Option B

Option C

Option D

Show Answer Comment (0)

Question 35

What Is a disadvantage of using a Vlookup formula?

Can return values only from the same data stream type

It cannot be used more than once from the same data stream.

Could extend processing time of data streams.

It allows classifying data only on a basis of mutual entity keys.

Show Answer Comment (0)

Question 36

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?

An attribute of 'Meeting Code'

A custom metric and set aggregation to AUTO

A custom metric and set aggregation to SUM

A separate entity key

Show Answer Comment (0)

Question 37

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?

Option A

Option B

Option C

Option D

Show Answer Comment (0)

Question 38

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?

All fields are mapped except for the Media Buy Key.

All fields are mapped except for the Creative Name

All fields are mapped except for the Media Buy Name.

All fields are mapped except for the Campaign Key

Show Answer Comment (0)

Question 39

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?

All mapped Measurements for a given row have values equal to zero

Main entity is not mapped

The source file does not contain the media Buy entity

The file does not contain any measurements (dimension only)

Show Answer Comment (0)