QUESTION: 33

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:

* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate

Which SQL statement should the consultant use?

SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
SELECTT1.CustomerID,T1.FirstName,T1.EmailAddress,T2.OrderlD,T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

Answer(s): D

Reveal Solution Next Question

QUESTION: 34

A customer provides a file containing only new and updated subscriber records exported from its marketing database.

* The file will be uploaded to the customer's Enhanced FTP automatically at 3AM daily.
* The customer requires that the import completes prior to 4AM.
* On average, the file will contain about 2 million rows of data each day.

Based on the customer's requirements and recommended best practices, how should the daily file be imported?

Import the file to a data extension, using the 'add and update' method.
Import the file to a list, using the 'update only' method.
Import the file to a list, using the 'add and update' method.
Import the file to a data extension, using the 'overwrite' method.

Answer(s): A

Reveal Solution Next Question

QUESTION: 35

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity.
The list is:

* Compiled in a database in the website Content Management System (CMS).
* Imported into Marketing Cloud nightly at 11 p.m.

What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

Engagement metrics will be passed into Marketing Cloud.
They will need to integrate with the Marketing Cloud SOAP API.
Unsubscribes should be synchronized between senders.
The third-party send list should be pulled from the CMS

Answer(s): B

Reveal Solution Next Question

QUESTION: 36

What is a correct statement about a database of record? Choose 2 answers

A database of record is a centralized storage repository of data about objects or people.
A database of record is any database containing subscriber data.
A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber.
A database of record is a system in which a subscriber's status is maintained

Answer(s): A,D

Reveal Solution Next Question

Free Certified Marketing Cloud Consultant Exam Braindumps

QUESTION: 33

QUESTION: 34

QUESTION: 35

QUESTION: 36