Salesforce Marketing-Cloud-Consultant Exam With Confidence Using Practice Dumps

A query activity is an automation studio activity that allows querying data from data extensions or data views using SQL statements. A data extension entry source is a journey builder entry source that allows injecting contacts into a journey based on a data extension. Journey activities are actions that occur within a journey, such as sending an email or updating a contact attribute. By using a query activity to filter contacts who have not made a purchase in the last six months from their order data extension, NTO can create a sendable data extension with those contacts and use it as a data extension entry source for their journey. Then, by using journey activities, they can communicate the same message across all channels to those contacts. References: &type=5 &type=5 &type=5

The LookupRows AMPscript function returns a rowset from a data extension that matches the specified criteria. It can be used to retrieve multiple rows of data from a data extension based on one or more column values. For example, NTO can use the LookupRows function to retrieve all rows from the second data extension that have the same session ID as the subscriber in the sendable data extension, and then loop through the rowset to display the product data for each abandoned cart item in the email. References: content.meta/mc-programmatic-content/lookuprows.htm

To choose a subscriber key for Marketing Cloud, Northern Trail Outfitters should use a value that is unique, persistent, and channel-agnostic. A CRM ID or a loyalty program number are both good options, as they meet these criteria and can be used to identify and track subscribers across different channels and platforms. Email and mobile device ID are not good options, as they are not unique or persistent (subscribers can change their email or device) and they are specific to one channel (email or mobile). References: &type=5