MARKETING-CLOUD-DEVELOPER Online Practice Questions and Answers

A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?

A. Use the RowCount function and an IF statement

B. Use the Lookup, Row and Field functions

C. Use the LookupOrderRows and Row functions

D. Use the DataExtensionRowCount function

What is the purpose of the IF statement below?

A. To handle when no row is returned by the LookupRows function

B. To handle when thesubscriber is in a held status

C. To handle when images are broken

D. To handle when there are multiple records in the data extension for the subscriber

A particular data extension need to be configured to store six months of data.

How should data retention be added to the data extension in Email Studio?

A. Run a query to overwrite the rows with six months of data

B. Import a file to overwrite the rows with six months of data

C. Create a new data extension that includes data retention settings

D. Update the data extension configuration to include data retention settings.

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 populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

A. SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC

B. SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY

C. SubscriberKey

D. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

E. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

Certification Aid wantsto add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.

A. Personalization Builder API

B. Event Notification API

C. Transactional Messaging API

D. Journey Builder API

Certification Aid sends an email to a newly imported List with Subscribers who have no associated Subscriber Key. Which value will become the Contact Key? Choose 1.

A. Contact ID

B. Email address

C. Subscriber ID

D. Unique random number

Northern Trails Outfitters (NTO) has asendable data extension with 1,500,000 contact records they want to delete.

Which step is required before deleting the contacts?

A. Query the records into a new sendable data extension and delete it

B. Navigate to Contact Builder and delete the data extension

C. Divide the records in half and delete each resulting data extension

D. Navigate to Email Studio and delete the data extension

Northern Trail Outfitters sends a weekly email with dynamic content, and they want to record custom data inside a send log on each send to record what content was displayed and correlation flags.

What is the maximum number of custom data points recommended by Salesforce to ensure sends speeds are not affected when inserting into the built-in send log?

A. 20 fields or less

B. 10 fields or less

C. No limit

D. 5 fields or less

A developer identified duplicate contacts and initiated aContact Delete process for 10 million subscribers. How could the process be expedited?

A. Change the Suppression value to a larger value

B. Manually delete subscribers in All Contacts

C. Stop current delete process and delete smaller groups

D. Delete anyunnecessary Sendable Data Extensions

A dataextension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.

Which SELECT statement is optimal for returning all of the columns in the data extension?

A. SELECT field*

B. SELECT*, field1, field2, field3

C. SELECT*

D. SELECT 22SE, field2, field3

NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of the recipient. Language is stored in a Profile Attribute. Which two Data Views would be included in the query? Choose 2 answer

A. _Subscribers

B. _Subscribers

C. _AllSubscribers

D. _Click

A developer wants to configure an automation to import files placed on the SFTP shared by a customer's data vendor. The automation will start when a file matching a specific naming pattern is encountered in the Import folder. The first step of the automation is a File Import Activity referencing a substion string for the matching file. Which substituon string represents the name of the file?

A. %%FILENAME%%

B. %%TRIGGER_FILENAME%%

C. %%FILENAME_FROM_TRIGGER%%

D. %%FILENAME_FROM_IMPORT%%

A developer needs to push real-time updates of the company's product catalog to adata extension.

Which two API options are available? Choose 2 answers

A. Use the DataExtensionObject SOAP object

B. Use the /hub/vl/aataevents REST route

C. Use the DataExtension SOAP object

D. Upload a file to the Enhanced SFTP for import

A developer needs to use the 'contacts/ route of the REST API to update records in a data extension.

What should the developer verify before making the API call?

A. Each contact should already exist in AllSubscribers.

B. Journey Builder should be configured to use the data extension.

C. Contact Key should be equal to Subscriber Key in the underlying data extensions to ensure proper joining.

D. The data extension should be linked in an Attribute Group in Contact Builder.