0% SFMC Consultant Certification Mock TestDive into our comprehensive mock test designed for aspiring SFMC Consultants. This test simulates the real certification exam, helping you gauge your readiness and identify areas of improvement.IntroductionPreparing for the SFMC Consultant certification? Our mock test is tailored to help you get a feel for the real exam. With questions curated by industry experts, you can be sure to test your knowledge on all relevant topics.FeaturesOver 100 multiple-choice questions.Timed test to simulate real exam conditions.Instant feedback on answers.Detailed explanations for each question. 1 / 60Marketing Cloud is divided in four primary groups: Messaging and Automation, Data and Advertising, Social Media, and Measurement and Analytics. Which of the following are not the part of MC Messaging and Automation Mobile Studio Advertising Studio Journey Builder MC Intelligence 2 / 60Journey Builder lets you map out the customer journey and adjust the customer's path based on behavior and allows marketers to orchestrate interactions across different channels and touchpoints? True False 3 / 60 What can we use to identify each single Core account, top-level Enterprise or Enterprise 2.0 accounts, Agency account, and any associated child accounts? Tenants Member ID Subdomain 4 / 60Marketing Cloud product we can use to visualize AI-powered real-time insights and create actionable reports across channels and campaigns to drive ROI is: Advertising Studio MC Personalization MC Intelligence Data Cloud 5 / 60A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices. Which reason warrants this implementation? Support non-English responses with Reply Mail Management Localized language and display options based on location and culture. Tracking information for campaigns sent by each office. Localized physical mailing address displayed in the default email footer 6 / 60When we are talking about API development, SQL, system integrations, email coding, audience segmentation, filtering and creating customer views, we are talking about which Task Group? Strategy and Planning Marketing Technology Data and Analytics Creative and Content 7 / 60Salesforce supports several different types of objects. There are standard objects, custom objects, external objects, platform events, and BigObjects. Select common business objects that are Salesforce standard objects (choose three): Lead Property Account Contact 8 / 60A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and Products. The data extensions contain the following information:- Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal- Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount- Products: ProductId, SKU, Name, Description, Cost, PriceWhich two actions should be taken in Data Designer? Choose 2 answers: Create a one-to-one relationship between the contact record and Order Details Create a one-to-many relationship between Orders and Order_Details Create a one-to-one relationship between Orders and Order_Details Create a one-to-one relationship between Order_Details and Products 9 / 60A customer is developing a new eCommerce section of their website and plans to leverage transactional data in customer journeys. Which two Marketing Cloud features will support this effort? Choose 2 answers: Data Designer Cloud Pages Web Analytics Connector Content Builder 10 / 60What is the capability of the Import within Contact Builder? Choose 2 answers: The data source can be a local file, data filter, or file on any FTP The target destination can be a DE, list, or All Contacts for Mobile Push or Connect 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 11 / 60A 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? Ensure that the User is assigned as System Administrator in Sales Cloud Check the Scope by User box in Marketing Cloud Ensure that the User has the correct profile in Marketing Cloud Create a User in Sales Cloud with a System Administrator Profil 12 / 60Can multiple Sales or Service Cloud Orgs be connected to one Marketing Cloud account? Yes No 13 / 60A customer wants to implement a Welcome email. New subscribers signing up on their website should receive the email promptly. They are utilizing Marketing Cloud Connect to connect Sales Cloud and Marketing Cloud. Which solution should capture the new subscribers? Smart Capture form on website Salesforce Triggered Sends File import to data extension Batch file dropped to SFTP 14 / 60A 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 are not recommended? (Choose two.) Use SQL Query Activities to create a Sendable Synchronized Data Extension Use Synchronized Data Sources to sync Sales Cloud objects to Marketing Cloud Use SQL Query Activities to output a Sendable Salesforce Data Extension Use Data Filters to segment data to output a Sendable Data Extension 15 / 60A customer wants to send a welcome email to Contacts when a Contact record is added as a Campaign Member to a 'Loyalty Member' Campaign in Sales Cloud. Which method should they use to send the email from Marketing Cloud? Create a scheduled Automation with a Query Activity and a Send Email Activity Create a Journey with a Salesforce Campaign entry source and an Email Activity Create a Journey with a Salesforce Data entry source and an Email Activity 16 / 60By default, each Marketing Cloud instance is configured as a Multi-Org. True False 17 / 60Marketing Cloud licenses are only required for Distributed Marketing Cloud system users. True False 18 / 60Which of the following is not supported for Marketing Cloud Connect features? Salesforce Enterprise Lightning Experience Developer Edition Sandbox 19 / 60Who is the person that can access Marketing Cloud Connect functionality in the Sales or Service Cloud, Marketing Cloud, or both? Marketing Cloud Connect User Salesforce System User Marketing Cloud Administrator 20 / 60Which integration provides insight into customer engagement behavior with a single view of a contact or lead? Journey Builder Integration Campaign Member Integration Email Studio Integration CloudPages Integration 21 / 60Multi-Org requires a new or separate installation of Marketing Cloud Connect. True False 22 / 60You can push tracking data from the Marketing Cloud back to your Sales or Service Cloud orgs using: Synchronized Data Extensions Shared Data Extensions Salesforce Data Extensions 23 / 60A Marketing Cloud administrator is asked by the Legal Team to automatically process certain keywords (such as “Unsubscribe”) when received as a reply to an email send, and to remove the Out of Office replies to help the team better interact with customer responses. Which functionality should they use? Reply Mail Management Tracking Extracts SQL Query Preference Management Center 24 / 60A Marketing Cloud admin has created some profile attributes, but doesn’t want the customer to see them in the profile center. How should the attributes be configured? Mark the attribute as hidden Mark attribute as read-only Mark attribute as a profile attribute Mark attribute as a preference center attribute 25 / 60A customer is adding Mobile Studio to its marketing tools. Currently, NTO uses Email Studio and Journey Builder to send email messages. They are using a unique alphanumeric as the Subscriber Key in Email Studio. What should the administrator do to prevent duplicates across all Marketing Cloud channels? Use Merge functionality for new Mobile contacts Use a single Contact Key value Use a channel-specific unique identifiers 26 / 60Reply Mail Management addresses automated replies produced by nearly all email software in use today. Which percentage of auto-replies RMM handles? 85% 60% 90% 40% 27 / 60Custom Domain for CloudPages SAP feature modifies view-as-a-webpage, link and image wrapping, and removes all references to Marketing Cloud in favor of your custom authenticated domain? True False 28 / 60Sending a minimum of X email messages per month is required for keeping a dedicated IP ramped up from a reputation perspective. 200000 250000 300000 29 / 60Which MobileStudio feature allows us to send surveys in order to receive the opinion of customers regarding their preferences? MobilePush MobileConnect GroupConnect 30 / 60 Client assigns a 15-digit integer as their OrderID which will be used as the primary key of a DE. The import file contains leading zeroes, but the client does not want to include them in the final values. Which data type should they use for the Order ID field? Decimal Integer Number Text 31 / 60A 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 and separated into two different data extensions. Which workflow should meet these requirements? Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2 Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2 File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2 File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1 32 / 60What storage model should be used if a subscriber has more than one value for an attribute? Profile Attribute Data Extensions Publication Lists Lists 33 / 60A 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 markets.In order for this solution to be viable, which skill set does the customer team need to possess? AMPscript SSJS SQL HTML 34 / 60What are two possible outcomes when "Send as Multipart MIME" is selected during the send process? Choose 2 answers: Open and click activity are tracked in either version The email will avoid detection by various SPAM filters An auto-generated text version will be sent with your HTML email A custom text version will be sent with your HTML email 35 / 60 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? Publication Lists Subscriber Keys Profile Center Send Logging 36 / 60A customer wants to perform an email send to a subset of a Synchronized Data Extension filtered on custom object data and return tracking to the Sales Cloud. What approach should the consultant recommend? Choose 2 answers: 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 Use Query Activities to create a Sendable Synchronized Data Extension Use Data Filters to segment data to output a Sendable Data Extension 37 / 60Which statement is correct regarding tracking aliases? Choose 2 answers: Tracking aliases are found in Tracking and some standard reports 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 38 / 60A customer would like to store financial data related to invoicing in its data extensions. Which field type should be used? Currency Decimal Number Float 39 / 60A publishing company has presented the following:- A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.- A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.- The customer's expiration date is included in the data file.What component should the customer's solution include? Choose 3 answers: Suppression list Data Filter Triggered Send Template-based emails Automation Studio 40 / 60Configuring an attribute group can let you use current, updated contact-driven data in your journey activities. True False 41 / 60A 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? An automation that queries the Complaint data view An automation that generates the Unsubscribe Event Extract An automation that queries the Unsubscribe data view An automation that generates the Complaint Tracking Extract 42 / 60Which of the following is not considered as the Salesforce Data Model key? Primary Key Composite Key Foreign Key Contact Key 43 / 60If using Marketing Cloud Connect, it is best practice to use the Lead or Contact ID as the contact key, to automatically sync with Sales Cloud and Service Cloud data and have a consistent identifier across all clouds. True False 44 / 60How long do Data Views store data? 3 months 6 months 1 year 45 / 60What is the cardinality for connecting a customer data extension to a purchases data extension, where each customer can have multiple purchases? One-to-one One-to-many Many-to-one Many-to-many 46 / 60 Data Views fields can be customized. True False 47 / 60The least performant option for writing data into the DE that can significantly extend your query time is: Append Update Overwrite 48 / 60There are few ways of getting data into the Marketing Cloud. Select activities that cannot be automated: Import Activity File Drop Manually Import Schedule 49 / 60When you import an encrypted file from an external FTP, why are two File Transfer activities needed? One to download the file to your desktop and one to transfer to the safehouse One to decrypt the file and one to import the data One to transfer to the safehouse and one to decrypt the file 50 / 60Which one is not an unsubscription level under Marketing Cloud? Data Extension unsubscription List unsubscription Global unsubscription Business Unit unsubscription 51 / 60What two data models are available in Marketing Cloud? Data Extensions All Subscribers Filters Lists 52 / 60 In which folder you can find Data Extensions that are shared across different Business Units? My Subscribers Shared Salesforce Data Extension Shared Data Extension Filtered Data Extension 53 / 60The best practice is to add all required fields to Send Log DE when creating it, to collect all historical data. Which of the following are not required, but can be added as custom fields in Send Log DE? Send Date JobID ListID Email or Campaign Name TriggeredSendID SubID 54 / 60If a subscriber is unsubscribed from the All Subscribers list, the subscriber is unsubscribed from all Publication lists automatically. True False 55 / 60What are the different email sending options in Email Studio? Choose three: Triggered Sends Campaign Sends Single Sends User-initiated Sends Automated Sends 56 / 60When sending messages to mobile numbers within a specific country, use: More than 200 characters Valid short or long codes In-App messages 57 / 60 Which of the following is not MobileConnect send status? Scheduled Canceled Deleted Failed 58 / 60Which one supports Facebook Messenger? In-App Messages GroupConnect Journey Builder Email Studio 59 / 60Which feature protects deliverability by identifying bad or flagged email addresses and prevents sending the email message, so the send doesn’t appear in your tracking? Send Classification Data Retention List Detective CAN-SPAM 60 / 60 If you are doing A/B Testing on more than 50000 subscribers, it is recommended sending to X% per each condition. 10% 3% 5% 12% Your score isThe average score is 37% 0% Restart quiz