ExamGecko
Login
Ask Question

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

List of questions

Question 21

Report
Export
Collapse

An implementation engineer has been asked to perform a QA for a newly created harmonization field, Color, implemented by a client.

The source file that was ingested can be seen below:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 21 65711 09232024002818000000

The client performed the below standard mapping:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 21 65711 09232024002818000000

As a final step, the client had created the field 'Color'. As can be seen, it is extracted from the Creative Name (after the '#' sign).

For QA purposes, you have queried a pivot table, with the following fields:

* Media Buy Key

* Media Buy Name

* In View Impressions

The final pivot is presented below:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 21 65711 09232024002818000000

A Harmonized dimension was created via a pattern over the Creative Name.
A Harmonized dimension was created via a pattern over the Creative Name.
A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)
A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)
An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.
An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.
An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.
An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.
Suggested answer: D
asked 23/09/2024
Nipunika Jayasundara
36 questions

Question 22

Report
Export
Collapse

An implementation engineer has been asked by a client for assistance with the following problem:

The below dataset was ingested:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 22 65712 09232024002818000000

However, when performing QA and querying a pivot table with Campaign Category and Clicks, the value for Type' is 4.

What could be the reason for this discrepancy?

The measurement 'Clicks' is set as a percentage.
The measurement 'Clicks' is set as a percentage.
A mapping formula was populated, indicating not to bring Type! values.
A mapping formula was populated, indicating not to bring Type! values.
The aggregation function is set as AVG
The aggregation function is set as AVG
The aggregation function is set as LIFETIME
The aggregation function is set as LIFETIME
Suggested answer: C
asked 23/09/2024
Ronakkumar Shyani
47 questions

Question 23

Report
Export
Collapse

An implementation engineer has been provided with the below dataset:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 23 65713 09232024002818000000

*Note: CPC = Cost per Click

Formula: Cost / Clicks

Which action should an engineer take to successfully integrate CPC?

Populate the logic within a custom measurement. No need to change Aggregation.
Populate the logic within a custom measurement. No need to change Aggregation.
Unmap it, as Datorama will calculate it automatically.
Unmap it, as Datorama will calculate it automatically.
Populate the logic within a custom measurement. Set Aggregation to AVG.
Populate the logic within a custom measurement. Set Aggregation to AVG.
Populate the logic within a custom measurement. Set Aggregation to SUM.
Populate the logic within a custom measurement. Set Aggregation to SUM.
Suggested answer: A
asked 23/09/2024
Lionel Fitzgerald Gweth
44 questions

Question 24

Report
Export
Collapse

A client would like to integrate the following two sources:

Google Campaign Manager:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 24 65714 09232024002818000000

IAS:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 24 65714 09232024002818000000

After configuring a Parent-Child relationship between the files, which query should an implementation engineer run in order to QA the setup?

Media Buy Type, Media Buy Name, Impressions, Analyzed Impressions
Media Buy Type, Media Buy Name, Impressions, Analyzed Impressions
Creative Name, Impressions, Analyzed Impressions
Creative Name, Impressions, Analyzed Impressions
Media Buy Name, Impressions
Media Buy Name, Impressions
Media Buy Type, Analyzed Impressions
Media Buy Type, Analyzed Impressions
Suggested answer: A
asked 23/09/2024
Saikhantsetseg Donnelly
38 questions

Question 25

Report
Export
Collapse

A client has integrated the following files:

File A:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 25 65715 09232024002818000000

File B:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 25 65715 09232024002818000000

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 A is set as the Parent data stream

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

* Override Media Buy Hierarchies is checked for file

* 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)
* 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)
Option A
Option A
Option B
Option B
Option C
Option C
Option D
Option D
Suggested answer: B
asked 23/09/2024
Yedron Rojas Acosta
49 questions

Question 26

Report
Export
Collapse

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

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 26 65716 09232024002818000000

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?

4
4
0
0
1
1
3
3
Suggested answer: A
asked 23/09/2024
Sukhpreet Sidhu
40 questions

Question 27

Report
Export
Collapse

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

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 27 65717 09232024002818000000

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?

1
1
0
0
3
3
4
4
Suggested answer: D
asked 23/09/2024
Kaliannan K
33 questions

Question 28

Report
Export
Collapse

Your client is interested in ingesting the below file:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 28 65718 09232024002818000000

The client decided to upload the file to a new generic data stream type and map 'Date' to 'Day' and 'Number of Topics' to a generic custom metric.

In regards to the fields 'Meeting Code' and 'Meeting Name', your client is debating several options.

Which two options would you recommend in order to avoid data loss?

'Meeting Code' will be mapped to 'Main Generic Entity Key'. 'Meeting Name' will be mapped to 'Main Generic Entity custom attribute'.
'Meeting Code' will be mapped to 'Main Generic Entity Key'. 'Meeting Name' will be mapped to 'Main Generic Entity custom attribute'.
'Meeting Code' will be mapped to 'Main Generic Entity Key'. 'Meeting Name' will be mapped to 'Generic Entity 2 Key'.
'Meeting Code' will be mapped to 'Main Generic Entity Key'. 'Meeting Name' will be mapped to 'Generic Entity 2 Key'.
'Meeting Code' will be mapped to 'Main Generic Entity Attribute 1'. 'Meeting Name' will be mapped to 'Main Generic Entity Attribute 2'.
'Meeting Code' will be mapped to 'Main Generic Entity Attribute 1'. 'Meeting Name' will be mapped to 'Main Generic Entity Attribute 2'.
'Meeting Code' will be mapped to 'Main Generic Entity custom attribute'. 'Meeting Name' will be mapped to 'Generic Entity Key'
'Meeting Code' will be mapped to 'Main Generic Entity custom attribute'. 'Meeting Name' will be mapped to 'Generic Entity Key'
Concatenation of both 'Meeting Code' and 'Meeting Name' will be mapped to 'Main Generic Entity Key'. 'Meeting Code' will be mapped to 'Main Generic Entity Attribute 1'. 'Meeting Name' will be mapped to 'Main Generic Entity Attribute 2'.
Concatenation of both 'Meeting Code' and 'Meeting Name' will be mapped to 'Main Generic Entity Key'. 'Meeting Code' will be mapped to 'Main Generic Entity Attribute 1'. 'Meeting Name' will be mapped to 'Main Generic Entity Attribute 2'.
Suggested answer: A, E
asked 23/09/2024
Jason Kelley
34 questions

Question 29

Report
Export
Collapse

A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing insights and cross-channel marketing activity analysis. Below are details regarding the different data sources and the number of data streams required for each source.

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 29 65719 09232024002818000000

When harmonizing the Objective field from within the data stream mapping, which advantage is gained?

Scalability
Scalability
Ease of Setup
Ease of Setup
Performance (Performance when loading a dashboard page)
Performance (Performance when loading a dashboard page)
Ease of Maintenance
Ease of Maintenance
Suggested answer: A
asked 23/09/2024
justin staley
34 questions

Question 30

Report
Export
Collapse

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:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 30 65720 09232024002818000000

Which formula will return the desired values?

LEFT(EXTRACT(csy['campaign_name]],~',0),3)
LEFT(EXTRACT(csy['campaign_name]],~',0),3)
EXTRACT(csv[campaign_name!;@',1)
EXTRACT(csv[campaign_name!;@',1)
EXTRACT(csv[campaign_name'],---,0)
EXTRACT(csv[campaign_name'],---,0)
EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)
EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)
LEFT(EXTRACT(csv[campaign_name'}/---',1),3)
LEFT(EXTRACT(csv[campaign_name'}/---',1),3)
Suggested answer: B
asked 23/09/2024
MIGUEL PARADA VAZQUEZ
34 questions
Total 61 questions
Go to page: of 7
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
An Implementation engineer is requested to create a new harmonization field 'Offer' and apply the following logic: The implementation engineer to use the Harmonization Center. Which of the below actions can help implement the new dimension 'Offer?
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?
Client has provided sample flies of their data from the following data sources: Google Campaign Manager Below are the requirements from the client and additional information: * The sources are linked to each other by shared Media Buy names. * 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. * The source of truth for cost is Google DV360. As a first step, a Parent-Child relationship was created between the two files, and the following mapping was performed, within both data streams: Please note: * All other measurements were mapped as well to the appropriate fields. * No other mapping manipulations or formulas were implemented. How many records will the merged table hold?
A client's data consists of three data streams as follows: * 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. Which data stream should be set as a parent?
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?
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?
Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence's data model?
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?
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?