Marketing-Cloud-Developer Free Practice Test

A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?

1. A. File Drop Automation
2. B. Scheduled Automation
3. C. Dynamic File Import

Correct Answer: B

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

1. A. Use intrisic functions in the WHERE clause
2. B. Use SELECT * to include all fields
3. C. Use Primary key(s) on fields used in joins
4. D. Use intermediate tables to stage data
5. E. Only update records that have changed since last execution

Correct Answer: CDE

A developer has a text field in a data extension they want to format using the FormatCurrency AMPscript function. Which two values would return $6.96? Choose 2

1. A. 6,961
2. B. 6.96
3. C. $6.96
4. D. 6.96

Correct Answer: CD

A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

1. A. Up to one million records can be deleted in each batch.
2. B. To more quickly remove contact information, use the suppression period length of 14.
3. C. The deletion process supersedes other automated account activities.
4. D. The suppression status does not show for individual contacts until the entire batch processes.

Correct Answer: CD

A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

1. A. Marketing Cloud does not allow DateAdd functions in Query Activitie
2. B. They should define a specific date.
3. C. Marketing Cloud _Bounce data view does not contain EmailAddres
4. D. They should join on SubscriberlD.
5. E. Marketing Cloud Data Views only hold 20 days worth of dat
6. F. They should narrow scope of DateAdd function.
7. G. Marketing Cloud does not allow use of GETDATE functio
8. H. They should define a specific date.

Correct Answer: B