Question 1

A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open DataViews. Which activities should the developer build to generate the data before transferring it to theSFTP?

Options :

A : Query Activity > Tracking Extract

B : Data Views Extract > Filter Activity

C : Filter Activity > Data Extension Extract

D : Query Activity > Data Extension Extract

Answer: B

Question 2

A developer needs to import a file into a data extension which contains transactional dat

a. The file includes a column labeled Purchase_Price with values varying from '$.05' to '$100'.

What Data Type should be used to prevent loss of data'

Options :

A : Text

B : Number

C : Decimal(9,2)

Answer: B

Question 3

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

Options :

A : PGP encryption

B : RSA encryption

C : GPG encryption

D : AES encryption

Answer: A,C

Question 4

A developer created a landing page in CloudPages which return unique content when subscriber data

is located on a related data extension. The developer does not know if all subscribers have rows in

the related data extension, and want default content to render if no subscriber data is found on the

related data extension. Which best practice should the developer follow to control the unique and

default content?

Options :

A : Use the RowCount function and an IF statement

B : Use the Lookup, Row and Field functions

C : Use the LookupOrderRows and Row functions

D : Use the DataExtensionRowCount function

Answer: A

Question 5

Northern Trails Outfitters (NTO) has a sendable data extension with 1,500,000 contact records they want to delete.

Which step is required before deleting the contacts?

Options :

A : Query the records into a new sendable data extension and delete it

B : Navigate to Contact Builder and delete the data extension

C : Divide the records in half and delete each resulting data extension

D : Navigate to Email Studio and delete the data extension

Answer: C

Free Marketing-Cloud-Developer Mock Exam – Practice Online Confidently

Buying Options: