Simulado 3 Flashcards
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.âce’ The customer requires that the import completes prior to 4 a.m.âce’ 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.
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.
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.
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.
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:âce’ The data would be stored in a reference data extension, related on SubscriberKey.âce’ There may be one or more records for each subscriber.âce’ The audience is generally over 1 million subscribers.✒ The content is time sensitive and should be sent as quickly as possible.âce’ The customer is not using “Catch and release” sending.âce’ 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 LookupOrdered Rows Function.
D. AMPscript a single LookupOrderRows Function.
D. AMPscript a single LookupOrderRows Function.
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).âce’ 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.
OC. 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.
A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. The customer has indicated the following:âce Emails will be built using a custom dynamic template for these messages.âce’ Links will vary over time and across campaigns.✒ Click activity will be cross-referenced with subscribers’ regional markets on a master subscriber data extension.âce’ 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
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
OD. Member Record
A. Subscriber Key
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.
Northern Trail Outfitters (NTO) wants to implement a cross-channel automated marketing solution that provides real-time messaging on a customer by customer basis. They have limited resources to manage this on their own once the initial implementation has been completed.Which three details should be verified to properly guide a solution they can manage after the initial implementation? (Choose three.)
A. Does NTO have personnel to configure the (sub)domain for sending emails?
B. Is the necessary data currently stored in a centralized location?
C. Does NTO have people with Marketing Cloud skills and/or certifications within the team?
D. Does NTO need a declarative-only approach?
E. What size should the team responsible for the implementation after go-live be?
A. Does NTO have personnel to configure the (sub)domain for sending emails?
C. Does NTO have people with Marketing Cloud skills and/or certifications within the team?
E. What size should the team responsible for the implementation after go-live be?
A B2B customer notices they have a large number of subscribers marked as ËœHeld'. During troubleshooting, they realize these were soft bounces from overwhelming the email servers of many of the small companies with which they do business. What step(s) should the customer take to move those subscribers back to ËœActive’?
A. Use a SQL query to change all subscribers with a status of ‘Held’ to ‘Active’ in All Subscribers.
B. Use Contact Builder to mass update all ‘Held’ subscribers to ‘Active’ status.
C. Extract subscribers who have a status of ‘Held’, then import subscribers as ‘Active’.
D. Subscribers with a status of ‘Held’ should be re-enabled by contacting support.
C. Extract subscribers who have a status of ‘Held’, then import subscribers as ‘Active’.
Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way. What should be recommended?
A. Implement a new SSL Certificate for the new brand.
B. Request a second SAP for the existing business unit.
C. Create a new business unit for the new brand.
D. Request a Private Domain to be added to the existing business unit.
D. Request a Private Domain to be added to the existing business unit.
A customer is using Marketing Cloud Connect but not sending tracking back to Sales Cloud. They want to create a Task on Contact and Lead records for follow up when someone has not opened five emails in a row.Which activities could be used to fulfill this requirement?
A. API Event Entry, SQL Query Activity, Task Activity
B. Scheduled Automation, Filter Activity; Data Extension Entry, Contact Activity
C. Salesforce Data Entry, SQL Query Activity, Task Activity
D. Scheduled Automation, SQL Query Activity; Data Extension Entry, Task Activity
B. Scheduled Automation, Filter Activity; Data Extension Entry, Contact Activity
A marketer wants to capture open-ended feedback from customers via SMS and write it to a data extension.How could MobileConnect be used to accomplish this?
A. Use an outbound message template with embedded AMPscript to capture the response.
B. Use an info capture message template to capture the response.
C. Use a text-response message template with embedded AMPscript to capture the response.
D. Use a vote/survey message template to capture the response.
B. Use an info capture message template to capture the response.
Northern Trail Outfitters sends emails for Password Resets from their web store when requested. An SMS message should be deployed if the password reset email is not sent. What processes should they utilize to ensure a timely delivery across email and SMS?
A. Transactional email send with the event notification service response to determine and trigger an API call to an SMS message
B. Multiple path journey with engagement split if password reset link clicked; if link not clicked, then SMS Password Reset activity
C. Triggered send definition, and use API response to determine and send API call to trigger an SMS password reset
D. Triggered send definition and use data extract Not Sent to a data extension then send SMS to those failed sends
D. Triggered send definition and use data extract Not Sent to a data extension then send SMS to those failed sends
