Salesforce Certified Marketing Cloud Developer · Free Practice Question Medium
Question 5
A developer wants to retrieve all records in the OrderDetails data extension which are associated with a particular customer. Which two AMPscript functions would return a suitable rowset(Choose 2)?
- A LookupRows
- B LookupOrderedRows
- C Row
- D Lookup
Reveal correct answers
Correct answers: A, B
Explanation
A and B are the correct answers because they are the only AMPscript functions that can return a rowset (multiple rows) of data. A. LookupRows is used to retrieve multiple rows from a data extension based on a specific condition. In this case, the developer can use LookupRows to retrieve all records in the OrderDetails data extension associated with a particular customer. B. LookupOrderedRows is similar to LookupRows but allows the developer to specify the order in which the rows are retrieved. It can also be used to retrieve multiple rows based on a condition, making it suitable for this scenario as well. C. Row is an AMPscript function used to retrieve data from a single row in a data extension, so it cannot return a rowset. D. Lookup is used to retrieve a single value from a data extension, not a rowset. It is not suitable for retrieving all records associated with a particular customer.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
