ExamGecko
Ask Question

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

List of questions

Question 141

Report
Export
Collapse

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.

SET @total = Sum(@var1, @var2, @var3)
SET @total = Sum(@var1, @var2, @var3)
SET @total = Add(@var1, Add(@var2, @var3))
SET @total = Add(@var1, Add(@var2, @var3))
SET @total = Add(@var1, @var2, @var3)
SET @total = Add(@var1, @var2, @var3)
SET @total = @var1 + @var2 + @var3
SET @total = @var1 + @var2 + @var3
Suggested answer: B
asked 23/09/2024
Michael Geary
35 questions

Question 142

Report
Export
Collapse

Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

File Import activity
File Import activity
Data Extract activity
Data Extract activity
Data Extension Import activity
Data Extension Import activity
File Transfer activity
File Transfer activity
Suggested answer: D
asked 23/09/2024
SERGIO MELOSEVICH
45 questions

Question 143

Report
Export
Collapse

Northtrn Trail Outfitters has set up their North American business unit to unsubscribe at the business unit level.

Which dataview would they query to identify all subscribers who are unsubscribed from that Business Unit?

ListSubscribers
ListSubscribers
ENT._Subscribers
ENT._Subscribers
_BusinessUnitUnsubscribes
_BusinessUnitUnsubscribes
.Subscribers
.Subscribers
Suggested answer: C
asked 23/09/2024
Artur Sierszen
48 questions

Question 144

Report
Export
Collapse

Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.

Which two file encryption options are supported when importing data files to Marketing Cloud?

Choose 2 answers

PGP encryption
PGP encryption
RSA encryption
RSA encryption
GPG encryption
GPG encryption
AES encryption
AES encryption
Suggested answer: A, C
asked 23/09/2024
Vincent Scotti
29 questions

Question 145

Report
Export
Collapse

A developer wants to create a data model in Contact Builder.

Which two applications will be able to use this newly-created data model for segmentation?

Choose 2 answers

Email Studio
Email Studio
Automation Studio
Automation Studio
Journey Builder
Journey Builder
Mobile Studio
Mobile Studio
Suggested answer: A, B
asked 23/09/2024
Hector Moreno
40 questions

Question 146

Report
Export
Collapse

Northtrn Trail Outfitters mistakenly synced the User_Salesforce object which added to their billable contact count.

What should be recommended to remove these contacts'

Update the sync to remove these contacts from the All Contacts table.
Update the sync to remove these contacts from the All Contacts table.
Use the REST API to delete the contacts from the All Subscribers table.
Use the REST API to delete the contacts from the All Subscribers table.
Put the synced records into a sendable data extension and use Contact Delete.
Put the synced records into a sendable data extension and use Contact Delete.
Use the SOAP API to delete the contacts from the All Contacts table.
Use the SOAP API to delete the contacts from the All Contacts table.
Suggested answer: C
asked 23/09/2024
Aleksei Chernikov
47 questions

Question 147

Report
Export
Collapse

A developer is creating a CloudPage which accepts secure parameters via an email link and will submit those parameters to another CloudPage for data upsert. The page currently captures an Appointment ID parameter passed into it and sets the value to the variable caapptld. The developer does NOT want the Appointment ID to be visible to anyone using the form.

What is the best method to ensure the parameters are passed successfully to the data upsert page?

Become a Premium Member for full access
  Unlock Premium Member

Question 148

Report
Export
Collapse

Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named 'Inventory', which contains the details for each product. A Boolean field named 'InStock' indicates whether the item is available.

Which snippet of AMPscript would return all products which are currently available?

Become a Premium Member for full access
  Unlock Premium Member

Question 149

Report
Export
Collapse

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a data extension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to be created in the US business unit to query all records in New York who are members of the business unit US.

SELECT * FROM MemberData WHERE State = 'NY' AND US = 1 What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?

Become a Premium Member for full access
  Unlock Premium Member

Question 150

Report
Export
Collapse

A developer wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needs to contain JobID, EventDate, and the counts of how many emails were sent with each JobID.

Which data view is required to gather this information?

Become a Premium Member for full access
  Unlock Premium Member
Total 197 questions
Go to page: of 20
Search

Related questions