Free Link Your Salesforce Data using Marketing Cloud Connect Exam MCC-201 Exam Practice Test

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:*Imported iota a staging data extension.*Separated into two different data extensions.Which automation should meet these requirements?

• Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
• File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
• Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
• File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Northern Trail Outfitters wants to import their Sales Cloud data into Marketing Cloud to leverage it within Journey Builder. They have approximately 10 million customers and the data needs to be available with a delay of no more than 30 minutes. Only customers where the consent checkbox is selected in Sales Cloud should be imported, which represents approximately half of their customer databaseWhat should they implement?

• All Subscribers, since these are synchronized in real time
• Import from Salesforce Report in Automation Studio
• Event Data from the Entry Event in Journey Builder
• Synchronized Data Extensions with a filter

Northern Trail Outfitters uses separate Marketing Cloud accounts as environments for development, UAT, and production. They want to test all automations and Journeys In each environment prior to launching in production.Which extension product should be used to speed up the migration of data extensions and Journey Builder configurations between each environment?

• Configuration Manager
• Change Sets
• Deployment Manager
• Ant Migration Tool

A user in the MC wants to use salesforce custom object data for segmenting and personalization.How should the consultant approach this requirement?

• Export report data from the sales cloud and import into a marketing cloud synchronized data extension. Use a filter activity to produce a sendable data extension. Create an email send activity in Automation Studio
• Sync contact and custom objects with Data Stream and send from Synchronized Data Extension with Salesforce email send. Ensure there is a lookup relationship to a contact or lead record.
• Create a custom report type that contains the contact or lead ID, email address, and custom object data, then from the marketing cloud, import into a Salesforce Data extension. Use AMPScript in the email to call data
• Map the custom objects to the profile center and use the email editor to insert the custom data. Create a user-initiated send to associate the email to the largest audience and return tracking data.

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? Select one.

• High Watermark if journey builder
• Preference center is too strict
• Deliverability issues on account
• Email frequency too high

Which three statements are correct regarding the automation tools in Marketing Cloud?Choose 3 answers

• Automation Studio and Journey Builder allow users to repeat an interaction indefinitely.
• Journey Builder allows users to inject Contacts from a data extension which is updated by Automation Studio.
• Journey Builder allows users to update a contact record in a journey or import data into a data extension.
• Automation Studio and Journey Builder allow users to define a wait activity based on duration.
• Automation Studio and Journey Builder allow users to define the parameters of a send within the tool.

A customer is starting a new children's fashion brand and wants to use a dedicated business unit within their existing Enterprise 2.0 account. They anticipate many of their current Enterprise contacts will subscribe to the children's brand, however, they want to separate subscriber opt-outs of the Enterprise and children's brands. The customer has minimal technical resources available for implementation and support.What should a consultant recommend to meet these criteria?

• Select 'Use separate 'Subscription Center' for this business unit' in Settings
• Create attributes for each child business unit in 'Profile Management' to record unsubscribes
• Create a Business Unit Filter in 'All Subscribers' List to record unsubscribes
• Select 'Subscribers will be unsubscribed from this business unity only' in Settings

Utilizing journey builder interactions for sending post-purchase communications to customers, what contact entry mode fits?

• Re-entry anytime
• Re-entry only after exit
• No re-entry

Northern Trail Outfitters wants to capture dietary preferences for Contacts who have registered for an upcoming launch event. They have created a data extension of Contacts who have registered for the event and will send them an SMS message from MobileConnect asking them to reply with their dietary preference. When Contact reply to SMS message, the response message will be inserted into a data extension using AMPscript.Which two MobileConnect templates should be used to send the SMS message and capture the responses?

• Text Response
• Info Capture
• Outbound
• Data Capture

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?

• Personalization strings
• AMPscript
• SQL Query
• Guide Template Language