A new record is appendedto the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.
Which two file encryption options are supported when importing data files to Marketing Cloud?
Choose 2 answers

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a dataextension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to becreated in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = 'NY' AND US = 1
What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?

A developer needs to know how many records are contained in a particular data extension. This will dictate what is displayed on a landing page.
Which AMPscript functionreturns the number of rows in a specified data extension?