ExamGecko
Login
Ask Question

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

List of questions

Question 71

Report
Export
Collapse

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?

Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();
Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();
Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();
Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();
Suggested answer: C
asked 23/09/2024
Michael Aragon
32 questions

Question 72

Report
Export
Collapse

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?

DataExtensionField
DataExtensionField
DataExtension
DataExtension
DataExtensionObject
DataExtensionObject
Row
Row
Suggested answer: C
asked 23/09/2024
Sukhpreet Sidhu
40 questions

Question 73

Report
Export
Collapse

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?

REPLACE and CHAR
REPLACE and CHAR
FORMAT and SPACE
FORMAT and SPACE
LTRIM and RTRJM
LTRIM and RTRJM
REPLICATE and NCHAR
REPLICATE and NCHAR
Suggested answer: A
asked 23/09/2024
Najim Abdelmoula
46 questions

Question 74

Report
Export
Collapse

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'

At least one Campaign must be associated to the data extension.
At least one Campaign must be associated to the data extension.
The Triggered Send Template must be used to create the data extension.
The Triggered Send Template must be used to create the data extension.
The data extension must be configured for sending.
The data extension must be configured for sending.
The data extension must contain a field of the EmailAddress data type.
The data extension must contain a field of the EmailAddress data type.
Suggested answer: C
asked 23/09/2024
Mohammed Meddah
39 questions

Question 75

Report
Export
Collapse

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?

SOAP does not support POST; use REST
SOAP does not support POST; use REST
The authentication token has expired.
The authentication token has expired.
It may be a temporary network issue.
It may be a temporary network issue.
'SentEvent' is not able to be updated using SOAP.
'SentEvent' is not able to be updated using SOAP.
Suggested answer: D
asked 23/09/2024
Ruggero Pozza
38 questions

Question 76

Report
Export
Collapse

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

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

Question 77

Report
Export
Collapse

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

Tracking Extract Activity
Tracking Extract Activity
Server-Side JavaScript Activity
Server-Side JavaScript Activity
Campaign Data Extract
Campaign Data Extract
SQL Query Activity
SQL Query Activity
Suggested answer: A, D
asked 23/09/2024
Robeena Meer
35 questions

Question 78

Report
Export
Collapse

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?

%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%
%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%
%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
Suggested answer: A
asked 23/09/2024
Christopher Fiotes
35 questions

Question 79

Report
Export
Collapse

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

Ends With operator
Ends With operator
%%MMMMdd%%
%%MMMMdd%%
%%Month%%%%Day%°/o
%%Month%%%%Day%°/o
Begins With operator
Begins With operator
Suggested answer: C, D
asked 23/09/2024
Juan Bueno
40 questions

Question 80

Report
Export
Collapse

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

Subscribers
Subscribers
TriggeredSendDefinition
TriggeredSendDefinition
Attribute
Attribute
Contact
Contact
Suggested answer: B, D
asked 23/09/2024
Oleksandr Kondratchuk
35 questions
Total 197 questions
Go to page: of 20
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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: How should the developer use AMPscript to generate the total?
A developer needs to push real-time updates of the company's product catalog to a data extension. Which two API options are available? Choose 2 answers
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'
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?
Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.
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?
A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?
A customer wants a list of subscribers who were sent an email within the past 12 months. How should this request be completed?
Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5
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