Salesforce Certified Marketing Cloud Developer (SP25) Marketing-Cloud-Developer Question # 7 Topic 1 Discussion

Salesforce Certified Marketing Cloud Developer (SP25) Marketing-Cloud-Developer Question # 7 Topic 1 Discussion

Marketing-Cloud-Developer Exam Topic 1 Question 7 Discussion:
Question #: 7
Topic #: 1

A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specificdata; however, the SQL they have written does not return any records. Below is the SQL statement:

Marketing-Cloud-Developer Question 7

What updates should be made to ensure this SQL statement returns the desired results?


A.

Marketing Cloud does not allow DateAdd functions in QueryActivities. They should define a specific date.


B.

Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.


C.

Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.


D.

Marketing Cloud does not allow use of GETDATE function. They should define a specific date.


Get Premium Marketing-Cloud-Developer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.