Data y Segmentación

A marketer is updating a data extension by manually importing a file using the Import Wizard. The marketer wants to ensure that only new records are added to the data extension during the import process. In which two ways should the data extension an Import Wizard be configured so that the marketer can achieve this?

• Select the update type "Overwrite"

• Select the update type "Add Only"

• Select the update type "Add and Update"

• Ensure the data extension has a Primary Key

A team wants to import a file with column names that do not match the fields into a data extension. What step is needed to align the file data to the field names in the data extension?

• Map the attributes in the file

• Choose the appropriate date format

• Name the new import definition

• Select the delimiting character

Northern trail Outfitters (NTO) plans to launch an email campaign. They have two data extensions. The Mountain Manor Campaign Data Extension will contain the sending audience for this campaign and includes fields for Email Address, Full Name, Loyalty Member ID, and Loyalty Member Status. NTO will be using AMPscript to reference data in a second non-sendable data extension named Loyalty Member. Which field on the Mountain Manor Campaign Data Extension should be created as a Primary Key to create unique relationships with the Loyalty Member Profile Data Extension?

• Email Address

• Loyalty Member ID

• Full Name

• Loyalty Member Status

A data administrator is creating a new data extension to store product catalog data. Character length limit is specified for each field. What are two beneficts

• To optimize import process speed

• To ensure data integrity

• To determine the correct data type

• To save the data extension

Northern Trail Outfitters (NTO) would like to create a landing page that displays subscriber information passed to it from email links on the page. This page contains a Smart Capture form. NTO would like to require email address, reply date, and response for subscribers completing the form. How should NTO set up its data extension?

• Create a data extension with email address, reply date, and response fields as non-nullable

• Create a data extension with email address as the Primary Key and reply date and response fields as nullable

• Create a data extension with email address as non-nullable; reply date and response fields as nullable

• Create a data extension with email address, reply date, and response fields as nullable

Which file type delimiter is available in the Import Wizard? Choose 3 answers

• Fixed Length

• Tab

• Other

• Comma

• Pipe

A marketer sent a promotional email to contacts who recently attended a trade show. the send contained 3,100 records. The delivery rate on the send was lower than antic tracking information, she determined many email addresses were problematic.

The data extension used for pated. After viewing

Which send tracking metric provides the bounce description "Address is non-existent at the domain'?

• Undeliverable

• Hard Bounce

• Blocked Bounce

• Soft Bounce

An email marketing team is setting up a campaign to message customers who register for an event. The registration data is being gathered in another system and will be passed to Marketing Cloud daily, and updates made to the customers' registration information will be reflected in the same file.

How should the import of event registration data be configured?

• Overwrite the records in the data extension

• Add new records into the data extension

• Delete record from All subscribers

• Add new records into All Subscribers

A marketer sends an email to a sendable data extension. The data extension has a subscriber relationship that

matches Customer_ID on the data extension to Subscriber Key on the All Subscribers List

How would the default send behavior perform for a pre-existing subscriber?

• The email will be sent to the field marked as the Primary Key

• The email will be sent to the email address stored on the data extension.

• The email will be sent to the Subscriber Key on the All Subscribers List.

• The email will be sent to the email address stored or the All Subscribers List.

A customer has a Send Log they are using to track the email addresses that were sent to, date and time of the send, and the name of the email sent for reporting purposes. Per best practice, the customer stores 10 days of data in their Send Log and then archives the data into another data extension that holds data for one year.

Which activity should be used to run the backup automatically?

• Import File

• SQL Query

• Data Extract

• Filter