Salesforce Certified- Marketing Cloud Consultant

Marketing Cloud user needs the email addresses of everyone who unsubscribed from a particular email send. This user does not know SQL and does not have access to the enhanced FTP account. What functionality should be used to retrieve the necessary data?

A customer needs to import data from an SFTP site. The customer wants to:
Segment the contents of the file and then send emails.
Transfer the file to the SFTP site at various times daily.
Send to data extensions.
Which workflow should meet these requirements?

A customer wants to create a journey with the goal of making users activate their accounts within 72 h of registration. New account registrations are stored in a data extension via an API call with a Boolean field indicating whether the subscriber has activated their account. The journey should send activation reminder emails 24 and 48 h after creating an account. The user exits the journey if they activate their account. Which activities should be included in the customer's journey?

A consultant is configuring Marketing Cloud Connect in Marketing Cloud. The customer requires that integrated users only have access to Sales Cloud data visible to them in their Salesforce account. How would the consultant ensure that this requirement is met?

A customer provides a file containing only new and updated subscriber records exported from its marketing database. The file will be uploaded to the customers Enhanced FTP automatically at 3AM daily. The customer requires that the import completes prior to 4AM. On average, the file will contain about two million rows of data each day. Based on the customer's requirements and recommended best practices, how should the daily file be imported?

A customer wants to integrate their website with Marketing Cloud so that users can update their marketing communication preferences. The customer has in-house web development resources available and is interested in leveraging tools such as Journey Builder in the future. What solution should the consultant propose, given the customer's requirements and available resources?

A customer has several values that need to be used in the body of an email send:
The data would be stored in a reference data extension, related on SubscriberKey.
There may be one or more records for each subscriber.
The audience is generally over 1 million subscribers.
The content is time sensitive and should be sent as quickly as possible.
The customer is not using Catch and release sending.
The reference data extension contains 25 columns.
What method should be used?

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity. The list is:
Compiled in a database in the website Content Management System (CMS).
Imported into Marketing Cloud nightly at 11 p.m.
What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. The customer has indicated the following:
Emails will be built using a custom dynamic template for these messages.
Links will vary over time and across campaigns.
Click activity will be cross-referenced with subscribers regional markets on a master subscriber data extension.
Retargeting messages will dynamically populate content based on regional market.
In order for this solution to be viable, which skill set does the customer team need to possess?

A financial services customer states that families often share email addresses across multiple checking, savings, loan, and credit accounts. The customer needs to allow individual accounts to use the same email address in Marketing Cloud but maintain separate subscriber attributes. Which component should be discussed with the customer to allow for this use case?