Salesforce Discussions

Exam Certified Marketing Cloud Consultant All Questions

View all questions & answers for the Certified Marketing Cloud Consultant exam

Go to Exam

Exam Certified Marketing Cloud Consultant topic 1 question 22 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Consultant

Question #: 22
Topic #: 1

[All Certified Marketing Cloud Consultant Questions]

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 3 a.m. daily.
✑ The customer requires that the import completes prior to 4 a.m.
✑ On average, the file will contain about two million rows of data each day.
Based on the customer's requirements and recommended best practices, how should the daily file be imported?

A. Import the file into a list, using the 'update only' method.
B. Import the file into a list, using the 'add and update' method.
C. Import the file into a data extension, using the 'add and update' method.
D. Import the file into a data extension, using the 'overwrite' method.

Show Suggested Answer

Suggested Answer: C 🗳️

by anacj at Sept. 2, 2021, 6:54 p.m.

Comments

Submit Cancel

Ton17

9 months ago

Selected Answer: C

C is the correct one

upvoted 3 times

...

F4D1

1 year, 3 months ago

Selected Answer: C

Answer is C. With overwrite existing contacts will be deleted.

upvoted 2 times

...

albertogdonas

1 year, 11 months ago

You can't use overwrite. Existing users that haven't been updated wouldn't be added

upvoted 3 times

...

placidworld

2 years, 2 months ago

You can use overwrite - 'a file containing only new and updated subscriber records'

upvoted 1 times

placidworld

2 years, 2 months ago

Typo< should be You can't use overwrite - 'a file containing only new and updated subscriber records'

upvoted 2 times

...

...

anacj

2 years, 5 months ago

D - overwrite IS FASTER

upvoted 1 times

...