Certified Marketing Cloud ConsultantPreview

During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria:
✑ Customer data will be fully refreshed every night via Import File Activity from the customer's data warehouse.
✑ Contact records will be augmented by relational data tables via Contact Builder.
✑ Customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists?

Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales
Cloud have a status of failed.
What should the consultant do to diagnose the issue?

A consultant wants to trigger an email whenever the Status field on the Lead Object changes to Hot. Tracking data will need to be kept in the Sales Cloud.
Which three steps should the consultant use in the solution? (Choose three.)

Which three statements are correct regarding the automation tools in Marketing Cloud? (Choose three.)

Collect addresses through Smartcapture, segment the data, send emails referencing data from a data extension.
What skillset is needed?

Which three statements are correct about Data Designer? (Choose three.)

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?

Northern Trail Outfitters (NTO) account will be used for email communications with its clients and employees. They want to send from two different subdomains, so they have delegated e.nto.com as their SAP domain and mail.nto.com as an additional Private Domain.
Which statement describes how this will impact the account?

An online retailer would like to utilize Journey Builder interactions for sending post-purchase communications to their customers.
What Contact Entry mode best fits this scenario?

If I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out.
What is the issue causing less emails to go out?

An entertainment company is hosting events across the country in different venues. They want to use Contact Builder to feed Journey Builder. Contact who enter a journey will go through a decision split based on the type of event. The journey will send a series of emails and one of them will contain the venue details dynamically populated with AMP script. The Company collects the following information:

• Customer data (email address, first name, last name...).
• Event registration (email address, event ID, event name, event type, venue ID...).
• Venue details (venue ID, venue name, venue address...).
• Payment details (email address, event ID, total paid...).
  The Company does not want to link everything in Contact Builder.
  Which are the two data sources that must be incorporated inside Contact Builder? (Choose two.)

ABC Company has scenario of a journey for "post-purchasing communication".
Which re-entry setting is correct?

Northern Trail Outfitters (NTO) uses Marketing Cloud to connect with its individual consumers, retailers and wholesale buyers, and its corporate apparel customers. Marketing Cloud is currently configured with data extensions containing Store, Order, Product, and Contact information. NTO is in the process of implementing Data Designer and linking its data extensions.
How should consumers, retailers, and wholesale buyers be defined in Data Designer?

A customer is developing a new eCommerce section of their website and plans to leverage transactional data in customer journeys.
Which two Marketing Cloud features will support this effort? (Choose two.)

ABC Company wants to import files at certain standard times, but occasionally a file will be dropped on a Friday if the 30th of the month falls on a weekend.
What is the flow?

What is the capability of the Import within Contact Builder? (Choose two.)

A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account's Enhanced SFTP 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.
Which method should be used to automate their monthly promotional email?

A retail company's database of record resides at a third party company that also keeps track of purchase history. Their database only updates once a day where new records can be created and merged. The database uses the unique identified "Customer ID".
The company wants to send real-time Welcome emails to 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 "Customer ID" in the database.
What three key issues should be addressed? (Choose three.)

ABC Company needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks:
✑ Maintain ABC Company's master suppression list.
✑ Configure data relationships.
✑ Create new subscriber attributes.
Which role should be assigned to the IT staff member?

Northern Trail Outfitters wants to create a query to populate a data extension with email subscribers who belong to a specific Publication List.
Which Data View could they use to achieve this?

Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeroes, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

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?

A customer wants to import the previous 10 years of customer purchase data in their Marketing Cloud account. Through discovery, it is determined there are over
200 million records they plan to upload via the REST API, and this volume will continue to grow as the current purchase data is added.
Which two questions should be asked for further discovery? (Choose two.)

A marketer wants to create and edit email content, as well as generate reports and manage subscriber data.
Using the principle of least privilege, which two pre-defined roles should be assigned? (Choose two.)

A user in the MC wants to use Salesforce custom object data for segmenting and personalization.
How should the consultant approach this requirement?