Marketing-Cloud-Consultant Practice Test Questions

Northern Trail Outfitters' marketing team is new to Marketing Cloud and has very little coding experience. They have employed a consultant to help them design an automated solution for maintaining an auto-suppression list. Which solution should the consultant recommend?

A. Use Einstein Segment Recommendations

B. Use an import activity to import a file from the SFTP

C. Use a query activity to populate the auto-suppression

D. Use the Import Wizard in Automation Studio

A consulting has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today’s product catalog. The product catalog is never the same; products can be added and removed. Which import type should be used?

A. Overwrite

B. Add Only

C. Add/Update

D. Update Only

A customer would like to store financial data related to invoicing in its data extensions. Which field type should be used?

A. Currency

B. Decimal

C. Number

D. Float

Northern Trail Outfitters (NTO) wants to use Marketing Cloud to solicit customer service feedback. If a customer indicates they are unhappy with the service they have received, NTO wants a new case to be created in Service Cloud. NTO is unsure of what is possible within Marketing Cloud but would like to use as much native functionality as possible. What approach would a consultant recommend?

A. Use an Engagement Split to capture positive responses, and a Case Activity to create a new case in Service Cloud.

B. Use Automation Studio to capture positive or negative responses, and a Case Activity to create a new case in Service Cloud.

C. Use an AppExchange package to create a customized API integration between Marketing Cloud and Service Cloud.

D. Use an Engagement Split to capture positive or negative responses, and a Custom Activity to create a new case in Service Cloud.

A customer has several values that need to be used in the body of an email send:

• The data would be stored in a reference data extension, related on Subscriber Key.
• There may be one or more records for each subscriber.
• The audience is generally over 1 million subscribers.
• The content is time sensitive and should be sent as quickly as possible.
• The customer is not using "catch and release" sending.
• The reference data extension contains 25 columns.

A. AMPscript a single Lookup Function

B. Server Side Javascript a single LookupOrderedRows Function

C. AMPscript a single LookupOrderedRows Function

D. Dynamic content via the Dynamic Content Wizard

During discovery, the customer outlines data requirements and the anticipated use of
Marketing Cloud with the following criteria:

• Customer data will be fully refreshed every night via Import activity from the customer's data warehouse.
• Contact records will be augmented by relational data tables via Contact Builder.
• The customer data file will contain 5M records with 40+ attributes.
• One attribute will house HTML code, 1000 characters max, that will be used to populate Account Access content areas in emails.
• A customer ID will be used as the unique identifier for each contact.

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

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

Northern Trail Outfitters maintains their primary customer identity in their ERP system but managers their customer service via Service Cloud. Customer data is updated in real-time based on changes in the ERP, and the ERP customer ID serves as the Customer Key. They want to leverage Synchronized Data Extensions to import data about cases from Service Cloud every 15 minutes.
What consideration should be made before implementing this solution?

A. Moving to use the email address as the contact key would simplify the integration since it is common to both systems.

B. Marketing Cloud will deduplicate customers based on their email address, meaning some customers may be overwritten or not receive email.

C. The number of contacts added to the instance will be approximately twice as large by using this integration pattern.

D. They will have to migrate to use Service Cloud IDs, such as the Contact ID, as the contact key instead of ERP IDs

NTO has to import a file that will be different every time. What method should be used?

A. Update

B. Overwrite

C. Add and Update

D. Add Only

Northern Trail Outfitters wants to import new contacts gathered from an external web form. The entries are being collected at high frequency, potentially thousands per minutes. The data does not need to be immediately ingested into Marketing Cloud as it is used in a daily scheduled automation. What Should be recommended?

A. Create this as a Journey Data Source via Journey Builder.

B. Push each new record into Marketing Cloud vis Platform Event API on form submit.

C. Perform a daily bulk export to SFTP for import via Automation.

D. Recreate this external web form inside Marketing Cloud.