ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 41 - Certified Marketing Cloud Intelligence Accredited Professional discussion

Report
Export

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;

A.
Option #1 & Option #4
Answers
A.
Option #1 & Option #4
B.
Option #1 & Option #3
Answers
B.
Option #1 & Option #3
C.
Option #2 & Option #3
Answers
C.
Option #2 & Option #3
D.
Option #2 & Option #4
Answers
D.
Option #2 & Option #4
Suggested answer: A
asked 23/09/2024
GBEMISOLA OSILALU
25 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first