ABC Company wants to set up a welcome journey that leverages customer data across three data extensions:
Customers, Orders, and Products.
What is the best way to facilitate this within Contact Builder?

• A.Create three distinct Attribute Groups that link Customers to Contacts, Orders to Customers, and Products to Orders.
• B.Create a single Attribute Group that links Customers to Contacts, Orders to Customers, and Products to Orders.
• C.Create three distinct Attribute Groups that link each data extension directly to Contacts.
• D.Create a single Attribute Group that links Contacts to Customers, Orders to Products, and Products to Customers.

Comment: *

Name: *

Email: *

Verification: *

A customer wants to configure appointment reminders for patients in their clinic. The reminder should be sent day before the appointment date at 10 a.m and the appointment record should be updated in the patient was sent a reminder email.
What solution could be recommended?

• A.Create a daily scheduled automation to refresh the audience, and use Data Extension entry source for a journey with activates a reminder and updates the record in CRM.
• B.Create a journey with CRM data source triggered on the reminder data and use Journey Builder activities to send a reminder and update the record in Synchronized Data Extension.
• C.Create a daily scheduled automation to refresh the audience, and use Automation Studio activities to send a reminder with AMPscript in the message to update the record in Synchronized Data Extension.
• D.Create a journey with CRM date based entry source, and use journey Builder activates to send a reminder and update the record in CRM.

Comment: *

Name: *

Email: *

Verification: *

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions - Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate.
Which SQL statement should the consultant use?

• A.SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerID=OrderTable.CustomerID
• B.SELECT T1.CustomerID, T1.FirstName, T1..EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID
• C.SELECT * FROM Subscribers WHERE CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate - JOIN OrderTable On CustomerID=CustomerID
• D.SELECT CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerID=CustomerID

Comment: *

Name: *

Email: *

Verification: *

A customer manages their field technicians in Salesforce CRM connected to Marketing Cloud. Once an appointment with a contact is scheduled for the technician through CRM, the notification message should be sent to the contact informing them about the scheduled visit date. When the notification is sent the
"Confirmation sent" checkbox on the appointment record should be updated in CRM.
All appointments scheduled on a given day will have their status updated in CRM at the end of business hours.
The Appointment object does not have a direct relationship with the contact.
What solution would a consultant recommend to address this use case?

• A.Configure Salesforce Send with Salesforce data extension, using Automation Studio activities to refresh the audience; send notification and SSJS activity to update CRM record(s)
• B.Configure journey with Salesforce Data entry source; use Journey Builder activities to send notification and update CRM record(s)
• C.Configure journey with API Event entry source, Process Builder to trigger event; use Journey Builder activities to send notification and update CRM record(s)
• D.Configure journey with Data Extension entry source; use Automation Studio activities to refresh the audience and Journey Builder activities to send notification and update CRM record(s)

Comment: *

Name: *

Email: *

Verification: *

A customer manually imports records for sending. Each record contains a warehouse ID that is shared between Marketing Cloud and a third-party system. The customer does not have developer resources, but wants to include the warehouse ID in their tracking parameters so that the third-party system can identify the subscriber.
What should a consultant recommend?

• A.Use Dynamic Content rules to select a content area for each subscriber.
• B.Use Guide Template Language created for each field in the data extension.
• C.Use AMPscript variables created from each field in the data extension.
• D.Use personalization strings created by selecting the data extension.

Comment: *

Name: *

Email: *

Verification: *