Question 1

A developer is writing a query to select unique subscribers who opened any emails sent since the beginning ofthe previous day.Which querywould provide that result?

Options :

A :

B :

C :

Answer: C

Question 2

A developer wants to populate a data extension with the date of the most recent click for each subscriber.Which query would accomplish this?

Options :

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

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

D : SELECT c.SubscriberKey, c.eventDate FROM_Click c WHERE c.IsUnique = 1

Answer: C

Question 3

NTO uses data extensions to manage the subscriber information usedfor their email sends, and those sendsincludes calls to update records with new or different subscriber information. The developer handling theserecords writes some AMPscript to check and see if the data extension containing those records updatedusingan InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating theapplication cannot insert a duplicate value for the primary key in the data extension?

Options :

A : The InsertDE function will always insert two rows into a data extension as part of the call

B : The InsertDE function cannot be used with name and value pairs

C : The InsertDE function comes after the system added the row as part of the email send

D : The InsertDE function cannot be used at send time

Answer: D

Question 4

A developer needs to import a file into a data extension which contains transactional data. The file includes acolumn labeled Purchase_Price with values varying from '$.05' to '$100'.What Data Type should be used to prevent loss of data'

Options :

A : Text

B : Number

C : Decimal(9,2)

Answer: C

Question 5

NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Theirdeveloper wrote the call using the TriggerSendDefinition object and the Create method, but noemails havebeen sent during his initial testing. Which object and method should the developer use?

Options :

A : TriggerSend object and Update method

B : TriggerSend object and Create method

C : TriggerSendDefinition object and Execute method

D : TriggerSendDefinitionobject and Update method

Answer: B

Free MCE-Dev-201 Mock Exam – Practice Online Confidently

Buying Options: