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

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

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 statusGiven 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 MetricA 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?

• 1
• 3
• 2

A client has provided you with sample files of their data from the following data sources:1.Google Analytics 2.Salesforce Marketing CloudThe link between these sources is on the following two fields:Message Send KeyA portion of: web_site_source_keyBelow 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 digitnumber, 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?

• Within both files, map the desired value to Custom Classification Key as follows Salesforce Marketing Cloud: map entire Message Key to Custom Classification Key. Google Analytics: map the extraction logic to Custom Classification Key.
• Create a Web Analytics Site custom attribute and populate it with the extraction logic. Create a Data Fusion between the newly created attribute and the Message Send Key.
• Upload the two files and create a Parent-Child relationship between them. The Override Media Buy Hierarchy checkbox is checked in Google Analytics.
• Create a Web Analytics Site Source custom attribute and populate it with the extraction logic. Create a Data Fusion between the newly created attribute and the Message Send Key.

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

What is the relationship between "Media Buy Key" and "Creative Key?

• One-to-many (one Media Buy ley has many Creative Key)
• One-to-one
• Many-to-many
• Many-to-one (one Creative Key has many Media Buy Keys)

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

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

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”

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

Which two statements are correct regarding the Parent-Child configuration?

• Parent-Child configurations can cause performances issues
• A Parent-Child cannot be configured between an Ads data stream type and a Conversion Tag one.
• Parent-Child links different tables based on shared key values
• Parent-Child allows sharing both dimensions and measurements

Which two statements are correct regarding LiteConnect?

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