Salesforce Certified Marketing Cloud Consultant — Question 47

Northern Trail Outfitters wants to send an email to website visitors who add items to their cart but fail to make a purchase. The email will include a list of products they added to their shopping cart.
✑ A sendable data extension contains the contact information and a session ID field for each subscriber who has abandoned their cart.
✑ A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL.
Which feature should be used to display the list of products for each subscriber in this email?

Answer options

• A. Enhanced Dynamic Content Block
• B. Lookup AMPscript function
• C. LookupRows AMPscript function
• D. Dynamic Content Block

Correct answer: C

Explanation

The correct answer is C, as the LookupRows AMPscript function allows you to retrieve multiple records from a data extension based on a specified criteria, which is ideal for pulling the list of products for each subscriber. Options A and D do not retrieve multiple rows of data, and B only retrieves a single record, making them unsuitable for this scenario.