Q36. A developer want to email a subscriber who is currently being processed for a Contact Deletion request. When could the Contact be reintroduced after a Contact Delete operation has started?

Q37. A company needs to retrieve a large number of rows from a data extension via the API.
Which two solutions would optimize the performance?
Choose 2 answers

Q38. NTO wants to exclude sending an email at send time to those with a record on the ‘Exclude’ Data Extension. The primary key on this data extension is Subscriber Key. How would a developer write the Exclusion Script?

Q39. A developer is configuring a new Marketing Cloud account and has decided touse a unique 10-digit integer as each customer’s Contact Key.
Which data type should be used when representing the value of Contact Key?

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

Q41. NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

Q42. A developer needs to know how many records are contained in a particular data extension. This will dictate what is displayed on a landing page.
Which AMPscript functionreturns the number of rows in a specified data extension?

Q43. A developer wants to use the RaiseError Ampscript function when a subscriber does not have the necessary data to build an email. Which two outcomes are possible using this function? Choose 2 answer

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

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

Q46. A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subsceriber submits the form?

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

Q48. A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

Q49. Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.

Q50. A developer is creating a CloudPage which accepts secure parameters via an email link and will submit those parameters to another CloudPage for data upsert. The page currently captures an Appointment ID parameter passed into it and sets the value to the variable caapptld. The developer does NOT want the Appointment ID to be visible to anyone using the form.
What is the best method to ensure the parameters are passed successfully to the data upsert page?

Q51. A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

Q52. Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.
Which two file encryption options are supported when importing data files to Marketing Cloud?
Choose 2 answers

Q53. Customer data has been imported into a staging data extension andneeds to be normalized before adding into the master data extension. A text field named ‘birthday’ contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query” Choose 2 answers

Q54. A developer is notified the View Email As Web Page (VAWP) link, when clicked, displays the message, The system is temporarily unavailable. We apologize for any inconvenience. Please try again later.
What could be a possible cause for the error

Q55. A developer wants to create a data model in Contact Builder.
Which two applications will be able to use this newly-created data model for segmentation?
Choose 2 answers

Q56. A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which query would provide that result?
A)

B)

C)

Q57. A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2

Q58. 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

Q59. How can SSJS variables be referenced for content personalization? Choose 1.