Clock Kicks would like to encrypt and store formdata submitted from a CloudPage in a data extension using AMPscript. Which three encryption options could be used when creating a new key in Key Management? Choose 3

A. SAML

B. Asymmetric

C. RSA

D. Salt

E. Symmetric

NTO uses data extensions to manage the subscriber information used for their emailsends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated using an InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?

A. The InsertDE function will always insert two rows into a data extension as part of the call

B. The InsertDE function cannot be used with name and value pairs

C. The InsertDE function comes after the system added the row as part of the email send

D. The InsertDE function cannot be used at send time

How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

A. Six Months

B. One Month

C. 12 Months

D. There is no limit

A developer wants to implement anewsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?

A. REST API, /address/v1/validateEmail route

B. SOAP API, Perform method with ValidationAction object

C. SOAP API, Describe method with EmailAddress object

D. REST API, /messaging/v1/domainverification route

A developer wants to retrieve all records in the OrderDetailsdata extension which are associated with a particular customer.

Which two AMPscript functions would return a suitable rowset?

Choose 2 answers

A. LookupRows

B. LookupOrderedRows

C. Row

D. Lookup

A developer needs to display a value which has beencalculated using an AMPscript block. This value is stored in the variable named 'Label'.

Which two ways should the developer display this value in the body of an email? Choose 2 answers

A. %%-v(@Label) -%%

B.

C. %%@Label%%

D. %%(Write (@Label1) 1%%

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 wants to build an email that dynamically populates the physical address of a company's locations using the variable゛ddress. The deployment goes to millions of subscribers and the developer wants the fastest possible performance.

Which AMPscript solution should be recommended?

A. %%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%

B. %% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%

C. %%;SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%

D. %: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%

A developer wants to use the RaiseError Ampscript function when a subscriber does not have the necessary data to build an email. Which two outcomes are possible using this function? Choose 2 answer

A. The send fails

B. The email is not sent to the particular subscriber

C. An error message is sent to the From Address used in the email

D. The send is retried

Customer data has been imported into a staging data extension and needs to benormalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.

Which SQL keywords and functions could be used to write the query'' Choose2 answers

A. CASE, ISDATE, CONVERT

B. WHERE, ISDATE, CONVERT

C. CASE, ISDATE, CAST

D. UPDATE, ISDATE, CONVERT