Salesforce MKT-101 Quiz 9 Topic 4 Questions 41-45

Question: 1

Northern Train Outfitters wants to make sure that a First Name and Last Name are always included when importing subscribers to a data extension. How can a marketer ensure that subscribers are imported with data in both of these fields?

AMake the First Name and Last name columns Primary Keys

BEnsure the Nullable property is unchecked for the First Name and Last Name columns

CCheck the Nullable property for the First Name and Last Name columns

DSet up a default value for the column

Show Answer

Question: 2

Northern Train Outfitters needs to ensure that 'Valued Customer' appears if no data exists in that field for a subscriber when using a personalization string to display the First_Name field in a data extension. How can the Marketer most easily achieve this during creation of the data extension?

AEnsure the Nullable box is not checked for the First_Name field

BFill in the source data with 'Valued Customer' for each blank First_Name field

CMark First_Name as the Primary Key

DMake 'Valued Customer' the Default Value for the First_Name field

Show Answer

Question: 3

A marketer is building a highly personalized email that is sent daily to one million subscribers. The data needed for the email is located in several data extensions.

What feature should the marketer use to merge the data into a single data extension to improve sending?

AProfile Management

BFile Triggers

CSQL Query Activities

DData Filters

Show Answer

Question: 4

A marketer wants to overwrite the data in a data extension on a daily basis

using Automation Studio. What can the marketer do to accomplish this task?

ACreate an import using the Import Wizard in Automation Studio.

BCreate an Import Activity and execute it manually.

CCreate an import using the Import Wizard in the Email Application.

DCreate an Import Activity to use in a workflow in Automation Studio.

Show Answer

Question: 5

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?

AUse the Import Activity to overwrite the records in the data extension.

BUse the Import Wizard to add new records into the data extension.

CUse the Import Wizard to overwrite the records in the data extension.

DUse the Import Activity to add new records into the data extension.

Show Answer

Salesforce MKT-101 Quiz:9 Topic:4 Questions:41-45