A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subscriber submits the form?

• A.CreateSMSConservation AMPscript function
• B.requestToken and messageContact REST API objects
• C.InsertData AMPscript function to add the subscriber to a MobileConnect list
• D.Outbound SMS template and Automation Send Method

Comment: *

Name: *

Email: *

Verification: *

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."?

• A.Query should check for a US value of True'
• B.MemberData should be prefixed with ENT
• C.Query Activities cannot use the " wildcard
• D.Incorrect syntax; Query Activities are written in SOQL

Comment: *

Name: *

Email: *

Verification: *

A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose 2

• A.Request the Impression Tracking feature be enabled on the account
• B.Include the functions BeginImpressionRegion and EndImpressionRegion
• C.Configure dynamic content block in Content Builder
• D.Add a unique identifier in the HTML tags within the generated content

Comment: *

Name: *

Email: *

Verification: *

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

• A.Use intrisic functions in the WHERE clause
• B.Use Primary key(s) on fields used in joins
• C.Only update records that have changed since last execution
• D.Use SELECT * to include all fields
• E.Use intermediate tables to stage data

Comment: *

Name: *

Email: *

Verification: *

Which AMPscript function group could most negatively Impact send processing?

• A.String functions
• B.Data extension functions
• C.Date Time
• D.Math functions

Comment: *

Name: *

Email: *

Verification: *