A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is 'true' (Data Type = Formula(Boolean)) -ContactType equals 'Phone' (Data Type = Text). Which field could be used to select a subset of records in the synchronization configuration?

Which AMPscript function group could most negatively Impact send processing?

A developer needs to know how many records are contained in a particular data extension. This will dictate what is displayed on a landing page.

Which AMPscript functionreturns the number of rows in a specified data extension?

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

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 developer receives a request for tracking data for alt sends associated with a specific JoblD. The developer needs to see Sends, Opens, Clicks, and Bounces.

Which two activities could the developer use? Choose 2 answers

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 developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Whichfeature should handle this scenario?

Certification Aid created a journey and event definition in Marketing Cloud. Which of the following resources are relevant to inject Contacts into the journey using the REST API? Choose 2.

A new record is appendedto the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.

Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber.

In which way could the developer create the CTA link?

Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

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 noemails have been sent during his initial testing. Which object and method should the developer use?

Northern Trails Outfitters (NTO)has a sendable data extension with 1,500,000 contact records they want to delete.

Which step is required before deleting the contacts?

NTO wants to exclude sending an email at send time to those with a record on the 'Exclude' Data Extension. The primary key on this data extension is Subscriber Key.

How would a developer write the Exclusion Script?

How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including:

Which subject line will be used at the time of deployment?

From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a dataextension 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 becreated 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 developer wants to create a Send LogData Extension to increase efficiency with tracking email sends.

Which two best practices should the developer remember when configuring the Send Log Data Extension? Choose 2 answers

A developer uses the messageDefinitionSends REST API endpoint to send a triggered send email. This method returns a 202 (success) response code. How could the developer validate if the email was successfully sent?

A developerwants to retrieve daily JSON data from a customer's API and write it to a data extension for consumption in Marketing Cloud at a later time.

What set of Server-Side JavaScript activities should the developer use?

A doctor's office creates Populations for staff, patients and vendors. What is the maximum number of Populations that should be created to ensure performance?

Which of the followingis a valid comment within an AMPscript code block? Choose 1.

Certification Aid wants to import data from a CSV file into a Data Extension. The CSV filecontains all relevant data. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

A developer needs to import a file into a data extension which contains transactional data. The file includes a column labeled Purchase_Price with values varying from '$.05' to '$100'.

What Data Type should be used to prevent loss of data'

What is the purpose of the IF statement below?

A developer wants to create a data model in Contact Builder.

Which two applications will be able to use this newly-created data model for segmentation?

Choose 2 answers

A developer want to email a subscriber who is currently being processed for a Contact Deletion request. When could the Contact be reintroduced after a Contact Delete operation has started?

A developer is making an API REST call to trigger an email send. An accesstoken is used to authenticate the call.

How long are Marketing Cloud v1 access tokens valid?

A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

A developer wants to build out aseries of CloudPages that will interact with several REST APIs.

Which Marketing Cloud supported scripting tool should be used?

Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

Clock Kicks would like to encrypt and storeform data 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

In what order is AMPscript evaluated before an email is sent?

Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website. Which API should be used for this? Choose 2.

A particular data extension need to be configured to store six months of data.

How shoulddata retention be added to the data extension in Email Studio?

A developer is troubleshooting the cause of incomplete results in the link tracking data for an email send.

How should the RedirectTo AMPscript function be described as it relates to link tracking'

A developer wants to personalize a welcome email with the recipient's first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensionscontain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?