Subscriber and Data Management

Question 1

How do you make SendLogs?

Answer 1

Created as data extensions via Create from Template

Question 2

How do you split synchronized data extensions into standard data extensions?

Answer 2

SQL queries in an automation

Question 3

How do you send to a synchronized data extension?

Answer 3

Must be queried with SQL and split into standard data extensions. Can’t send or start a journey with a synchronized data extension.

Question 4

Subscriber Key vs Subscriber ID?

Answer 4

Subscriber Key is user-defined, Subscriber ID is system-defined

Question 5

When do you need a subscriber key?

Answer 5

Sendable data extensions

Question 6

What are emails sent to if no publication list is chosen at send time?

Answer 6

The All-Subscribers list

Question 7

Where are publication lists selected?

Answer 7

In Journey Builder- “Manage Recipients” section of Delivery Options

Question 8

What’s the difference between a target data extension and an original data extension?

Answer 8

Target data extensions are created automatically by MC when an original data extension is filtered

Question 9

What is a NotSent Tracking Extract?

Answer 9

Shows reasons for send failures. Is performed in Automation Studio.

Question 10

What shows engagement data in Automation Studio SQL queries?

Answer 10

Data Views

Question 11

What do Add-Only Imports require?

Answer 11

A primary key

Question 12

What must sendable data extensions be mapped to?

Answer 12

All Subscribers list

Question 13

How do you receive real-time data like website submissions?

Answer 13

API integrations

Question 14

What has to be created before an SQL Query is created?

Answer 14

A target data extension

Question 15

What are the SQL Query update options?

Answer 15

Append, Update, Overwrite

Question 16

What are the import update options?

Answer 16

Add and Update, Add Only

Question 17

What is a contact?

Answer 17

An individual who receives communication via any channel

Question 18

What is a subscriber?

Answer 18

An individual who opted in to receive communication via a particular channel

Question 19

Send Relationship

Answer 19

A field used at the send time to identify the email recipient

Question 20

Locale Data Type

Answer 20

Allows two characters to define country and five characters to define language

Question 21

Where are subscribers stored?

Answer 21

Email Studio

Question 22

How are subscribers created?

Answer 22

Import into the All Subscribers list or being sent an email

Question 23

What data type is a Subscriber Key?

Answer 23

Text

Question 24

What must the subscriber key be if Marketing Cloud Connect is enabled?

Answer 24

The 18 digit lead or contact ID

Question 25

What is a subscriber key used for?

Answer 25

Retrieving email addresses, identifying the record to update during data imports, and preference management

Question 26

When do subscriber key and contact key have the same value?

Answer 26

Subscriber information is mapped to the Contact model before data is added to Marketing Cloud

Question 27

What are the All Subscribers List statuses?

Answer 27

Active Held Bounced Unsubscribed

Question 28

What is the Held status?

Answer 28

Person had three or more hard or soft bounces in the last 15 days (or one hard bounce from a trusted domain). Permanently suppressed.

Question 29

What is the Bounced status?

Answer 29

Person had 1-2 soft bounces or one hard bounce (non-trusted domain). Resets to Active if the person engages with an email.

Question 30

Data Designer

Answer 30

Enables viewing and managing contact data by relating data to the contact record or linking data extensions

Question 31

What section should be used for data management?

Answer 31

Contact Builder

Question 32

What data model can have more than 500,000 subscribers?

Answer 32

Data Extension

Question 33

What data model has a limited number of attributes?

Answer 33

List

Question 34

What is the recommended data model?

Answer 34

Data extension

Question 35

What are the types of data extensions?

Answer 35

Standard Salesforce Synchronized

Question 36

What are Salesforce data extensions used for?

Answer 36

Sending email tracking info to Sales or Service Cloud

Question 37

What are the data extension creation methods?

Answer 37

Create New From Existing From Template

Question 38

What item is not copied from the original data extension when a data extension is created From Existing?

Answer 38

Records

Question 39

What are the Data Retention Policy targets?

Answer 39

Individual Records All Records All Records and Data Extensions

Question 40

Where do you view all of your Data Retention Policies?

Answer 40

Data Extensions dashboard view in Contact Builder

Question 41

What does a primary key ensure in a data extension?

Answer 41

Records are not overwritten

Question 42

Where are Data Extension Storage Details exported from?

Answer 42

A CSV in Setup/Metrics

Question 43

What is the max recommended amount of columns in a data extension?

Answer 43

50

Question 44

Send Relationship

Answer 44

Used at send time to identify a recipient and creates the link between the sendable data extension and the All Subscribers list

Question 45

What field is the Send Relationship mapped to in the All Subscribers list?

Answer 45

Subscriber Key

Question 46

What is checked to determine a subscriber's status?

Answer 46

Send Relationship

Question 47

What are the methods to add records to Marketing Cloud?

Answer 47

Manual Record Creation Import Import File Activity Synchronized Data Sources API Integration SmartCapture forms

Question 48

What is not required in the overwrite import type?

Answer 48

Primary Key

Question 49

Where is manual record creation done?

Answer 49

Contact Builder

Question 50

When should the Import record creation type be used?

Answer 50

One-time record additions like in-person newsletter signups

Question 51

What is required to perform imports from a File Location source?

Answer 51

Enhanced FTP

Question 52

What is the max size of an import file?

Answer 52

20mb

Question 53

What formats can an import file be?

Answer 53

Comma Tab One-Character Delimited

Question 54

What are the field mapping types?

Answer 54

Header Row Ordinal Manually

Question 55

Ordinal Field Mapping Type

Answer 55

Maps by order of fields (first column mapped to first field, etc)

Question 56

What should the Import File Activity creation type be used for?

Answer 56

Large-volume files

Question 57

What happens to deleted data extensions?

Answer 57

Moved to the Recycle Bin and deleted after 30 days

Question 58

What is needed before an Import File Activity for encryped files?

Answer 58

File Transfer activity

Question 59

Where do File Transfer activities place unencrypted files?

Answer 59

Marketing Cloud Safehouse

Question 60

Where are data filters created and how are they run?

Answer 60

Created in Email Studio, run by Filter activities in Automation Studio

Question 61

What are the segmented data extension types?

Answer 61

Random data extensions Filtered data extensions

Question 62

How long will Automation Studio attempt to run an SQL Query before giving an error?

Answer 62

30 minutes

Question 63

In SQL Queries, what has to be placed before a "From" clause to get data from a business unit's enterprise parent account?

Answer 63

ENT

Question 64

How long can data views store tracking data?

Answer 64

Six months

Question 65

How are data view tables accessed?

Answer 65

SQL Queries

Question 66

How are email sends identified?

Answer 66

System-defined JobId number

Question 67

What are the unsubscribe types?

Answer 67

Universal Global

Question 68

What does a Global unsubscribe remove a person from?

Answer 68

All emails sent by any Marketing Cloud instance

Question 69

What controls which communications subscribers receive?

Answer 69

Publication Lists

Question 70

True/False: publication lists can receive imports

Answer 70

True

Question 71

True/False: publication lists cannot be made public and used in a preference center

Answer 71

False

Question 72

Profile Center

Answer 72

Gives control of the records stored about a person (ie name and email)

Question 73

Subscription Center

Answer 73

Email subscription preferences page

Question 74

What appears in the Tracking tab of Email Studio?

Answer 74

Job ID Total Sent Send Performance

Question 75

Send Logs

Answer 75

Capture unique info like send fail data

Question 76

How many send logs can a business unit have?

Answer 76

One

Question 77

Tracking Extracts

Answer 77

Used to export email performance data

Question 78

NotSent Tracking Extracts

Answer 78

Export send fail data