Black Friday Rush: 75% Off All Exam Bundles! Apply the coupon code below before the offer expires! - Ends in 0d 00h 00m 00s - Coupon code: newyear

Salesforce Marketing-Cloud-Consultant - Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25)

Northern Trail Outfitters wants to set up an automation that imports a file and sends an email to the contacts when the file is dropped on the SFTP. The name of the file will change, though it will always start with thankyou_customers .

How would they set up the Import Activity to know the name of the file?

A.

Set File Naming Pattern to %%AUTOMATED_FILENAME%%

B.

Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%

C.

Filename is automatically passed to Import Activity with File Drop Automations

D.

Check the 'Use filename from Automation' checkbox

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 previously opted out.

Which feature should they use?

A.

Exclusion Script

B.

Auto-suppression List

C.

Suppression List

D.

Exclusion List

Northern Trail Outfitters (NTO) wants to send out a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, is housed in a separate data extension than the one used for journey injection. NTO needs to use an attribute-to-attribute comparison on the customer number field in the journey source and transaction data extensions.

Which activity would they use to accomplish this?

A.

Einstein Split Activity

B.

Decision Split Activity using only Contact Data

C.

Decision Split Activity using both Contact and Journey Data

D.

Decision Split Activity using only Journey Data

A customer asks why the send time values within an email are not being added to a Send Log.

Which two actions would successfully write send time variables to their Send Log? (Choose 2 answers)

A.

Match an AMPscript variable name to a Send Log field.

B.

Ensure the Send Log is linked in an attribute group.

C.

Enable send logging to a data extension during the send process.

D.

Use the WriteToLog() AMPscript function in the content.

A customer is creating a re-engagement campaign. The campaign only targets subscribers who have had emails fail at send time due to Held status within the last 60 days. The goal is to send an SMS to the subscribers asking them if they want to update their email address.

What should a consultant recommend to meet the criteria?

A.

Use SQL Query and Import activities from Automation Studio to inject the subscribers into a data extension used as an Entry Source by Journey Builder.

B.

Use Tracking Extract, File Transfer, and Import activities from Automation Studio to inject the subscribers into a data extension used as an Entry Source by Journey Builder.

C.

Use Data Extension Extract and Import activities from Automation Studio to inject the subscribers into a CloudPage used as an Entry Source by Journey Builder.

D.

Use SQL Query and File Transfer activities from Automation Studio to inject the subscribers into an API Event used as an Entry Source by Journey Builder.

Scenario:

Northern Trail Outfitters is using a Salesforce entry event in a Journey to send SMS to contacts located in the United States. They notice new SMS contacts are not receiving messages, and the mobile number in the Salesforce Entry Data Extension was missing the country code.

How could they resolve this issue?

A.

Select 'Normalize Phone Number' in Journey settings.

B.

Format the phone field in Salesforce as +1[phonenumber].

C.

Select 'US' as the sending country in SMS activity.

D.

Configure the phone field in Salesforce as US locale.

A customer's web developer team is creating a form that will leverage a Marketing Cloud REST API endpoint to upsert rows into a data extension.

How should the consultant create an installed package in Marketing Cloud to facilitate this functionality?

A.

Enable the package for all business units in the Marketing Cloud account.

B.

Create a separate installed package for each individual web form.

C.

Instruct the web team to store the client ID and secret in the client-side code.

D.

Ensure the package scope includes Read and Write permissions for data extensions.

A customer wants to capture and categorize email Not Sent events and begin identifying trends. They want to keep the data in Marketing Cloud and run queries against the dataset. The customer created a data extension to receive the information.

Which order of Automation Studio activities should be recommended?

A.

Data Extract with the Data Extension Extract type > File Transfer to Safehouse > File Transfer unzip > SQL Query

B.

SQL Query > Data Extract with the Data Extension Extract type > File Transfer to Safehouse > Import File

C.

Data Extract with the Tracking Extract type > File Transfer from Safehouse > File Transfer unzip > Import File

D.

Data Factory Utility > File Transfer from Safehouse > Import File > Data Extract with Tracking Extract type

Northern Trail Outfitters wants to have a periodic, dynamic newsletter sent to a set data extension, but the data in this data extension will be regularly updated, and the subscribers inside could be removed/added multiple times.

What option should speed up the delivery while meeting these criteria?

A.

Journey that allows re-entry after exiting

B.

Scheduled Automation utilizing Triggered Send Emails

C.

Scheduled Automation using a Send Activity

D.

Single Send Journey

Northern Trail Outfitters (NTO) imports a file daily into Marketing Cloud of customers who have bought a tent from their website. They want to set up a month-long welcome Journey that sends emails specific to the purchase, such as the type of tent, recommended accessories, and care tips at different points throughout the Journey.

NTO also recognizes that due to their pricing strategy, customers may purchase more than one tent within a month.

What type of data should be used in the Decision Splits in their Journey to make sure the choices reflect the correct tent?

A.

Journey Data

B.

Salesforce Data

C.

Contact Data

D.

Entry Data