Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam - Topic 11 Question 45 Discussion

Actual exam question for Salesforce's Marketing Cloud Intelligence Accredited Professional (AP-215) exam

Question #: 45
Topic #: 11

[All Marketing Cloud Intelligence Accredited Professional (AP-215) Questions]

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?

DDepends on the Data Updates Permissions

Show Suggested Answer

Suggested Answer: A

Since the data sources are linked by shared Media Buy names and all other measurements are mapped to appropriate fields without additional manipulations, each unique Media Buy Name from Google DV360 will pair with its corresponding Media Buy Name in Google Campaign Manager. The number of records in the merged table will equal the number of unique Media Buy Names in Google DV360, provided there is a matching name in Google Campaign Manager. The sample shows 4 unique Media Buy Names in Google DV360, thus resulting in 4 records.

by Dustin at Jan 28, 2026, 10:36 AM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Intelligence Accredited Professional (AP-215) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Matilda

5 days ago

The merged table will hold the total records from both sources.

upvoted 0 times

...

Silvana

10 days ago

Haha, I bet the client is going to be surprised when they see the final merged table. Hopefully, it's not a huge mess!

upvoted 0 times

...

Vanda

15 days ago

I think the number of records will depend on how many unique Media Buy names there are across the two sources. The question says they are linked by shared Media Buy names.

upvoted 0 times

...

Truman

20 days ago

Hmm, I'm not sure about that. Shouldn't the number of records be the sum of the unique records from both sources?

upvoted 0 times

...

Alida

25 days ago

42 records

upvoted 0 times

...

Kristal

1 month ago

I recall something about how mapping fields can influence the final record count, but I’m not confident about the specifics in this case.

upvoted 0 times

...

Hollis

1 month ago

I feel like we discussed that the source of truth for cost being Google DV360 might not change the record count, but I could be wrong.

upvoted 0 times

...

Ammie

2 months ago

I think the merged table will hold the total number of records from both sources, but I’m not clear on how the shared Media Buy names impact that.

upvoted 0 times

...

Delbert

2 months ago

I remember we practiced a similar question about merging datasets, but I’m not sure how the Parent-Child relationship affects the record count.

upvoted 0 times

...

Glory

2 months ago

The client's requirements seem straightforward, but I want to double-check my understanding before I start crunching the numbers. I'll make sure I have a clear picture of how the data sources are connected.

upvoted 0 times

...

Sharen

2 months ago

This looks like a good opportunity to practice my data integration skills. I'll need to carefully consider the requirements and make sure I'm not missing any edge cases.

upvoted 0 times

...

Emmett

3 months ago

Okay, so we've got the parent-child relationship established and the initial mapping done. Now we just need to figure out how many records the merged table will hold. I think I can work this out step-by-step.

upvoted 0 times

...

Ruth

3 months ago

Hmm, I'm a bit confused about the requirement to use the campaign/site values from Google CM instead of DV360. I'll need to think through how to implement that properly.

upvoted 0 times

...

Lauryn

3 months ago

This seems like a straightforward data integration problem. I'd start by understanding the relationship between the two data sources and how they're linked through the Media Buy names.

upvoted 0 times

...