Northern Trail Outfitters Is building a data extension that will store preference data for the its subscribers.
Which settings should be enabled to allow a SQL Query Activity to update the data extension?

When receiving spam complaints from recent email sends, a marketer from Northern Trail Outfitters (NTO) identifies an email address that has consistently marked promotional email messages from WTO as spam.
What should me marketer do to prevent the subscriber from receiving further commercial messages?

Northern Trail Outfitters imports an encrypted file of its subscribers' favorite colors.
Which automation activity and configuration setting should be used for import to a data extension?

A marketing manager wants to import the Not Sent extract into a data extension to leverage as an exclusion audience.
Which steps should be configured within Automation Studio to accomplish this?

Within Datorama reports for Marketing Cloud, a marketer would like to create new set of report for the organization that are custom and not available within the perconfigured reports.
What should be created to achieve this?