ExamGecko
Login
Ask Question

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

Add to Whishlist

List of questions

Question 31

Report Export Collapse

A client provides the following three files:

File A:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 31 65721 09232024002818000000

File B:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 31 65721 09232024002818000000

File C:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 31 65721 09232024002818000000

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:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 31 65721 09232024002818000000

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

Become a Premium Member for full access
  Unlock Premium Member

Question 32

Report Export Collapse

Your client provided the following sources:

Source 1:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 32 65722 09232024002818000000

Source 2:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 32 65722 09232024002818000000

Source 3:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 32 65722 09232024002818000000

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:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 32 65722 09232024002818000000

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

Become a Premium Member for full access
  Unlock Premium Member

Question 33

Report Export Collapse

What are unstable measurements?

Become a Premium Member for full access
  Unlock Premium Member

Question 34

Report Export Collapse

A client provides the following two data streams:

Data Stream 1:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 34 65724 09232024002818000000

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)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 34 65724 09232024002818000000

B)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 34 65724 09232024002818000000

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 34 65724 09232024002818000000

D)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 34 65724 09232024002818000000

Become a Premium Member for full access
  Unlock Premium Member

Question 35

Report Export Collapse

What Is a disadvantage of using a Vlookup formula?

Become a Premium Member for full access
  Unlock Premium Member

Question 36

Report Export Collapse

Your client is interested in ingested the below file to a new generic data stream type:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 36 65726 09232024002818000000

The field 'Meeting Code' was mapped to the main entity key. 'How should the 'Room Number' be mapped?

Become a Premium Member for full access
  Unlock Premium Member

Question 37

Report Export Collapse

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:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 37 65727 09232024002818000000

From looking at the table, what are the aggregation settings for each one of the newly created KPIs?

A)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 37 65727 09232024002818000000

B)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 37 65727 09232024002818000000

C)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 37 65727 09232024002818000000

D)

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 37 65727 09232024002818000000

Become a Premium Member for full access
  Unlock Premium Member

Question 38

Report Export Collapse

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:

Salesforce Certified Marketing Cloud Intelligence Accredited Professional image Question 38 65728 09232024002818000000

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

Become a Premium Member for full access
  Unlock Premium Member

Question 39

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 40

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member
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?