MARKETING-CLOUD-DEVELOPER Online Practice Questions and Answers

A marketer is planning a weekly promotional send.

Which two types of data extensions could be sent to? Choose 2 answers

A. Synchronized Data Extension

B. Sendable Data Extension

C. Salesforce Data Extension

D. Send Log Data Extension

A developer used LookupRows toretrieve data when building a dynamic email.

What should be the next step before using this rowset within a FOR loop?

A. Use Row to return a specific row of the rowset

B. Set the rowset to a new array variable

C. Close the delimited AMPscrlpt Code Block

D. Use RowCount to ensure the rowset contains data

A developer wants to create a JavaScript Web Token using a key from Key Management.

What function should the developer use?

A. ContentBlockByKey()

B. GetJWTByKeyName()

C. RegExMatch()

D. GeUWT()

A developer is making an API REST call to trigger an email send. An access token is used toauthenticate the call.

How long are Marketing Cloud v1 access tokens valid?

A. Access tokens expire after 24 hours.

B. REST calls do not require an access token.

C. Each API call requires a new access token.

D. Access tokens expire after one hour.

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

A. Use intrisic functions in the WHERE clause

B. Use SELECT * to include all fields

C. Use Primary key(s) on fields used in joins

D. Use intermediate tables to stage data

E. Only update records that have changed since last execution

What can be created in Attribute Groups within Contact Builder? Choose 2.

A. Data Extensions

B. Relationships

C. Populations

D. Attribute Groups

Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named 'Inventory', which contains the details for each product. A Boolean field named'InStock' indicates whether the item is available.

Which snippet of AMPscript would return all products which are currently available?

A. LookupRows ('Ent. Inventory*, 'true', 'InStock')

B. LookupRows ('Ent. Inventory*, itemName, 'InStock', 'true')

C. LookupRows ('Ent. Inventory*, 'InStock', 'true', )

D. LookupRows ('Inventory*, 'InStock' 'true',)

A developer wants to delete a batch of subscribers from Marketing Cloud. The developer performs a Contact Delete on a batch of records in a data extension in Contact Builder. Which scenario would cause subscriber records to remain in the data extension?

A. Sendable data extension with SubscriberKey and EmailAddress fields

B. Non-sendable data extension with SubscriberKey field

C. Contact Delete process does not delete rows from data extensions

D. Sendable data extension with SubsciberKey field

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]%%

Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.

A. DataExtensionObject object

B. Subscriber object

C. Attribute object

D. DataExtension object