ExamTopics Logo
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Marketing Cloud Email Specialist All Questions

View all questions & answers for the Certified Marketing Cloud Email Specialist exam
Go to Exam

Exam Certified Marketing Cloud Email Specialist topic 1 question 28 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Email Specialist
Question #: 28
Topic #: 1
[All Certified Marketing Cloud Email Specialist Questions]

A customer has a Send Log they are using to track the email addresses that were sent to, date and time of the send, and the name of the email sent for reporting purposes. Per best practice, the customer stores 10 days of data in their Send Log and then archives the data into another data extension that holds data for one year.
Which activity should be used to run the backup automatically?

  • A. SQL Query
  • B. Import File
  • C. Filter
  • D. Data Extract
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Twerk at Dec. 10, 2022, 11:52 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Twerk
Highly Voted 2 years, 2 months ago
Should be A
upvoted 12 times
...
roank07
Highly Voted 1 year, 9 months ago
Correct Answer - A (https://help.salesforce.com/s/articleView?id=sf.mc_es_send_logging_best_practices.htm&type=5)
upvoted 5 times
...
ChessRambo
Most Recent 1 week, 2 days ago
Selected Answer: A
Correct answer is A SQL Query activities in Automation Studio allow marketers to select and transfer data from one Data Extension to another automatically. Since the customer needs to move Send Log data older than 10 days into an archive Data Extension, an SQL Query can be used to filter records and insert them into the archive Data Extension on a scheduled basis.
upvoted 1 times
...
1460c33
2 months, 3 weeks ago
It's A. "You can also use a query activity to move data from an active send log to an archive data extension, as necessary."
upvoted 1 times
...
LilianNg
11 months, 1 week ago
Selected Answer: C
Use case: Birthday Email campaign You have a Data Extension of Contacts with a ‘birthday’ attribute. You want to send an email to those contacts with a birthday in that month. You can achieve this by creating a Filter Activity that includes a Data Filter where the Contact’s birthday is in the current month. An Automation Studio job would be set to run monthly.
upvoted 1 times
...
AleAleAleAle
1 year, 6 months ago
Selected Answer: A
You can also use a query activity to move data from an active send log to an archive data extension, as necessary.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago