Certified Marketing Cloud Consultant Dumps PDF Free Download

QUESTION: 31

What are data extension data retention policies?

Settings to "soft" delete all data in a Data Extension so there is no data loss.
Settings to control when a data extension creates a back-up of the data it contains.
Settings to define when a data extension or the data within the data extension is deleted.
Settings to prevent users from deleting a Data Extension created by another user.

Answer(s): C

QUESTION: 32

A customer would like to store financial data related to invoicing in its data extensions. Which field type should be used?

Currency
Decimal
Number
Float

Answer(s): B

Reveal Solution Next Question

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

Salesforce Certified Marketing Cloud Consultant Certified Marketing Cloud Consultant Exam Questions in PDF

Free Salesforce Certified Marketing Cloud Consultant Dumps Questions (page: 7)

QUESTION: 31

QUESTION: 32

QUESTION: 33

QUESTION: 34

QUESTION: 35