Question: 1
What is a correct statement about a database of record? Choose 2 answers
Question: 2
A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings
* Data for the campaign will be in two data extensions: Customer and New Accounts
* The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.
* The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.
Which automated workflow meets the customer's requirements?
A A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
B A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
C A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
D A scheduled automation that starts at 12:00 a.m. and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activity, and Send Email Activity.
Answer : C
Show Answer
Hide Answer
Question: 3
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?
Question: 4
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?
Question: 5
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?
A SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
B SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
C SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
D SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID
Answer : D
Show Answer
Hide Answer
