Explanation
To send an email confirming opt-in when someone signs up for their emails via a form on their website, a triggered send data extension can be used to capture the form data and deploy the email. The triggered send data extension can be linked to a triggered send definition that contains the email creative and settings. The developer can use the SOAP or REST API to trigger the email from the website form, and the marketing team can change the email creative without involving the developer. References:
https://help.salesforce.com/s/articleView?id=sf.mc_es_triggered_sends.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.mc_es_create_triggered_send_data_extension.htm&type=5

Explanation
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:
https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-co

Explanation
Creating and enabling a BLOCKOUT window in MobileConnect can be used to prevent SMS messages from being sent during certain hours of the day. A BLOCKOUT window is a time period during which no messages are sent or received by MobileConnect, regardless of when they were scheduled or triggered. References:
https://help.salesforce.com/articleView?id=sf.mc_moc_blockout_window.htm&type=5

Explanation
To capture open-ended feedback from customers via SMS and write it to a data extension, Northern Trail Outfitters should use a text-response message template with embedded AMPscript to capture the response. A text-response message template is a template that allows marketers to send a text message to a mobile number and receive a reply. AMPscript is a scripting language that allows marketers to perform complex tasks within messages, such as inserting data into a data extension. References:
https://help.salesforce.com/s/articleView?id=sf.mc_moc_text_response.htm&type=5
https://help.salesforce.com/s/articleView?id=sf.mc_es_ampscript_overview.htm&type=5

Explanation
A limitation that the consultant should consider when recommending Field-Level Encryption is that Field-Level Encryption doesn't support segmenting, filtering, or querying encrypted fields. Field-Level Encryption is a feature that allows marketers to encrypt sensitive data in Marketing Cloud using encryption keys and algorithms. However, encrypted fields cannot be used for segmenting subscribers using filters or queries, as they cannot be evaluated or compared with other values. References:
https://help.salesforce.com/s/articleView?id=sf.mc_overview_field_level_encryption.htm&type=5