Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named 'Inventory', which contains the details for each product. A Boolean field named 'InStock' indicates whether the item is available.
Which snippet of AMPscript would return all products which are currently available?

A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?

A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the performance? Choose 2

A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.
Which SELECT statement is optimal for returning all of the columns in the data extension?

Northern Trails Outfitters (NTO) has a sendable data extension with 1,500,000 contact records they want to delete.
Which step is required before deleting the contacts?