Marketing-Cloud-Intelligence Exam Dumps : Marketing Cloud Intelligence Accredited Professional (AP-215)

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;

Client has provided sample flies 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.

As a first step, a Parent-Child relationship was created between the two files, and the following mapping was performed, within both data streams:

Please note:

• All other measurements were mapped as well to the appropriate fields.

• No other mapping manipulations or formulas were implemented.

How many records will the merged table hold?

A client's data consists of three data streams as follows:

Data Stream A: