Online Access Free Marketing-Cloud-Developer Practice Test

A developer needs to import a file into a data extension which contains transactional data. 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'

• A.Decimal(9,2)
• B.Text
• C.Number

A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers

• A.The query takes more than 60 minutes to run.
• B.The query results in duplicate rows not allowed by the primary key.
• C.The query is inserting a value that is larger than the size of a field.
• D.The query is returning more than one million rows.
• E.The query is not returning a value for a non-nullable field.

A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including:

Which subject line will be used at the time of deployment?

• A.Enjoy 10% off today
• B.Enjoy 15% off today
• C.Enjoy 20% off today

A marketer is planning a weekly promotionalsend.
Which two types of data extensions could be sent to?
Choose 2 answers

• A.Sendable Data Extension
• B.Salesforce Data Extension
• C.Synchronized Data Extension
• D.Send Log Data Extension

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?

• A.Use the DataExtensionRowCount function
• B.Use the Lookup, Row and Field functions
• C.Use the LookupOrderRows and Row functions
• D.Use the RowCount function and an IF statement