Salesforce CRT-550 Quiz 6 Topic 1 Questions 26-30

Question: 1

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?

ASELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD

BSELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD

CSELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD

DSELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

Show Answer

Question: 2

Which data object should be used in conjunction with data extensions to create an opt- down strategy for customers?

AProfile attributes

BPreference attributes

CPublication Lists

DPreference Lists

Show Answer

Question: 3

What are data extension data retention policies?

ASettings to 'soft' delete all data in a Data Extension so there is no data loss.

BSettings to control when a data extension creates a back-up of the data it contains.

CSettings to define when a data extension or the data within the data extension is deleted.

DSettings to prevent users from deleting a Data Extension created by another user.

Show Answer

Question: 4

What is a correct statement about Send Log data?

Choose 3 answers

ACan be accessed via Query activities.

BCan be incorporated into standard reports.

CCan be stored for a set period of time.

DCan be added to a standard data view.

ECan be included in measures and filters.

Show Answer

Question: 5

A daily deal website is concerned with their sender reputation and needs consistent visibility into subscribers who report their email as spam.

How can they determine which subscribers reported their email as spam so they can flag those records in their customer service database?

AAn automation that queries the Complaint data view.

BAn automation that generates the Unsubscribe Event Extract.

CAn automation that queries the Unsubscribe data view.

DAn automation that generates the Complaint Tracking Extract.

Show Answer

Salesforce CRT-550 Quiz:6 Topic:1 Questions:26-30