Subscriber & Data Management

Question 1

What are Data Extensions in Marketing Cloud?

Answer 1

Flexible data storage solutions within Email Studio, acting like tables to hold subscriber data that doesn’t fit standard profile attributes

Question 2

Handling, Integrating, Enabling

Name three reasons to use Data Extensions

Answer 2

1) Handling varied data structures
2) Integrating external data
3) Enabling targeted sends

Question 3

How do you update a Filtered Data Extension with new records?

Answer 3

Use the “Refresh” function

Question 4

Can you explain the “Randomise” function for Data Extensions?

Answer 4

It creates new Data Extensions by randomly splitting existing ones into subsets

Question 5

How do Data Extensions help with email personalisation?

Answer 5

They store custom data that can be included in email messages

Question 6

What is the purpose of a SQL Query Activity in Marketing Cloud?

Answer 6

To retrieve specific data from data extensions using custom SQL queries and store the results

Question 7

What is a crucial step to ensure accurate field naming in your SQL query?

Answer 7

Drag and drop fields from the data extension list instead of manually typing them

Question 8

Can you use both “JOIN” and “SELECT “ in the same SQL query within a SQL Query Activity?

Answer 8

It is not recommended. Specify individual columns instead of using “SELECT ”

Question 9

What are the three data handling options when configuring a SQL Query Activity?

Answer 9

1) Append 2) Update 3) Overwrite

Question 10

Where can you monitor the execution history and results of your SQL Query Activity?

Answer 10

In the activity logs

Question 11

What is the primary function of Audience Builder in Marketing Cloud?

Answer 11

To dynamically segment contacts into targeted audiences based on attributes and behaviors

Question 12

Explain the difference between “Audiences” and “Segments” in Audience Builder.

Answer 12

Audiences are broad collections of contacts, while Segments are subsets with specific criteria within an Audience

Question 13

Which tab in Audience Builder is used to suppress specific contacts from an audience?

Answer 13

The “Exclusions” tab

Question 14

How can you utilise segmented audience data in other Marketing Cloud activities?

Answer 14

By publishing the audiences as Data Extensions

Question 15

What is the purpose of “Dimension Packages” in Audience Builder?

Answer 15

To define the organisation and display of subscriber data in the Attribute Library

Question 16

What are Auto-Suppression Lists in Marketing Cloud

Answer 16

Account or business unit-level lists that automatically exclude specific email addresses from Email Studio sends, acting as “do-not-contact” lists

Question 17

What are Auto-Suppression Lists in Marketing Cloud?

Answer 17

Account or business unit-level lists that automatically exclude specific email addresses from Email Studio sends, acting as “do-not-contact” lists

Question 18

Provide three common use cases for Auto-Suppression Lists

Answer 18

1) Addresses with spam complaints
2) Unsubscribe lists from previous providers
3) Competitors’ email addresses

Question 19

What is the scope difference between Child Business Unit and Enterprise Business Unit for Auto-Suppression Lists?

Answer 19

Child Business Unit limits suppression to that specific unit, while Enterprise Business Unit applies it account-wide

Question 20

What happens to the triggered send queue when you enable an Auto-Suppression List?

Answer 20

It is republished with the changes, but existing content is not updated.

Question 21

Will subscribers already in the triggered send queue be suppressed when an Auto-Suppression List is enabled?

Answer 21

No, they will not be suppressed.