ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 102 - Certified Marketing Cloud Consultant discussion

Report
Export

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:

*Imported iota a staging data extension.

*Separated into two different data extensions.

Which automation should meet these requirements?

A.
Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
Answers
A.
Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
B.
File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
Answers
B.
File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
C.
Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
Answers
C.
Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
D.
File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Answers
D.
File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Suggested answer: B
asked 23/09/2024
Abdelilah BAKIR
27 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first