Salesforce Related Exams
Marketing-Cloud-Intelligence Exam
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:

The client suggested to create, without any mapping manipulations, several patterns via the harmonization center that will generate two
Harmonized Dimensions:
Exam ID
Exam Topic
Given the above information, which statement is correct regarding the ability to implement this request with the above suggestion?
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 client's data consists of three data streams as follows:
Data Stream A:

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.
The client would like to have a "Site Revenue" measurement.
This measurement should return the highest revenue value per Site, for example:
For Site Key ‘SK_C_2’, the "Site Revenue" should be $7.00.
When aggregated by date, the "Site Revenue" measurement should return the total sum of the results of all sites.
For example:
For the date 1 Apr 2020, "Site Revenue" should be $11.00 (sum of Site Revenue for Site Keys ‘SK_C_1' ($4.00) and ‘SK_C_2’ ($7.00))

Which options will yield the desired result;