Free Salesforce Marketing-Cloud-Consultant Exam Questions

Become Salesforce Certified with updated Marketing-Cloud-Consultant exam questions and correct answers

Page: 1 / 66

Total 327 Questions | Updated On: Jan 10, 2025

Add To Cart

Question 1

A customer needs to import data from an SFTP site. The customer wants to:

* Segment the contents of the file and then send emails.

* Transfer the file to the SFTP site at various times daily.

* Send to data extensions.

What sequence of automation activities should meet these requirements?

A : heduled: Import File > SQL Query(s) > Send Email(s)

B : heduled: Transfer File > Import File > SQL Query(s) > Send Email(s)

C : le Drop: Import File > SQL Query(s) > Send Email(s)

D : le Drop: Import File > Group Refresh > Send Email(s)

Answer: C

Question 2

A customer has an eCommerce site and Imports data into three data extensions daily; 'Orders', 'Order_Details' and 'Products'

the data extension contains the following information:

* Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal

* Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount

* Products: ProductId, SKU, Name, Description, Cost, Price

What two actions should be taken in Data Designer?

A : eate a one-to-one relationship between Orders and order_Details

B : eate a one-to-one relationship between the contact record and Order_Details

C : eate a one-to-one relationship between Order_Details and Products

D : eate a one-to-many relationship between Orders and Order_Details

Answer: B,C

Question 3

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?

A : eate and execute a SQL Query against the _Click data view.

B : eate and execute a Tracking Extract.

C : eate and execute a Subscriber Engagement report.

D : eate and execute a Data Filter on the_Click data view.

Answer: A

Question 4

Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed.

What should the consultant do to diagnose the issue?

A : itiate a log to troubleshoot package-related API calls.

B : ange the connection option to Scope by User.

C : ure the System User is assigned the Standard User Profile.

D : nually clear the OAuth token to refresh the connection.

Answer: A

Question 5

North Trail Outfitters (NTO) wants to automate the sending of shipping notices and a customer survey.

*Shipping notices will be sent once a day.

*The shipping file will be placed on the FTP sometime after 4:00 p.m.

*The shipping data will be stored in the shipping Notice data extension.

*A field in the data extension will contain the shipping data.

*The survey needs to be sent at 9:00 a.m., exactly 10 days after the customers order ships.

Which workflow would most effectively enable NTO to do this?

A :

Other-Image-9c0fb7cbb-873a-4d8e-bfa7-8e82647ec94e

B :

Other-Image-11c0fb7cbb-873a-4d8e-bfa7-8e82647ec94e

C :

Other-Image-13c0fb7cbb-873a-4d8e-bfa7-8e82647ec94e

D :

Other-Image-15c0fb7cbb-873a-4d8e-bfa7-8e82647ec94e

Answer: A

Page: 1 / 66

Total 327 Questions | Updated On: Jan 10, 2025

Add To Cart