Free Marketing-Cloud-Developer Practice Exam Questions

Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

A. File Import activity

B. Data Extract activity

C. Data Extension Import activity

D. File Transfer activity

Explanation:

Before importing zipped files into a Data Extension, a File Transfer activity is needed to unzip the files on the Marketing Cloud Enhanced FTP server. This activity moves and decompresses the files to make them available for import.

File Transfer Activity: This activity is used to move files from one location to another and to unzip compressed files.

[: Salesforce File Transfer Activity, ]

A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

A. Bulk

B. SOAP

C. XML

D. REST

Explanation:

To manage the data model programmatically and access the Attribute Group schema, the REST API should be used. The REST API provides endpoints to interact with and retrieve information about Attribute Groups and their schemas.

[: Salesforce REST API, , , , ]

Which AMPscript function group could most negatively Impact send processing?

A. String functions

B. Data extension functions

C. Date Time

D. Math functions

B. Data extension functions

Explanation:

Data extension functions in AMPscript, such as LookupRows, LookupOrderedRows, and UpdateDE, can most negatively impact send processing because they involve querying and manipulating data extensions. These operations can be resource-intensive and time-consuming, especially when dealing with large data sets.

[: Salesforce AMPscript Functions, , ]

A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for eachmonth in the following way: How should the developer use AMPscript to generate the total?

A. SET @total - (@jan - 3fet - @mar @apr>

B. SET @total = AZD((@jan @feb) @mar) @apr)

C. SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))

D. SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))

C. SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))

Explanation:

To aggregate monthly energy usage data stored in variables for each month, you should use the ADD function in AMPscript to sum up the values. The ADD function can be nested to handle multiple values.

AMPscript Example:

%%[ SET @total = ADD(@jan, ADD(@feb, ADD(@mar, @apr))) ]%% [: Salesforce AMPscript Functions - ADD, , , ]

Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and thefile name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

A. %%Month%%%%Day%%

B. %%MMDD%%

C. Ends With operator

D. Begins With operator

B. %%MMDD%%

D. Begins With operator

Explanation:

To define a filename pattern that matches files starting with the current month and day, you can use the %%MMDD%% pattern and the "Begins With" operator.

%%MMDD%% Pattern: This pattern represents the month and day in a two-digit format.

Begins With Operator: This operator ensures that the automation matches filenames that start with the specified pattern.

[: Salesforce File Drop Automations, , , , , ]

Marketing-Cloud-Developer Practice Test