Subscriber and Data Management

Question 1

Includes fields for a subscriber to plug in personal information

Answer 1

Profile center

Question 2

Includes lists for a subscriber to subscribe to

Answer 2

Subscription center

Question 3

Master list of subscriber records for the account

Answer 3

All Subscribers

Question 4

All Subscriber list contains…

Answer 4

email address, subscriber key, status, and any attributes created

Question 5

Unique Identifier for a subscriber

Answer 5

Subscriber Key

Question 6

Uniquely identifies a row of data in a data extension, and makes that row required for all records

Answer 6

Primary Key

Question 7

If not promary key is marked on a DE, the only way to import is…

Answer 7

to overwrite all data in the data extension

Question 8

Defines a field in a sendable data extension to map to the subscriber key in All Subscribers when sending

Answer 8

Send relationship

Question 9

3 types of unsubscribes

Answer 9

global, master, list-level

Question 10

Unsubscribe that occurs when a subscriber has requested not to receive any type of communication from any account, regardless of sender

Answer 10

Global unsubscribe

Question 11

Unsubscribe that results when a subscriber makes a spam complaint and is unsubbed in All Subscribers, or unsubscribes through the subscription center

Answer 11

Master unsubscribe

Question 12

Unsubscribe that occurs when a subscriber unsubs from a list in the subscription center

Answer 12

List-level unsubscribe

Question 13

4 ways to import data in SFMC

Answer 13

Create Subscriber Wizard, Import Wizard, Import File ACtivity, Via API

Question 14

4 ways to import data into a DE

Answer 14

Import Wizard, Import File ACtivity, Via API, Add a record through Contact Builder

Question 15

An activity to retrieve a data extension or system data view information that matches your criteria

Answer 15

Query activity

Question 16

2 segmentation tools in SFMC

Answer 16

Filters, queries

Question 17

Filters are comprised of…

Answer 17

rules

Question 18

A segmentation tool to segment subscribers based on the action or actions taken by a subscriber upon receipt of an email

Answer 18

measures

Question 19

Available measures in SFMC

Answer 19

Bounce, click, forward to friend, not clicked, not opened, open,sent, survey response, unique open, unique click, unsubscribe

Question 20

When you add or update data in a list or data extension, your filtered data extension needs to be…

Answer 20

refreshed

Question 21

The engine that runs the data filter, either manually or in an automation

Answer 21

Filter activity

Question 22

Criteria (rules) applied to a specific data extension or list in order to segment the data

Answer 22

Data Filter

Question 23

3 steps to automate a filter

Answer 23

Create the data filter, create the filter activity, automate via automation studio

Question 24

An activity to retrieve a data extension or system data view information that matches your criteria

Answer 24

Query Activity

Question 25

Query activities use ____ to acces data based on your criteria and places the results in a results data extension

Answer 25

SQL

Question 26

Shareable objects in Enterprise 2.0

Answer 26

Portfolio, Content, Templates, Emails, DEs, Publication Lists, Suppression Lists

Question 27

Create a filtered DE by filtering on these 3 things

Answer 27

fields, filters, measures

Question 28

Only __ random DEs can be created at one time

Answer 28

12

Question 29

Use this to relate two data extensions based on a common column

Answer 29

Data Relationship

Question 30

SQL Queries must contain these three things

Answer 30

name, external key, and a description

Question 31

Data actions available in a SQL query

Answer 31

Append, Update, Overwrite

Question 32

Allows you to segment your subscribers in sophisticated way and publish audiences for use in send or other activities, including in automations

Answer 32

Audience Builder

Question 33

This represents a group in Audience Builder who meet a set of user-defined criteria

Answer 33

Segment

Question 34

Gives you access to data not available via standard tracking

Answer 34

Send logging

Question 35

Tool that maintain information of emails addresses and domains that could cause deliverability problems

Answer 35

List Detective

Question 36

Green shirt

Answer 36

active subscriber

Question 37

Yellow shirt

Answer 37

bounced subscriber

Question 38

Gray shirt

Answer 38

held/undeliverable subscriber

Question 39

Red shirt

Answer 39

unsubbed subscriber

Question 40

A _____ is a subset of subscribers based on filterable attributes such as gender

Answer 40

Group

Question 41

Two kinds of subscriber groups

Answer 41

Filtered, Random

Question 42

3 types of Data extensions

Answer 42

standard, filtered, random

Question 43

Create a data relationship under the _____menus

Answer 43

Subscribers -> Data Relationships

Question 44

For queries involving data views, implement with a _____ cap.

Answer 44

6 month

Question 45

Segments of standard DEs

Answer 45

Filtered DEs

Question 46

Segments of any kind of DE

Answer 46

Random DE