Q94. NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns.
They request a developer to create a query which aggregates clicks grouped by language of the recipient.
Language is stored in a Profile Attribute.Which two Data Views would be included in the query? Choose 2 answer

Q95. 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:
How should the developer use AMPscript to generate the total?

Q96. How often should a developer request a new token when making multiple API calls in v1?

Q97. Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website. Which API should be used for this? Choose 2.

Q98. 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?

Q99. 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?

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

Q101. A developer wants to expand the functionality of existing code which was written in AMPscript, but prefers to use Server-Side JavaScript (SSJS) for updates.
Which SSJS statement will retrieve the value of the AMPscript variable named subKey?

Q102. A developer used LookupRows to retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?

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

Q104. A developer needs to push real-time updates of the company’s product catalog to a data extension.
Which two API options are available? Choose 2 answers

Q105. NTO uses an external CRM which only exports encrypted files. NTO’s marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given thse requirements? Choose 3

Q106. A field value returned from a DE lookup contains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

Q107. A developer is troubleshooting why an API client Jd and chent_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?

Q108. NTO had an Enterprise 2.0 account; subscribers unsubscribers from the business unit only. A developer is identifying subscribers who unsubscribed from any of the NTO child business units. Which method would identify the most accurate status fro subscribers of each business unit?

Q109. A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = ‘Tacos’?

Q110. NTO wants to exclude sends to specific subscribers based on a business rule, which is defined in an Exclusion Script. Which three types of sends would support this functionality? Choose 3

Q111. NTO had an Enterprise 2.0 account; subscribers unsubscribes from the business unit only. A developer is identifying subscribers who unsubscribed from any of the NTO child business units. Which method would identify the most accurate status for subscribers of each business unit?

Q112. A developer wants to build an audience by identifying subsceibers who opened a specific email. Which query should the developer use?

Q113. A developer wants to populate a data extension with the date of the most recent click for each subscriber.
Which query would accomplish this?

Q114. A developer needs to use the ‘contacts/ route of the REST API to update records in a data extension.
What should the developer verify before making the API call?