SFMC Consultant Flashcards
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 SFTP at 10:00 p.m.
Which automated workflow meets the customers’ requirements?
A. A scheduled automation which starts at 2:00 a.m. and executes Data Extract Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
B. A drop automation which executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
C. A scheduled automation which starts at 2:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.
D. A scheduled automation which starts at 12:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.
C. A scheduled automation which starts at 2:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.
Explanation:
Should start after 1:00 AM after data update. Since its encrypted so File transfer is required.
ABC Company 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 ABC Company to do this?
A. Automation 1: Triggered Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email
B. Automation 1: Scheduled to run daily at 7:00 PM Import File -> Filter -> Send Email -> Wait -> Filter -> Send Email
C. 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
D. Automation 1: Triggered Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter -> Send Email -> Filter -> Send Email
A. Automation 1: Triggered Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email
Explanation:
If a question is related to automation and it mentions that a file will be available in the FTP always at a specific time, your answer will be an option with a scheduled automation. Scheduled automations are used when you know the time a file is pushed into FTP and it always runs at a scheduled time. If a question is related to automation and there is an uncertainty when the file will be pushed to FTP (ex; a day before last working day / if a date falls on a weekend, it will be available on last Friday etc.), your answer will be an option with a Triggered Automation. Triggered Automations are fired as soon as a file hits a specific location within FTP. Transfer activity is involved when file is encrypted.
During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria:
Customer data will be fully refreshed every night via Import File Activity from the customer’s data warehouse.
Contact records will be augmented by relational data tables via Contact Builder. Customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists?
A. Data extensions are necessary for Contact Builder.
B. Data extensions allow for add/update Import File Activity.
C. Data extensions can store HTML code as an attribute.
D. Data extensions support Customer ID to be used as Subscriber Key.
A. Data extensions are necessary for Contact Builder.
A customer wants Sales Cloud users to create and send Marketing Cloud emails.
Which two recommendations should the consultant make? (Choose two.)
A. The consultant should enable deep linking in Marketing Cloud Connect configuration.
B. Each user should have a one-to-one relationship between the Marketing Cloud user and the Sales Cloud user.
C. Each Sales Cloud user should have a System Administrator Profile and a Role at the top of the Role Hierarchy.
D. The consultant should enable the Create Email feature on the user Profile in Sales Cloud.
A. The consultant should enable deep linking in Marketing Cloud Connect configuration.
B. Each user should have a one-to-one relationship between the Marketing Cloud user and the Sales Cloud user.
Why would a contact fail to enter a Journey Builder interaction? (Choose three.)
A. The interaction has an A/B/n split, and the contact does not meet the criteria.
B. The interaction allows re-entry only after exiting, and the contact already exists.
C. The contact falls below the High Water Mark.
D. The contact did not meet the entry criteria.
E. The entry event was not fired via Automation Studio.
B. The interaction allows re-entry only after exiting, and the contact already exists.
C. The contact falls below the High Water Mark.
D. The contact did not meet the entry criteria.
A customer is collecting data from a Smart Capture form that stores submissions in a data extension. The customer wants an email was sent to the marketing manager each morning that contains the previous days submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.
Which automation workflow will accomplish this?
A. Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email
B. Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email
C. Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
D. Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email
C. Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
ABC Company has to import a file that will be different every time. What method should be used? A. Add Only B. Update Only C. Overwrite D. Add/Update
C. Overwrite
Explanation:
In overwrite everything is changed. Removed and then added.
ABC Company wants to import files at certain standard times, but occasionally a file will be dropped on a Friday if the 30th of the month falls on a weekend.
What is the flow?
A. A user-initiated message to send an email to customers who made a purchase daily.
B. Triggered Import - user initiated send (not scheduled).
C. A scheduled automation to send emails to customers who made a purchase daily.
B. Triggered Import - user initiated send (not scheduled).
If a question is related to automation and it mentions that a file will be available in the FTP always at a specific time, your answer will be an option with a scheduled automation. Scheduled automations are used when you know the time a file is pushed into FTP and it always runs at a scheduled time. If a question is related to automation and there is an uncertainty when the file will be pushed to FTP (ex; a day before last working day / if a date falls on a weekend, it will be available on last Friday etc.), your answer will be an option with a Triggered Automation. Triggered Automations are fired as soon as a file hits a specific location within FTP. Transfer activity is involved when file in encrypted.
Northern Trail Outfitters (NTO) experienced a 24-hour website outage beginning on a peak shopping day, as a result, a number of logged-in customer’s shopping sessions were disrupted. When the site is back online, the retailer would like to encourage those shoppers to return the site and continue their shopping.
What action should Northern Trail Outfitters (NTO) take?
A. Create and send an apology email which includes a discount for a future purchase to all customers.
B. Do NOT send an email, as outage may have increased negative sentiment, resulting in unsubscribes.
C. Import a file of logged-in customers into NTO’s existing Abandoned Cart journey in Journey Builder.
D. Create a user-initiated message to logged-in customers to send once the website is restored.
C. Import a file of logged-in customers into NTO’s existing Abandoned Cart journey in Journey Builder.
The answer can be 1 or 3. But the most appropriate solution is 1. Sending emails will not take the user to a state where they left on the website. This requires developer involvement.
A user in Marketing Cloud needs to send an email to a Salesforce Report via a Send Flow process.
How should the consultant meet this requirement?
A. Assign the integrated user the Marketing Cloud for AppExchange User permission in Sales Cloud.
B. Create data validation rules for the integrated user in Sales Cloud.
C. Create a Salesforce Data Extension for the user to select during a Send Flow.
D. Add custom VisualForce Page to the page layouts in Marketing Cloud.
C. Create a Salesforce Data Extension for the user to select during a Send Flow.
Analyst of 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 • Delivery Rate • Overall Bounce Rate • Block Bounce Rate • Open Rate • Click Rate • Complaint Rate • Unsubscribe Rate Which email report should NTO’s Marketing Analyst pull from Marketing Cloud to get this information? A. Campaign Email Tracking Report B. Account Send Summary Report C. Email Send Report D. Email Performance Over Time Report
A. Campaign Email Tracking Report
Northern Trail Outfitters 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?
A. An automation that queries the Complaint data view.
B. An automation that queries the Unsubscribe data view.
C. An automation that generates the Spam Complaints Over Time Report.
D. An automation that generates the Unsubscribe Event Extract.
A. An automation that queries the Complaint data view.
A retail company’s database of record resides at a third party company that also keeps track of purchase history. Their database only updates once a day where new records can be created and merged. The database uses the unique identified “Customer ID”.
The company wants to send real-time Welcome emails to newly registered website users who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to “Customer ID” in the database. What three key issues should be addressed? (Choose three.)
A. How will Marketing Cloud and the database synchronize?
B. What will be used as Subscriber Key?
C. Will the company need a custom preference center?
D. What publication lists will be used?
E. Will new users have an “Customer ID”?
A. How will Marketing Cloud and the database synchronize?
C. Will the company need a custom preference center?
D. What publication lists will be used?
When joining a data extension in Contact Builder, in which scenario should a consultant mark the Use as Root checkbox?
A. Supplemental data for an interaction in Journey Builder.
B. One-to-Many Relationship to the Contact Record.
C. Data for both Email and MobileConnect sends.
D. Database of record other than All Subscribers.
D. Database of record other than All Subscribers.
ABC Company 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. A user-initiated message to send an email to customers who made a purchase daily.
B. A triggered message to send an email as soon as a customer completes a purchase.
C. A scheduled automation to send emails to customers who made a purchase daily.
D. A triggered automation to send emails to customers who have made a purchase.
B. A triggered message to send an email as soon as a customer completes a purchase.
Explanation: Transactional message (Order confirmation) requires triggered message.
A retail company’s database of record resides at a third party company that also keeps track of purchase history. Their database only updates once a day where new records can be created and merged. The database uses the unique identified “Customer ID”.
The company wants to send real-time Welcome emails to newly registered website users who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to “Customer ID” in the database. What three key issues should be addressed? (Choose three.)
A. How will Marketing Cloud and the database synchronize?
B. What will be used as Subscriber Key?
C. Will the company need a custom preference center?
D. What publication lists will be used?
E. Will new users have an “Customer ID”?
A. How will Marketing Cloud and the database synchronize?
C. Will the company need a custom preference center?
D. What publication lists will be used?
When joining a data extension in Contact Builder, in which scenario should a consultant mark the Use as Root checkbox?
A. Supplemental data for an interaction in Journey Builder.
B. One-to-Many Relationship to the Contact Record.
C. Data for both Email and MobileConnect sends.
D. Database of record other than All Subscribers.
D. Database of record other than All Subscribers.
ABC Company 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. A user-initiated message to send an email to customers who made a purchase daily.
B. A triggered message to send an email as soon as a customer completes a purchase.
C. A scheduled automation to send emails to customers who made a purchase daily.
D. A triggered automation to send emails to customers who have made a purchase.
B. A triggered message to send an email as soon as a customer completes a purchase.
Explanation: Transactional message (Order confirmation) requires triggered message.
A customer executes a large number of sends via Marketing Cloud connect and is concerned about API limits.
What should the consultant suggest to minimize the impact of Marketing Cloud Connect on daily API limits? (Choose two.)
A. Filter data
B. Upgrade the MC account to ConnectedApp
C. Turn off link details tracking
D. Turn off Individual Levels Tracking
B. Upgrade the MC account to ConnectedApp
D. Turn off Individual Levels Tracking
A customer wants to perform an email send to a subset of a Synchronized Data Extension referencing Sales Cloud custom object data and return tracking to Sales Cloud. What approaches should the consultant recommend? (Choose two.)
A. Use SQL Query Activities to create a Sendable Synchronized Data Extension.
B. Use Synchronized Data Sources to sync Sales Cloud objects to Marketing Cloud.
C. Use SQL Query Activities to output a Sendable Salesforce Data Extension.
D. Use Data Filters to segment data to output a Sendable Data Extension.
B. Use Synchronized Data Sources to sync Sales Cloud objects to Marketing Cloud.
C. Use SQL Query Activities to output a Sendable Salesforce Data Extension.
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?
A. My Reports
B. My Tracking
C. Data Views
D. Tracking Extract
B. My Tracking
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.
Which workflow should meet these requirements?
A. Triggered Automation: Import File > Group Refresh > Send Email(s)
B. Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
C. Triggered Automation: Import File > SQL Query(s) > Send Email(s)
D. Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)
C. Triggered Automation: Import File > SQL Query(s) > Send Email(s)
If a question is related to automation and it mentions that a file will be available in the FTP always at a specific time, your answer will be an option with a scheduled automation. Scheduled automations are used when you know the time a file is pushed into FTP and it always runs at a scheduled time. If a question is related to automation and there is an uncertainty when the file will be pushed to FTP (ex; a day before last working day / if a date falls on a weekend, it will be available on last Friday etc.), your answer will be an option with a Triggered Automation. Triggered Automation’s are fired as soon as a file hits a specific location within FTP. Transfer activity is involved when file in encrypted.
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?
A. 24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email
B. 24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email
C. Decision Split >24 hour Wait > Send Email > Decision Split > 48 hour Wait > Send Email
D. Decision Split >24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email
A. 24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email
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 would the consultant ensure that this requirement is met?
A. Ensure that the User is assigned as System Administrator in Sales Cloud.
B. Check the Scope by User box in Marketing Cloud.
C. Ensure that the User has the correct profile in Marketing Cloud.
D. Create a User in Sales Cloud with a System Administrator Profile.
B. Check the Scope by User box in Marketing Cloud.
A customer provides a file containing only new and updated subscriber records exported from its marketing database. The file will be uploaded to the customer’s Enhanced FTP automatically at 3 a.m. daily.
The customer requires that the import completes prior to 4 a.m.
On average, the file will contain about two million rows of data each day.
Based on the customer’s requirements and recommended best practices, how should the daily file be imported?
A. Import the file into a list, using the ‘update only’ method.
B. Import the file into a list, using the ‘add and update’ method.
C. Import the file into a data extension, using the ‘add and update’ method.
D. Import the file into a data extension, using the ‘overwrite’ method.
C. Import the file into a data extension, using the ‘add and update’ method.
Explanation:
Since Record count in more than 500 K so DE is used. New and Update is already specified in question.
Which three statements about Send Log Data is correct? (Choose three.) A. Can be stored for periods of time. B. Uses Measures, filters and programs. C. Added to a standard view. D. Accessed using query. E. Can be viewed in standard report.
A. Can be stored for periods of time.
B. Uses Measures, filters and programs.
D. Accessed using query.
Explanation:
Send Log data is not accessible through standard reports or standard view.
Which two statements about a database of record are correct? (Choose two.)
A. It is any data structure in which multiple opt-in statuses can be stored for a subscriber.
B. It is a system in which a subscriber’s status is maintained.
C. It is any database containing subscriber data.
D. It is a centralized storage repository of data about objects or people.
B. It is a system in which a subscriber’s status is maintained.
D. It is a centralized storage repository of data about objects or people.
A customer wants to integrate their website with Marketing Cloud so 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?
A. Configure a data structure using lists and leverage the out-of-the-box Preference Center.
B. Configure a relational data structure using data extensions and leverage a Web Collect form hosted in CloudPages.
C. Configure a data structure using lists and leverage a SmartCapture form the client can iFrame into their website.
D. Configure a relational data structure using data extensions and consult with the customer on API integration with their website.
D. Configure a relational data structure using data extensions and consult with the customer on API integration with their website.
Explanation:
Since Company has web developer so API integration is preferred solution.
Which two statements are correct about Send Logging? (Choose two.)
A. AMPscript can be used to pull data from Send Logs for use within emails.
B. Send Log data extensions are archived automatically based on retention settings.
C. A business unit can support up to three Send Logs.
D. SQL Query Activities can reference Send Logs in combination with system data views.
A. AMPscript can be used to pull data from Send Logs for use within emails.
D. SQL Query Activities can reference Send Logs in combination with system data views.
Explanation:
Send Log data extensions are never archived. Its deleted. A business unit can support only one Send Log.
A user receives a message stating that there is an error binding data bound member when testing an Entry Event in Journey Builder. What can a user do to ensure that contacts enter this interaction successfully based on the error message? (Choose two.)
A. Import new subscribers to the All Subscribers table.
B. Fire the event in both Automation Studio and the Entry Event.
C. Make sure the contact is above the High Water Mark on the source data.
D. Select a source DE with a root relationship to the contact.
C. Make sure the contact is above the High Water Mark on the source data.
D. Select a source DE with a root relationship to the contact.
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 used as part of the solution.
Which feature should be utilized to make this happen?
A. Send Logging
B. Publication Lists
C. Profile Center
D. Subscriber Keys
B. Publication Lists
If I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out.
What is the issue causing less emails to go out?
A. Preference center is too strict.
B. High Watermark if journey builder.
C. Email frequency too high.
D. Deliverability issues on account.
B. High Watermark if journey builder.
A customer has several values that need to be used in the body of an email send:
The data would 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 “Catch and release” sending. The reference data extension contains 25 columns.
What method should be used?
A. Dynamic content via the Dynamic Content Wizard.
B. AMPscript a single Lookup Function.
C. Server side JavaScript a single LookupOrderedRows Function.
D. AMPscript a single LookupOrderRows Function.
D. AMPscript a single LookupOrderRows Function.
Explanation:
AMPscript can simply and efficiently handle inline personalization or simple IF ELSE statements. Dynamic content is a set of predefined content elements that are displayed based on the value a specific recipient bears in a specific field / attribute AMPscript Lookup rows fetch dynamically content from a data extension based on the attribute that serves as the key value.
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 Marketing Cloud?
A. Unsubscribes should be synchronized between senders.
B. They will need to integrate with the Marketing Cloud SOAP API.
C. Engagement metrics will be passed into Marketing Cloud.
D. The third-party send list should be pulled from the CMS.
B. They will need to integrate with the Marketing Cloud SOAP API.
Because this is what required to meet requirement “Unsubscribes should be synchronized between senders” as well as “Engagement metrics will be passed into Marketing Cloud. “
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 content based on regional market.
In order for this solution to be viable, which skill set does the customer team need to possess?
A. HTML
B. SSJS
C. AMPscript
D. SQL
C. AMPscript
AMPscript can simply and efficiently handle inline personalization or simple IF ELSE statements. Dynamic content is a set of predefined content elements that are displayed based on the value a specific recipient bears in a specific field / attribute AMPscript Lookup rows fetch dynamically content from a data extension based on the attribute that serves as the key value.
An entertainment company is hosting events across the country in different venues. They want to use Contact Builder to feed Journey Builder. Contact who enter a journey will go through a decision split based on the type of event. The journey will send a series of emails and one of them will contain the venue details dynamically populated with AMP script. The Company collects the following information: - Customer data (email address, first name, last name…).
- Event registration (email address, event ID, event name, event type, venue ID…).
- Venue details (venue ID, venue name, venue address…).
- Payment details (email address, event ID, total paid…).
The Company does not want to link everything in Contact Builder.
Which are the two data sources that must be incorporated inside Contact Builder? (Choose two.)
A. Event Registration
B. Customer Data
C. Venue Details
D. Payment Details
B. Customer Data
C. Venue Details
A financial services customer states that families often share email addresses across multiple checking, savings, loan, and credit accounts. The customer needs to allow individual accounts to use the same email address in Marketing Cloud but maintain separate subscriber attributes.
Which component should be discussed with the customer to allow for this use case?
A. Subscriber Key
B. Contact ID
C. Data Extensions
D. Member Record
A. Subscriber Key
A company collects subscriptions on its website. It does the following:
Compiles 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 subscriber engagement with prior sends.
Which automation sequence (excluding waits) should cover these requirements?
A. File Transfer > Import File > Measures > Send Email
B. File Transfer > SQL Query > Measures > Send Email
C. File Transfer > Data Extract > Filters > Send Email
D. File Transfer > Import File > SQL Query > Send Email
D. File Transfer > Import File > SQL Query > Send Email
What is the capability of the Import within Contact Builder? (Choose two.)
A. The target destination can be a DE, list, or All Contacts for Mobile Push or Connect.
B. The data source can be a local file, data filter, or file on any FTP.
C. Like the Import Wizard, the Contact Builder import definition can be executed without saving.
D. In order to use Map by Header Row, the fields in the DE and file must match exactly.
A. The target destination can be a DE, list, or All Contacts for Mobile Push or Connect.
D. In order to use Map by Header Row, the fields in the DE and file must match exactly.
A data source cannot be a data filter so answer A is not right.
As part of their brand guidelines, ABC Company uses a custom brand font for all print marketing materials. ABC Company wants to use their custom brand font in email as well.
What is the recommended best practice for font usage in email?
A. Build an email as one image, with all text saved in the brand font.
B. Use a web-safe font for text that closely matches the brands custom font.
C. Edit an emails HTML to list the custom brand font in the style tags font-family property.
D. Build an email using multiple images, with all text saved in the brand font
B. Use a web-safe font for text that closely matches the brands custom font.
A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account’s Enhanced SFTP on a monthly basis on the 15th day of each month, expecting the email to be deployed upon completion of the import activity. However, if the 15th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15th and expect the promotional email to be sent on that Friday.
Which method should be used to automate their monthly promotional email?
A. Create a scheduled daily automation which includes an Import File Activity and Send Email Activity.
B. Create a file drop automation which includes an Import File Activity and Send Email Activity.
C. Create a scheduled monthly automation which includes an Import File Activity and triggered send.
D. Create a file drop automation which includes an Import File Activity and triggered send
B. Create a file drop automation which includes an Import File Activity and Send Email Activity.
Since Time is not fixed, its triggered Automation and User Initiated. Triggered send is used for transactional message.
A customer needs to link demographic information to its contact model in Contact Builder.
What type of relationship should be used?
A. One-to-Many Relationship
B. Many-to-One Relationship
C. Many-to-Many Relationship
D. One-to-One Relationship
A. One-to-Many Relationship
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? A. Guide Template Language B. Personalization strings C. AMPscript D. SQL Query
C. AMPscript
ABC Company 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 two.)
A. Marketing Cloud Channel Manager
B. Marketing Cloud Administrator
C. Marketing Cloud Email Marketing Manager
D. Marketing Cloud Regional or Local Administrator
A. Marketing Cloud Channel Manager
B. Marketing Cloud Administrator
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? A. Overwrite B. Update Only C. Add Only D. Add/Update
Which import type should be used?
A. Overwrite
In and Add/Update, you can never delete. In question, its being removed.
ABC Company 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 two.)
A. Assign Channel Managers the role of Marketing Cloud Analyst.
B. Assign Administration User permissions to individual users.
C. Assign Administration User permissions to the Channel Manager role.
D. Assign Administration User permissions to each business unit.
C. Assign Administration User permissions to the Channel Manager role.
D. Assign Administration User permissions to each business unit.
A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM 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?
A. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
B. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
C. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
D. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
C. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
No file transfer required because there is no file encryption required.
A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits.
What should the consultant suggest to minimize the impact of Marketing Cloud Connect on daily API limits?
A. Filter target audiences based on mapped profile attributes to reduce Bulk API calls.
B. Use Data Stream to sync object data into a Data Extension in the Marketing Cloud.
C. Share Sales Cloud user licenses across Marketing Cloud users.
D. Upgrade the Marketing Cloud Account to ConnectedApp Authentication.
D. Upgrade the Marketing Cloud Account to ConnectedApp Authentication.
Which data object should be used in conjunction with data extensions to create an opt-down strategy for customers? A. Profile attributes B. Publication Lists C. Preference Lists D. Preference attributes
B. Publication Lists