A developer must identify every subscriber who was sent Job ID 420 but did not click any links.
Which SQL statement would return the required results?
ASELECT s.SubscriberKey -FROM _Sent s -JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobIDWHERE s.JobID = 420
BSELECT s.SubscriberKey -FROM _Sent s -LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobIDWHERE s.JobID = 420
CSELECT s.SubscriberKey -FROM _Sent s -LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobIDWHERE s.JobID = 420 AND c.SubscriberKey IS NULL
0
Community Discussion
No comments yet. Be the first to start the discussion!
Which AMPscript function returns the result of code interpreted within a code block and includes that result in the rendered content where the code block is located?
AOutput
BTreatAsContentArea
CV
0
Community Discussion
No comments yet. Be the first to start the discussion!
A developer created a complex dynamic email with many data variations. Instead of manually creating test data, they want to use a subset of live data to validate the email’s dynamic aspects.
Which SQL function should be used to obtain a representative sample from a larger data set?
AOVER
BNTILE
CHAVING
0
Community Discussion
No comments yet. Be the first to start the discussion!
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Save question
0
Community Discussion
No comments yet. Be the first to start the discussion!
Which object must be included to successfully create a TriggeredSend object?
ATriggeredSendDefinition
BAttribute
CContact
Northern Trail Outfitters wants to send a receipt email through the SOAP API whenever a customer completes a purchase. Their developer used the TriggeredSendDefinition object with the Create method, but no emails have been sent in initial testing.
Which object and method should the developer use?
ATriggeredSendDefinition object and Update method
BTriggeredSend object and Create method
CTriggeredSend object and Update method
A developer needs to use the RaiseError AMPscript function when a subscriber lacks the required data to construct an email.
Which outcome can this function produce?
AThe email is not sent to the particular subscriber.
BAn error message is sent to the From Address used in the email.
CThe send is retried
A developer is investigating why an API client_id and client_secret authenticate successfully but cannot access data in a child business unit.
What should be verified to confirm that the installed package can access the child business unit’s data?
AThe account_id and parent MID are included in the authorization call
BThe Installed Package has access to the selected child business unit
CThe Installed Package has full Enterprise access to all available child business units
A developer needs to create an HTML table whose rows alternate background colors between white and red. The developer does not know how many rows will be sent in each email, so they use a loop and assign the RowCount() of the table rows to the variable @numerator.
What AMPscript logic should be used within the loop to determine the background color for each table row?
A%%[ IF MOD(@numerator,2) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF ]%%
B%%[ IF SUBSTRING(DIVIDE(@numerator,2),l) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF ]%%
C%%[ IF @numerator/2 = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF ]%%
A developer built an email that uses the @subjectLine variable for its subject line. After revisions, the developer declared @subjectLine in multiple places within the email, including:
%%[ SET @subjectLine = 'Enjoy 10% off today' ] %% declared at the top of the HTML body
%%[ SET @subjectLine = 'Enjoy 15% off today' ]%% declared at the top of the Text body
%%[ SET @subjectLine = 'Enjoy 5% off today' ] %% declared at the bottom of the HTML body
%%[ SET @subjectLine = 'Enjoy 20% off today' ]%% declared within the Subject Line
Which subject line will be used at deployment time?
AEnjoy 10% off today
BEnjoy 20% off today
CEnjoy 15% off today
A developer must identify every subscriber in the Customers data extension who has made a purchase during the past 30 days. Purchase information is stored in the Orders data extension, which includes a column named PurchaseDate. Contacts are identified in both data extensions by a column named ContactKey, and the Orders data extension can include multiple instances of the same subscriber.
Which SQL keyword should the developer use to obtain the required result?
AOUTER JOIN
BINNER JOIN
CORDER BY PurchaseDate ASC
A developer is using the SOAP API to dynamically show Profile and Preference Attributes in a custom profile center.
Which method can support this dynamic functionality?
AConfigure
BExtract
CDescribe
A specific data extension must be configured to retain six months of data.
How should data retention be applied to the data extension?
AUpdate the data extension configuration.
BImport a file to overwrite the rows with six months of data.
CRun a query to overwrite the rows with six months of data.
Northern Trail Outfitters (NTO) wants to identify the best identifier for subscribers across every channel.
What should be recommended?
AContact Key
BSubscriber ID
CEmail Address
An AMPscript UpdateDE function updates a column value in a data extension row when an email is sent. The email is sent to 250,000 subscribers, but the user cancels the send while it is in progress and only 400 emails are sent.
How many subscriber rows are affected by the UpdateDE function?
A400 subscribers who were sent the email
BNo rows are updated
COnly subscribers who exist in All Subscriber
A developer needs to extract tracking data from Marketing Cloud to an FTP site. A marketer has created a Data Extract Activity in the user interface.
Which option is available for extracting the data?
AAutomation Studio
BJourney Builder
CREST API
Northern Trail Outfitters uses an asynchronous SOAP API call to the TriggeredSend object to deliver order-confirmation emails to customers.
Which API object and attribute should be used to obtain the API call’s status?
AResult Object and EmailAddress
BResultItem Object and RequestID
CResultItem Object and OrderID
A developer is creating an integration with the Marketing Cloud API.
Which configuration should be selected for the API integration component in its associated Installed Package?
ASelect the 'Require Secret for Web Server Flow' option.
BSelect the minimum required scope for the integration.
CSelect the 'Admin-approved users are pre-authorized' option under Permitted Users.
A developer must import a file each night for use by multiple SQL Query Activities. The file may arrive at any time between 2 a.m. and 5 a.m., and a requirement is to use a unique filename for every import instead of overwriting the file on the FTP site.
Which action should be configured?
AFile Drop Automation
BScheduled Automation
CDynamic File Import
A developer wants to build a data model in Contact Builder.
Which application can use this newly created data model for segmentation?
AJourney Builder
BAutomation Studio
CEmail Studio
A developer must add From Addresses to Marketing Cloud and ensure they are verified before they are used for sending.
A developer is asked to integrate Marketing Cloud with a lead-capture tool. The lead-capture tool will call the Marketing Cloud API to create a data extension whenever a new lead form is published. The name of each created data extension must exactly match the form name.
Which API feature could dynamically create these data extensions?
AREST API using POST on the /interaction/v1/EventDefinitions endpoint with Schema populated
BSOAP API using Create Method and the DataExtension Object
CCreating the data extension using API is not possible
A developer needs to aggregate monthly energy-usage data across a four-month period for each subscriber in an email. The monthly usage values are stored in variables for each month as follows:
SET @jan = LOOKUP("energyusage","jan","subscriber_key",_subscriberKey)
How should AMPscript be used to produce the total?
ASET @total = (ADD(@jan,@feb), ADD(@mar, @apr))
BSET @total = ADD(@jan,ADD(@feb,ADD(@mar,@apr)))
CSET @total = ADD(((@jan, @feb) @mar) @apr)
A developer started a batch deletion of Contacts in Contact Builder after an import error during implementation. More than two million records need to be deleted.
Which factor should be considered when batch-deleting a large volume of contacts?
AThe deletion process supersedes other automated account activities.
BTo more quickly remove contact information, use the suppression period length of 14.
CUp to one million records can be deleted in each batch.
Community Discussion