SFDC Marketing Cloud Consultant Practice Exam
Settings
-
+
It's probably the best tool for digital marketers at current. It's a customer relationship management (CRM) platform for all the marketing professionals that allows them to create and manage marketing relationships with their customers. Well, we have created this practice test for all those individuals who are looking towards cracking this exam to be a certified professional in the same field.
- 1.An online retail customer needs daily promotional email content to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose. The customer has communicated the following: The email content will highlight new inventory each day A small team will run both their digital marketing operations and their email programs A user needs to build, test, and send a daily email in less than an hour Images for the emails will be hosted on their website CMS Which question is relevant to identify strategies for designing the custom template for the customer’s daily promotional email? Choose 3:
- A.
How often will the layout of the content in a content area change?
- B.
What is the maximum file size of the images being used?
- C.
What From Name will be used for these emails?
- D.
Will image URL’s be available publicly?
- E.
How often will email content be image-only with text overlaying images?
- 2.
- A.
How will Marketing Cloud and the database sync up?
- B.
Will new users have an “Email ID”?
- C.
What will be used as the Subscriber Key?
- D.
What publication lists will be used?
- E.
Will the company need a custom preference center?
- 3.
- A.
Should customers exit the journey when the goal is met?
- B.
How are subscribers identified in your web analytics?
- C.
How many messages should be included in each journey?
- D.
How long after the behavior occurs will a subscriber need to enter a journey?
- E.
Should a single customer exist in multiple journeys at the same time?
- 4.
- A.
Use a web-safe font for text that closely matches the brand’s custom font
- B.
Build an email as one image, with all text saved in the brand font.
- C.
Edit an email’s HTML to list the custom brand font in the style tag’s font-family property
- D.
Build an email using multiple images, with all text saved in the brand font
- 5.
- A.
Increase volume of emails to a wider audience
- B.
Increase the use of dynamic content in emails
- C.
Adopt a Cart Abandonment Email Campaign
- D.
Introduce more identity verification steps in check out process
- 6.
- A.
Will customers be able to sign up for the loyalty program at the store?
- B.
Is the purpose of these emails for acquisition or retention or transactional?
- C.
Will multiple languages be used, with a “From Name” lookup table needed?
- D.
Will version values/meanings change. Precluding reusable AMPscript?
- 7.
- A.
Publication lists
- B.
Subscriber Keys
- C.
Profile Center
- D.
Send Logging
- 8.
- A.
Subscriber Key
- B.
Contact ID
- C.
Member Record
- D.
Data Extensions
- 9.
- A.
AMPscript
- B.
SSJS
- C.
SQL
- D.
HTML
- 10.
- A.
Data extensions allow for add/update Import activity
- B.
Data extensions can store HTML code as an attribute
- C.
Data extensions support Customer ID to be used as Subscriber Key
- D.
Data extensions are necessary for Contact Builder
- 11.A publishing company has presented the following: A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical The customer’s expiration data is included in the data file What component should the customer’s solution include? Choose 3:
- A.
Suppression List
- B.
Data Filter
- C.
Triggered Sends
- D.
Template-based emails
- E.
Automation Studio
- 12.
- A.
Use the web analytics platform to trigger behavioral marketing emails
- B.
Track web activity from a click on an email URL back to a specific email campaign
- C.
Pass web conversation data back into Marketing Cloud for use in email reporting
- D.
Recognize web traffic as originating from email instead of another channel
- E.
Match subscribers to web activity by passing Subscriber ID through email links
- 13.
- A.
Campaign Email Tracking Report
- B.
Email Performance Over Time Report
- C.
Email Send Report
- D.
Option 4
- 14.
- A.
Configure a relational data structure using Data Extensions and consult with the customer on API integration with their website
- B.
Configure a data structure using Lists and leverage a SmartCapture form that the client can iFrame into their website
- C.
Configure a relational data structure using Data Extensions and leverage a SmartCapture form that is hosted in Landing Pages.
- D.
Configure a data structure using Lists and leverage the out-of-the-box Preference Center
- 15.
- A.
Pick “Choose from list” selecting the from name and from email values from the list of account users
- B.
Utilize data extension AMPscript lookups to dynamically populate the from name and from email values
- C.
Match the external keys of the sender profile and data extension containing account representative details
- D.
Populate substitution strings in the sender profile for the profile attributes containing from name and from email values
- 16.
- A.
IP ramp-up takes four to six weeks to be able to fully send to all 3 million customers
- B.
IP ramp-up can be accelerated by migrating to pre-warmed IP addresses
- C.
IP ramp-up is important to establish a positive sender reputation
- D.
IP ramp-up can be bypassed, given their historical lack of deliverability issues
- 17.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.
Check the Scope by User box in Marketing Cloud
- B.
Create a User in Sales Cloud with a System Administrator profile
- C.
Ensure that the User has the correct profile in Marketing Cloud
- D.
Ensure that the user is assigned as System Administrator in Sales Cloud
- 18.
- A.
Create a Salesforce Data Extension for the user to select during a Guided Send
- B.
Assign the integrated user the Marketing Cloud AppExchange User permission set in Sales Cloud
- C.
Create data validation rules for the integrated user in Sales Cloud
- D.
Add customer links to the page layouts in Marketing Cloud
- 19.A customer wants to send an email from Sales Cloud on behalf of the record owner How should the consultant meet this requirement? Choose 2:
- A.
Use the Organization-Wide Email Address
- B.
Use a custom Delivery Profile
- C.
Use a custom Send Classification
- D.
Use the Send From Records Owner option
- 20.
- A.
Use Data Stream to sync Sales Cloud objects to the Marketing Cloud
- B.
Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension
- C.
Use Query Activities to create a Sendable Synchronized Data Extension
- D.
Use Data Filters to segment data to output a Sendable Data Extension
- 21.
- A.
Create a custom Email Specialist role with needed permissions and assign it to the Email Specialist
- B.
Alter the roles of Content Creator and Data Manager by denying permissions and then assign the roles to the Email Specialists
- C.
Check “Allow” automation permissions for the Content Creator Role and assign it to the Business Units
- D.
Check “Allow” automation permissions for the Content Creator Role and assign it to the Email Specialists
- 22.NTO needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks Maintain NTO master suppression list Configure data relationships Create new subscriber attributes Which role should be assigned to the IT staff member?
- A.
Analyst
- B.
Data Manager
- C.
Administrator
- D.
Content Creator
- 23.A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices Which reason warrants this implementation>
- A.
Support non-english responses with Reply Mail Management
- B.
Localized language and display options based on location and culture
- C.
Tracking information for campaigns sent by each office Localized physical mailing address displayed in the default email footer
- D.
Localized physical mailing address displayed in the default email footer
- 24.NTO has doubled in size over the last couple of years. Because of this growth they have decided to organize their company into Business Units to better manage operations Which statements is correct regarding the Business Unit functionality within Marketing Cloud? Choose 2
- A.
Business Units can have more than one parent Business Unit
- B.
Subscribers can only appear in one Business Unit
- C.
Business Units can mirror an organization’s operational structure
- D.
Business Units can share information with other Business Units
- 25.
- A.
Confirm that Reply Mail Management (RMM) is configured for the customer’s account
- B.
Confirm that the RMM setting ‘Unsubscribe Manual Request’ is set to YES
- C.
Confirm that the RMM setting ‘Delete auto-replies and out-of-office replies’ are set to NO
- D.
Confirm that an email address was provided as the Routing Address for Remaining Replies
- E.
Confirm that the subscriber’s request contained one of the standard terms that qualify for automatic unsubscribe
- 26.To fuel their expansion, NTO recently acquired Eagle Outfitters (EO). There is currently a 30 percent overlap between the guests of each brand and they will be pursuing cross-marketing opportunities. It was recommended that their Marketing Cloud account now include a separate business unit for EO and the company secure a new sender authentication package for EO using the private domain e-EO.com. Select the statement that correctly describes the implication of this recommendation Choose 2
- A.
The IP address included in the sender authentication package will have the same reputation as the ones being used for NTO
- B.
The EO business unit can also have the NTO authentication package applied simultaneously for cross-marketing emails
- C.
The private domain, e-EO.com, will be used for all link wrapping, image URL’s, and landing page URL’s
- D.
The e-EO.com domain will act as the form address for the emails and authenticate using SPF, SenderID, and DKIM authentication
- E.
The email headers for EO will still reflect the private domain for NTO since that is the parent company
- 27.
- A.
Report activity that generates Recent Send Summary Report > Report delivered directly to FTP
- B.
Extract activity of Tracking Extracts that combines data into required file > Transfer activity
- C.
Query activity to pull data view information > Extract activity of data extension > Transfer activity
- D.
Extract activity of data view tables > Query activity to create the required file > Transfer activity
- 28.A daily deal website is concerned with their sender reputation and needs consistent visibility into subscribers who report their email as spam. How can 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 generates the Unsubscribe Event Extract
- C.
An automation that queries the Unsubscribe data view
- D.
An automation that generates the Complaint Tracking Extract
- 29.What is a correct statement about Send Log Data? Choose 3
- A.
Can be incorporated into standard reports
- B.
Can be stored for a set period of time
- C.
Can be added to a standard data view
- D.
Can be included in measures and filters
- E.
Can be accessed via Query activities
- 30.Which data object should be used in conjunction with data extensions to create an opt-down strategy for customers?
- A.
Profile attributes
- B.
Preference attributes
- C.
Publication Lists
- D.
Preference Lists
- 31.What are data extension data retention policies?
- A.
Settings to “soft” delete all data in a Data Extension so there is no data loss
- B.
Settings to control when a data extension creates a back-up of the data it contains
- C.
Settings to define when a data extension or the data within the data extension is deleted
- D.
Settings to prevent users from deleting a Data Extension created by another user
- 32.A customer would like to store financial data related to invoicing in its data extension. Which field type should be used?
- A.
Currency
- B.
Decimal
- C.
Number
- D.
Float
- 33.
- A.
SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2. OrderDate, T2. ShippedDate FROM Subscribers T1 INNER JOIN OorderTable T2 ON T1.CustomerID=T2.CustomerID
- B.
SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2. OrderDate, T2. ShippedDate FROM Subscribers T1 Left JOIN OorderTable T2 ON T1.CustomerID=T2.CustomerID
- C.
SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2. OrderDate, T2. ShippedDate FROM Subscribers T1 OUTER JOIN OorderTable T2 ON T1.CustomerID=T2.CustomerID
- D.
SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2. OrderDate, T2. ShippedDate FROM Subscribers T1 RIGHT JOIN OorderTable T2 ON T1.CustomerID=T2.CustomerID
- 34.
- A.
Import the file to a data extension, using the add and update method
- B.
Import the file to a list, using the “update only” method
- C.
Import the file to a list, using the “add and update” method
- D.
Import the file to a data extension, using the “overwrite” method
- 35.
- A.
Engagement metrics will be passed into Marketing Cloud
- B.
They will need to integrate with the Marketing Cloud SOAP API
- C.
Unsubscribes should be synchronized between senders
- D.
The third-party send list should be pulled from the CMS
- 36.What is a correct statement about a database of record? Choose 2:
- A.
A database of record is a centralized storage repository of data about objects or people
- B.
A database of record is any database containing subscriber data
- C.
A database of records is a data structure in which multiple opt-in statuses can be stored for a subscriber
- D.
A database of record is a system in which a subscriber’s status is maintained
- 37.
- A.
A scheduled automation that starts at 2 am, that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity and Send Email Activity
- B.
A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity and Send Email Activity
- C.
A scheduled automation that starts at 2 am, that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity and Send Email Activity
- D.
A scheduled automation that starts at 12 am and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activities and Send Email Activity
- 38.
- A.
File Transfer, Data Extract, Filter, Sends
- B.
File Transfer, Query, Measures, Sends
- C.
File Transfer, Import, Measures, Sends
- D.
File Transfer, Import, Query, Sends
- 39.
- A.
Triggered Automation: Import File > SQL Query > Send emails
- B.
Scheduled Automation: Transfer File > Import File > SQL Query > Send Emails
- C.
Scheduled Automation: Import File > SQL Query > Send Emails
- D.
Triggered Automation: Import File > Group Refresh > Send Emails
- 40.
- A.
Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email
- B.
Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email
- C.
Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email
- D.
Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
- 41.
- A.
Create a triggered automation that includes an import activity and triggered send
- B.
Create a scheduled daily automation that includes an import activity and user-initiated send
- C.
Create a scheduled monthly automation that includes an import activity and triggered send
- D.
Create a triggered automation that includes an import activity and user-initiated send
- 42.
- A.
Triggered send
- B.
Guided Send
- C.
Automated Send
- D.
User-Initiated Send
- 43.
- A.
Personalized Strings
- B.
AMPscript
- C.
SQL Query
- D.
Guided Template Language
- 44.Which one do you like?
- A.
Option 1
- B.
Option 2
- C.
Option 3
- D.
Option 4
- 45.
- A.
AMPscript a single Lookup Function
- B.
Serve Side Javascript a single LookupOrderedRows Function
- C.
AMPscript a single Lookup OrderedRows Function
- D.
Dynamic content via the Dynamic Content Wizard
- 46.
- A.
Tracking aliases are found in Tracking and some standard reports
- B.
Tracking aliases are associated with a URL in HTML as: tag=”alias text”
- C.
Tracking aliases can differentiate click activity in an email to the same URL
- D.
Tracking aliases are primarily relevant when used with email conversion tracking
- 47.
- A.
The data source can be a local file, data filter, or file on any FTP
- B.
The target destination can be a DE, list, or All Contacts for Mobile Push or Connect
- 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
- 48.NTO plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships. NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database What action should be taken when using Contact Builder? Choose 2
- A.
Conduct manual imports of customer information from Sales Cloud
- B.
Create a data extension to incorporate the imported data from a Salesforce Dashboard
- C.
Combine each individual’s channel contact information under one record
- D.
Use Marketing Cloud Connect to include data from Sales Cloud
- 49.
- A.
Create a new Attribute Group referencing all the email address fields in Data Designer
- B.
Create a new Import to populate subscriber email addresses into All Subscribers
- C.
Add all email address fields into the Mobile Application and Predictive Intelligence Applications
- D.
Add all email address fields into the Contact Configuration screen in the correct order
- 50.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.
Database of record other than All Subscribers
- C.
One-to-many Relationship to the Contact Record
- D.
Data for both Email and MobileConnect Sends
- 51.A customer has three data extensions that need to be added to Contact Builder Customers contains customer information Orders contains order information Products contains product information
- A.
Customer Data Customers Orders Products
- B.
Customer Data Customers Orders Products
- C.
Customer Data Customers Orders Products
- D.
Option 4
- 52.What statements are correct regarding Attribute Groups? Choose 2:
- A.
They link data extensions to subscriber lists
- B.
They link data extensions to contacts
- C.
They link data extensions to other data extensions
- D.
They link subscriber lists to contacts.
- 53.NTO is considering adopting Attribute Groups when incorporating data from their external systems. What statements are accurate regarding Attribute Groups? Choose 2:
- A.
They can contain only one data extension
- B.
They can be created by templates to accomplish certain tasks
- C.
They link data extensions to other data extensions or contacts
- D.
They replicate the structure from the external system data into templates
- 54.
- A.
Automation Studio and Journey Builder allow users to define a wait state based on duration or duration + time
- B.
Automation Studio allows users to inject Contacts from a data extension into an interaction in Journey Builder
- C.
Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool
- D.
Journey Builder allows users to update a contact records in an interaction or import data into a data extension
- E.
Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely
- 55.
- A.
Engagement Split > Send Email > Wait > Random Split > Send Email
- B.
Random Split > Send Email > Join > Decision Split > Wait > Send Email
- C.
Random Split > Send Email > Wait > Engagement Split > Join > Send Email
- D.
Decision Split > Send Email > Engagement Split > Send Email
- 56.
- A.
Define Goal, Send Email, Wait, Decision Split
- B.
Random Split, Send Email, Wait, Define Goal
- C.
Define Goal, Update Contact Data, Send Email, Wait
- D.
Update Contact Data, Wait, Send Email, Join
- 57.A customer wants to create a Journey with the goal of making users activate their accounts within 72hrs or 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 an activation reminder emails 24 and 48hrs after creating an account. The user exits the journey if they activate their account. Which activities should be included in the customer’s journey?
- A.
24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email
- B.
Decision Split > 24 hour Wait > Send Email > Decision Split > 48 hour Wait > Send Email
- C.
24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email
- D.
Decision Split > 24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email
- 58.
- A.
Select a source DE with a root relationship to the contact
- B.
Make sure the contact is above the High Water Mark on the source data
- C.
Import new subscribers to the All Subscribers table
- D.
Fire the event in both Automation Studio and the Entry Event
- 59.
- A.
The interaction allows re-entry only after exiting, and the contact already exists
- B.
The contact falls below the High Water Mark
- C.
The interaction has an A/B/n split, and the contact does not meet the criteria
- D.
The entry event was not fired via Automation Studio
- E.
The contact did not meet the entry criteria
- 60.
- A.
Filter target audiences based on mapped profile attributes to reduce Bulk API calls
- B.
Upgrade the Marketing Cloud Account to ConnectedApp Authentication
- C.
Use Data Stream to sync object data into a Data Extension in the Marketing Cloud
- D.
Share Sales Cloud user licenses across Marketing Cloud users.
- 61.
- A.
No re-entry
- B.
Re-entry anytime
- C.
Re-entry only after exiting
- D.
Re-entry after time
- 62.
- A.
Data extension with opt in status
- B.
Send email activity which contains a link to subscription center
- C.
WebCollect
- D.
SmartCapture
- 63.Collect addresses through SmartCapture, segment the data, send emails referencing data from a data extension What skillset is needed?
- A.
AMPscript
- B.
HTML
- C.
CSS
- D.
SQL
- 64.What are two ways Contact Builder can alter the data in Data Extensions
- A.
Add single record
- B.
Extract data
- C.
Clear records
- D.
Option 4
- 65.How are publication lists used in the Marketing Cloud?
- A.
To send communication to all subscribers, regardless of opt-in status
- B.
To manage subscribers in guided and triggered email sends
- C.
To build dynamic content rules by subscriber type
- D.
To allow subscribers to opt-down/out instead of unsubscribing from all
- 66.
- A.
Open and click activity are tracked in either version
- B.
The email will avoid detection by various SPAM filters
- C.
An auto-generated text version will be sent with your HTML email
- D.
A custom text version will be sent with your HTML email
- 67.NTO needs to reduce the amount of work when managing messages to customer, 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 file drop automation to send emails to customers who have made a purchase
- B.
A user-initiated message to send an email to customers who made a purchase daily
- C.
A scheduled automation to send emails to customers who made a purchase daily
- D.
A triggered message to send an email as soon as a customer completes a purchase
- 68.
- A.
Overwrite
- B.
Add Only
- C.
Add/Update
- D.
Update Only
Back to top