Free Preparing for your Salesforce Certified Marketing Cloud Consultant Exam CRT-550 Exam Practice Test

An analytics team wants to get hourly updates on email metrics (send, open, click) to provide timely next best actions to the sales team.What method should the team use?

• Send Logs
• Data views
• Tracking Extracts
• Scheduled Reports

Northern Trail Outfitters is migrating from a legacy emailing tool to Marketing Cloud. As part of the migration, they have to go through a security review. Their data privacy team has made it clear that the data in the sandbox should never be mixed with data In production during testing cycles.What recommendation would a consultant provide on the architecture to fulfill this requirement?

• Implement two separate Marketing Cloud instances.
• Ensure test sends are done from data extensions with attribute 'Is Testing1.
• Create one or more additional business units for testing.
• Use Subscriber Filter per business unit to filter production from test data.

Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file drops, they want to be able to have it immediately imported and then segmented to enter a specific journey depending on the data inside the file.Which two options would meet these requirements? Choose 2 answers

• Scheduled Automation
• File Drop Automation
• SQL Query
• Decision Split

A customer wants to create a loyalty program by Identifying all subscribers who clicked on a link within any email sent within the last six months.What should be recommended?

• Create and execute a SQL Query against the _Click data view.
• Create and execute a Tracking Extract.
• Create and execute a Subscriber Engagement report.
• Create and execute a Data Filter on the_Click data view.

Northern Trail Outfitters (NTO) wants to import recent customer transaction data from their data warehouse into Marketing Cloud on a nightly basis. They plan to create a File Drop Automation to trigger an automation when a data file is transferred from the data warehouse to the import folder in their Enhanced FTP account. NTO notes that user passwords expire every 90 days and they do not want to update their file transfer script on the data warehouse each time a password changes and they do not want to compromise security.Which solution should the consultant recommend?

• Contact the Marketing Cloud account representative to enable Single Sign-On Authentication using SAML
• Request SSH key authentication to be enabled for the FTP user and create an SSH Key in Key Management
• Enable the 'Exclude FTP Users From Password Expiration' option in Setup > Security Settings
• Upload data files to Marketing Cloud using SFTP instead of FTP

A marketer at Northern Trail Outfitters (NTO) wants to send important updates to customers about products they have previously purchased. The marketer has little experience with coding. Also, the information is spread across multiple data extensions and is imported nightly from NTO's ecommerce platform - Contacts, Orders, Order Items, and Products.Which design should a consultant recommend for segmentation?

• Combine the data outside of Marketing Cloud and upload it into a Sendable Data Extension.
• Establish data relationships and create Data Filters for the marketer to modify.
• Create SQL Query Activities for the marketer to modify.
• Link the data extensions in an Attribute Group.

Northern Trail Outfitters (NTO) uses the SAP domain comms.nto.com and has just opened an office in Australia. They have created a business unit for their new office and want to use the domain comms.nto.com.au to send emails to their Australian customers.What would be required to enable sending emails from their new domain without impacting deliverability?

• An additional IP address
• An additional Sender Authentication Package
• An additional private domain
• Register the new domain in Setup > From Address Management

A B2B customer has customized journeys they want to use for several key accounts they are trying to sell into.How could Marketing Cloud Connect be used to initiate these sends when contacts for select accounts are created?

• Salesforce Campaign Entry Source on the Lead Object
• Salesforce Data Entry Source on the Contact Object
• Salesforce Data Entry Source on the Account Object
• Welcome Email Configuration on the Account Object

Northern Trail Outfitters 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
• Use Content Builder Send Flow to send the email to the Salesforce Campaign
• 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

Northern Trail Outfitters has acquired a new company and is importing customer data to Marketing Cloud. They want to ensure commercial emails are not sent to email addresses who have previouslyopted-out.Which feature should they use?

• Exclusion Script
• Auto-suppression List
• Suppression List
• Exclusion List