MARKETING-CLOUD-DEVELOPER Online Practice Questions and Answers

NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but no emails havebeen sent during his initial testing. Which object and method should the developer use?

A. TriggerSend object and Update method

B. TriggerSend object and Create method

C. TriggerSendDefinition object and Execute method

D. TriggerSendDefinition object andUpdate method

How often should a developer request a new token when making multiple API calls in v1?

A. When changing routes/objects

B. Before every new call

C. Once an hour

D. Every 15 minutes

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

A. Configure a longer timeout period within Administration in Automation Studio.

B. Use intermediate tables to break queries into smaller parts.

C. Ensure all SQL Query Activities are in the same step in the automation.

D. Limit joins to the INNER JOIN within all SQL Query Activities.

What can be created in Attribute Groups within Contact Builder? Choose 2.

A. Data Extensions

B. Relationships

C. Populations

D. Attribute Groups

A developer wants CloudPages to work with a REST API returning data in JavaScript Object Notation. The developer wants to efficiently ingest the data and write it to a data extension.

Which function should be used?

A. Server-Side 3avaScript function Stringify

B. Server-Side JavaScript function ParseJSON

C. AMPscript function BuildRowsetFromXML

D. AMPscript function BuildRowsetFromString

NTO isusing a mobile campaign to collect an 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 TriggerSend object? Choose 2

A. Attribute

B. TriggerSendDefinition

C. Contact

D. Subscribers

NTO wants to exclude sends to specificsubscribers based on a business rule, which is defined in an Exclusion Script. Which three types of sends would support this functionality? Choose 3

A. Journey Builder Send Email Activity

B. Content Builder Send Flow

C. Send Marketing Cloud Email in Salesor Service Cloud

D. Journey Builder Send SMS Activity

E. Automation Studio Send Email Activity

CertificationAid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page. When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

A. AMPscript to create Salesforce record, SSJS for form handling.

B. SSJS to create Salesforce record, AMPscript for form handling.

C. AMPscript for whole functionality.

D. SSJS for whole functionality.

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a data extension In the SharedData 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.?

A. Incorrect syntax; Query Activities are written in SOQL

B. MemberData should be prefixed with ENT

C. Query should check fora US value of True'

D. Query Activities cannot use the " wildcard

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 is returning more than one million rows.

C. The query results in duplicate rows not allowed by the primary key.

D. The query is not returning a value for a non-nullable field.

E. The query is inserting a value that is larger than the size of a field.