ExamGecko
Home Home / Salesforce / Certified Marketing Cloud Developer

Salesforce Certified Marketing Cloud Developer Practice Test - Questions Answers, Page 8

Question list
Search
Search

List of questions

Search

Related questions











A developer wants to retrieve daily JSON data from a customer's API and write it to a data extension for consumption in Marketing Cloud at a later time.

What set of Server-Side JavaScript activities should the developer use?

A.
Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
A.
Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
Answers
B.
Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
B.
Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
Answers
C.
Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();
C.
Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();
Answers
D.
Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();
D.
Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();
Answers
Suggested answer: C

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.
DataExtensionField
A.
DataExtensionField
Answers
B.
DataExtension
B.
DataExtension
Answers
C.
DataExtensionObject
C.
DataExtensionObject
Answers
D.
Row
D.
Row
Answers
Suggested answer: C

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?

A.
REPLACE and CHAR
A.
REPLACE and CHAR
Answers
B.
FORMAT and SPACE
B.
FORMAT and SPACE
Answers
C.
LTRIM and RTRJM
C.
LTRIM and RTRJM
Answers
D.
REPLICATE and NCHAR
D.
REPLICATE and NCHAR
Answers
Suggested answer: A

New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder.

What would allow the data extension to be selected for journey entry'

A.
At least one Campaign must be associated to the data extension.
A.
At least one Campaign must be associated to the data extension.
Answers
B.
The Triggered Send Template must be used to create the data extension.
B.
The Triggered Send Template must be used to create the data extension.
Answers
C.
The data extension must be configured for sending.
C.
The data extension must be configured for sending.
Answers
D.
The data extension must contain a field of the EmailAddress data type.
D.
The data extension must contain a field of the EmailAddress data type.
Answers
Suggested answer: C

A developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform 'Post' on objects of type 'SentEvent'".

What could be the issue?

A.
SOAP does not support POST; use REST
A.
SOAP does not support POST; use REST
Answers
B.
The authentication token has expired.
B.
The authentication token has expired.
Answers
C.
It may be a temporary network issue.
C.
It may be a temporary network issue.
Answers
D.
'SentEvent' is not able to be updated using SOAP.
D.
'SentEvent' is not able to be updated using SOAP.
Answers
Suggested answer: D

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

A.
In case of 'Not Authorized' errors, request a new Access Token and attempt the call again.
A.
In case of 'Not Authorized' errors, request a new Access Token and attempt the call again.
Answers
B.
In case of Server errors, request a new Access Token before each request.
B.
In case of Server errors, request a new Access Token before each request.
Answers
C.
In case of Server errors, ensure the Server is available and attempt the call again.
C.
In case of Server errors, ensure the Server is available and attempt the call again.
Answers
D.
Use Username and Password authentication instead of oAuth client ID and client secret.
D.
Use Username and Password authentication instead of oAuth client ID and client secret.
Answers
E.
Store the expiry of the access token to ensure a new token is requested if the old one is invalid.
E.
Store the expiry of the access token to ensure a new token is requested if the old one is invalid.
Answers
Suggested answer: A, D, E

A developer receives a request for tracking data for alt sends associated with a specific JoblD. The developer needs to see Sends, Opens, Clicks, and Bounces.

Which two activities could the developer use? Choose 2 answers

A.
Tracking Extract Activity
A.
Tracking Extract Activity
Answers
B.
Server-Side JavaScript Activity
B.
Server-Side JavaScript Activity
Answers
C.
Campaign Data Extract
C.
Campaign Data Extract
Answers
D.
SQL Query Activity
D.
SQL Query Activity
Answers
Suggested answer: A, D

A developer wants to build an email that dynamically populates the physical address of a company's locations 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?

A.
%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
A.
%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
Answers
B.
%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%
B.
%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%
Answers
C.
%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
C.
%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
Answers
D.
%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
D.
%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
Answers
Suggested answer: A

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 2 answers

A.
Ends With operator
A.
Ends With operator
Answers
B.
%%MMMMdd%%
B.
%%MMMMdd%%
Answers
C.
%%Month%%%%Day%°/o
C.
%%Month%%%%Day%°/o
Answers
D.
Begins With operator
D.
Begins With operator
Answers
Suggested answer: C, D

Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPScript's 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? Choose 2 answers

A.
Subscribers
A.
Subscribers
Answers
B.
TriggeredSendDefinition
B.
TriggeredSendDefinition
Answers
C.
Attribute
C.
Attribute
Answers
D.
Contact
D.
Contact
Answers
Suggested answer: B, D
Total 197 questions
Go to page: of 20