Salesforce Marketing Cloud Intelligence Accredited Professional - Marketing-Cloud-Intelligence Exam Questions

QUESTION NO: 1
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?

QUESTION NO: 2
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.

Which three advantages does a client gain from using Calculated Dimensions as the harmonization method for creating the Objective field?

QUESTION NO: 3
Which three statements accurately describe the different data stream types in Marketing Cloud intelligence?

QUESTION NO: 4
Your client is interested in ingesting the below file:

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?

QUESTION NO: 5
What Is a disadvantage of using a Vlookup formula?

QUESTION NO: 6
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?

QUESTION NO: 7
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?