MARKETING-CLOUD-DEVELOPER Online Practice Questions and Answers

A developer wants to transformthe date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

A. %%=DataAdd(Date_Enrolled,-1)=%%

B. %%=DateAdd(Date_Enrolled,-1 'H')=%%

C. %%=DateDiff(Date_Enrolled, 1, 'H')=%%

D. %%=FormatDate(Date_Enrolled,-1,'HH','en-us')=%%

A developer is using the legacy endpoint www.exacttargetapis.com and has been asked toswitch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?

A. A longer lasting OAuth token

B. API calls will no longer fail

C. Gain access to TSE-specific REST routes

D. Improved API performance

Northern Trail Outfitters has created subscriber attributes including AGE underProfile Manager within their Enterprise 2.0 account.

How would a developer retrieve subscribers over 30 years of age?

A. The data cannot be retrieved with a query

B. Create a filtered Group of subscribers with AGE more than 30

C. Create a query that references the _Subscribers data view

D. Create a query that references the _EnterpriseAttribute data view

Certification Aid wants to import an encrypted CSV file from the Marketing Cloud Enhanced FTP server. Which two File Transfer activities are needed to achieve this? Choose 2.

A. To decrypt the import file on the Enhanced FTP server.

B. To move the import file from the Safehouse to Marketing Cloud.

C. To decrypt the import file on the Safehouse.

D. To move the import file from the Enhanced FTP server to the Safehouse

A developer wants to set a variable to use a field from a Sendable Data Extension.

Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension used to send the email? Choose 2answers

A. SET @firstName = [First Name]

B. SET @firstName = %%First Name%%

C. SET @firstName = attributeValue (''First Name'')

D. SET @firstName = ''First Name'']

A developer wants to add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?

A. GET using the REST API/asset/v1/content/assets and parse theFileProperties parameter

B. Use the SOAP API to create a Porfoglio object and idenfity the Source property

C. POST to the REST API/asset/v1/content/categories and parse the Description parameter

D. POST to the REST API/asset/v1/content/assets and parse the FileProperties parameter

How often should a developer request a new token when making multiple API calls in v1?

A. When changing routes/objects

B. Before every new call

C. Once an hour

D. Every 15 minutes

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?

A. Marketing Cloud does not allow DateAdd functions in Query Activities. They should define a specific date.

B. Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.

C. Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.

D. Marketing Cloud does not allow use of GETDATE function. They should define a specific date.

A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installedproperly. What should be confirmed next to continue troubleshooting the send's tracking information?

A. The audience was a Salesforce Data Extension containing the appropriate SFID

B. The email was sent to the All Subscribers list

C. The tracking destination folder was set to My Tracking

D. The audience was built using a Triggered Send Data Extension template

A developer wants to retrieve daily JSON data from a customer's API and write it to a data extension for consumption in Marketing Cloud at a later time.

What set of Server-Side JavaScript activities should the developer use?

A. Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();

B. Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();

C. Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();

D. Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();

A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer doesnot know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

A. %%[IF DIVIDE(@numerator,2) =1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

B. %%[IF SUBSTRING(DIVIDE(@numerator,2),1) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

C. %%[IF @numerator/2 = 1 THEN SET @color = 'Red'ELSE SET @color = 'White' ENDIF]%%

D. %%[IF MOD(@numerator,2) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

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 each month 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))

A developer needs to process a payload from an external system in a CloudPage.

What Marketing Cloud Server-Side JavaScript Platform function should be used for converting a string payload in JSON format to a JavaScript object?

A. Base64Decode

B. ParseJSON

C. CreateObject

D. Stringify

NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use to personalize emailsfrom an external data source?

A. External Objects

B. Tokenized Sending

C. Salesforce Shield

D. Single Sign-On

Certification Aid wants to import data from a CSV file into a Data Extension. The CSV file containsall relevant data. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

A. Add only

B. Overwrite

C. Add and update

D. Update only