Free Certified Marketing Cloud Consultant Exam Braindumps (page: 28)

Page 28 of 74

In which two ways can Contact Builder be used to affect data stored on a data extension? Choose 2 answers

  1. Reconcile contact data on multiple Contact IDs
  2. Add a single record to a data extension
  3. Export data from a data extension to any SFTP location
  4. Clear the data from a data extension

Answer(s): A,C



Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeros, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

  1. Number
  2. Text (15)
  3. Decimal (15,0)
  4. Decimal (15,2)

Answer(s): C

Explanation:

The order ID field is conducive because it places all of the items that the customers want under one order. You can imagine how problematic it would be if the rules would be set in different areas. It will be harder for the company to track the orders of each customer.
This may lead to people receiving items that they did not order or not getting any of the things that they have ordered at all. The order ID field will make everything more organized and correct. The fewer mistakes that the company makes in processing orders, the happier the customers will be with their shopping experience.



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)

B)

C)

D)

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Answer(s): A



A university plans to use Journey Builder to improve their 1:1 marketing to potential students, current students, and alumni. The university currently has student data in Sales Cloud. Other data, such as course catalog, student demographics, and alumni information, is stored in external systems. Which two actions should be consultant recommend? Choose 2 answers

  1. Use Synchronized Data Sources to obtain data from Sales Cloud.
  2. Create an Import Activity to import alumni data into Salesforce Report.
  3. Create list attribute to store student data from Sales Cloud.
  4. Use Data Designer to link student and alumni data to the contact record.

Answer(s): A,D



Page 28 of 74



Post your Comments and Discuss Salesforce Certified Marketing Cloud Consultant exam with other Community members:

Shobena commented on June 19, 2024
Yesterday I gave this exam. Passed it on the first try. This prep material is very accurate and cover all topics.
INDIA
upvote