MARKETING-CLOUD-DEVELOPER Online Practice Questions and Answers

A customer wants a list of subscribers who were sent an email within the past 12 months.

How should thisrequest be completed?

A. Create a measure with criteria sent_date is after today minus 565 days

B. Run a tracking extract via the SOAP API

C. Query against the Job and Sent data views

D. Locate the email sends in the Tracking tab within Email Studio

NTO puts the word TEST at the beginning of the name for each testemai. Which query would return the subs who were sent those emails?

A. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'

B. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'

C. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE

D. EmailName LIKE 'TEST%'

E. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE

F. EmailName = 'TEST%'

What parameter should a developer include to ensure the MobileConnect Contact is tied tothe Email Contact when making a QueueMO call for an existing email subscriber?

A. mobilenumbers

B. phonenumbers

C. emailaddress

D. subscribers

When do synchronous REST API calls to Marketing Cloud time out?Choose 2.

A. 240 seconds for tracking and data retrieve operations.

B. 300 seconds for tracking and data retrieve operations.

C. 120 seconds for non-tracking operations.

D. 240 seconds for non-tracking operations.

A developer wants to retrieve a row of data from a data extension using the SOAP API.

Which API Object should be used for this call?

A. DataExtensionField

B. DataExtension

C. DataExtensionObject

D. Row

A developer started a Contact Delete process that is now complete.

In which two places would the ContactDelete process remove data? Choose 2 answers

A. Non-Sendable Data Extensions

B. Import Files on the Enhanced SFTP

C. Sendable Data Extensions

D. Mobile Lists

A customer wants to export send data to their SFTP. Which two automations would accomplish this? Choose2

A. Tracking Extract

B. Tracking Extract > File Transfer

C. Query (Data Views) > Data Extension Extract > File Transfer

D. Query (Data Views) > File Transfer

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

A developer needs to determine why a Query Activity in an Automation has failed.

Which three scenarios could have caused this? Choose 3 answers

A. The query takes more than 60 minutes to run.

B. The query is returning more than one million rows.

C. The query results in duplicate rows not allowed by the primary key.

D. The query is not returning a value for a non-nullable field.

E. The query is inserting a value that is larger than the size of a field.

A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose 2

A. Request the Impression Tracking feature be enabled on the account

B. Include the functions BeginImpressionRegion and EndImpressionRegion

C. Configure dynamic content block in Content Builder

D. Add a unique identifier in the HTML tags within the generated content