Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Marketing Cloud Email Specialist > Subscriber and Data Management > Flashcards

Subscriber and Data Management Flashcards

1
Q

How do you make SendLogs?

A

Created as data extensions via Create from Template

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

SQL queries in an automation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How do you send to a synchronized data extension?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Subscriber Key vs Subscriber ID?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When do you need a subscriber key?

A

Sendable data extensions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

The All-Subscribers list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Where are publication lists selected?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a NotSent Tracking Extract?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What shows engagement data in Automation Studio SQL queries?

A

Data Views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What do Add-Only Imports require?

A

A primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What must sendable data extensions be mapped to?

A

All Subscribers list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

API integrations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

A target data extension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the SQL Query update options?

A

Append, Update, Overwrite

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are the import update options?

A

Add and Update, Add Only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is a contact?

A

An individual who receives communication via any channel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a subscriber?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Send Relationship

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Locale Data Type

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Where are subscribers stored?

A

Email Studio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

How are subscribers created?

A

Import into the All Subscribers list or being sent an email

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What data type is a Subscriber Key?

A

Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

The 18 digit lead or contact ID

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What is a subscriber key used for?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What are the All Subscribers List statuses?

A

Active
Held
Bounced
Unsubscribed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is the Held status?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What is the Bounced status?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Data Designer

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What section should be used for data management?

A

Contact Builder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

Data Extension

33
Q

What data model has a limited number of attributes?

34
Q

What is the recommended data model?

A

Data extension

35
Q

What are the types of data extensions?

A

Standard
Salesforce
Synchronized

36
Q

What are Salesforce data extensions used for?

A

Sending email tracking info to Sales or Service Cloud

37
Q

What are the data extension creation methods?

A

Create New
From Existing
From Template

38
Q

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

39
Q

What are the Data Retention Policy targets?

A

Individual Records
All Records
All Records and Data Extensions

40
Q

Where do you view all of your Data Retention Policies?

A

Data Extensions dashboard view in Contact Builder

41
Q

What does a primary key ensure in a data extension?

A

Records are not overwritten

42
Q

Where are Data Extension Storage Details exported from?

A

A CSV in Setup/Metrics

43
Q

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

44
Q

Send Relationship

A

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

45
Q

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

A

Subscriber Key

46
Q

What is checked to determine a subscriber’s status?

A

Send Relationship

47
Q

What are the methods to add records to Marketing Cloud?

A

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

48
Q

What is not required in the overwrite import type?

A

Primary Key

49
Q

Where is manual record creation done?

A

Contact Builder

50
Q

When should the Import record creation type be used?

A

One-time record additions like in-person newsletter signups

51
Q

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

A

Enhanced FTP

52
Q

What is the max size of an import file?

53
Q

What formats can an import file be?

A

Comma
Tab
One-Character Delimited

54
Q

What are the field mapping types?

A

Header Row
Ordinal
Manually

55
Q

Ordinal Field Mapping Type

A

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

56
Q

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

A

Large-volume files

57
Q

What happens to deleted data extensions?

A

Moved to the Recycle Bin and deleted after 30 days

58
Q

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

A

File Transfer activity

59
Q

Where do File Transfer activities place unencrypted files?

A

Marketing Cloud Safehouse

60
Q

Where are data filters created and how are they run?

A

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

61
Q

What are the segmented data extension types?

A

Random data extensions
Filtered data extensions

62
Q

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

A

30 minutes

63
Q

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

64
Q

How long can data views store tracking data?

A

Six months

65
Q

How are data view tables accessed?

A

SQL Queries

66
Q

How are email sends identified?

A

System-defined JobId number

67
Q

What are the unsubscribe types?

A

Universal
Global

68
Q

What does a Global unsubscribe remove a person from?

A

All emails sent by any Marketing Cloud instance

69
Q

What controls which communications subscribers receive?

A

Publication Lists

70
Q

True/False: publication lists can receive imports

71
Q

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

72
Q

Profile Center

A

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

73
Q

Subscription Center

A

Email subscription preferences page

74
Q

What appears in the Tracking tab of Email Studio?

A

Job ID
Total Sent
Send Performance

75
Q

Send Logs

A

Capture unique info like send fail data

76
Q

How many send logs can a business unit have?

77
Q

Tracking Extracts

A

Used to export email performance data

78
Q

NotSent Tracking Extracts

A

Export send fail data

Marketing Cloud Email Specialist (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions