NO.24 The customer has the following requirements for storing engagement data in their data warehouse:
*All email open and click activity must be pulled daily from Marketing Cloud.
*Output files must meet the specific requirements for the data warehouse.
*All the activity must be provided via SFTP in one file.
Which automation workflow meets the customer requirements?

NO.25 A customer has a robust Sales Cloud org with several custom objects. Historically, they have created complex reports, referencing many custom objects, to target subscribers and exported them to another email system for deployment. With the implementation of Marketing Cloud Connect, the customer wants to simplify the sending process using Marketing Cloud with as little additional setup as possible.
What should a consultant recommend to meet this criteria?

NO.26 Northern Trail Outfitters wants to implement a Welcome email. New subscribers signing up on their website should receive the email promptly. They are utilizing Marketing Cloud Connect to connect Sales Cloud and Marketing Cloud.
Which solution should capture the new subscribers?

NO.27 A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails.
What should a consultant recommend’

NO.28 What is a correct statement about Send Log data?
Choose 3 answers

NO.29 A marketer wants to capture open-ended feedback from customers via SMS and write it to a data extension.
How could MobileConnect be used to accomplish this?

NO.30 Northern Trail Outfitters sends emails for Password Resets from their web store when requested. An SMS message should be deployed if the password reset email is not sent.
What processes should they utilize to ensure a timely delivery across email and SMS?

NO.31 Northern Trail Outfitters wants to send special discount offer to engaged customers on their email list.
What should be resolved prior to generating the audience?

NO.32 Northern Trail Outfitters (NTO) wants to use Case data from Service Cloud as part of their current email messaging campaign. They want to import cases that indicate the customer wants someone to contact them after the case is closed. NTO tracks cases with a checkbox field called “Contact Me”.

NO.33 An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal object due to the nature of their messages.
What method should be suggested in this scenario?

NO.34 Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber’s account representative without segmenting the audience by sales representative.
In which two ways could this distributor-specific sender profile be configured in a Marketing Cloud account with Sender Authentication Package implemented?
Choose 2 answers

NO.35 Northern Trail Outfitters upgraded their Marketing Cloud account which now includes a Sender Authentication Package (SAP), They send regularly 300,000
What should they be aware of with respect to sender reputation?

NO.36 A customer has an email newsletter to send out, but wants to deliver it with a targeted message for customers within a specified age range. These data have been defined in attributes from a sign-up landing page.
How should the customer individualize the email content?

NO.37 A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account’s Enhanced FTP on a monthly basis on the 15th day of each month, expecting the email to be deployed upon completion of the import activity. However, if the 15th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15th and expect the promotional email to be sent on that Friday.
Given the customer’s requirements, which method should be used to automate their monthly promotional email?

NO.38 A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits.
What should the consultant suggest to minimise the impact of Marketing Cloud Connect on daily API limits? Choose 2

NO.39 Northern Trail Outfitters (NTO) wants to implement a drip campaign to its highest-value outdoor sports customers. NTO is including a deep product discount and wants to limit the audience to not only its best customers, but also those customers most likely to respond.
Which three criteria should they use to create an audience for this campaign? Choose 3 answers

NO.40 A 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?

NO.41 A customer wants to integrate a new dataset with pre-existing contacts. This data will be updated via separate data feeds from the main contact information.
What data model configuration should be recommended’