Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam - Topic 10 Question 52 Discussion

A client has integrated the following files:File A:File B:The client would like to link the two files in order to view the two KPIs ('Tasks Completed' and 'Tasks Assigned) alongside 'Employee Name' and/or'Squad'.The client set the following properties:+ File A is set as the Parent data stream* Both files were uploaded to a generic data stream type.* Override Media Buy Hierarchies is checked for file A.* The 'Data Updates Permissions' set for file B is 'Update Attributes and Hierarchy'.When filtering on the entire date range (1-30/8), and querying employee ID, Name and Squad with the two measurements - what will the result look like?A)B)C)D)
C) Option C
A) Option A
B) Option B
D) Option D

Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam - Topic 10 Question 52 Discussion

Actual exam question for Salesforce's Marketing Cloud Intelligence Accredited Professional (AP-215) exam
Question #: 52
Topic #: 10
[All Marketing Cloud Intelligence Accredited Professional (AP-215) Questions]

A client has integrated the following files:

File A:

File B:

The client would like to link the two files in order to view the two KPIs ('Tasks Completed' and 'Tasks Assigned) alongside 'Employee Name' and/or

'Squad'.

The client set the following properties:

+ File A is set as the Parent data stream

* Both files were uploaded to a generic data stream type.

* Override Media Buy Hierarchies is checked for file A.

* The 'Data Updates Permissions' set for file B is 'Update Attributes and Hierarchy'.

When filtering on the entire date range (1-30/8), and querying employee ID, Name and Squad with the two measurements - what will the result look like?

A)

B)

C)

D)

Show Suggested Answer Hide Answer
Suggested Answer: C

In Marketing Cloud Intelligence, when linking two data streams, the parent data stream (File A) provides the main structure. Since 'Override Media Buy Hierarchies' is checked for File A, the hierarchies from File B will be aligned with File A. Given 'Data Updates Permissions' set for file B as 'Update Attributes and Hierarchy', this means that attributes and hierarchy will be updated in the parent file based on the child file (File B), but the child file's metrics won't be associated with the parent file's date.

Hence, when filtering on the entire date range (1-30/8), the resulting view will align with the structure of the parent data stream, showing the KPIs ('Tasks Completed' from File A and 'Tasks Assigned' from File B) alongside the employee names and squads from the respective files. Since the employee IDs align, the data can be linked properly. However, since the dates do not align (File A data is from 01/08/2019 and File B from 15/08/2019), only attributes from File B will be updated without date association.

The result will look like Option C, where the employee names are corrected based on File B's data, the squads are added from File B, and the tasks_completed and tasks_assigned are displayed from their respective files. The tasks_assigned from File B are shown without date association as File B's date doesn't match with File A's.


Contribute your Thoughts:

0/2000 characters
Curtis
4 days ago
Totally agree, the hierarchy settings can really change the output!
upvoted 0 times
...
Lashawn
9 days ago
Wait, are we sure about the data updates permissions? Seems sketchy.
upvoted 0 times
...
Rosalyn
14 days ago
Not sure about that, I lean towards Option C.
upvoted 0 times
...
Frank
19 days ago
I think Option B looks right based on the KPIs.
upvoted 0 times
...
Aleisha
24 days ago
File A is the Parent data stream, so it should influence the results.
upvoted 0 times
...
Otis
30 days ago
I recall that filtering by date range is crucial, but I can't quite remember how it interacts with the attributes from both files.
upvoted 0 times
...
Rodolfo
1 month ago
I think if File A is the parent, we should see all employees listed, but I'm uncertain about how missing data in File B might impact the output.
upvoted 0 times
...
Mariann
1 month ago
This question feels similar to the practice one about linking data streams. I think the key is understanding how the KPIs are aggregated.
upvoted 0 times
...
Keshia
2 months ago
I remember we discussed how parent-child relationships work in data streams, but I'm not sure how the override setting affects the results.
upvoted 0 times
...

Save Cancel