Question 1

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?

Options :

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

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

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

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

Answer: B,C

Question 2

Northern Trail Outfitters (NTO) wants email subscribers to adopt their app. They are investigating using MobileConnect features since over 90% of their subscribers provide a Mobile Phone Number when registering.

Which three considerations should be made before implementing MobileConnect?

Choose 3 answers

Options :

A : Long and Short Codes are not available for all countries.

B : NTO would be charged by mobile operators directly for messages.

C : Inbound messaging only works with local Long or Short Codes.

D : Not all countries are supported by MobileConnect.

E : Opting in for messages can only be done via inbound message.

Answer: A,C,D

Question 3

Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.

How should this distributor-specific sender profile be configured in the Marketing Cloud?

Choose 2 answers

Options :

A : Pick 'Choose from list,' selecting the from name and from email values from the list of account users.

B : Utilize data extension AMPScript lookups to dynamically populate the from name and from email values.

C : Match the external keys of the sender profile and data extension containing account representative details.

D : Populate substitution strings in the sender profile for the profile attributes containing from name and from email values.

Answer: B,D

Question 4

A publishing company presented the following: A need to send renewal reminders to customers whose subscribers expire in 7 days and 15 days. A campaign needs to created and managed by a general marketing user who will not have administrative rights and who is not technical. The customer's expiration data is included in the data filter.

Which three components should the customer's solution include?

Options :

A : Data Filter

B : Template Based emails

C : Suppression List

D : Automation Studio

E : Triggered Send

Answer: A,B,D

Question 5

Northern Trail Outfitters wants to send an email to one million contacts in Sales Cloud. The criteria to segment contacts include using 10+ fields to segment.

Which process should the consultant utilize for a reliable send method?

Options :

A : Query Synchronized Data Extensions using a query activity to a Salesforce Data Extension, then send via Email Studio Send Flow

B : Import Salesforce Report through an import activity to a Salesforce Data Extension, then send to data extension using Email Studio email send

C : Assign the one million contacts from the report to a Salesforce campaign, and use a Single Step journey with Salesforce Campaign as an entry event

D : Send to a Salesforce Report from Marketing Cloud using Email Studio Send Flow

Answer: A

Confidently Practice Online with Free Marketing-Cloud-Consultant Exam Cram

Buying Options: