|Northern Trail outfitters (NTO) needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks: Maintain NTO’s master suppression list Configure data relationships Create new subscriber attributes What role should be assigned to the IT staff member? Data Manager Analyst Content Creator Administrator .
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. What component should be discussed with the customer to allow for this use case? Data extensions Subscriber Key Contact ID Member Record .
A customer wants to send an email from Sales Cloud on behalf of the record owner. In which two ways should the consultant meet this requirement? Choose 2 answers. use a custom Delivery Profile Use a custom Send Classification Use the Organization-Wide Email address Use the “Send From Record Owner” option.
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 should this distributor-specific sender profile be configured in the Marketing Cloud? Choose 2 answers Match the external keys of the sender profile and data extension containing account representative details. Utilize data extension AMPscript lookups to dynamically populate the From Name and From Email values Use substitution strings to populate the From Name and From Email values in the sender profile Pick “Choose from list,” selecting the From Name and From Email values from the list of account users.
A user in Marketing Cloud needs to send an email to a Salesforce Report via a Guided send process. How should the consultant meet this requirement?
Create a Salesforce Data Extension for the user to select during a Guided Send. Create data validation rules for the integrated user in Sales Cloud. Add custom VisualForce page to the age layouts in Marketing Cloud. Assign the integrated user the Marketing Cloud AppExchange User permission set in Sales Cloud. .
A customer wants to automate the process of sending a series of welcome emails based on the subscriber’s data. Emails should be sent weekly for up to five weeks. If a subscriber makes a purchase, they should stop receiving welcome emails. A Boolean flag should be set in the data extension if the subscriber makes it through the welcome series. Which should be used to accomplish this in Journey Builder Random Split, send Email, Wait, Define Goal Update Contact Data, Wait, Send Email, Join Define Goal, Update Contact Data, Send Email, Wait Define Goal, Send Email, Wait, Decision Split. .
The Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting. These metrics need to be reported per email campaign for each of NTO’s Business Units:
Number of Sends
Overall Bounce Rate
Block Bounce Rate
What email report should NTO’s Marketing Analyst pull from Marketing Cloud to get the information? Email Send Report Campaign Email Tracking Report Account Send Summary Report Email Performance Over Time Report .
Northern Trail Outfitters (NTO) has doubled in size over the last couple of years. Because of this growth they have decided to organize their company into Business Units to better manage operation. Which two statements are correct regarding the Business Unit functionality within Marketing Cloud? Choose 2 answers Business Units can have more than one parent Business Unit. Subscribers can only appear in one Business Unit. Business Units can mirror an organization’s operational structure. Business Units can share information with other Business Units. .
Which two statements are correct regarding Attribute Groups? Choose 2 answers They link data extensions to contacts. They link subscriber lists to contacts. They link data extensions to subscriber lists. They link data extensions to other data extensions. .
A customer would like to send a quarterly reengagement email to subscribers who have not opened in the previous three months. The customer’s plans are to:
Use an existing Paste HTML email for the first send.
Make only minor changes to the email creative for future sends.
Use an existing Measure to build the subscriber audience for current and future sends. Deploy emails manually for now, but possibly automate in the future.
Which send method is recommended for the re-engagement Triggered Send Send Email Activity Guided Send Send Flow Activity.
A customer has several values that need to be used in the body of an email send:
The data should 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 burst sending
The reference data extension contains 25 columns.
What method should be used?
A retail company does business in both the United States and Canada. They also have a loyalty program in which a customer can enroll. The company will provide a presegmented customer file, per campaign, which has a “Version” data field indicating the type of email the customer is to revive. Which two questions should be asked to determine a data/segmentation strategy? Choose 2 answers Will a lookup table be needed for a dynamic “From Name”? Will “Version” values/meanings change, precluding reusable AMPscript? Is the purpose of these emails for acquisition or retention or transactional? Will customers be able to sign up for the loyalty program at the store?.
A publishing company has presented the following: A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days. A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical. The customer’s expiration date is included in the data file. Which three components should the customer’s solution include? Choose 3 answers Triggered Send Template-based emails Automation Studio Data Filter Suppression list .
Northern Trail Outfitters (NTO) is considering adopting Attribute Groups when incorporating data from their external systems. Which two statements are accurate regarding Attribute Groups? Choose 2 answers They can contain only one data extension They can be created by templates to accomplish certain tasks. They replicate the structure from the external system data into templates. They link data extensions to other data extensions or contacts.
Which three statements about Send Log data are correct? Choose 3 answers Can be added to a standard data view. Can be accessed via SQL Query Activities. Can be included in measures and filters Can be stored for a set period of time. Can be incorporated into standard reports.
Which three statements are correct regarding the automation tools in Marketing Cloud? Choose 3 answers Automation Studio allows users to inject Contacts from a data extension into an interaction in Journey Builder. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool. Automation Studio and Journey Builder allow users to define a wait activity based on duration or duration + time. Journey Builder allows users to update a contact record in an interaction or import data into a data extension.
What are two capabilities of the Import within Contact Builder? Choose 2 answers The target destination can be a data extension, list, or All Contacts for Mobile Push or Connect The data source can be a local file, data filter, or file on any FTP. In order to user Map by Header Row, the fields in the data extension and file must match exactly. Like the Import Wizard, the Contact Builder import definition can be executed without saving.
Which three reasons would cause a contact to fail to enter a Journey Builder interaction? Choose 3 answers The entry event was not fired via Automation Studio The interaction has an A/B/n split, and the contact does not meet the criteria. The contact falls below the High Water Mark. The interaction allows re-entry only after exiting, and the contact already exists. The Contact did not meet the entry criteria. .
Which data object should be used in conjunction with data extensions to create an opt-down strategy for customers? Publication Lists Preference attributes Profile attributes Preference Lists .
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 context based on regional market.
In order for this solution to be viable, what skill set does the customer team need to possess? SQL HTML SSJS AMPscript .
Northern Trail outfitters (NTO) is launching a new campaign, driving them to redesign their data structure. NTO needs to change the cardinality between two data extensions inside Contact Builder. What are two consequences of this change? Choose 2 answers All filters created before will adapt automatically to the new cardinality. All scheduled sends using a filter based on one of the data extensions should be reviewed. One of the data extensions must be deleted from the attribute group in order to change the cardinality. A contact may not show up in the filter based on one of the data extensions.
To fuel their expansion, Northern Trail Outfitters (NTO) recently acquired Eagle Outfitters (EO). There is currently a 30 percent overlap between the guests of each brand and they will be pursuing cross-marketing opportunities. It was recommended that their Marketing Cloud account now include a separate business unit for EO and the company secure a new sender authentication package for EO using the private domain eEO.com. which two statements correctly describe the implication of their recommendation? Choose 2 answers The private domain, e-EO.com, will be used for all link wrapping, image URLs, and landing page URLs. The email headers for EO will still reflect the private domain for NTO since that is the parent company. The EO business unit can also have the NTO authentication package applied simultaneously for cross-marketing emails. The e-EO.com domain will act as the From Address for the emails and authenticate using SPF, SenderID, and DKIM authentication. .
A retail company needs to create journeys that will target subscribers based on website behavior. They have identified three separate groups:
Customers who searched for an item on their website.
Customers who abandoned a cart on their website.
Customers who made a purchase on their website.
Which three questions should the consultant ask in order to design the data structure for this solution? Choose 3 answers How are subscribers identified in your web analytics? Should a single customer exist in multiple journeys at the same time? How long after the behavior occurs will a subscriber need to enter a journey? How many messages should be included in each journey? Should customers exit the journey when the goal is met? .
An online retail customer needs daily promotional email context to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose. The customer has communicated the following:
The email content will highlight new inventory each day.
A small team will run both their digital marketing operations and their email program.
A user needs to build, test, and send a daily email in less than an hour.
Images for the emails will be hosted on their website CMS.
Which three questions are relevant to identify strategies for designing the custom template for the customer’s daily promotional email? Choose 3 answers What is the maximum file size of the images being used? How often will email content be image-only with text overlaying images? Will image URLs be available publicly? How often will the layout of the content in a content area change?.
As part of their brand guidelines, Northern Trail Outfitters (NTO) uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well. What is the recommended best practice for font usage in email? Edit an email’s HTML to list the custom brand font in the style tag’s font-family property. Use a web-safe font that most closely matches the brand’s custom font for live text. Build an email using multiple images, with all text saved in the brand font. Build an email as on image, with all text saved in the brand font. .
An existing triggered send needs to be updated with new content. Select the correct sequence. Archive Current Message interation – Edit message content -- Restart triggered Email interaction Open Send Definition -- Edit Message Content -- Publish Changes Copy Send Definition -- Select updated Content -- Archive Original Definition - Start New Definition Pause Message Interaction -- Edit Message Content -- Publish Changes -- Restart Triggered Email interaction.
A subscriber asked to be removed from a customer’s email list multiple times by replying directly to the customer’s marketing message, but continues to receive emails. Which three steps will solve how replies are managed by the application? Choose 3 answers Confirm that Reply Mail Management (RMM) is configures for the customer’s account Confirm that the subscriber’s request contained on eof the standard terms that qualify for automatic unsubscribe. Confirm that the RMM setting ‘Delete auto-replies and out-of-office replies’ is set to NO. Confirm that an email address was provided as the Routing Address for Remaining Replies. Confirm that the RMM setting ‘Unsubscribe Manual Requests’ is set to YES. .
A retail company’s database of record resides at a third 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. Which three key issues should be addressed? Choose 3 answers What publication lists will be used? What will be used as Subscriber Key? Will new users have an “Email ID”? How will Marketing Cloud and the database sync up? Will the company need a custom preference center? .
A customer is interested in designing a solution to ensure that subscribers only receive categories of emails that they want to receive. The built-in subscription center will be use as part of the solution. What feature should be utilized to make this happen? Send Logging. Profile Center Publication Lists Subscriber Keys. .
Which three statements are correct about Data Designer? Choose 3 answers Data extensions can be linked to either the contact record or different data extensions, including data extensions from other attribute groups. Each attribute group can contain multiple lists, and each list can include multiple attributes Data extensions should be linked directly to the contact record prior to being linked to different data extensions. Each attribute group can contain multiple data extensions, and each data extension can include multiple attributes. Each attribute group contains one data extension, and each data extension can include up to 50 attributes.
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 AM daily. The customer required that the import completes prior to 4AM.
On average, the file will contain about 2 million rows of data each day.
Based on the customer’s requirements and recommended best practices, how should the daily file be imported Import the file to a data extension, using the ‘add and update’ method. Import the file to a list, using the ‘add and update’ method. Import the file to a list, using the ‘update only’ method. Import the file to a data extension, using the ‘overwrite’ method. .
what are two ways Contact Builder can be used to affect data stored on a data extension? Choose 2 answers Export data from a data extension to any FTP location. Reconcile contact data on multiple Contact IDs. Add a single record to a data extension. Clear the data from the data extension.https://mc.exacttarget.com/cloud/#app/Contact%20Builder .
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? Configure a relational data structure using Data Extensions and leverage a SmartCapture form that is hosted in Landing Pages. Configure a relational data structure using Lists and leverage the out-of-the box Preference Centre. Configure a relational data structure using Data Extensions and consult with the customer on API integration with their website Configure a data structure using Lists and leverage a SmartCapture form that the client can iFrame into their website.
A customer wants to create a journey in Journey Builder with the goal of making users activate their accounts within 72 hours 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 hours and 48 hours after creating an account.
Which sequence of activities should be used for the customer’s journey? 24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email Decision Split >24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email Decision Split >24 hour Wait > Send Email > Decision Split > 48 hour Wait > Send Emai 24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email.
Which two statements about a database of record are correct? Choose 2 answers A database of record is any database containing subscriber data. A database of record is a system in which a subscriber’s status is maintained. A database of record is a centralized storage repository of data about objects or people. A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber.
A daily deal website is concerned with their sender reputation and needs consistent visibility into subscribers who report their email as spam. How should they determine which subscribers reported their email as spam so they can flag those records in their customer service database An automation that generates the Complaint Tracking Extract. An automation that queries the Unsubscribe data view. An automation that generates the Unsubscribe Event Extract. An automation that queries the Complaint data view. .
A company collects subscriptions on its website. It does the following:
Complies that subscription list in a database in the website Content Management System (CMS)
Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
Uses Marketing Cloud as the database of record.
Sends up to five emails a week based on a subscriber engagement with prior sends.
What automation sequence (excluding waits) should cover these requirements? File Transfer > Data Extract > Filters > Send Email File Transfer > Import File > Measures > Send Email File Transfer > Import File > SQL Query > Send Email File Transfer > SQL Query > Measures > Send Email .
A customer wants to link web analytics data to subscriber data. How should this be set up in Data Designer? Link to the Marketing Cloud API Link to the Web Analytics SFTP Link to Marketing cloud data extensions Link to the Web Analytics Provider API .
A customer has three data extensions that need to be added to Contact Builder.
Customers contains customer information
Orders contains order information
Products contains product information
How should these data extensions be linked within an Attribute Group? Customer Data <One-to-One> Customers <One-to-One> Orders <One-to-One> Products Customer Data <One-to-Many> Customers <One-to-One> Orders <One-to-Many> Product Customer Data <One-to-One> Customers <One-to-Many> Orders <One-to-Many> Products Customer Data <One-to-One> Products <One-to-Many> Orders <One-to-One> Customer.
A customer wants to display a subscriber’s first name and the date of send in its monthly newsletter. Subscriber first name data is stored in a data extension that will not be used in the send definition. Which option should be in this scenario? Personalization strings AMPscript Guide Template Language SQL Query .
A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices. What reason warrants this implementation? Tracking information for campaigns sent by each office. Localized language and display options based on location and culture. Support non-English responses with Reply Mail Management Localized physical mailing address displayed in the default email footer. .
Subscribers are collected on a customer’s website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to five 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 The third-party send list should be pulled from the CMS The will need to integrate with the Marketing Cloud SOAP API. Engagement metrics will be passed into Marketing Cloud Unsubscribes should be synchronized between senders. .
During discovery, the customer outlines data requirements and the acticipated 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.
One attribute will house HTML code, 1000 characters max that will b used to populate Account Access content areas in emails.
A customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists? Data extensions allow for add/update Import File Activity Data extensions can store HTML code as an attribute. Data extensions are necessary for Contact Builder. Data extensions support Customer ID to be used as Subscriber Key. .
By which three standard methods could contacts be injected into a Journey Builder Interaction? Choose 3 answers Mobile Response Event Date-Based Event Sales/Service Cloud Event CloudPages Form Submit Event Predictive Intelligence Event .
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.
What workflow should meet these requirements? Triggered Automation: Import File > SQL Query(s) > Send Email(s) Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s) Triggered Automation: Import File > Group Refresh > Send Email(s) Scheduled Automation: Import File > SQL Query(s) >Send Email(s).
Which two statements are correct regarding tracking aliases? Choose 2 answers Tracking aliases are found in Tracking and some standard reports Tracking aliases are primarily relevant when used with emails conversion tracking. Tracking aliases are associated with a URL in HTML as: tag=”alias text”. Tracking aliases can differentiate click activity in an email to the same URL.
A customer would like to store financial data related to invoicing in its data extensions.
What field type should be used? Number Currency Float Decimal .
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 should the consultant ensure that this requirement is met Create a User in Sales Cloud with a System Administrator Profile. Ensure that the User has the correct profile in Marketing Cloud. Check the Scope By User box in Marketing Cloud. Ensure that the User is assigned as System Administrator in Sales Cloud. .
A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks. They have communicated the following.
They currently have 3 million customers.
They email customers twice a week with no known deliverability issues.
Their contract includes one Sender Authentication Package (SAP).
Which two responses articulate proper IP warming? Choose 2 answers IP ramp-up can be bypassed, given their historical lack of deliverability issues. IP ramp-up can be accelerated by migrating to pre-warmed IP addresses. IP ramp-up is important to establish a positive sender reputation IP ramp-up takes four to six weeks to be able to fully send to all 3 million customer. .
A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their accounts 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?
Create a scheduled monthly automation that includes an Import File Activity and triggered send Create a file drop automation that includes an Import File Activity and triggered send. Create a file drop automation that includes an Import File Activity and Send Email Activity. Create a scheduled daily automation that includes an Import File Activity and Send Email Activity.
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 FTP in one file.
Which automation workflow meets the customer requirements? Report activity that generates Recent Send Summary report > Report delivered directly to FTP Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity.
A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings.
Data for the campaign will be in two data extensions: customer and New Accounts
The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.
The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.
Which automated work flow meets the customer’s requirements? A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity > Import File Activity > SQL Query Activity > Wait Activity and > Send Email Activity. A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity. A file drop automation that executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity. A scheduled automation that starts at 12:00 a.m and executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity. .
Northern Trail Outfitters is noticing a gradual decline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend. Which two actions should be taken to increase subscriber engagement? Choose 2 answers Adopt a Cart Abandonment Email Campaign. Introduce more identity verification steps in check out process. Increase the use of dynamic content in emails. Increase volume of emails to a wider audience. .
A financial company will be using 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 FTP each Monday at 1.00 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 5 days after send.
Which automation sequence represents a viable solution? File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfe Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfe.
What are data extension data retention policies? Settings to define when a data extension or the data within the data extension is deleted. Settings to control when a data extension creates a back-up of the data it contains. Settings to prevent users from deleting a Data Extension created by another user. Settings to “soft” delete all data in a Data Extension so there is no data loss. .
Northern Trail Outfitters (NTO):
Employs Email Specialists responsible for creating content, testing, sending emails, defining the activities for Automation Studio, and creating automations.
Prefers not to use custom roles unless it is absolutely necessary
Email Specialist resides in multiple business units.
Using best practices, how should a consultant create and assign roles for NTO? Alter the roles of Content Creator and Data Manager by denying permissions and then assign the roles to the Email Specialists. Check “Allow” automation permissions for the Content Creator Role and assign it to the Business Units. Create a custom Email Specialist role with needed permissions and assign it to the Email Specialists. Check “Allow” automation permissions for the Content Creator Role and assign it to the Email Specialists.
A customer needs to compare the engagement across three creative versions of an email, and then send a follow-up email for those contacts who did not engage with any of the test versions.
Which sequence of activities in journey Builder would best accomplish this? Engagement Split > Send email > Wait > Random Split > Send email Random Split > Send email > Join > Decision Split > Wait > Send email Random Split > Send email > Wait > Engagement Split > Join > Send email Decision Split > Send email > Engagement Split > Send email .
Northern Trail Outfitters (NTO) plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships. NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database. Which two actions should be taken when using Contact Builder? Choose 2 answers Create a data extension to incorporate the imported data from a Salesforce Dashboard Combine each individual’s channel contact information under one record. Use Marketing Cloud Connect to include data from Sales Cloud. Conduct manual imports of customer information from Sales Cloud. .
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. Which two approaches should the consultant recommend? Choose 2 answers Use Synchronized Data Sources to sync Sales Cloud objects to the Marketing Cloud. Use Data Filters to segment data to output a Sendable Data Extension. Use SQL Query Activities to output a Sendable Salesforce Data Extension. Use SQL Query Activities to create a Sendable Synchronized Data Extension.
A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions—subscribers and OrderTable, and the customer would like to include kay information from both tables, such as:
Which SQL statement should the consultant use? SELECT CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerID=CustomerID SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerID=OrderTable.CustomerID SELECT * FROM Subscribers WHERE CustomerID, FirstName, EmailAddress, OrderID, OrderDate, Shipped Date JOIN OrderTable On CustomerID=CustomerID.
Northern Trail Outfitters (NTO) is running a campaign for a brand new type of footwear inside Journey Builder. The entry event: Prevents contacts from entering the journey if “shoes” is not selected in their preferences. Is based on a data extension which has Email Address as Primary Key. A few weeks after launching the campaign, NTO’s data analyst noticed a reduced email volume and that some contacts inside the data extension updated their preferences after the launch of the campaign. Even with the entry event being triggered every day, those contacts are not receiving the welcome emails. What could be the reason? The preference center is too precise. Their account has deliverability issues. The contact fell below the High Water Mark. The entry event is triggered too often.
Northern Trail Outfitters (NTO) 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 NTO does not want to include them in the final values. Which data type should they use for the Order ID field? Decimal (15,0) Decimal 15,2) Number Text (15).
The Corporate Apparel Division of Northern Trail Outfitters (NTO)is moving to Marketing Cloud and will be using NTO’s existing account. The Corporate Apparel team has asked for a recommendation on whether they should have a separate business unit. Which consideration warrants the creation of a separate business unit for Corporate Apparel’s instance of Marketing Cloud Branding for the Corporate Apparel is different from NTO. Using different From Name and Email Address settings. Managing Unsubscribes for the Corporate Apparel Division only. Sending from a separate IP Address and Domain .
During discovery it was confirmed that: The customer has purchased a Corporate Edition account. A master audience file containing contact information and data points will be used for segmentation and imported nightly. The Customer would like to implement a mechanism that consistently prevents sending promotional emails to subscribers who work for their top three competitors. What feature should a consultant include in the solution? A global unsubscribe. An auto-exclusion list. An exclusion list. An auto-suppression list. .
Northern Trail Outfitters is expanding its marketing efforts globally. Each country’s marketing department has its own business unit and is responsible for the creation and execution of all the marketing campaigns. The Marketing Cloud Administrator is having trouble keeping up with the constant influx of new users and would like to speed up the turnaround of granting new users access to the Marketing Cloud. In what two ways can this be accomplished? Choose 2 answers. Assign Administration User permissions to each business unit. Assign Administration User permissions to the Channel Manager role. Assign Administration User permissions to individual users. Assign Channel Managers the role of Marketing Cloud Analyst. .
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.
One attribute will house HTML code, 1000 characters max that will be used to populate Account access content areas in emails.
A Customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists? Data extensions are necessary for Contact Builder. Data extensions allow for add/update Import File Activity. Data extensions support Customer ID to be used as Subscriber Key. Data extensions can store HTML code as an attribute. .
A company is hosting a series of events and wants its customers who register to enter into a journey. Which two methods are viable configurations for these contracts to enter? Chose 2 answers. A form hosted on the company website that fires the entry even via SOAP API. A SmartCapture form hosted on a CloudPage that populates the entry source. A form hosted on the company website that fires the entry even via REST API. A SmartCapture form hosted on a CloudPage that updates a profile attribute. .
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? My Tracking Tracking Extract Data Views My Reports .
A large retail group consists of a corporate team and several divisions operating under different brand names. All plan to share one Marketing Cloud account. Each brand has its own marketing department and operates independently, with its own creative assets, subscribers, and data structure. What are the two reasons why the recommended account configuration is one corporate Parent account, with each brand configured as a separate child Business Unit? Choose 2 answers Brands can set their own physical address and SAP. Email sends can be separated into Tracking folders for each brand. User roles can be customized to allow or deny specific permissions. Subscribers can be maintained at the Business Unit level. .
Northern Trail Outfitters (NTO) wants to automate the sending of shipping notices and a customer survey.
Shipping notices will be sent once a day.
The shipping file will be placed on the FTP some time after 4:00 p.m.
The shipping data will be sorted in the Shipping Notice data extension.
A field in the data extension will contain the shipping date.
The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer’s order ships.
Which workflow would most effectively enable NTO to do this? Automation 1: Triggered Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email Automation 1: Scheduled to run daily at 7:00 PM Import File -> Filter-> Send Email-> Wait -> Filter -> Send Email Automation 1: Triggered Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter-> Send Email-> Filter -> Send Email Automation 1: Scheduled to run daily at 7:00 PM Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter-> Send Email-> Filter -> Send Email .
What storage model should be used if a subscriber has more than one value for an attribute? Profile Attribute Data Extensions Publication Lists Lists .
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 2 answers. Customer Data Event Registration Venue Details Payment Details .
An online retailer would like to be utilize Journey Builder interactions for sending postpurchase communications to their customers. What Contact Entry mode best fits this scenario? Re-entry anytime. Re-entry only after existing. Re-entry after time. No re-entry. .
Northern Trail Outfitters (NTO) has decided to use Journey Builder to launch evendriven lifecycle marketing programs. This includes personalized interactions with customers with the goal of increasing purchase frequency. Which two pieces of information would help NTO achieve this objective? Choose 2 answers Products purchased from a competitor. Number of items per order. Channel preference of customers. Last purchase date .
A restaurant supply company captures email subscribers and leads through trade shows. They hold a giveaway at each trade show to entice booth visitors to leave their contact information. In the past, they have used a fishbowl to capture business cards, but need to update this to an online sweepstakes entry vehicle displayed on a mounted tablet.
Individuals should only be allowed to enter once, and the winner will be selected randomly.
All entrants receive a follow-up email after the trade show asking them to confirm their opt-in for a monthly newsletter.
Which two components are appropriate for this solution? Choose 2 answers Microsite with Web Collect to store entrants on a data extension. Microsite with Smart Capture to store entrants on a data extension. Send Email Activity with a link to a subscription center. Data Extension with double opt-in status defined. .
A customer with limited technical resources has requested assistance in setting up a small email deployment that the customer will maintain long term. The email will display men’s shoes to males in the audience and women’s shoes to females in the audience. The sendable data extension contains a field with a value of Male or Female. Which method should a consultant recommended to ensure content is displayed properly within the email. AMPscript conditional against the Gender field AMPscriptlookupRows functions A/B Test content type Dynamic Content Wizard .
A user in the Marketing Cloud wants to use Salesforce Custom object data for segmenting and personalization. How should the consultant approach this requirement? Map the custom objects to the Profile Center and use the email editor to insert the custom object data. Create a User-Initiated Send to associate the email to the target audience and return Tracking data. Sync contact and custom objects with Data Stream and send from Synchronized Data Extension with Salesforce Email Send. Ensure there is a lookup relationship to a contact or lead record. Export report data from the Sales Cloud and import into a Marketing Cloud Synchronized Data Extension. Use a filter activity to produce a sendable data extension. Create an Email Send activity in Automation Studio. Create a custom report type that contains the contact or lead id, email address, and custom object data, them from Marketing Cloud, import into a Salesforce data extension. Use AMPScript in the email to call data.
Northern Trail Outfitters(NTO) experienced a 24-hour website outage beginning on a peak shopping day. As a result, a number of logged-in customers’ shopping sessions were disrupted. When the site is back online, the retailer would like to encourage those shoppers to return to the site and continue their shopping. What action should NTO take? Import a file of logged-in customers into NTO’s existing Abandoned Cart journey in Journey Builder. Create a user-initiated message to logged–in customers to send once the website is restored. Do not send an email, as outage may have increased negative sentiment, resulting in unsubscribes. Create and send an apology email that includes a discount for a future purchase to all customers.
Northern Trail Outfitters wants to set up a welcome journey that leverages customer data across three data extensions: Customers, Orders, and Products. What is the best way to facilitate this within Contact Builder? Create three distinct Attribute Groups that link Customers to Contacts, Orders to Customers, and Products to Orders. Create a single Attribute Group that links Contacts to Customers, Orders to Products, and Products to Customers. Create three distinct Attribute Groups that link each data extension directly to Contacts. Create a single Attribute Group that links Customers to Contacts, Orders to Customers, and Products to Orders.
A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and 'Products. The data extensions contain the following information: Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount Products: ProductId, SKU, Name, Description, Cost, Price Which two actions should be taken in Data Designer? Choose 2 answers Create a one-to-one relationship between the contact record and Order Details. Create a one -to -many relationship between Orders and Order_Details. Create a one-to-one relationship between Orders and Order_Details. Create a one-to-one relationship between Order_Details and Products.
A university plans to use Journey Builder to improve their 1:1 marketing to potential students, current students, and alumni. The university currently has student data in the Sales Cloud. Other data, such as course catalog, student demographics, and alumni information, is stored in external systems. Which two actions should the implementation Consultant recommend? Choose 2 answers. Use Data Designer to link student and alumni data to the contact record. Create an Import Activity to import alumni data into Salesforce Report. Create list attributes to store student data from the Sales Cloud. Use Synchronized Data Sources to data from the Sales Cloud. .
Northern Trail Outfitters (NTO) has a requirement to create a distinction between marketing and transactional emails in terms of From Name and IP Address for reputation purposes. Which two actions should NTO take in order to create Send Classifications? Choose 2 answers Define a Sender Profile Define a Subscriber -specific From Name. Define custom Reply Mail Management. Define a Delivery Profile. .
The Northern Trail Outfitters (NTO) marketing team is launching a new email campaign. NTO's Email Specialist wants to perform quality assurance checks on the email prior to send and has asked about using the Validate functionality for this effort. Which three items will Validate check in an email message? Choose 3 answers a Each content area specified in a dynamic content rule exists. Words or phrases used may trigger spam filters. Grammar and spelling in the email text is correct. Correct syntax is used on any AMPScript in the email's code. Personalization strings map to attributes or data extension fields .
A customer will provide a single daily file on the Marketing Cloud SFTP at 3AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions. Which workflow should meet these requirements? Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2 Schedules Starting Source: Import File Activity > SQL Query Activity 1 > SQL Activity 2 File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2 File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1 .
A customer wants Sales Cloud users to create and send Marketing Cloud emails. Which two recommendations should the consultant make? Choose 2 answers Each user should have a one-to-one relationship between the Marketing Cloud user and the Sales Cloud user. The consultant should enable deep linking in Marketing Cloud Connect configuration. The consultant should enable the Create Email feature on the user Profile in the Sales Cloud. Each Sales Cloud user should have a System Administrator Profile and a Role at the top of the Role Hierarchy. .
Northern Trail Outfitters is setting up new hires on its instance of Marketing Cloud, which includes Email Studio, Mobile Connect, and Social Studio. One of the hires needs to manage the operations of all of the North American Business Units. What two roles, custom or standard, could be assigned to this user to meet the requirement? Choose 2 answers Marketing Cloud Channel Manager Marketing Cloud Email Marketing Manager Marketing Cloud Regional or Local Administrator Marketing Cloud Administrator .
A customer frequently holds seminars and other events to interface with their customers. They plan to do the following: Use SmartCapture forms to write data into event registration data extensions. Cross-reference the records in each registration data extension with corresponding invitation email sends. Send a follow-up email to customers who click on the registration link in the invitation email, but do not complete registration. Which skill is needed to build an efficient solution? AMPscript SQL HTML CSS .
How are publication lists used in the Marketing Cloud? To send communication to all subscribers, regardless of opt -in status. To manage subscribers in guided and triggered email sends. To build dynamic content rules by subscriber type. To allow subscribers to opt-down/out instead of unsubscribing from all. .
What are two possible outcomes when "Send as Multipart MIME" is selected during the send process? Choose 2 answers Open and click activity are tracked in either version. The email will avoid detection by various SPAM filters. An auto -generated text version will be sent with your HTML email. A custom text version will be sent with your HTML email. .
Northern Trail Outfitters needs to reduce the amount of work when managing messages to customers, but cannot add any more personnel due to budget constraints. There has been an increased number of customer purchases on their website, and the team currently sends batch order confirmations. What solution will decrease manual workloads on the team and will improve their customers experience? A file drop automation to send emails to customers who have made a purchase. A user -initiated message to send an email to customers who made a purchase daily. A scheduled automation to send emails to customers who made a purchase daily. A triggered message to send an email as soon as a customer completes a purchase. .
A Consultant has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's
product catalog. The product catalog is never the same; products can be added and removed. Which import type should be used? Overwrite Add Only Add/Update Update Only .
Which two statements are correct about Send Logging? Choose 2 answers Send Log data extensions are archived automatically based on retention settings. AMPscript can be used to pull data from Send Logs for use within emails. SQL Query Activities can reference Send Logs in combination with system data views. A business unit can support up to three Send Logs. .
A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks. They have communicated the following: They currently have 3 million customers. They email customers twice a week with no known deliverability issues. Their contract includes one Sender Authentication Package (SAP). Which two responses articulate proper IP warming? Choose 2 answers IP ramp -up takes four to six weeks to be able to fully send to all 3 million customers. IP ramp -up can be accelerated by migrating to pre -warmed IP addresses. IP ramp -up can be bypassed, given their historical lack of deliverability issues. IP ramp -up is important to establish a positive sender reputation.
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 the customer use to create an audience for this campaign? Choose 3 answers Proximity to Store Ages in Household Lifetime Purchase Value Conversion Rate Last Purchase Date.
A customer wants to automate a series of three emails as part of a Membership Renewal drip campaign. Email #1 will be sent one month prior to the member's renewal date. Email
#2 will be sent one week prior to the member's renewal date. Email #3 will be sent on the member's renewal date. A master audience is updated in real time via the API. Which steps should be included in the customer's automation? Import File Activity > three Send Activities to the master data extension. Three Send Activities to the master data extension. Import File Activity > three Filter Activities > three Send Activities to the filtered audiences Three Filter Activities > three Send Activities to the filtered audiences.
As part of their brand guidelines, Northern Trail Outfitters (NTO) uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well. What is the recommended best practice for font usage in email? Edit an email's HTML to list the custom brand font in the style tag's font -family property Build an email as one image, with all text saved in the brand font. Build an email using multiple images, with all text saved in the brand font. Use a web -safe font that most closely matches the brand's custom font for live text.
A customer needs to link demographic information to its contact model in Contact Builder. What type of relationship should be used? One -to -Many Relationship Many -to -Many Relationship One -to -One Relationship Many -to -One Relationship .
A start-up meal delivery company recently launched in Canada to great success. Through their website, customers can order individual meal kits for up to six people or subscribe to a weekly meal kit delivery. As a new company, resources are limited, but demand is taxing their manual processes for sending out ecommerce messages, such as order confirmation and subscription confirmations. What recommendation would best provide a scalable solution for the start-up? A manual email send for each transactional message. A triggered automation to send transactional messages. Triggered email sends to deliver transactional messages. An automated program to send daily transactional messages. .
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 2 answers Data Designer Cloud Pages Web Analytics Connector Content Builder .
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 3 answers Put a SOAP API in place via the Marketing Cloud API. Create the Triggered Send Definition in the Marketing Cloud. Enable Triggered Sends on the Lead Object in configuration. Create the Triggered Send Definition in the Sales Cloud. Write an Apex Trigger on the Lead Object.