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*, 'InStock', 'true', )
• B.LookupRows ('Ent. Inventory*, 'true', 'InStock')
• C.LookupRows ('Inventory*, 'InStock' 'true',)
• D.LookupRows ('Ent. Inventory*, itemName, 'InStock', 'true')

Comment: *

Name: *

Email: *

Verification: *

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.Ensure all SQL Query Activities are in the same step in the automation.
• C.Configure a longer timeout period within Administration in Automation Studio.
• D.Use intermediate tables to break queries into smaller parts.

Comment: *

Name: *

Email: *

Verification: *

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.Outbound SMS template and Automation Send Method
• D.InsertData AMPscript function to add the subscriber to a MobileConnect list

Comment: *

Name: *

Email: *

Verification: *

A developer wants to build an email that dynamically populates the physical address of a company's locations using the variable ©address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance.
Which AMPscript solution should be recommended?

• A.%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
• B.%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
• C.%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
• D.%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%

Comment: *

Name: *

Email: *

Verification: *

A developer needs to push real-time updates of the company's product catalog to a data extension.
Which two API options are available? Choose 2 answers

• A.Use the /hub/vl/aataevents REST route
• B.Use the DataExtensionObject SOAP object
• C.Use the DataExtension SOAP object
• D.Upload a file to the Enhanced SFTP for import

Comment: *

Name: *

Email: *

Verification: *