Marketing-Cloud-Developer Free Practice Test

Which AMPscript function group could most negatively Impact send processing?

1. A. String functions
2. B. Data extension functions
3. C. Date Time
4. D. Math functions

Correct Answer: B

A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each.
Which application utilizes the REST API?

1. A. Automation Studio
2. B. Classic Content
3. C. Content Builder

Correct Answer: B

Northern Trail Outfitters uses a Send Log and sends more than one million emails per day. They want to execute daily reports on all subscriber activity without impacting send performance.
Which set of best practices should be implemented''

1. A. Add a data retention policy to the Send Lo
2. B. then run reports from the Send Log data extension.
3. C. Add a data retention policy to the Send Lo
4. D. then run reports from the _Opens data view.
5. E. Copy new Send Log records to an Archive data extension, then run reports from the Archive data extension.
6. F. Copy new Send Log records to an Archive data extension, then run reports from the Send Log data extension.

Correct Answer: B

A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a column called 'PurchaseDate'. Contacts are identified in both data extensions by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscnber.
Which SQL keyword should the developer use to achieve the desired result?

1. A. INNER JOIN
2. B. OUTER JOIN
3. C. ORDER BY PurchaseDate ASC

Correct Answer: C

Northern Trail Outfitters has created subscriber attributes including AGE under Profile Manager within their Enterprise 2.0 account.
How would a developer retrieve subscribers over 30 years of age?

1. A. The data cannot be retrieved with a query
2. B. Create a filtered Group of subscribers with AGE more than 30
3. C. Create a query that references the _Subscribers data view
4. D. Create a query that references the _EnterpriseAttribute data view

Correct Answer: B