Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ99

VerifiedScripting and Automation

Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Every business unit can access a Shared Data Extension named Inventory, which contains the details for each product. A Boolean field called InStock identifies whether an item is available.

Which AMPscript snippet returns all products that are currently available?

Explanation

LookupRows() retrieves all rows that match a specified column and value. Filtering InStock for true returns available products. A shared data extension stored at the parent Enterprise level must be referenced from a business unit with the ENT. prefix, so Ent.Inventory is required.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!