SFMC Developer Certification Mock Test

Test your technical prowess with our SFMC Developer mock test. Designed to mirror the actual certification exam, this test will challenge your knowledge on scripting languages, data models, and more.

Introduction

Aspiring to be a certified SFMC Developer? Our mock test is your perfect companion in your preparation journey. Experience a realistic test environment and get to know where you stand.

Features

Over 120 multiple-choice and code-based questions.
Timed test to replicate the pressure of the real exam.
Instant feedback and code evaluations.
Comprehensive explanations for each question.

1 / 60

1. What would be the output of the following AMPscript code?
%%[ var @tier, @amount, @freeShipping set @tier = “Platinum” set @totalAmount = 400 if @tier == “Platinum” or @tier == “Gold” and @totalAmount > 500 then set @freeShipping = true endif ]%% You %%=Iif(@freeShipping == true, “qualify”, “do not qualify”)=%% for free shipping.

You qualify for free shipping.

You do not qualify for free shipping.

You for free shipping.

Error

2 / 60

2. Which AMPscript function is used to encrypt the query string in an URL?

TreatAsContent

CloudPagesURL

RedirectTo

None of the above

3 / 60

3. Which AMPscript function is used to retrieve the field values from the HTML form?

RequestParameter

HTTPGet

QueryParameter

None of the above

4 / 60

4. What would be the output of the following AMPscript code?
%%[ var @x, @y, @result set @x = 24 set @y = 4 set @result = Mod(Divide(Add(Multiply(Subtract(@x,@y),@y),@x),@y),@x) ]%% %%=v(@result)=%%

5 / 60

5. What would be the output of the following AMPscript code?
%%[ var @membership, @loyaltyPoints, @discount set @membership = “Gold” set @loyaltyPoints = 400 if empty(@membership) and not @loyaltyPoints > 500 then set @discount = 5 else set @discount = 10 endif output(@discount) ]%%

Error

None of the above

6 / 60

6. What would be the output of the following code?

SFMC

SFMCCertification

SFMC-Certification

Error

7 / 60

7. What would be the output of the following code?
%%[ var @name, @result set @name = "Trailhead" set @result = substring(@name, length(@name), -4) ]%% %%=v(@result)=%%

Trailhead

Trail

head

Error

8 / 60

8. What would be the output of the following code?

%%[
var @startDate, @currentDate, @diffYear
set @startDate = '2022-12-01 00:00 AM'
set @currentDate = '2023-04-19 00:00 AM'
set @diffYear = dateDiff(@startDate, @currentDate,"Y")
]%%
%%=v(@diffYear)=%%

NULL

Error

9 / 60

9. Which of the following AMPscript syntax is correct?

%%[
set name
var name = “Salesforce”
]%%

%%[
var @name
set @name = “Salesforce”
]%%

%[
var @name
set @name = “Salesforce”
]%

%%[
var @name
@name = Salesforce
]%%

10 / 60

10. In order to utilize SSJS Platform library functions, we need to call the library via Platform.Load('Core', '1')

True

False

11 / 60

11. Which of the following is used for error handling in SSJS?

try/catch

if/else

None of the above

12 / 60

12. Which of the following is the correct syntax for SSJS?

All of the above

13 / 60

13. What will be the output of the following code?

certification

developer

certification: developer

Error

14 / 60

14. Which SSJS function is used to convert a JavaScript object into a JSON string value?

ParseJSON

Stringify

Convert

Object

15 / 60

15. Which among the following is not an AMPscript function?

CreateSalesforceObject

RetrieveSalesforceObjects

UpdateSingleSalesforceObject

DeleteSalesforceObject

16 / 60

16. What is correct order of operations for AMPscript?

HTML > Text > Subject Line

Text > HTML > Subject Line

Subject Line > Text > HTML

Text > Subject Line > HTML

17 / 60

17. How can you access an SSJS variable to retrieve the required information?

<ctrl:field>“varName“</ctrl:field>

<ctrl:var name=“varName“ />

<ctrl:field name=“varName“ />

<ctrl:eval name="varName" />

18 / 60

18. The developer wants to pull the list of records created in the last 24 hours using AMPscript. What logic will produce the desired output?

DateAdd(Now(), 24, “H”)

DateAdd(Now(), 24, “M”)

DateAdd(Now(), -24, “D”)

DateAdd(Now(), -24, “H”)

19 / 60

19. A data extension has a column with a value separated by a delimiter. Which AMPscript function can be used to split the value based on the delimiter?
Example: a|b|c|d
Result:
a
b
c
d

Substring

BuildRowSetFromString

Split

Char

20 / 60

20. The developer wants to display the output of a variable in SSJS, which among the following should be used?

21 / 60

21. After you add an API integration component in the Installed Package, you can’t delete it.

True

False

22 / 60

22. When making an API request, the user receives the response with code 200. What does it represent?

Successful Request

Unauthorized Request

Bad Request

Service Unavailable

23 / 60

23. Genetrix wants to send a Triggered Email to its client when they fill out a form on
the website. Which API should be used?

SOAP API

REST API

SOAP and REST API

SOAP or REST API

24 / 60

24. A developer receives a 401 unauthorised status from a REST API request. What can be the reason for this?

Requested resource not found

Too many send requests

Token is either invalid or lacks valid authentication

None of the above

25 / 60

25. Genetrix wants to create a template under content builder based on the data received from an external source. Which API should be used?

SOAP API

REST API

XML API

Content API

26 / 60

26. Select the statements that are true regarding OAuth 2.0 access token for the API.

Expires after 20 min

request using POST /v2/accessToken

Expires after 120 min

request using POST /v2/token

27 / 60

27. Which component should be created in an Installed Package within Marketing Cloud for utilizing APIs?

API Integration

Custom Integration

Data Integration

None of the above

28 / 60

28. The developer wants to send a transaction email message to the user who has registered for a credit card on the website. Which REST API endpoint should be used for this request?

POST /messaging/v1/{messageKey}

POST /messaging/v1/email/{messageKey}

POST /messaging/v1/messages/{messageKey}

POST /messaging/v1/email/messages/{messageKey}

29 / 60

29. Which of the following statements are correct regarding Send Logs? Choose 2.

Send logs allows to capture run-time information about an email send

Default fields in Send Logs can be modified

Custom fields can be added to Send Logs

Multiple Send Logs can be created per channel per MID

30 / 60

30. The following are the two data extensions setup in SFMC - CustomerDE and OrderDE

CustomerDE

Id	FirstName	LastName
101	Ross	Geller
102	Rachel	Green
103	Chandler	Bing

OrderDE

Id	Item	Amount	Customer_Id
O-001	Monitor	14000	101
O-002	Mouse	400	101
O-003	Laptop	30000	102
O-004	Keyboard	800	103
O-005	Mouse	400	103

A user wants to display the customers with total orders, total amount, and have purchased more than one item. Which of the following is the correct query?

SELECT Id, FirstName, LastName, COUNT(o.Id), SUM(o.Amount)
FROM CustomerDE c
JOIN OrderDE o
ON c.Id = o.Customer_Id
GROUP BY Id, FirstName, LastName
HAVING COUNT(o.Id) > 1

SELECT Id, FirstName, LastName, COUNT(o.Id), SUM(o.Amount)
FROM CustomerDE c
JOIN OrderDE o
ON c.Id = o.Customer_Id

SELECT Id, FirstName, LastName, o.Id, SUM(o.Amount)
FROM CustomerDE c
JOIN OrderDE o
ON c.Id = o.Customer_Id
HAVING COUNT(o.Id) > 1
GROUP BY Id, FirstName, LastName, o.Id

SELECT Id, FirstName, LastName, o.Id, SUM(o.Amount)
FROM CustomerDE c
JOIN OrderDE o
ON c.Id = o.Customer_Id
GROUP BY Id, FirstName, LastName, o.Id

31 / 60

31. A developer wants to populate the data extension with the latest transaction date for each subscriber. Which query can be used?

SELECT subscriberKey, transactionDate FROM Orders

SELECT TOP 1 subscriberKey, transactionDate FROM Orders

SELECT subscriberKey, transactionDate FROM Orders ORDER BY transactionDate desc

SELECT subscriberKey, MAX(transactionDate) FROM Orders GROUP BY subscriberKey

32 / 60

32. Which of the following statements are true regarding Data Views? Choose 2.

Data Views cannot be customised

Data Views have a retention period of 6 months

Data Views can be customised by adding custom fields

Data Views can be accessed from the Interface/UI

33 / 60

33. The developer wants to query the total number of bounces for each domain based on a specific email job. Which query should be used to achieve this?

SELECT b.jobid, b.domain
FROM [_bounce] b
WHERE b.jobid = EMAIL_JOB_ID
GROUP BY b.jobid, b.domain

SELECT b.jobid, b.domain, Count(*) AS BounceCount
FROM [_bounce] b
WHERE b.jobid = EMAIL_JOB_ID
GROUP BY b.jobid, b.domain

SELECT b.jobid, b.domain, Count(*) AS BounceCount
FROM [_bounce] b
WHERE b.jobid = EMAIL_JOB_ID

SELECT b.jobid, b.domain, Count(*) AS BounceCount
FROM [_bounce] b
GROUP BY b.jobid, b.domain
WHERE b.jobid = EMAIL_JOB_ID

34 / 60

34. Which data model is used to store relational data and can store more than 500,000 records?

Lists

Data Extensions

Lists and Data Extensions

None of the above

35 / 60

35. Which of the following can be used with data extensions for managing subscriber-level opt-ins and opt-outs?

Exclusion List

Suppression List

Publication List

All of the above

36 / 60

36. What is the default period where Contact Builder suppresses contact information from showing up in all the channels?

2 days

7 days

14 days

30 days

37 / 60

37. What is correct order for Contact Deletion Process?

Suppression > Deletion > Initiation

Suppression > Initiation > Deletion

Initiation > Deletion > Suppression

Initiation > Suppression > Deletion

38 / 60

38. In an Enterprise 2.0 account, the developer wants to delete 3 million records from a child business unit. Which steps can help to achieve this? Choose 2.

Create a single deletion request for 3 million records

Create three deletion requests for 3 million records

Initiate contact deletion in child business unit

Initiate contact deletion at parent/top-level business unit

39 / 60

39. Under Contact Builder, when an attribute group is deleted, the data extensions within that attribute group are also deleted.

True

False

40 / 60

40. Which among the following cannot be placed in a shared folder for sharing the data with other business units in Enterprise 2.0 account?

Data Extensions

Data Filters

Publication List

Suppression List

41 / 60

41. Which of the following statements are correct regarding Exclusion Scripts? Choose 2.

AMPscript blocks can be added

Variables cannot be set

The expression must evaluate to true or false

Used for segmenting

42 / 60

42. The data retention policies cannot be set for an existing data extension that contains 10,000 records.

True

False

43 / 60

43. The developer has created a data extension with test records. But when previewing the email, the data extension is not appearing for selection. What should be done to resolve this issue?

Enable IsSendable checkbox

Enable IsTestable checkbox

Enable IsSendable and IsTestable Checkbox

Enable IsVisible and IsTestable Checkbox

44 / 60

44. The developer wants to randomly select 10% of the subscribers from a Data Extension using SQL. Which among the following should be used?

SELECT TOP PERCENT 20 SubscriberKey, EmailAddress FROM CustomerData

SELECT TOP RANDOM 20 SubscriberKey, EmailAddress FROM CustomerData

SELECT RANDOM PERCENT 20 SubscriberKey, EmailAddress FROM CustomerData

SELECT TOP 20 PERCENT SubscriberKey, EmailAddress FROM CustomerData

45 / 60

45. The developer has deleted 100 contacts from the account using the contact deletion process. Where will the contacts be deleted from?

Sendable Data Extension

Non-Sendable Data Extension

Synchronized Data Extension

All of the above

46 / 60

46. The developer wants to create contacts in Marketing Cloud. Which REST API endpoint should be used for this request?

GET /contacts/v1/contact

POST /contacts/v1/contacts

POST /v1/contacts

GET /v1/contacts

47 / 60

47. How can a Developer reference an attribute in AMPscript?

%%[SET @name = FieldValue(“Name”)]%%

%%[SET @name = Attribute[“Name”]]%%

%%[SET @name = Field[“Name”]]%%

%%[SET @name = AttributeValue(“Name“)]%%

48 / 60

48. Which AMPscript function enables the suppression or cancellation of an email send, and can be used for exception handling?

ThrowError

RaiseError

ShowError

SuppressError

49 / 60

49. What would be output of the following AMPscript code?

%%[
var @tier, @level
set @tier = "Silver"
if length(@tier) > 1 then
set @level = 1
elseif length(@tier) > 2 then
set @level = 2
elseif length(@tier) > 3 then
set @level = 3
endif
set @level = 4
]%%

50 / 60

50. Genetrix adds a prefix GEN for each of their email names (example: GEN_Welcome_Email). Which query should the developer use to retrieve the list of subscribers who have received the email?

SELECT s.subscriberKey FROM _job j
INNER JOIN _sent s on j.JobID = s.JobID
WHERE j.EmailName = 'GEN%'

SELECT s.subscriberKey FROM _job j
INNER JOIN _sent s on j.EmailName LIKE 'GEN%'

SELECT s.subscriberKey FROM _job j
INNER JOIN _sent s on j.JobID = s.JobID
WHERE j.EmailName LIKE 'GEN%'

SELECT s.subscriberKey FROM _job j
INNER JOIN _sent s on j.JobID = s.JobID
WHERE j.EmailName IN ('GEN')

51 / 60

51. Which among the following is a valid data type in Data Extension?

Picklist

Decimal

TextArea

Currency

52 / 60

52. Which among the following is the correct syntax for a lookup function in SSJS Platform library?

53 / 60

53. In Marketing Cloud, the send log data extensions do not capture the content builder test sends.

True

False

54 / 60

54. Which among the following statements are true regarding server-to-server integration? Choose 2

server-to-server makes API request in context of an end user

server-to-server makes API request in context of an integration user

server-to-server uses grant type as Client Credentials

server-to-server uses grant type as JSON web token(JWT)

55 / 60

55. Which SSJS function is used to retrieve information from specified form fields, such as data included in POST requests?

GetRequestHeader

GetPostData

GetFormField

GetFieldData

56 / 60

56. Which data view should be used to find unsubscribe data for the subscribers at a business unit level?

_SubscriberUnsubscribe

_UserUnsubscribe

_AccountUnsubscribe

_BusinessUnitUnsubscribes

57 / 60

57. What value does the developer use to uniquely identify subscribers in email studio?

SubscriberKey

SubscriberID

ContactKey

Contact ID

58 / 60

58. Genetrix wants to import a list of subscribers into a data extension to send an email. In the data extension, only the new records should be added and those that are not in the file should be deleted. Which operation should be used for this?

Update

Add and Update

Overwrite

Add

59 / 60

59. Which SSJS library is mainly used to interact with Email Studio objects via SOAP API?

Platform

Object

Core

60 / 60

60. In an Enterprise 2.0 account, the developer wants to pull the data from a data extension that is part of the shared folder. Which query should be used to achieve this?

SELECT Id, FirstName, LastName, Email
FROM ProfileData

SELECT Id, FirstName, LastName, Email
FROM Ent.ProfileData

SELECT Id, FirstName, LastName, Email
FROM Enterprise.ProfileData

SELECT Id, FirstName, LastName, Email
FROM Account.ProfileData

Your score is

Please rate this quiz

Thank you for participating in the quiz

Quick Links

Our Services

Subscribe to our newsletter

COPYRIGHT ©

ALL RIGHTS RESERVED