Free Marketing-Cloud-Email-Specialist Exam Braindumps

As part of a daily shipping notification automation, Northern Trail Outfitters needs to join data from the Shipping data extension and the Purchase data extension.
What activity is designed to address this scenario?

1. A. SQL Query Activity
2. B. Filter Activity
3. C. Group Refresh
4. D. File Transfer Activity

Correct Answer: A

A marketing team has done an audit on the file formats of marketing-related data that it receives in order to bring it into Marketing Cloud. The team found it receives data delimited by:
• Commas
•Tabs
• Pipes
• Tilde
• Fixed widths
Which format will need to be pre-processed or parsed after import into Marketing Cloud?

1. A. Fixed widths
2. B. Pipe
3. C. Tab
4. D. Comma

Correct Answer: D

What is a true statement about Subscriber Key? (Choose 3)

1. A. SubscriberKey allows an email address to appear multiple times in a list or All Subscribers when populated with a value other than an email address
2. B. Subscriber Key is mapped to a field in a sendable data extension when defining a Send Relationship
3. C. SubscriberKey and Primary Key are interchangeable terms
4. D. Subscriber Key is a unique identifier for a subscriber, and can be populated with an email address or another unique value
5. E. Subscriber Key determines what update types will be available when importing data

Correct Answer: ABD

Northern Trail Outfitters is implementing Marketing Cloud and is unsure whether to use lists or data extensions. Their consultant recommended they use data extensions.
Which three considerations did the consultant take into account when recommending a data extension-based model over lists?
Choose 3 answers

1. A. They have fewer than 15 data points.
2. B. Flexible data storage is needed.
3. C. They have fewer than 250,000 subscribers.
4. D. They are storing product and store data.
5. E. Journey Builder willbe used.

Correct Answer: BDE

Northern Trail Outfitters has a Master Customer shared data extension. The company wants to make the table available to some of the business units, but not all of them.
How can access to the Master Customer table be restricted?

1. A. Shared Data Extension Permissions
2. B. Date/Time Range for Access
3. C. Data Extension Sharing Rules
4. D. Manage Data Extension Policies

Correct Answer: A