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

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 Key
* Media Buy Name
* In View Impressions
The final pivot is presented below:

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?

Which two statements are correct regarding LiteConnect?

Your client has provided sample files 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
Which action(s) are needed to take place in order to meet the client's requirement and set Google DV360 as the source of truth for Cost?

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?

Your client would like to create a new harmonization field - Exam Topic.
The below table represents the harmonization logic from each source.

As can be seen from the table there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that where an Exam ID is found -a single Exam Topic value is associated with it.
The Client has a requirement to be able to view measurements from all data sources sliced by Exam Topic values as seen in the following example:

Which harmonization feature should an Implementation engineer use to meet the client's requirement?

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?