Salesforce Marketing Cloud Consultant Quiz 6 Topic 12 Questions 26-30

Question: 1

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: 2

A customer would like to store financial data related to invoicing in its data extensions.

Which field type should be used?

ACurrency

BDecimal

CNumber

DFloat

Show Answer

Question: 3

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: 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

The customer has these requirements for storing engagement data in their data warehouse:

* All email open and click activity must be pulled daily from the Marketing Cloud.

* Output files must meet the specific requirements for the data warehouse.

* All the activity must be provided via FTP in one file.

Which automation workflow meets the customer requirements?

AReport activity that generates Recent Send Summary report > Report delivered directly to FTP

BExtract activity of Tracking Extracts that combines data into required file > Transfer activity

CQuery activity to pull data view information > Extract activity of data extension > Transfer activity

DExtract activity of data view tables > Query activity to create the required file > Transfer activity

Show Answer

Salesforce Marketing Cloud Consultant Quiz:6 Topic:12 Questions:26-30