Certified Marketing Cloud DeveloperPreview

A developer wants to create a Send Log Data Extension to increase efficiency with tracking email sends.
Which best practice should be utilized when configuring the Send Log Data Extension?

A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links.
Which SQL statement would produce the desired results?

Which AMPscript function returns the result of interpreted code within a code block and includes the result in the rendered content, where the code block is located?

A developer built a complex dynamic email with many data variants. Rather than create test data manually, they want to use a subset of live data to validate the dynamic aspects of the email.
Which SQL function should be used to collect a representative sample from a larger data set?

Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code.
Which object is required to successfully create a TriggeredSend object?

A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator.
What AMPscript logic should be used to determine the background color of each table row within the loop?

A developer is troubleshooting why an API client_id and client_secret are authenticating yet failing to access data from a child business unit.
What should be checked to validate the installed package can access the child business unit data?

Northern Trail Outfitters wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggeredSendDefinition object and the Create method, but no emails have been sent during his initial testing.
Which object and method should the developer use?

A developer wants to use the RaiseError AMPscript function when a subscriber does not have the necessary data to build an email.
Which outcome is possible using this function?

A developer created an email using the @subjectLine variable as the subject line. Due to revisions, the developer declared @subjectLine in multiple locations throughout the email, including:
• %%[ SET @subjectLine = 'Enjoy 10% off today' ] %% was declared at the top of the HTML body
• %%[ SET @subjectLine = 'Enjoy 15% off today' ]%% was declared in the top of the Text body
• %%[ SET @subjectLine = 'Enjoy 5% off today' ] %% was declared at the bottom of the HTML body
• %%[ SET @subjectLine = 'Enjoy 20% off today' ]%% was declared within the Subject Line
Which subject line will be used at the time of deployment?

A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a column called 'PurchaseDate'. Contacts are identified in both data extensions by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscriber.
Which SQL keyword should the developer use to achieve the desired result?

A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center.
Which method could be used to support the dynamic functionality?

A particular data extension needs to be configured to store six months of data.
How should data retention be added to the data extension?

An UpdateDE AMPscript function is used to update a column value in a data extension row when an email is sent. The email is being sent to 250,000 subscribers, but the user decides to cancel the send during the sending process and only 400 emails are sent.
How many subscriber rows would be affected by the UpdateDE function?

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels.
What should be recommended?

A developer wants to extract tracking data from the Marketing Cloud to an FTP site. A marketer created a Data Extract Activity in the user interface.
Which option would be available to extract the data?

Northern Trail Outfitters is using an asynchronous SOAP API call to the TriggeredSend object to send order confirmation emails to their customers.
Which API object and attribute should be used to retrieve the status of the API call?

What is the purpose of the IF statement below?

A developer is building an integration using the Marketing Cloud API.
Which configuration should be used for the API integration component in the associated Installed Package?

A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?

A developer wants to create a data model in Contact Builder.
Which application will be able to use this newly-created data model for segmentation?

A developer needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending.
Which route would allow this?

A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will call the Marketing Cloud API to create a data extension every time a new lead form is published. The created data extension's name should match the name of the form exactly.
Which API feature could be used to dynamically create these data extensions?

A developer wants to aggregate monthly energy usage data over a four-month period for each subscriber within an email. The monthly usage values are stored in variables for each month in the following way:
SET @jan = LOOKUP("energyusage","jan","subscriber_key",_subscriberKey)
How should AMPscript be used to generate the total?