You have already completed the Test before. Hence you can not start it again.
Test is loading...
You must sign in or sign up to start the Test.
You have to finish following quiz, to start this Test:
Your results are here!! for" SF Marketing Cloud Developer Practice Test 1 "
0 of 50 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
Salesforce Certified Marketing Cloud Developer
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking view questions. Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Answered
Review
Question 1 of 50
1. Question
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 unexpected errors gracefully to ensure the best user experience. Which two features should handle this scenario?
Correct
The best way, not only to debug your CloudPages, but also to handle all exceptions, is to include a JavaScript Try/Catch statement in all your CloudPages, regardless of whether you are coding them using AMPscript or Server-Side JavaScript.
The try statement allows you to define a block of code to be tested for errors while it is being executed. The catch statement allows you to define a block of code to be executed, if an error occurs in the try block. Wrapping the whole code included in your CloudPage in a try/catch statement, will not only help you catch errors, regardless of in which part of the code they appear, but it will also prevent your subscribers from seeing the dreaded 500 error if something goes wrong.
Now that we have a mechanism for catching errors on a CloudPage, it would be also good to have somewhere to store them, so that they can be reviewed on a regular basis. This can be easily achieved by creating a dedicated Data Extension and inserting a new row to that Data Extension every time an error is caught. So we add a script that will allow us to log data into the Data Extension.
This mix of Server-Side JavaScript and AMPscript, can be used to log data from the Personalization Strings.
Example:
{{your script goes here}}
%%[
if not empty(@err) then
InsertData(‘ent.ErrorLogging’,’SubscriberKey’,_SubscriberKey,’MID’,memberid,’error’,@err)
endif
]%%
Incorrect
The best way, not only to debug your CloudPages, but also to handle all exceptions, is to include a JavaScript Try/Catch statement in all your CloudPages, regardless of whether you are coding them using AMPscript or Server-Side JavaScript.
The try statement allows you to define a block of code to be tested for errors while it is being executed. The catch statement allows you to define a block of code to be executed, if an error occurs in the try block. Wrapping the whole code included in your CloudPage in a try/catch statement, will not only help you catch errors, regardless of in which part of the code they appear, but it will also prevent your subscribers from seeing the dreaded 500 error if something goes wrong.
Now that we have a mechanism for catching errors on a CloudPage, it would be also good to have somewhere to store them, so that they can be reviewed on a regular basis. This can be easily achieved by creating a dedicated Data Extension and inserting a new row to that Data Extension every time an error is caught. So we add a script that will allow us to log data into the Data Extension.
This mix of Server-Side JavaScript and AMPscript, can be used to log data from the Personalization Strings.
Example:
{{your script goes here}}
%%[
if not empty(@err) then
InsertData(‘ent.ErrorLogging’,’SubscriberKey’,_SubscriberKey,’MID’,memberid,’error’,@err)
endif
]%%
Unattempted
The best way, not only to debug your CloudPages, but also to handle all exceptions, is to include a JavaScript Try/Catch statement in all your CloudPages, regardless of whether you are coding them using AMPscript or Server-Side JavaScript.
The try statement allows you to define a block of code to be tested for errors while it is being executed. The catch statement allows you to define a block of code to be executed, if an error occurs in the try block. Wrapping the whole code included in your CloudPage in a try/catch statement, will not only help you catch errors, regardless of in which part of the code they appear, but it will also prevent your subscribers from seeing the dreaded 500 error if something goes wrong.
Now that we have a mechanism for catching errors on a CloudPage, it would be also good to have somewhere to store them, so that they can be reviewed on a regular basis. This can be easily achieved by creating a dedicated Data Extension and inserting a new row to that Data Extension every time an error is caught. So we add a script that will allow us to log data into the Data Extension.
This mix of Server-Side JavaScript and AMPscript, can be used to log data from the Personalization Strings.
Example:
{{your script goes here}}
%%[
if not empty(@err) then
InsertData(‘ent.ErrorLogging’,’SubscriberKey’,_SubscriberKey,’MID’,memberid,’error’,@err)
endif
]%%
Question 2 of 50
2. Question
A developer receives a request to integrate Marketing Cloud with 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 the developer use to dynamically create these data extensions?
Correct
When creating an event definition, the API uses the information contained in the schema object to create a data extension associated with the event definition. The schema defines the name, nullability, and default values of the fields to be included in the data extension.
Creates an event definition (name and data schema for an event) and defines an event definition key. The resource uses this key when firing an event to send it to the appropriate journey. Typically, marketers create the event definition in the Journey Builder UI. Use this resource instead if you are using a custom application for Journey Builder functionality. To call this resource, assign your API Integration the Automation | Interactions | Read scope.
Incorrect
When creating an event definition, the API uses the information contained in the schema object to create a data extension associated with the event definition. The schema defines the name, nullability, and default values of the fields to be included in the data extension.
Creates an event definition (name and data schema for an event) and defines an event definition key. The resource uses this key when firing an event to send it to the appropriate journey. Typically, marketers create the event definition in the Journey Builder UI. Use this resource instead if you are using a custom application for Journey Builder functionality. To call this resource, assign your API Integration the Automation | Interactions | Read scope.
Unattempted
When creating an event definition, the API uses the information contained in the schema object to create a data extension associated with the event definition. The schema defines the name, nullability, and default values of the fields to be included in the data extension.
Creates an event definition (name and data schema for an event) and defines an event definition key. The resource uses this key when firing an event to send it to the appropriate journey. Typically, marketers create the event definition in the Journey Builder UI. Use this resource instead if you are using a custom application for Journey Builder functionality. To call this resource, assign your API Integration the Automation | Interactions | Read scope.
Question 3 of 50
3. Question
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 the developer use AMPscrpit to generate the total?
Correct
Incorrect
Unattempted
Question 4 of 50
4. Question
A Marketer is sending an email with dynamic content contained in a series of conditionals. Which Ampscript function should be used to track the different versions of the content within the email?
Correct
BeginImpressionRegion : Denotes the beginning of a region to track with impression tracking.
ContentAreaByName : Returns the content contained in the specified stored content area.
ContentBlockByName : Returns content contained in the specified stored content block or code snippet from Content Builder, including the Image Block type. These functions support email messages only. For text-only parts of the email, such as From Address, From Name, or Subject Line, reference the code snippet block.
ContentArea : For classic content, returns content contained in the specified stored content area. For Content Builder, use ContentBlockById.
Incorrect
BeginImpressionRegion : Denotes the beginning of a region to track with impression tracking.
ContentAreaByName : Returns the content contained in the specified stored content area.
ContentBlockByName : Returns content contained in the specified stored content block or code snippet from Content Builder, including the Image Block type. These functions support email messages only. For text-only parts of the email, such as From Address, From Name, or Subject Line, reference the code snippet block.
ContentArea : For classic content, returns content contained in the specified stored content area. For Content Builder, use ContentBlockById.
Unattempted
BeginImpressionRegion : Denotes the beginning of a region to track with impression tracking.
ContentAreaByName : Returns the content contained in the specified stored content area.
ContentBlockByName : Returns content contained in the specified stored content block or code snippet from Content Builder, including the Image Block type. These functions support email messages only. For text-only parts of the email, such as From Address, From Name, or Subject Line, reference the code snippet block.
ContentArea : For classic content, returns content contained in the specified stored content area. For Content Builder, use ContentBlockById.
Question 5 of 50
5. Question
Which two ways would a developer write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean Field in a Sendable Data Extension? Choose 2:
Correct
Incorrect
Unattempted
Question 6 of 50
6. Question
Customer data has been imported into a staging data extension and needs to be normalised 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 answer.
Correct
Incorrect
Unattempted
Question 7 of 50
7. Question
A developer wants to retrieve a row of data from a data extension using the SOAP API. Which API Object should be used for this call?
A developer is configuring a File Drop Automation and wants to use a Filename pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. May15) the file is dropped onto the SFTP site. Which two configurations should be used for the automation to successfully start? Choose two.
Correct
-> Use Begins With when Automation Studio is looking for files whose filename starts with the filename pattern.
-> File naming patterns can only contain one of each wildcard option per pattern.
Incorrect
-> Use Begins With when Automation Studio is looking for files whose filename starts with the filename pattern.
-> File naming patterns can only contain one of each wildcard option per pattern.
Unattempted
-> Use Begins With when Automation Studio is looking for files whose filename starts with the filename pattern.
-> File naming patterns can only contain one of each wildcard option per pattern.
Question 9 of 50
9. Question
A developer wants to configure an automation to import files placed on the SFTP shared by the customer’s data vendor. The automation will start when a file matching a specific naming pattern is encountered in the Import Folder. The first step of the automation is a File Import Activity referencing a substitution string for the matching file.
Which Substitution String represents the name of the file?
Correct
%%FILENAME_FROM_TRIGGER%%
We place this substitution strings in the File Naming Pattern field of a file transfer activity or import activity. And use this strings to reuse the trigger file in a subsequent step of a file drop automation.
This string returns the name of the file placed in the FTP folder.
Incorrect
%%FILENAME_FROM_TRIGGER%%
We place this substitution strings in the File Naming Pattern field of a file transfer activity or import activity. And use this strings to reuse the trigger file in a subsequent step of a file drop automation.
This string returns the name of the file placed in the FTP folder.
Unattempted
%%FILENAME_FROM_TRIGGER%%
We place this substitution strings in the File Naming Pattern field of a file transfer activity or import activity. And use this strings to reuse the trigger file in a subsequent step of a file drop automation.
This string returns the name of the file placed in the FTP folder.
Question 10 of 50
10. Question
Which WHERE clause will pull all rows with an age of 18?
Correct
Incorrect
Unattempted
Question 11 of 50
11. Question
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?
Correct
Environment variables are used to avoid storage of app secrets in code or in local configuration files. Environment variables override configuration values for all previously specified configuration sources.
There are of course many different places where people store such secrets. From worst to best, one could think of the following: in your source code repository on GitHub (of course, nobody should ever do that), in configuration files (encrypted or not), in environment variables, or in specialized secret vaults.
We avoid storing the id and secret directly in Ampscript.
First you create the three required assets in Key Management:
· Password
· Salt
· Initialisation vector
Store your client ID and secret securely. Never expose this information on the client side via JavaScript or store it in a mobile application.
The client_id is a public identifier for apps. Even though it’s public, it’s best that it isn’t guessable by third parties, so many implementations use something like a 32-character hex string. It must also be unique across all clients that the authorization server handles. If the client ID is guessable, it makes it slightly easier to craft phishing attacks against arbitrary applications.
Incorrect
Environment variables are used to avoid storage of app secrets in code or in local configuration files. Environment variables override configuration values for all previously specified configuration sources.
There are of course many different places where people store such secrets. From worst to best, one could think of the following: in your source code repository on GitHub (of course, nobody should ever do that), in configuration files (encrypted or not), in environment variables, or in specialized secret vaults.
We avoid storing the id and secret directly in Ampscript.
First you create the three required assets in Key Management:
· Password
· Salt
· Initialisation vector
Store your client ID and secret securely. Never expose this information on the client side via JavaScript or store it in a mobile application.
The client_id is a public identifier for apps. Even though it’s public, it’s best that it isn’t guessable by third parties, so many implementations use something like a 32-character hex string. It must also be unique across all clients that the authorization server handles. If the client ID is guessable, it makes it slightly easier to craft phishing attacks against arbitrary applications.
Unattempted
Environment variables are used to avoid storage of app secrets in code or in local configuration files. Environment variables override configuration values for all previously specified configuration sources.
There are of course many different places where people store such secrets. From worst to best, one could think of the following: in your source code repository on GitHub (of course, nobody should ever do that), in configuration files (encrypted or not), in environment variables, or in specialized secret vaults.
We avoid storing the id and secret directly in Ampscript.
First you create the three required assets in Key Management:
· Password
· Salt
· Initialisation vector
Store your client ID and secret securely. Never expose this information on the client side via JavaScript or store it in a mobile application.
The client_id is a public identifier for apps. Even though it’s public, it’s best that it isn’t guessable by third parties, so many implementations use something like a 32-character hex string. It must also be unique across all clients that the authorization server handles. If the client ID is guessable, it makes it slightly easier to craft phishing attacks against arbitrary applications.
Question 12 of 50
12. Question
When appending data to links via Web Analytic Connector, which parameter should be used to track subscriber behavior?
Correct
Subscriber-Level Data
Use account-level data to identify activity from a specific subscriber. This data is applied to all links in each email so that website traffic is attributed to the subscriber who received the email. For example, include the Subscriber ID in links and identify subscribers who click links within the web analytics service. By storing the subscriber ID in a cookie, the web analytics tool can continue to track the subscriber’s progression through your site.
Incorrect
Subscriber-Level Data
Use account-level data to identify activity from a specific subscriber. This data is applied to all links in each email so that website traffic is attributed to the subscriber who received the email. For example, include the Subscriber ID in links and identify subscribers who click links within the web analytics service. By storing the subscriber ID in a cookie, the web analytics tool can continue to track the subscriber’s progression through your site.
Unattempted
Subscriber-Level Data
Use account-level data to identify activity from a specific subscriber. This data is applied to all links in each email so that website traffic is attributed to the subscriber who received the email. For example, include the Subscriber ID in links and identify subscribers who click links within the web analytics service. By storing the subscriber ID in a cookie, the web analytics tool can continue to track the subscriber’s progression through your site.
Question 13 of 50
13. Question
A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the bounce reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL Statement:
SELECT s.EmailAddress, s.SubscriberKey, b.JobID, b.EventDate, b.SMTPBounceReason
FROM _Subscribers s JOIN_Bounce b ON s.EmailAddress = b.EmailAddress
WHERE b.EventDate > DateAdd(Day, -30, GETDATE())
What updates should be made to ensure this SQL statement returns the desired result?
Correct
Incorrect
Unattempted
Question 14 of 50
14. Question
A developer is using the REST Authorisation Service to obtain an Oath access token. Which method should be used to include the access token in the API request?
Correct
Bearer authentication (also called token authentication) is an HTTP authentication scheme that involves security tokens called bearer tokens.
The name “Bearer authentication” can be understood as “give access to the bearer of this token.” The bearer token allowing access to a certain resource or URL and most likely is a cryptic string, usually generated by the server in response to a login request.
The client must send this token in the Authorization header when making requests to protected resources:
Authorization: Bearer
Incorrect
Bearer authentication (also called token authentication) is an HTTP authentication scheme that involves security tokens called bearer tokens.
The name “Bearer authentication” can be understood as “give access to the bearer of this token.” The bearer token allowing access to a certain resource or URL and most likely is a cryptic string, usually generated by the server in response to a login request.
The client must send this token in the Authorization header when making requests to protected resources:
Authorization: Bearer
Unattempted
Bearer authentication (also called token authentication) is an HTTP authentication scheme that involves security tokens called bearer tokens.
The name “Bearer authentication” can be understood as “give access to the bearer of this token.” The bearer token allowing access to a certain resource or URL and most likely is a cryptic string, usually generated by the server in response to a login request.
The client must send this token in the Authorization header when making requests to protected resources:
Authorization: Bearer
Question 15 of 50
15. Question
A developer uses an API to send data to a Marketing Cloud Data extension once every five minutes using the REST API. They notice data does not always write to the data extension, leading to data loss. Which three best practices are recommended to avoid this issue? Choose 3 answers.
Correct
Incorrect
Unattempted
Question 16 of 50
16. Question
Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer Data is stored in a data extension with the Subscriber Key set as a Primary Key. Which steps is required for NTO when creating relationships for this data extension in Data Designer?
Correct
Incorrect
Unattempted
Question 17 of 50
17. Question
A developer is implementing a custom profile center and using the LogUnsubEvent request. Which parameter is required for the event to be tied to the appropriate send?
Correct
The Subscriber Context is defined by the SubscriberID, SubscriberKey and EmailAddress parameters. You must supply at least one of these parameters. If you provide more than one of these parameters, we retrieve the Subscriber using one of the values and validate that the other values match the retrieved Subscriber. If they don’t match, an error returns.
If the SubscriberKey permission is turned on and you supply the EmailAddress parameter, you must supply either the SubscriberID or the SubscriberKey.
Incorrect
The Subscriber Context is defined by the SubscriberID, SubscriberKey and EmailAddress parameters. You must supply at least one of these parameters. If you provide more than one of these parameters, we retrieve the Subscriber using one of the values and validate that the other values match the retrieved Subscriber. If they don’t match, an error returns.
If the SubscriberKey permission is turned on and you supply the EmailAddress parameter, you must supply either the SubscriberID or the SubscriberKey.
Unattempted
The Subscriber Context is defined by the SubscriberID, SubscriberKey and EmailAddress parameters. You must supply at least one of these parameters. If you provide more than one of these parameters, we retrieve the Subscriber using one of the values and validate that the other values match the retrieved Subscriber. If they don’t match, an error returns.
If the SubscriberKey permission is turned on and you supply the EmailAddress parameter, you must supply either the SubscriberID or the SubscriberKey.
Question 18 of 50
18. Question
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?
Correct
Incorrect
Unattempted
Question 19 of 50
19. Question
A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?
Correct
In order to inject a contact into a journey, we will use Salesforce Marketing Cloud’s REST API, specifically the /interaction/v1/events route. Here’s an example request:
Host: https://YOUR_SUBDOMAIN.rest.marketingcloudapis.com
POST /interaction/v1/events
Content-Type: application/json
Authorization: Bearer YOUR_ACCESS_TOKEN
{
“ContactKey”: “ID601”,
“EventDefinitionKey”:”AcmeBank-AccountAccessed”,
“Data”: {
“accountNumber”:”123456″,
“patronName”:”John Smith” }
}
Incorrect
In order to inject a contact into a journey, we will use Salesforce Marketing Cloud’s REST API, specifically the /interaction/v1/events route. Here’s an example request:
Host: https://YOUR_SUBDOMAIN.rest.marketingcloudapis.com
POST /interaction/v1/events
Content-Type: application/json
Authorization: Bearer YOUR_ACCESS_TOKEN
{
“ContactKey”: “ID601”,
“EventDefinitionKey”:”AcmeBank-AccountAccessed”,
“Data”: {
“accountNumber”:”123456″,
“patronName”:”John Smith” }
}
Unattempted
In order to inject a contact into a journey, we will use Salesforce Marketing Cloud’s REST API, specifically the /interaction/v1/events route. Here’s an example request:
Host: https://YOUR_SUBDOMAIN.rest.marketingcloudapis.com
POST /interaction/v1/events
Content-Type: application/json
Authorization: Bearer YOUR_ACCESS_TOKEN
{
“ContactKey”: “ID601”,
“EventDefinitionKey”:”AcmeBank-AccountAccessed”,
“Data”: {
“accountNumber”:”123456″,
“patronName”:”John Smith” }
}
Question 20 of 50
20. Question
Northern Trail Outfitters (NTO) wants to prevent competitors from receiving a coupon email. They also want to capture email addresses of competitors who are included in the targeted audience. Which feature could NTO use to prevent the coupon from being sent and report the email addresses skipped?
Correct
-> Auto-suppression lists typically include addresses with a history of spam complaints, unsubscribe lists from previous providers or advertisers, addresses of your competitors, and cancelled customers.
->Exclusion scripts enable Subscribers to be conditionally excluded from being sent an email, based on a logical test.
Incorrect
-> Auto-suppression lists typically include addresses with a history of spam complaints, unsubscribe lists from previous providers or advertisers, addresses of your competitors, and cancelled customers.
->Exclusion scripts enable Subscribers to be conditionally excluded from being sent an email, based on a logical test.
Unattempted
-> Auto-suppression lists typically include addresses with a history of spam complaints, unsubscribe lists from previous providers or advertisers, addresses of your competitors, and cancelled customers.
->Exclusion scripts enable Subscribers to be conditionally excluded from being sent an email, based on a logical test.
Question 21 of 50
21. Question
A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose two answers.
Correct
Incorrect
Unattempted
Question 22 of 50
22. Question
A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension. Which SELECT statement is optimal for returning all the columns in the data extension?
Correct
Often, the bigger problem with SELECT * is the effect it will have on the execution plan. The SELECT * queries show 50% load and the SELECT column query takes 0% load, regardless of order.
Incorrect
Often, the bigger problem with SELECT * is the effect it will have on the execution plan. The SELECT * queries show 50% load and the SELECT column query takes 0% load, regardless of order.
Unattempted
Often, the bigger problem with SELECT * is the effect it will have on the execution plan. The SELECT * queries show 50% load and the SELECT column query takes 0% load, regardless of order.
Question 23 of 50
23. Question
A developer is leveraging the SOAP API to dynamically display profile and Preference Attributes in a custom profile centre. Which method could be used to support the dynamic functionality ?
Correct
Configure:
Use the Configure method to configure an account. Like many other SOAP methods, the Configure method accepts an array of objects to act upon and returns one result object for each object in the array. Therefore, a web service client can create one or many subscriber attributes (or property definitions) in one call and receive detailed results for each completed action.
Describe:
Use the Describe method to get information about the metadata associated with an object. You could use the Describe method to dynamically build profile centers and track data retrieval interfaces. The Describe method supports a request for object metadata in the form of an ObjectDefinitionRequest and returns a single ObjectDefinition object.
Extract:
Use the Extract method to extract a package to the Marketing Cloud FTP site. Specify the File Transfer Location only when the intent is to deliver the file to a different FTP site.
Perform:
Use the Perform method to manage asynchronous processes, like sending email, importing subscribers, or starting an import definition.
When using the Perform method as part of an email send definition, you can override certain aspects of the SenderProfile object.
Incorrect
Configure:
Use the Configure method to configure an account. Like many other SOAP methods, the Configure method accepts an array of objects to act upon and returns one result object for each object in the array. Therefore, a web service client can create one or many subscriber attributes (or property definitions) in one call and receive detailed results for each completed action.
Describe:
Use the Describe method to get information about the metadata associated with an object. You could use the Describe method to dynamically build profile centers and track data retrieval interfaces. The Describe method supports a request for object metadata in the form of an ObjectDefinitionRequest and returns a single ObjectDefinition object.
Extract:
Use the Extract method to extract a package to the Marketing Cloud FTP site. Specify the File Transfer Location only when the intent is to deliver the file to a different FTP site.
Perform:
Use the Perform method to manage asynchronous processes, like sending email, importing subscribers, or starting an import definition.
When using the Perform method as part of an email send definition, you can override certain aspects of the SenderProfile object.
Unattempted
Configure:
Use the Configure method to configure an account. Like many other SOAP methods, the Configure method accepts an array of objects to act upon and returns one result object for each object in the array. Therefore, a web service client can create one or many subscriber attributes (or property definitions) in one call and receive detailed results for each completed action.
Describe:
Use the Describe method to get information about the metadata associated with an object. You could use the Describe method to dynamically build profile centers and track data retrieval interfaces. The Describe method supports a request for object metadata in the form of an ObjectDefinitionRequest and returns a single ObjectDefinition object.
Extract:
Use the Extract method to extract a package to the Marketing Cloud FTP site. Specify the File Transfer Location only when the intent is to deliver the file to a different FTP site.
Perform:
Use the Perform method to manage asynchronous processes, like sending email, importing subscribers, or starting an import definition.
When using the Perform method as part of an email send definition, you can override certain aspects of the SenderProfile object.
Question 24 of 50
24. Question
A developer wants to expand the functionality of existing code which was written in AMPscript, but prefers to use Server-Side JavaScript (SSJS) for updated.
Which SSJS statement will retrieve the value of the AMPscript variable named subkey?
A developer need to identify all subscribers who were sent JOB ID 420 but did not click any links. Which SQl statement would produce the desired result?
Correct
Incorrect
Unattempted
Question 26 of 50
26. Question
What is the purpose of IF statement below?
%%[
SET @rows = LookupRows ( ‘DEName’ , ‘SubscriberKey’ , _ SubscriberKey)
IF RowCount (@rows) > 0 THEN
SET @row = row(@rows)
SET @image = Field(@row , ‘image’)
]%%
%%[ ELSE ]%%
%%[ ENDIF ]%%
Correct
Incorrect
Unattempted
Question 27 of 50
27. Question
From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?
Correct
For Enterprise 2.0 accounts the deletion will have to be initiated in the parent business unit. However, for contacts created at child business unit level such as contacts created by triggered sends, the API call will have to include the MID of the child business unit.
Incorrect
For Enterprise 2.0 accounts the deletion will have to be initiated in the parent business unit. However, for contacts created at child business unit level such as contacts created by triggered sends, the API call will have to include the MID of the child business unit.
Unattempted
For Enterprise 2.0 accounts the deletion will have to be initiated in the parent business unit. However, for contacts created at child business unit level such as contacts created by triggered sends, the API call will have to include the MID of the child business unit.
Question 28 of 50
28. Question
A developer wants to build an email that dynamically populates the physical address of a company’s location using the variable @address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance. Which AMPscript solution should be recommended?
Correct
Incorrect
Unattempted
Question 29 of 50
29. Question
A particular data extension needs to be configured to store six months of data. How should data retention be added to the data extension in Email Studio?
A developer wants to personalize a welcome email with the recipient’s first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensions contain the unique identifier in a field named CustomerKey. Which AMPscript syntax would populate the first name personalization as requested?
Correct
Incorrect
Unattempted
Question 31 of 50
31. Question
A developer receives Error Code 5 when performing a SOAP API call. The error states: “Cannot Perform ‘Post’ on object of type ‘SentEvent’”. What could be the issue?
A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?
Correct
Incorrect
Unattempted
Question 33 of 50
33. Question
NTO uses data extensions to manage the subscriber information used for their email send, and those sends include calls to update records with new or different subscriber information. The developer handling these records write some Ampscript to check and see if the data extension containing those records updates using an InsertDE() call if the record doesn’t yet exist.
Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?
Correct
Instead of making several different AMPscript calls as part of an email send, the Marketing Cloud takes all applicable AMPscript calls and completes them in one call at the end of the send. In the above scenario, the AMPscript call using the InsertDE() function comes after the system added the row as part of the email send, and thus the Marketing Cloud errors out that call because the row already exists.
In this case, an UpsertDE() AMPscript call handles the check on the existence of the row and adds any additional or necessary information. When writing your AMPscript, always remember that all calls will process at the end of the subscriber batch when performing email sends.
Incorrect
Instead of making several different AMPscript calls as part of an email send, the Marketing Cloud takes all applicable AMPscript calls and completes them in one call at the end of the send. In the above scenario, the AMPscript call using the InsertDE() function comes after the system added the row as part of the email send, and thus the Marketing Cloud errors out that call because the row already exists.
In this case, an UpsertDE() AMPscript call handles the check on the existence of the row and adds any additional or necessary information. When writing your AMPscript, always remember that all calls will process at the end of the subscriber batch when performing email sends.
Unattempted
Instead of making several different AMPscript calls as part of an email send, the Marketing Cloud takes all applicable AMPscript calls and completes them in one call at the end of the send. In the above scenario, the AMPscript call using the InsertDE() function comes after the system added the row as part of the email send, and thus the Marketing Cloud errors out that call because the row already exists.
In this case, an UpsertDE() AMPscript call handles the check on the existence of the row and adds any additional or necessary information. When writing your AMPscript, always remember that all calls will process at the end of the subscriber batch when performing email sends.
Question 34 of 50
34. Question
A developer is notified the View Email as Web Page(VAWP) link, when clicked, displays the message, “The system temporarily unavailable . We apologize for any inconvenience. Please try again later.”
What could be the possible case of error?
Correct
If the data in the Data Extension/List used at the time of the send was overwritten, updated, deleted this will break that link. This is related to how the VAWP link is working. The ‘View as webpage’ link is different to the the data in the original email sent for a particular subscriber in the data contained within an email is static, whereas the data contained within the ‘View as webpage’ link is pulled each time the page is rendered.
Incorrect
If the data in the Data Extension/List used at the time of the send was overwritten, updated, deleted this will break that link. This is related to how the VAWP link is working. The ‘View as webpage’ link is different to the the data in the original email sent for a particular subscriber in the data contained within an email is static, whereas the data contained within the ‘View as webpage’ link is pulled each time the page is rendered.
Unattempted
If the data in the Data Extension/List used at the time of the send was overwritten, updated, deleted this will break that link. This is related to how the VAWP link is working. The ‘View as webpage’ link is different to the the data in the original email sent for a particular subscriber in the data contained within an email is static, whereas the data contained within the ‘View as webpage’ link is pulled each time the page is rendered.
Question 35 of 50
35. Question
A sendable Data Extension with a text field named ‘Balance’ contains the value $6.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?
Correct
Incorrect
Unattempted
Question 36 of 50
36. Question
A developer wants to set a variable to use a field from a Sendable Data Extension. Which two options could be used in an AMPscript block to set the variable as a ‘First Name’ field from a Sendable Data Extension used to send the email?
Correct
set @FirstName = AttributeValue(“First_Name”) /* handle null gracefully
Incorrect
set @FirstName = AttributeValue(“First_Name”) /* handle null gracefully
Unattempted
set @FirstName = AttributeValue(“First_Name”) /* handle null gracefully
Question 37 of 50
37. Question
A developer wants to retrieve daily JASON data from a customer’s API and write it to the data extension for consumption in Marketing Cloud at a later time.
What set of Server Side Javascript activities should the developer use?
A developer needs to determine why a Query Activity in Automation has failed. Which three scenarios could have caused this? Choose 3 answers.
Correct
Typically, if Query Activities fail, it’s one of these 6 things:
a) Primary key violation — your query results in duplicate rows not allowed by the primary key
b) Inserting a null value into a non-nullable field
c) Inserting a value too long for the field (truncation)
d) Timeout — if your query doesn’t complete within the 30-minute timeout window, it’ll error out.
e) Your target Data Extension no longer exists
f) Data type conversion — trying to insert a $12.34 string into a Decimal field
Incorrect
Typically, if Query Activities fail, it’s one of these 6 things:
a) Primary key violation — your query results in duplicate rows not allowed by the primary key
b) Inserting a null value into a non-nullable field
c) Inserting a value too long for the field (truncation)
d) Timeout — if your query doesn’t complete within the 30-minute timeout window, it’ll error out.
e) Your target Data Extension no longer exists
f) Data type conversion — trying to insert a $12.34 string into a Decimal field
Unattempted
Typically, if Query Activities fail, it’s one of these 6 things:
a) Primary key violation — your query results in duplicate rows not allowed by the primary key
b) Inserting a null value into a non-nullable field
c) Inserting a value too long for the field (truncation)
d) Timeout — if your query doesn’t complete within the 30-minute timeout window, it’ll error out.
e) Your target Data Extension no longer exists
f) Data type conversion — trying to insert a $12.34 string into a Decimal field
Question 39 of 50
39. Question
In what order is Ampscript evaluated before an email is sent?
Correct
AMPscript processes functions in this order:
1. HTML Body
2. Text Body
3. Subject Line
Any preheader values reside at the beginning of the body and process accordingly.
Incorrect
AMPscript processes functions in this order:
1. HTML Body
2. Text Body
3. Subject Line
Any preheader values reside at the beginning of the body and process accordingly.
Unattempted
AMPscript processes functions in this order:
1. HTML Body
2. Text Body
3. Subject Line
Any preheader values reside at the beginning of the body and process accordingly.
Question 40 of 50
40. Question
Northern Trail Outfitters (NTO) 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?
Correct
Incorrect
Unattempted
Question 41 of 50
41. Question
A developer who is new to Marketing Cloud, needs to design a landing page for a new customer. They choose to use Server-Side Javascript (SSJ) due to their extensive knowledge of JavaScript from previous projects.
Which two features would the developer be able to leverage in their Server-Side code? Choose 2.
Correct
Server-side JavaScript does not work with the DOM and will not function with exterior libraries. Instead, use libraries provided by Marketing Cloud to create server-side JavaScript. All functions native to JavaScript, such as arrays, math functions, the EVAL function, and try catch blocks work with server-side JavaScript.
Incorrect
Server-side JavaScript does not work with the DOM and will not function with exterior libraries. Instead, use libraries provided by Marketing Cloud to create server-side JavaScript. All functions native to JavaScript, such as arrays, math functions, the EVAL function, and try catch blocks work with server-side JavaScript.
Unattempted
Server-side JavaScript does not work with the DOM and will not function with exterior libraries. Instead, use libraries provided by Marketing Cloud to create server-side JavaScript. All functions native to JavaScript, such as arrays, math functions, the EVAL function, and try catch blocks work with server-side JavaScript.
Question 42 of 50
42. Question
NTO uses a Send Log and sends more than one million emails per day. They want to execute daily reports on all subscriber activity without impacting the performance. Which set of best practices should be implemented?
Correct
Incorrect
Unattempted
Question 43 of 50
43. Question
A developer wants to create a Send Log Data Extension to increase efficiency with tracking email sends. Which two best practices should the developer remember when configuring the Send Log Data Extension? Choose 2:
Correct
Here is a list of best practices for use of send logging in Marketing Cloud Email Studio. Follow all general data extension best practices for send logging data extensions as well.
-> Use send logging to retain information that can change after a send occurs and can affect reporting. Send logging captures send-time values for reports, extracts, and tracking data.
-> Use data retention to limit the amount of data stored. Limit data storage to 10 days.
-> Add 10 or fewer custom fields to the send log.
-> Minimize the size of the fields used in a send log to the size required for the expected data.
-> Limit the number of activities concurrently using a data extension. For example, schedule a query activity or report that is reading from the send log to run at a different time than a send that uses the Send Log. You can also use a query activity to move data from an active send log to an archive data extension, as necessary.
-> Dates added are in UTC-6.
Incorrect
Here is a list of best practices for use of send logging in Marketing Cloud Email Studio. Follow all general data extension best practices for send logging data extensions as well.
-> Use send logging to retain information that can change after a send occurs and can affect reporting. Send logging captures send-time values for reports, extracts, and tracking data.
-> Use data retention to limit the amount of data stored. Limit data storage to 10 days.
-> Add 10 or fewer custom fields to the send log.
-> Minimize the size of the fields used in a send log to the size required for the expected data.
-> Limit the number of activities concurrently using a data extension. For example, schedule a query activity or report that is reading from the send log to run at a different time than a send that uses the Send Log. You can also use a query activity to move data from an active send log to an archive data extension, as necessary.
-> Dates added are in UTC-6.
Unattempted
Here is a list of best practices for use of send logging in Marketing Cloud Email Studio. Follow all general data extension best practices for send logging data extensions as well.
-> Use send logging to retain information that can change after a send occurs and can affect reporting. Send logging captures send-time values for reports, extracts, and tracking data.
-> Use data retention to limit the amount of data stored. Limit data storage to 10 days.
-> Add 10 or fewer custom fields to the send log.
-> Minimize the size of the fields used in a send log to the size required for the expected data.
-> Limit the number of activities concurrently using a data extension. For example, schedule a query activity or report that is reading from the send log to run at a different time than a send that uses the Send Log. You can also use a query activity to move data from an active send log to an archive data extension, as necessary.
-> Dates added are in UTC-6.
Question 44 of 50
44. Question
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?
Correct
Incorrect
Unattempted
Question 45 of 50
45. Question
A developer is using the legacy endpoint http://www.exacttargetapis.com and has been asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?
Correct
Because subdomains are unique and assigned to each tenant, we can better optimize our customers’ experience. The new tenant-specific Marketing Cloud endpoint (TSEs) structure provides an improved API performance and a faster Marketing Cloud experience.
Incorrect
Because subdomains are unique and assigned to each tenant, we can better optimize our customers’ experience. The new tenant-specific Marketing Cloud endpoint (TSEs) structure provides an improved API performance and a faster Marketing Cloud experience.
Unattempted
Because subdomains are unique and assigned to each tenant, we can better optimize our customers’ experience. The new tenant-specific Marketing Cloud endpoint (TSEs) structure provides an improved API performance and a faster Marketing Cloud experience.
Question 46 of 50
46. Question
A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code. Which syntax should the developer use?
Correct
Comments can be included in AMPscript blocks. They are contained within an opening /* and closing */ syntax pair and provide the ability to include a readable explanation or annotation for users. Any comments are ignored by Marketing Cloud and will not be interpreted. They can be used on a single line or traverse multiple lines.
Incorrect
Comments can be included in AMPscript blocks. They are contained within an opening /* and closing */ syntax pair and provide the ability to include a readable explanation or annotation for users. Any comments are ignored by Marketing Cloud and will not be interpreted. They can be used on a single line or traverse multiple lines.
Unattempted
Comments can be included in AMPscript blocks. They are contained within an opening /* and closing */ syntax pair and provide the ability to include a readable explanation or annotation for users. Any comments are ignored by Marketing Cloud and will not be interpreted. They can be used on a single line or traverse multiple lines.
Question 47 of 50
47. Question
A Marketing director at NTO wants to analyse the send, click and open data views. Which activities should the developer build to generate the data before transferring it to the SFTP?
Correct
Incorrect
Unattempted
Question 48 of 50
48. Question
NTO is using a mobile campaign to collect email addresses of interested subscribers. Using Ampscript API functions they will send a confirmation email when an email is texted into their short code.
Which two objects are required to successfully create a TriggeredSend Object?
A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call. How long are Marketing Cloud v1 access token valid?
Correct
The access token will be valid for 60 minutes and it is issued with the scopes specified on the API integration in Installed Packages. With Legacy Packages, the access token can only be used in the context of the business unit that created the integration.
Incorrect
The access token will be valid for 60 minutes and it is issued with the scopes specified on the API integration in Installed Packages. With Legacy Packages, the access token can only be used in the context of the business unit that created the integration.
Unattempted
The access token will be valid for 60 minutes and it is issued with the scopes specified on the API integration in Installed Packages. With Legacy Packages, the access token can only be used in the context of the business unit that created the integration.
Question 50 of 50
50. Question
A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete. How could the process be expedited?
Correct
Removing any unneeded sendable DE speed up the delete process.
Incorrect
Removing any unneeded sendable DE speed up the delete process.
Unattempted
Removing any unneeded sendable DE speed up the delete process.
Use Page numbers below to navigate to other practice tests