Validate your Marketing-Cloud-Developer Exam Preparation with Marketing-Cloud-Developer Practice Test (Online & Offline) [Q97-Q113]

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

Q98. 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 subscriber submits the form?

Q99. Customer data has been imported into a staging data extension and needs 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

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

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

Q102. A developer is troubleshooting the cause of incomplete results in the link tracking data for an email send.
How should the RedirectTo AMPscript function be described as it relates to link tracking’

Q103. A developer wants to include an AMPscript if/else statement in an email to satisfy the condition “if the subscriber’s tier is not premier then display heading encouraging them to upgrade.” The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?

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

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

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

Q107. A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?

Q108. Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

Q109. A developer identified a use case where atriggered send of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls.
When the REST call is made, a “401 Unauthorized” error is returned. What is the first thing the developer should check?

Q110. What is the operational order of the Contact Delete process for Marketing Cloud?

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

Q112. A developer is using the REST Authorization Service to obtain an OAuth access token. Which method should be used to include the access token in the API requests

Q113. A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber.
In which way could the developer create the CTA link?