Free Marketing Cloud Intelligence Accredited Professional Exam Marketing-Cloud-Intelligence Exam Practice Test

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

• Populate the logic within a custom measurement. No need to change Aggregation.
• 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 SUM.

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

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

Which three statements describe Overarching Entities? 03m 23s

• Once the data streams in which Custom Classification values were mapped are deleted, their data is deleted.
• Some overarching entities hold a Many-to-Many relationship with the main entity, and others hold a One-to-Many relationship with it.
• When needed, these entities can act as a main entity, replacing the original one.
• These are mappable dimensions that are present in each and every dataset type
• The values of these entities are stored at the workspace level, rather than the data stream level

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.

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? A)B)C)D)

• Option A
• Option B
• Option C
• Option D

Ina workspace that contains one hundred data streams and a lot of data, what is the biggest downside of using calculated dimensions?

• Performance
• Ease of setup
• Ease of maintenance
• Scalability

An implementation engineer has been asked by a client for assistance with the following problem: The below dataset was ingested: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.
• A mapping formula was populated, indicating not to bring Type! values.
• The aggregation function is set as AVG
• The aggregation function is set as LIFETIME

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.When harmonizing the Objective field from within the data stream mapping, which advantage is gained?

• Scalability
• Ease of Setup
• Performance (Performance when loading a dashboard page)
• Ease of Maintenance

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:The client performed the below standard mapping: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 KeyMedia Buy NameIn View ImpressionsThe final pivot is presented below:

• A Harmonized dimension was created via a pattern over the Creative Name.
• 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 Creative custom attribute.

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 2A 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?

• Registered
• Interest & Registered
• Confirmed Interest & Registered
• Interest
• Confirmed Interest