NO.22 A customer provides a file containing only new and updated subscriber records exported from its marketing database.
* The file will be uploaded to the customer’s Enhanced FTP automatically at 3 a.m. daily.
* The customer requires that the import completes prior to 4 a.m.
* 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?

NO.23 Which statement IS correct regarding the automation tools in the Marketing Cloud?
Choose 3 answers

NO.24 Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, Is housed in a separate data extension than the one used for Journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the Journey source and transaction data extensions.
Which activity would they use to accomplish this?

NO.25 A retail company’s database of record resides at a 3rd-party company that also keeps track of purchase history.
That database only updates once a day where new records can be created and merged.
The database uses an “Email ID,” which is a numeric field that represents both the business unit and email address.
The company now wants to be able to send real-time Welcome emails to people (newly registered website users) who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to “Email ID” in the database.
What key issue should be addressed?
Choose 3 answers

NO.26 A customer would like to store financial data related to invoicing in its data extensions.
Which field type should be used?

NO.27 Northern Trail Outfitters sends a monthly loyalty balance email to inform members of their current points balance. Emails are segmented based on loyalty status, and no segment should contain more than 2500 contacts for any send.
What should be used to prevent emails from being sent if they exceed 2500 contacts7

NO.28 A financial company wants to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following:
* Payments.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.
* Payments.csv will be encrypted.
* Payments.csv will contain data from the previous week.
* Late payment notices will be sent each Monday at noon.
* They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send.
Which automation sequence represents a viable solution?

NO.29 Northern Trail Outfitters has determined they will initially deploy messaging to email and SMS channels, but also plan for social advertising. Customer data originates within their point-of-sale system which communicates to Marketing Cloud in real-time via API. They want to configure their customer data for long-term cleanliness and maintainability.
Which two best practices should be utilized? (Choose 2 answers)

NO.30 Northern Trail Outfitters has master data extension of 880,000 subscribers they want to randomly split into 11 groups to test different messaging strategies.
How could this be accomplished?

NO.31 Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way.
What should be recommended?

NO.32 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?

NO.33 A customer wants to perform an email send to a subset of a Synchronized Data Extension filtered on custom object data and return tracking to the Sales Cloud.
What approach should the consultant recommend?
Choose2 answers

NO.34 Northern Trail Outfitters receives data from their point-of-sale system every night. The file is placed on their Enhanced FTP, but there is not a consistent time or naming convention for the file.
In which two ways should they set up their automation to import the data from the file on a nightly bais?
(Choose 2 answers)

NO.35 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.36 Northern Trail Outfitters has acquired a new company and is importing customer data to Marketing Cloud. They want to ensure commercial emails are not sent to email addresses who have previously opted-out.
Which feature should they use?