Free Marketing-Cloud-Developer Exam Braindumps certification guide Q&A [Q18-Q37]

Q18. Contact Builder can be used to create a relational model of an organization’s data within Marketing Cloud.
Which three factors should be taken into consideration when preparing data to be used in Contact Builder?
Choose 3 answer

Q19. Which programming language should be used in email messages? Choose 1.

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

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

Q22. 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)

Q23. A sendable data extension with a text field named ‘Balance’ contains the value S6.96 for a particular record. The following AMPscript statement is included in an email:
IF (Balance > 6.00) THEN
SET @Result = ‘Balance is more than $6.00
ENDIF
Why would this IF statement yield unintended results?

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

Q25. A developer needs to create a fully-branded CloudPage which includes images hosted in Content Builder. The developer wants to secure the page and its elements using the SSL protocol.
What is the minimum number of SSL certificates required?

Q26. A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.
Which SQL functions could be used to change each line break to a single space?

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

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

Q29. A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

Q30. A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server. What steps should the developer take?

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

Q32. A developer receives a 401 Unathorized HTTP status message from a REST API request. What is the reason for this error?

Q33. Which action could the RaiseError AMPscript function be configured to perform?

Q34. Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 =
30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.

Q35. Which SSJS library can be used in email messages? Choose 1.

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

Q37. A developer identified duplicate contacts and initiated a Contact Delete process for 10 milion subscribers. How could the process be expedited?