Question 1

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 2

A developer wants to include a comment within an AMPscript code block for the benefit of other developerswho will be reviewing the code.Which syntax should the developer use?

Options :

A : < !- This is a comment

B : // This is acomment

C : -- This is a comment

D : /" This is a comment */

Answer: D

Question 3

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

Question 4

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 5

What parameter should a developer include to ensure the MobileConnectContact is tied to the Email Contactwhen making a QueueMO call for an existing email subscriber?

Options :

A : mobilenumbers

B : phonenumbers

C : emailaddress

D : subscribers

Answer: C

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

Buying Options: