Marketing Cloud Practice Exam

Certification Aid wants to promote Marketing Cloud as the database of record. What is a correct statement about a database of record? (Choose 2). - A database of record is any database containing subscriber data. - A database of record is data stricture in which multiple opt-in statuses an be stored for a subscriber - A database of record is a centralized storage repository of data about objects or people. - 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 system in which a subscriber's status is maintained

Certification Aid wants to display the subscriber's first name and the send date in a monthly newsletter. The subscriber's first name is stored in a data extension which is not used in the send definition. How can this be achieved? (Choose 1). - SQL Query - Personalization strings - AMPscript - Guide Template Language

- AMPscript

Certification Aid wants to generate a report with email metrics for each business unit. Email metrics should include: number of sends, delivery rate, overall bounce rate, block bounce rate, open rate, click rate, complaint rate, and unsubscribe rate. Which standard email reports contains this information? (Choose 1). - Email Send Report - Email Performance Over Time Report - Account Send Summary Report - Campaign Email Tracking Report

- Account Send Summary Report

Certification Aid wants to use Contact Builder to manage data extension records. Which data operations are supported in Contact Builder? (Choose 2). - Extract Data - Edit Multiple Records - Add Single Record - Clear Records

- Add Single Record - Clear Records

Certification Aid has doubled in size over the past years and wants to configure business units to better manage Marketing Cloud operations. Which statements regarding business units are correct? (Choose 2). - Business Units can share information with other Business Units - Subscribers can only appear in one Business Unit - Business Units can mirror an organization's operational structure - Business Units can have more than one parent Business Unit

- Business Units can share information with other Business Units - Business Units can mirror an organization's operational structure

Certification Aid wants to use Send Logs to report a historical sends. Which statements concerning Send Logs are true? (Choose 3). - Can be accessed via Query activities - Can be stored for a set period of time - Can be added to a standard data view - Can be incorporated into standard reports - Can be included in measures and filters

- Can be accessed via Query activities - Can be stored for a set period of time - Can be included in measures and filters

Certification Aid noticed that a subscriber is still receiving emails, although he has asked multiple times to be removed from a publication list by replying to Marketing Cloud emails. What are relevant troubleshooting steps to resolve this? (Choose 3). - Confirm that the RMM setting "Unsubscribe Manual Requests" is set to YES - Confirm that the RMM setting "Delete auto-replies and out-of-office replies" is set to NO - Confirm that Reply Mail Management (RMM) is configured for the customer's account - Confirm that the email address was provided as the Routing Address for Remaining Replies - Confirm that the subscriber's request contained one of the standard terms that qualify for automatic unsubscribe

- Confirm that the RMM setting "Unsubscribe Manual Requests" is set to YES - Confirm that Reply Mail Management (RMM) is configured for the customer's account - Confirm that the subscriber's request contained one of the standard terms that qualify for automatic unsubscribe

Certification Aid wants to create an email campaign to send renewal reminders to customers whose subscriptions end in 15 days and 7 days. The expiration date for subscription is stored for each customer in common data extension. The campaigns should be maintained by a non-technical marketing user with no administrative permissions. Which Marketing Cloud features should be used to achieve this? (Choose 3). - Data Filter - Template-based emails - Triggered Send - Suppression List - Automation Studio

- Data Filter - Template-based emails - Automation Studio

Certification Aid wants to create a customer journey which targets subscriber based on website behavior. There are 3 relevant groups: customers who searched for an item, customers who abandoned a cart, and customers who made a purchase on the website. Which questions are relevant to design the data structure for this solution? (Choose 3). - How many messages should be included in each journey? - How long after the behavior occurs will a subscriber need to enter a journey? - How are subscribers identified in your web analytics? - Should a single customer exist in multiple journeys at the same time? - Should customers exit the journey when the goal is met?

- How are subscribers identified in your web analytics? - Should a single customer exist in multiple journeys at the same time? - Should customers exit the journey when the goal is met?

Certification Aid wants to send a daily email promotion with minimal effort. A dynamic template should be built to highlight the new inventory each day. A small team will manage this email campaign and should be able to build, test, and send the daily email in less than an hour. Images included in the email will be hosted on the website CMS. Which questions are relevant to identify strategies for designing the dynamic email template? (Choose 3). - How often will the layout of the content in a content area change? - What is the maximum file size of the images being used? - What From Name will be used for those emails? - Will image URLs be available publicly? - How often will email content be image-only with text overlaying images?

- How often will the layout of the content in a content area change? - What is the maximum file size of the images being used? - How often will email content be image-only with text overlaying images?

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 their send is connected to the "Email ID" in the database. What key issue should be addressed? (Choose 3). - How will Marketing Cloud and the database sync up? - Will new users have an "Email ID"? - What will be used as the Subscriber Key? - What publication lists will be used? - Will the company need a custom preference center?

- How will Marketing Cloud and the database sync up? - What will be used as the Subscriber Key? - Will the company need a custom preference center?

Certification Aid newly purchased Marketing Cloud including the Sender Authentication Package (SAP). The company wants to fully migrate their existing email marketing platform to Marketing Cloud within 3 weeks. Certification Aid has 3 million customers to which emails are sent twice a week without known deliverability issues. Which IP warming restrictions should be considered? (Choose 2). - IP warming is important to establish a positive sender reputation. - IP warming takes four to six weeks to be able to fully send to all 3 million customers. - IP warming can be accelerated by migrating to pre-warmed IP addresses. - IP warming can be bypassed, given their historical lack of deliverability issues.

- IP warming is important to establish a positive sender reputation - IP warming takes four to six weeks to be able to fully send to all 3 million customers

Certification Aid wants to use Contact Builder to import data into Marketing Cloud. Which statements are true concerning Contact Builder imports? - In order to use Map by Header Row, the fields in the DE and file must match exactly - The target destination can be a DE, list, or All Contacts for Mobile Push or Connect - The data source can be a local file, data filter, or file on any FTP - Like the Import Wizard, the Contact Builder import definition can be executed without saving

- In order to use Map by Header Row, the fields in the DE and file must match exactly - The target destination can be a DE, list, or All Contacts for Mobile Push or Connect - The data source can be a local file, data filter, or file on any FTP

Certification Aid notices a decline in conversion rates from emails sent with Marketing Cloud. What actions can be taken to increase subscriber engagement? (Choose 2). - Increase volume of emails to a wider audience. - Increase the use of dynamic content in emails. - Adopt a Cart Abandonment Email Campaign - Introduce more identity verification steps in check out process.

- Increase the use of dynamic content in emails - Adopt a Cart Abandonment Email Campaign

Certification Aid wants to target subscribers who are most likely to buy services. Which data can help to identify those subscribers? (Choose 3). - Lifetime purchase value - Proximity to store - Last purchase to date - Conversion rate

- Lifetime purchase value - Last purchase to date - Conversion rate

Certification Aid wants to automate marketing activities. Which statements are correct concerning automation tools in Marketing Cloud? (Choose 3). - Automation Studio and Journey Builder allow users to define a wait state based on duration or duration + time - Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool - Journey Builder allows users to update a contact record in an interaction or import data into a data extension - 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 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

Certification Aid wants to define Attribute Groups in Contact Builder. Which statements are true concerning Attribute Groups? - Link data extensions to contacts - Link data extensions to other date extensions - Link subscriber lists to contacts - Link data extension to subscriber list

- Link data extensions to contacts - Link data extensions to other date extensions

Certification Aid plans to configure multiple business units in Marketing Cloud, to support the digital marketing activities of five internal offices. Which reason supports the use of business units? (Choose 2). - 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 - Separate tracking information for campaigns sent by each office

- Localized physical mailing address displayed in the default email footer - Separate tracking information for campaigns sent by each office

Certification Aid wants to use Journey Builder to create a "post-purchasing communication" journey. Which re-entry settings would be appropriate for this? (Choose 2). - Re-entry only after exiting - No re-entry - Re-entry after time - Re-entry anytime

- Re-entry only after exiting - Re-entry anytime

Certification Aid created a journey in Journey Builder. While testing, an error message states "Error binding data bound member." and no contacts enter the journey. How can this be resolved? (Choose 2). - Fire the event in both Automation Studio and the Entry Event - Select a source DE with a root relationship to the contact - Make sure the contact is above the High Water Mark on the source data - Import new subscribers to the All Subscribers table

- Select a source DE with a root relationship to the contact - Make sure the contact is above the High Water Mark on the source data

Certification Aid wants to gather new email subscribers as part of a raffle at a customer event. Participants should be able to enter their contact information in a tablet-based webform which stores the information in a data extension. The winner of the raffle should be randomly selected. After the event, an email should be sent to all participants to gather opt-in for marketing emails. Which Marketing Cloud features should be recommended for this solution? (Choose 2). - Smart Capture - Send email activity containing a link to subscription center - Data Extension with opt-in status - Web Collect

- Smart Capture - Send email activity containing a link to subscription center

Certification Aid created a journey in Journey Builder. What are possible reasons for contacts to fail entering a journey? (Choose 4). - The entry event was not fired via Automation Studio - The contact falls below the High Water Mark - The interaction has an A/B/n split, and the contact does not meet criteria - The contact did not meet the entry criteria - The contact did not meet the filter criteria

- The entry event was not fired via Automation Studio - The contact falls below the High Water Mark - The contact did not meet the entry criteria - The contact did not meet the filter criteria

Certification Aid wants to define Attribute groups in Contact Builder to incorporate data from external systems. Which statements are true concerning Attribute Groups? - They replicate the structure from the external system data into templates - They link data extensions to other data extensions or contacts - They can be created from templates to accomplish certain tasks - They can contain only one data extension

- They link data extensions to other data extensions or contacts - They can be created from templates to accomplish certain tasks

Certification Aid wants to use the Web Analytics Connector to better understand the behavior of subscribers visiting their website from Marketing Cloud emails. What are the features of the Web Analytics Connector? (Choose 3). - Track web activity from a click on an email URL back to a specific email campaign - Match subscribers to web activity by passing Subscriber ID through email links - Use the web analytics platform to trigger behavioral marketing emails - Pass web conversion data back into Marketing Cloud for use in email reporting - Recognize web traffic as originating from email instead of another channel

- Track web activity from a click on an email URL back to a specific email campaign - Match subscribers to web activity by passing Subscriber ID through email links - Recognize web traffic as originating from email instead of another channel

Certification Aid wants to use tracking aliases. Which statement is correct regarding tracking aliases? (Choose 2). - Tracking aliases are primarily relevant when used with email conversion tracking - Tracking aliases are associated with a URL in HTML as: tag= "alias text" - Tracking aliases are found in Tracking and some standard reports - Tracking aliases can differentiate click activity in an email to the same URL

- Tracking aliases are primarily relevant when used with email conversion tracking - Tracking aliases can differentiate click activity in an email to the same URL

Certification Aid uses Marketing Cloud Connect and wants to send an email to a subset of subscribers in a Synchronized Data Extension. The subscribers should be filtered based on custom object data and tracking information should be pushed back to Salesforce. How can this be achieved? (Choose 2). - Use Data Stream to sync Sales Cloud objects to the Marketing Cloud - Use Data Filters to segment data to output a Sendable Data Extension - Use Query Activities to create a Sendable Synchronized Data Extension - Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension

- Use Data Stream to sync Sales Cloud objects to the Marketing Cloud - Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension

Certification Aid uses Salesforce Sales Cloud as the database of record for subscribers. The company wants to use Contact Builder to store more customer information and to establish more effective one-on-one messages across channels. How can this be achieved? (Choose 2). - Use Marketing Cloud Connect to include data from Sales Cloud - Create a data extension to incorporate the imported data from a Salesforce Dashboard - Combine each individual's channel contact information under one record - Conduct manual imports of customer information from Sales Cloud

- Use Marketing Cloud Connect to include data from Sales Cloud - Combine each individual's channel contact information under one record.

Certification Aid uses Marketing Cloud Connect and wants to send an email from Salesforce on behalf of the record owner. The email address of the record owner should be used as the From address in the email send. How can this be achieved? (Choose 2). - Use a custom Send Classification - Use the Organization-Wide Email address - Use a custom Delivery Profile - Use the Send from Record Owner option

- Use a custom Send Classification - Use the Send From Record Owner option

Certification Aid wants monthly customer newsletters to appear to be sent on behalf of each subscriber's account representative. Segmenting the email audience by sales rep. should be avoided. How can this be achieved? (Choose 2). - Utilize data extension AMPscript lookups to dynamically populate the from name and from email values - Pick "Choose from List," selecting the from name and from email values from the list of account users - Match the external keys of the sender profile and data extension containing account representative data - Populate substitution strings in the sender profile for the profile attributes containing from name and from email values

- Utilize data extension AMPscript lookups to dynamically populate the from name and from email values - Populate substitution strings in the sender profile for the profile attributes containing from name and from email values

Certification Aid operates in Europe in Asia and offers a common loyalty program. Each region provides a pre-segmented CSV file for emails campaigns with a "Version" column that indicates which email a subscriber should receive. Which questions are relevant to determine an improved segmentation strategy? (Choose 2). - Will multiple languages be used, with a "From Name" lookup table needed? - 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? - Will version values/meanings change, precluding reusable AMPscript?

- Will multiple languages be used, with a "From Name" lookup table needed? - Is the purposes of these emails for acquisition or retention or transactional?

Certification Aid uses a third-party company to maintain the database of record and to keep track of customer purchases. The database of record can only be synchronized with other systems once a day, to create and merge new records. It uses a numeric "Email ID" field to identify both business unit and email addresses. Certification Aid wants to create a welcome journey and send emails to newly registered customers. The new customers should be connected to the "Email ID" in the database of record. Which key issues should be addressed with this setup? (Choose 3). - Will the company need a custom preference center? - How will Marketing Cloud and the database sync up? - Will new users have an "Email ID"? - What publication lists will be used? - What will be used as Subscriber Key?

- Will the company need a custom preference center? - How will Marketing Cloud and the database sync up? - What will be used as Subscriber Key?

Certification Aid wants to use Journey Builder to remind customers to activate their account within 72 hours after registration. Account registrations are stored in a data extension via on API call. A boolean flag in the data extension indicates whether the account is activated or not. The journey should send activation reminders 24 hours and 48 hours after registration. Customers exit the journey if they activate their account. Which activity sequence should be used for this? (Choose 1). - Decision Split > 24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email - 24 hour Wait > Decision Split > Send Email> 48 hour Wait > Decision Split > Send Email - 24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email - Decision Split > 24 hour Wait > Send Email > Decision Split > 48 hour Wait > Send Email

24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email

Certification Aid wants to retarget subscribers who clicked on links to key products promoted across email campaigns. Links to key products vary over time and across campaigns, and click activity is cross-referenced with regional marketing assigned to subscribers. Retargeting emails should be built with custom dynamic templates, and content should be populated based on regional markets assigned to subscribers. Which skillset is required to achieve this? (Choose 1). - HTML - AMPscript - SQL - SSJS

AMPScript

Certification Aid wants to collect email addresses with Smart Capture, segment the data, and send emails including data from related data extensions. Which skillset is required to achieve this? (Choose 1). - SQL - HTML - CSS - AMPScript

AMPscript

Certification Aid wants to include 25 fields from a related data extension in an email send. The data extension can be referenced by SubscriberKey and contains one or more records for each subscriber. The email audience is larger than 1 million and the email should be sent as quickly as possible. Which method should be used to populate this information? (Choose 1). - AMPscript a single LookupOrderedRows Function - AMPscript a single Lookup Function - Dynamic content via the Dynamic Content Wizard - Server Side Javascript a single LookupOrderedRows Function

AMPscript a single LookupOrderedRows Function

Certification Aid created a new email address field in Contact Builder. How can Marketing Cloud be configured to use email addresses in this new field? (Choose 1). - Create a new Import to populate subscriber email addresses into All Subscribers - Create a new Attribute Group referencing all email address fields in Data Designer - Add all email address fields into the Contact Configuration screen in the correct order - Add all email address fields into the Mobile Application and Predictive Intelligence Applications

Add all email address fields into the Contact Configuration screen in the correct order

Certification Aid wants to launch a daily deal email campaign and is concerned about its sender reputation. The company wants to identify subscribers who report emails as spam, and store those subscribers in a data extension. How can this be achieved? (Choose 1). - An automation that generates the Complaint Tracking Extract - An automation that generates the Unsubscribe Event Extract - An automation that queries the Complaint data view - An automation that queries the Unsubscribe data view

An automation that queries the Complaint data view

Certification Aid uses Marketing Cloud Connect and wants a Marketing Cloud user to send an email to a Salesforce report via Guided Send. How can this be achieved? (Choose 1). - Create data validation rules for the integrated user in Sales Cloud. - Create a Salesforce Data Extension for the user to select during a Guided Send. - Assign the integrated user the Marketing Cloud AppExchange User permission set in Sales Cloud. - Add custom links to the page layouts in Marketing Cloud.

Assign the integrated user the Marketing Cloud AppExchange User permission set in Sales Cloud

Certification Aid employs several email specialists for creating content, testing/sending emails, and defining activities and workflows in Automation Studio. The email specialists need access to data in multiple business units. Certification Aid prefers to avoid creating custom roles unless it is absolutely necessary. How should roles be created and assigned according to best practices? (Choose 1). - 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 the the Email Specialists - Alter the roles of Content Creator and Data Manager by denying permissions and then assign the roles to the Email Specailists - Check "Allow" automation permissions for the Content Creator Role and assign it to the Business Units.

Check "Allow" automation permissions for the Content Creator Role and assign it the the Email Specialists

Certification Aid wants to configure Marketing Cloud Connect in a way that integrated users only have access to Salesforce data visible to them in their Salesforce account. How can this be achieved? (Choose 1). - Ensure that the User has the correct profile in Marketing Cloud. - Ensure that the User is assigned as System Administrator in Sales Cloud. - Check the Scope by User box in Marketing Cloud - Create a User in Sales Cloud with a System Administrator Profile

Check the Scope by User box in Marketing Cloud

Certification Aid wants to create three data extensions in Contact Builder: Customers containing customer information, Orders containing order information, and Products containing product information. How should those data extensions be linked within an Attribute Group? (Choose 1). - Customer Data <one-to-many> Products <one-to-many> Orders <one-to-one> Customers - 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> Products - Customer Data <one-to-many> Customers <one-to-many> Orders <one-to-many> Products

Customer Data <one-to-many> Customers <one-to-many> Orders <one-to-many> Products

Certification Aid needs to provide an IT staff member with access to Marketing Cloud to maintain suppression lists, data relationships, and subscriber attributes. Which role should be assigned to this employee? (Choose 1). - Content Creator - Administrator - Data Manager - Analyst

Data Manager

Certification Aid states the following data requirements and anticipated use of Marketing Cloud: customer data will be fully refreshed every night via Import activity from the data warehouse; customer data will contain 5 million records and over 40 attributes; Contact records will be augmented with relational data tables in Contact Builder; one attribute will store HTML code with up to 1000 characters; a customer ID will be used as the unique identifier for each contact. Which of those statements makes the use of data extensions instead of lists necessary? (Choose 1). - Data extensions can store HTML code as an attribute - Data extensions allow for add/update Import activity - Data extensions support Customer ID to be used as Subscriber Key - Data extensions are necessary for Contact Builder

Data extensions are necessary for Contact Builder

Certification Aid uses Contact Builder to create and relate data extensions. In which scenario should the Use as Root checkbox be checked? (Choose 1). - Supplemental data for an interaction in Journey Builder - Data for both Email and MobileConnect sends - Database of record other than All Subscribers - One-to-Many Relationship to the Contact Record

Database of record other than All Subscribers

Certification Aid wants to store financial data related to invoices in data extensions. Which field type should be used for this data? (Choose 1). - Float - Decimal - Number - Currency

Decimal

Certification aid wants to use Journey Builder to send welcome emails based on subscriber data. Emails should be sent weekly for up to five weeks. If a subscriber makes a purchase within the five weeks, a boolean set flag in data extension should be set and the subscriber should stop receiving welcome emails. Which activity sequence should be used for this? (Choose 1). - Define Goal > Send Email > Wait > Decision Split - Define Goal > Update Contact Data > Send Email > Wait - Update Contact Data > Wait > Send Email > Join - Random Split > Send Email > Wait > Define Goal

Define Goal > Update Contact Data > Send Email > Wait

Certification Aid collects new subscribers from its website. New subscribers are stored in a subscription list within the Content Management System of the website. This list is encrypted and plcaed on the Enhanced FTP at 11PM every day. Marketing Cloud is the database of records and sends up to five emails a week, based on subscriber engagement from prior sends. Which order of Automation Studio activities accurately describes the data flow for this? (Choose 1). - File Transfer > Query > Measures > Sends - File Transfer > Data Extract > Filters > Sends - File Transfer > Import > Query > Sends - File Transfer > Import > Measures > Sends

File Transfer > Import > Query > Sends

Certification Aid wants to use Automation Studio activities to extract an encrypted list of subscribers from an external system, and add them to a Subscriber List on a weekly basis. Which activity order accurately describes the data flow for this? (Choose 1). - Data Extract > Import File - Import File > Extract File - File Transfer > Import File - Import File > Data Extract

File Transfer > Import File

Certification Aid exports a file containing new and updated subscribers from an external database on a daily basis. The file will be uploaded to the Marketing Cloud Enhanced FTP at 3AM every day. Certification Aid requires that the import is completed before 4AM. The file contains around 2 million rows each day. How should this file be imported into Marketing Cloud (Choose 1). - Import the file to a data extension with the "overwrite" method - Import the file to a data extension with the "add and update" method - Import the file to a list with the "add and update" method - Import the file to a list with the "update only" method

Import the file to a data extension with the "add and update" method

Certification Aid wants to implement an opt-down strategy for customers. Which Marketing Cloud feature should be used to achieve this? (Choose 1). - Preference attributes - Profile attributes - Publication Lists - Preference Lists

Publication Lists

Certification Aid wants to use the Subscription Center to ensure that subscribers only receive emails for which they have opted-in. Which Marketing Cloud feature should be used to achieve this? (Choose 1). - Subscriber Keys - Profile Center - Send Logging - Publication Lists

Publication Lists

Certification Aid wants to use Journey Builder to compare engagement across three different emails, and then send to follow-up email to contacts who did not engage with any of the three emails. Which activity sequence should be used for this? (Choose 1). - Random Split > Send email > Wait > Engagement Split > Join > Send Email - Engagement Split > Send Email > Wait > Random Split > Send email - Decision Split > Send email > Join > Decision Split > Wait > Send email

Random Split > Send email > Wait > Engagement Split > Join > Send Email

Certification Aid wants to integrate the company website with Marketing Cloud, to allow subscribers to update their marketing communication preferences. An integration with Journey Builder is also planned. In-house web developers are available to integrate the website with Marketing Cloud. Which Marketing Cloud configuration should be suggested to achieve this? (Choose 1). - Relational data structure using Data Extensions and consult with the customer on API integration with their website. - Data structure using Lists and leverage a Smart Capture form that the client can iFrame into their website. - Relational data structure using Data Extensions and leverage a Smart Capture form that is hosted in Landing Pages. - Data structure using Lists and leverage the out-of-the-box Preference Center.

Relational data structure using Data Extensions and consult with the customer on API integration with their website

Certification Aid wants to use Automation Studio to send an email to all subscribers who have made a purchase. The relevant data for this exists in two data extensions: Subscribers and OrderTable. The email should contain information from both data extensions, such as: CustomerID, FirstName, EmailAddress, OrderID, OrderDate and ShippedDate. Which SQL should be used to achieve this? (Choose 1). - SELECT * FROM Subscribers WHERE CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate - JOIN OrderTable on CustomerID = CustomerID - SELECT CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerID = CustomerID - SELECT T1.CustomerID, T1.FirstName, T1.Email Address, T2.OrderiD, T2OrderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN Order table ON Subscribers.CustomerID=OrderTable.CustomerID - SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNERJOIN OrdertTable T2 ON T1.CustomerID=T2.CustomerID

SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNERJOIN OrdertTable T2 ON T1.CustomerID=T2.CustomerID

Certification Aid wants to use Automation Studio to export subscriber data from Marketing Cloud into a data warehouse. All email open and click activity data should be exported from Marketing Cloud daily. The export must be provided in a single file on an SFTP site, and meet specific requirements to allow importing into the data warehouse. Which order of activities should be used to achieve this? (Choose 1). - Extract activity of Tracking Extracts that combines data into required file > Transfer Activity - Extract activity of data view tables > Query activity to create the required file > Transfer Activity - SQL Query activity to pull Data View information into data extension > Data Extract activity of data extension > Transfer activity - Report activity that generates Recent Send Summary report > Report delivered directly to FTP

SQL Query activity to pull Data View information into data extension > Data Extract activity of data extension > Transfer activity

Certification Aid wants to use Automation Studio activities to send a welcome email to new customers. Data relevant for the welcome campaign is stored in two data extensions: Customers and NewAccounts. The Customers data extension is used by multiple campaigns and updated daily at 1AM. NewAccounts data is encrypted and placed on the Enhanced FTP at 10PM every day. Which activity order accurately describes the data flow for this? (Choose 1). - Scheduled automation that starts at 12AM and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activity, and Send Email Activity - Schedule automation that starts at 2AM that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity - Scheduled automation that starts at 2AM that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity - Triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity

Schedule automation that starts at 2AM that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity

Certification Aid collects data from a Smart Capture form and stores submissions in a data extension in Marketing Cloud. Automation Studio should be used to send an email to the marketing manager each morning, with all Smart Capture submissions from the previous day attached as a CSV file. Assuming the email attachments feature is enabled, which order of activities should be used to achieve this? (Choose 1). - Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email - Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email - Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email - Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email

Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email

Certification Aid wants to use data extensions to store subscriber data. What are data extension retention policies? (Choose 1). - Settings to define when a data extension or the data within the data extension is deleted - Settings to prevent users from deleting a Data Extension created by another user - Settings to control when a data extension creates a back-up of the data it contains - Settings to "soft" delete all data in a Data Extension so there is no data loss

Settings to define when a data extension or the data within the data extension is deleted

Certification Aid states that multiple subscribers often share a common email address. Which Marketing Cloud features can be used to maintain different subscriber attributes for the same email address? (Choose 1). - Data Extensions - Contact ID - Member Record - Subscriber Key

Subscriber Key

Certification Aid has acquired a company called Super Courses. To perform cross-marketing activities for the two brands, Certification Aid wants to integrate Super Courses into the existing Marketing Cloud account. It was recommended to create a separate business unit for Super Courses, and setup an additional Sender Authentication Package (SAP) with the private domain supercourses.com. What are the implications of this recommendation on emails sent from the Super Courses business unit? (Choose 2). - The domain supercourses.com will be used for all link wrapping, image URLs, and landing page URLs - The email headers and footers will reflect the private domain of Certification Aid as it is the parent company - The dedicated IP address included in the Super Courses SAP will have the same reputation as the ones used for Certification Aid - The domain supercourses.com will act as the from email address for the emails and authenticated with SPF or DKIM - the existing Certification Aid SAP can be applied simultaneously to the Super Courses business unit for cross-marketing emails

The domain supercourses.com will be used for all link wrapping, image URLs, and landing page URLs - The domain supercourses.com will act as the from email address for the emails and authenticated with SPF or DKIM

Certification Aid uses Marketing Cloud as the database of record for subscriber data. The company sends up to five emails to customers each week. The subscriber list for this is compiled in the company's website Content Management System and imported into Marketing Cloud daily at 11PM. What should be considered, if a third-party system wants to send emails to customers outside of Marketing Cloud? (Choose 1). - Unsubscribes should be synchronized between senders - They will need to integrate with the Marketing Cloud SOAP API - Engagement metrics will be passed into Marketing Cloud - The third-party send list should be pulled from the CMS

They will need to integrate with the Marketing Cloud SOAP API

Certification Aid wants to use Automation Studio to import a subscriber file from a remote SFTP site, segment the subscribers, and send emails to the different segments. The import file is placed on the SFTP site at various times daily and data extensions should be used for email sends. Which activity order accurately describes the data flow for this? (Choose 1). - Triggered Automation: Import File > SQL Query(s) > Send Email(s) - Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s) - Scheduled Automation: Import File > SQL Query(s) > Send Emails(s) - Triggered Automation: Import File > Group Refresh > Send Email(s)

Triggered Automation: Import File > SQL Query(s) > Send Email(s)

Certification Aid wants to automate monthly promotion emails with Automation Studio. A file containing relevant subscribers is uploaded on the 15th day of each month to the Enhanced FTP. However, if the 15th day of the month is a Saturday or Sunday, the file will be placed on the Enhanced FTP on the Friday prior the 15th day. In both cases, the promotion emails should be sent as soon as the data import of the file is completed. Which automation configuration should be used to achieve this? (Choose 1). - Scheduled monthly automation that includes an import activity and triggered send - Scheduled daily automation that includes an import activity and user-initiated send - Triggered automation that includes an import activity and triggered send - Triggered automation that includes an import activity and user-initiated send

Triggered automation that includes an import activity and user-initiated send

Certification Aid executes a large number of sends with Marketing Cloud Connect and is concerned about Salesforce API limits. How can the number of API calls from Marketing Cloud Connect towards Salesforce be minimized? (Choose 1). - Share Sales Cloud user licenses across Marketing Cloud users - Use Connected App authentication - Use Data Stream to syn object data into a Data Extension in the Marketing Cloud - Filter target audiences based on mapped profile attributes to reduce Bulk API calls

Use Connected App authentication

Certification Aid uses a custom brand font for all print marketing materials. The same brand font should be used in emails sent with Marketing Cloud. What should be recommended to achieve this? (Choose 1). - Build the email as one image containing all text in the brand font. - Specify the brand font in the font-family property of the email. - Use a web-safe font for email text which closely matches the brand font. - Build the email with multiple images containing all text in the brand font.

Use a web-safe font for email text which closely matches the brand font

Certification Aid wants to send a quarterly re-engagement email to subscribers who have not opened in the previous 3 months. An existing Paste HTML email should be used for the first send, and only minor changes should be done for future sends. To build the subscriber audience for the first and future sends, an existing Measure should be used. Email sends are deployed manually for now, but might be automated in the future. Which email creation methods should be used for this? (Choose 1). - User-Initiated Sends - Triggered Sends - Automated Sends - Guided Sends

User-Initiated Send

Certification Aid has configured two domains in the same Marketing Cloud account. The domain certificationaid.com was configured with SAP, and the domain crtaid.com as a private domain. Which URL will appear in email links and images? (Choose 1). - certificationaid.com - Depends on the From email address - exct.net - crtaid.com

certificationaid.com