Online Access Free Marketing-Cloud-Developer Practice Test

A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?

• A.File Drop Automation
• B.Dynamic File Import
• C.Scheduled Automation

What is the operational order of the Contact Delete process for Marketing Cloud?

• A.Delete initiated > Suppression phase > Final Deletion
• B.Delete initiated > Final deletion
• C.Data identified > Suppression phase > Delete initiated > Account page
• D.Delete initiated > Final deletion >Suppression phase

A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?

• A.Limit joins to the INNER JOIN within all SQL Query Activities.
• B.Use intermediate tables to break queries into smaller parts.
• C.Configure a longer timeout period within Administration in Automation Studio.
• D.Ensure all SQL Query Activities are in the same step in the automation.

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?

• A.LookupRows ('Ent. Inventory*, 'true', 'InStock')
• B.LookupRows ('Ent. Inventory*, itemName, 'InStock', 'true')
• C.LookupRows ('Inventory*, 'InStock' 'true',)
• D.LookupRows ('Ent. Inventory*, 'InStock', 'true', )

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.The authentication token has expired.
• B.'SentEvent' is not able to be updated using SOAP.
• C.SOAP does not support POST; useREST
• D.It may be a temporary network issue.