1

Which AMPscript function is used to retrieve a single value from a data extension based on a lookup key?

ALookupRows() BLookup() CDataExtensionRowCount() DRetrieveDE()

2

What does the AMPscript function LookupRows() return?

AA single string value from the first matching row BA JSON array of matching records CA rowset object containing all matching rows DThe count of rows matching the lookup criteria

3

In AMPscript, which syntax is correct for an IF/ELSE conditional block?

A%%[IF @var == "value" THEN ... ELSE ... ENDIF]%% B%%[if(@var, "value") { ... } else { ... }]%% C<ctrl:if condition="@var == value"> ... </ctrl:if> D%%IF @var EQ "value" THEN ... END%%

4

Which AMPscript function outputs a value to the rendered email or page?

APrint() BEcho() CWrite() DOutput()

5

In Server-Side JavaScript (SSJS), which object is used to interact with Marketing Cloud data extensions?

APlatform.DE BPlatform.Function.CreateObject("DataExtension") CSFMC.DataExtension DMC.DataExtensionObject

6

Which Marketing Cloud REST API endpoint is used to initiate a triggered send?

A/messaging/v1/email/send B/email/v1/triggeredsend C/messaging/v1/messageDefinitionSends/{id}/send D/send/v2/email/triggered

7

What is the correct Marketing Cloud REST API endpoint to obtain an OAuth access token?

Ahttps://<subdomain>.auth.marketingcloudapis.com/v2/token Bhttps://<subdomain>.rest.marketingcloudapis.com/auth/token Chttps://login.salesforce.com/services/oauth2/token Dhttps://<subdomain>.soap.marketingcloudapis.com/oauth/token

8

Which data extension field type should be used to store a subscriber's email address as the primary key?

AText with max length 100 BEmailAddress type with Required flag CText with Primary Key and Required flags DEmailAddress type set as Primary Key

9

Which SQL statement is used in Automation Studio to query a sendable data extension for subscribers who have not opened an email in the last 90 days?

ASELECT * FROM _Open WHERE EventDate < DATEADD(day, -90, GETDATE()) BSELECT s.EmailAddress FROM Subscribers s WHERE s.EmailAddress NOT IN (SELECT SubscriberKey FROM _Open WHERE EventDate > DATEADD(day,-90,GETDATE())) CSELECT EmailAddress FROM _Sent WHERE OpenDate IS NULL AND SendDate < 90 DSELECT * FROM _Subscribers WHERE LastOpen < NOW() - 90

10

Which AMPscript function is used to insert or update a row in a data extension?

AInsertDE() BUpdateDE() CUpsertDE() DAddDE()

11

In the Marketing Cloud contact model, what is the purpose of the Contact Key?

AIt is the unique identifier that links a contact across all channels in Marketing Cloud BIt is the primary email address associated with a subscriber CIt is the Salesforce CRM Contact record ID DIt is an auto-generated sequence number for each send

12

Which SSJS library object provides access to WSProxy functionality for SOAP API calls within Marketing Cloud?

APlatform.SOAP BSFMC.WSProxy CCore.SOAP Dnew Script.Util.WSProxy()

13

What is the primary purpose of the Journey Builder Interaction REST API?

ATo create and edit email content within journeys BTo inject contacts into a journey or fire journey events programmatically CTo retrieve open and click tracking data for journey emails DTo configure journey canvas activities via code

14

Which AMPscript function retrieves the value of a field from a row returned by LookupRows()?

AGetRow() BGetValue() CField() DRowValue()

15

In SSJS, which function is used to write content to a CloudPage response?

APlatform.Response.Write() BResponse.Output() CDocument.Write() DPlatform.Print()

16

Which Marketing Cloud SOAP API object is used to retrieve subscriber status information?

AEmailSendDefinition BListSubscriber CSubscriberStatus DSubscriber

17

What is the Transactional Messaging API in Marketing Cloud used for?

ASending bulk promotional emails to all subscribers simultaneously BSending real-time, 1-to-1 triggered messages like order confirmations and password resets CScheduling recurring batch email sends DManaging subscriber list imports and exports

18

Which AMPscript function counts the number of rows returned by a LookupRows() call?

ACount() BRowCount() CRowCount() on the rowset DLookupCount()

19

Which Content Builder REST API endpoint is used to create a new content block?

APOST /asset/v1/content/assets BPOST /content/v1/blocks/create CPOST /contentbuilder/v1/assets DPUT /asset/v1/content/blocks

20

In Marketing Cloud, what is WSProxy primarily used for in SSJS?

AMaking external HTTP requests to third-party APIs BRendering AMPscript content within SSJS pages CConnecting to Salesforce CRM via the Connector DPerforming SOAP API operations without raw XML, using a simpler JavaScript wrapper

21

What does the AMPscript function DateAdd() return when called as DateAdd(@date, 7, "D")?

AThe date 7 hours after @date BThe date 7 days after @date CThe date 7 months after @date DThe date formatted as DD/MM/YYYY

22

When creating a triggered send in Marketing Cloud, which setting determines whether suppression lists are applied?

AEmail Type BPriority Level CSend Classification DThrottle Rate

23

Which AMPscript function is used to redirect a subscriber to a different URL from an email?

ARedirectTo() BRedirect() CNavigateTo() DLinkTo()

24

In SSJS, how do you perform an HTTP GET request to an external API?

APlatform.HTTP.Get(url) BSSJS.HTTP.Request(url, "GET") CHTTPRequest.Get(url) Dvar req = new Script.Util.HttpRequest(url); req.method = "GET"; req.send();

25

Which Automation Studio activity type allows you to run SQL queries against data extensions?

AData Extract Activity BQuery Activity CScript Activity DFilter Activity

26

What is the purpose of the Marketing Cloud "installed package" when setting up API access?

AIt installs third-party apps from the AppExchange into Marketing Cloud BIt provides a managed package for deploying email templates CIt creates a connected app that provides Client ID and Client Secret for OAuth authentication DIt synchronises subscriber data between Sales Cloud and Marketing Cloud

27

Which data view in Marketing Cloud stores email click tracking data?

A_Click B_ClickTracking C_EmailClick D_TrackingClicks

28

When using the Marketing Cloud REST API, what HTTP status code indicates a successful resource creation?

A200 OK B204 No Content C202 Accepted D201 Created

29

Which AMPscript function converts a string to uppercase?

AToUpper(@str) BUpperCase(@str) CUpper(@str) DStringUpper(@str)

30

In Marketing Cloud, what is a CloudPage?

AA template for creating responsive email layouts BA cloud-hosted file storage location for tracking pixels CA hosted web page within Marketing Cloud that supports AMPscript and SSJS DAn API endpoint for receiving incoming webhook data

31

Which grant type is used in Marketing Cloud's OAuth 2.0 authentication for server-to-server integrations?

Aclient_credentials Bauthorization_code Cpassword Dimplicit

32

Which AMPscript function checks if a variable is empty or null?

AIsNull(@var) BIsEmpty(@var) CCheckNull(@var) DEmpty(@var)

33

In Marketing Cloud's data extension SQL queries, which system data view contains bounce tracking information?

A_EmailBounce B_Bounce C_BouncedSubscribers D_HardBounce

34

What is the maximum number of lookup columns supported in a single AMPscript Lookup() function call?

A2 B5 C2 (column-value pairs) DUnlimited

35

Which SSJS function is used to serialize a JavaScript object to a JSON string?

AStringify(obj) BJSON.stringify(obj) CPlatform.JSON.Encode(obj) DSerializeJSON(obj)

36

Which Marketing Cloud component allows you to define reusable data entry points for Journey Builder?

AData Extension Entry Sources BAutomation Entry Events CSalesforce Data Entry Events DAPI Events configured as journey entry sources

37

When debugging AMPscript errors on a CloudPage, which function helps suppress errors and return a default value instead?

ATryCatch() BIIF() CSuppressError() DHandleError()

38

In Marketing Cloud, which data extension relationship type is used to store attributes related to a specific contact?

ARoot attribute group BPopulation data extension CContact attribute set linked via Contact Key DSubscriber attribute extension

39

Which AMPscript function concatenates multiple strings together?

AConcat() BJoin() CAppend() DMerge()

40

Which Marketing Cloud feature allows personalizing email content based on subscriber attributes without AMPscript?

AContent Builder Rules BJourney Decision Splits CEmail Studio Filters DDynamic Content blocks in Content Builder

41

In Marketing Cloud SOAP API, which request type is used to retrieve objects?

AQueryRequest BRetrieveRequest CGetRequest DSelectRequest

42

What does the AMPscript FOR loop structure look like?

A%%[FOR @i = 1 TO 10 STEP 1 { ... }]%% B%%[LOOP @i FROM 1 TO 10 DO ... END]%% C%%[FOR @i = 1 TO 10 DO ... NEXT @i]%% D%%[FOREACH @row IN @rows ... ENDFOREACH]%%

43

Which Marketing Cloud REST API verb is used to update an existing resource?

APATCH BPUT only CPOST with update flag DUPDATE

44

In Marketing Cloud, which feature prevents the same contact from entering a Journey Builder journey more than once while currently active in it?

AJourney Throttle Setting BSuppression List CHoldout Group DRe-entry setting on the journey

45

Which AMPscript personalization string retrieves the subscriber's email address?

A%%email%% B%%emailaddr%% C%%subscriber.email%% D%%EmailAddress%%

46

In Marketing Cloud, what is the purpose of a Sender Authentication Package (SAP)?

AIt encrypts data stored in data extensions at rest BIt provides multi-factor authentication for Marketing Cloud users CIt sets up dedicated IP, custom domain, and private domain for email sending authentication DIt authorises third-party apps to access the Marketing Cloud API

47

Which WSProxy method is used to retrieve Marketing Cloud objects in SSJS?

Aproxy.retrieve("ObjectType", cols, filter) Bproxy.get("ObjectType", filter) Cproxy.query("ObjectType", conditions) Dproxy.fetch("ObjectType", filter)

48

In Marketing Cloud, which data view stores unsubscribe tracking information?

A_Optout B_Unsubscribe C_GlobalUnsubscribe D_Unsubscribed

49

What is the correct AMPscript syntax to declare and set a variable?

A%%[var @name = "value"]%% B%%[SET @name = "value"]%% C%%[@name := "value"]%% D%%[LET @name = "value"]%%

50

Which Marketing Cloud REST API endpoint retrieves the status of an asynchronous request?

AGET /messaging/v1/status/{requestId} BGET /async/v1/results/{requestId} CGET /messaging/v1/messageDefinitionSends/{id}/deliveries DGET /email/v1/sends/{requestId}/status

Salesforce Certified Marketing Cloud Engagement Developer Mock Test