Email Specialist For Testing

A Call to Action should be action orientated. Which words would you include in a Call to Action?

A Data Extension can have multiple Primary Keys

A Data Filter can join two or more data extensions?

A Decision Split can use either Journey Data or Contact Data.

A Filter Activity can be used to join two Data Extensions.

A Filter Activity cannot be used to refresh a Filtered Data Extension.

A Filter Activity relies on the criteria set from the Data Filter in Email Studio to populate the resulting Data Extension.

A Filtered Data Extension automatically updates when the source Data Extension is updated.

A Journey can only have one version active at a time.

A Journey that is built from a Journey Template cannot be modified.

A Journey with fifty contacts in it needs to be modified, so a new version is created. This new version is activated and is now the active version. Will the contacts that were already in the Journey be moved to the updated version or stay in the version they were in?

A Primary Key can also be used for the Send Relationship in a Data Extension.

A Single Send Journey can be scheduled.

A template is required for a Paste HTML email.

A Text Only email displays black text on a white background, with blue hyperlinks.

A URL can be personalised.

A wait activity in Automation Studio can be set with a Specific Time or a Duration.

According to best practice, how many email address attributes can you have in a sendable data extension?

Adding text on top of an image is a best practice?

All Data Extensions need a Primary Key

During the Implementation, Miho outlined that she would like an onboarding campaign setup that coaches customers on how to make a purchase through the new website. The goal of the onboarding program is to get 20% of the targeted customers to make a purchase.

You suggest building a Journey that uses both the Subscriber and Transaction data extensions, and that an Attribute Group will need to be built out.

How would you explain to Miho what an Attribute Group is?

Emails can be built in Journey Builder.

Emails can only be built out with a template.

Emails should not be built by using one big image.

Emails should only use Static Content or Dynamic Content.

Fiona at Inspyr is concerned about List Churn. She’s read that most email lists have a churn rate of about 30%. She would like to retain as many of her subscribers as she can to maximise the investment in Marketing Cloud. From a content perspective, what is the most important area to focus on?

Fiona has seen a spike in visits to the website and wants to know if the latest email has impacted on that. Which metric should she use in the Email Tracking?

Fiona is interested in how an email has performed. Specifically, she would like to know if the email has performed better on desktop or mobile devices. What report would she run in Analytics Builder to determine this?

Fiona is very concerned about list churn and wants to monitor individual emails for any spikes in churn. Which metric should Fiona be monitoring in Email Tracking?

Fiona needs to share the Account Send Summary report with her colleagues. As the Account Send Summary Report can’t be seen as a snapshot in Analytics Builder, what delivery methods can Fiona use to share this report? Choose Two (2).

Fiona would like a breakdown of the Inspyr subscribers by engagement. She’d like the following segments setup in Marketing Cloud:

• Highly Engaged: A subscriber that has opened or clicked in the last 30 Days
• Engaged: A subscriber that has opened or clicked in the last 31 – 90 Days
• Unengaged: A subscriber that has not opened or clicked in the last 30 Days
• Churned: A subscriber that has not opened or clicked in more than 120 Days

Which segmentation tools could be used? Choose all that apply.

Fiona would like to send an email that contains a customer’s transaction history over the past 30 days. The transaction data is held in the Transactions non-sendable data extension, while the subscribers data is held in the Subscribers sendable data extension. What method should Fiona use to include the transaction data in the email?

Fiona, the Chief Marketing Officer at Inspyr, is concerned about unsubscribes in Marketing Cloud. With their current provider, the subscriber opts out of a list, but, Fiona understands that with her Enterprise 2.0 Marketing Cloud account, the default setting opts the subscriber out of all sends. Inspyr has two email programs, Inspyr Events and Inspyr Publications. Fiona wants to make sure that if a subscriber opts out of Inspyr Events, they can still receive emails from Inspyr Publications. What is the fastest way to accomplish this?

For personalisation purposes, how would you change a record with the first name attribute “JASON” into “Jason”?

For a Path Optimiser in Journey Builder, the winning path needs to be selected based on Web Analytics data. This data is not available in Marketing Cloud. How can the winner be determined?

How big would an import file need to be before you have to use the FTP to manually import the data?

How does Journey Builder process a test when the Journey contains an Engagement Split?

How can Data Views be accessed?

How does Marketing Automation benefit an organisation? (Choose Three)

How does the send relationship in a Data Extension work with All Subscribers at send time?

In Automation Studio, an activity is:

In Automation Studio, an automation can run be run in excess of a one-year time period.

In Automation Studio, an automation cannot be run again until all steps in the automation have completed.

In Automation Studio, if a Verification Activity detects that there are more subscribers in a Data Extension than expected, what can happen? Choose three (3).

In Automation Studio, the workflow is:

In Automation Studio, the workflow is built with:

In Automation Studio, what does a Verification Activity do?

In Automation Studio, where a Step has multiple activities, each activity runs once the preceding activity has completed successfully.

In Data Designer, what is meant by “attribute group”?

In email design, it is ok to add interactive design like mouseover and hover effects.

In email design, what is meant by “keeping content above the fold”?

In email design, why are buttons preferred to text links?

In Journey Builder, Exit Criteria can be set to remove people out of the Journey.

In Journey Builder, how can you identify an activity in a Journey that errors during Validation?

In Journey Builder, how many versions of a Journey can be active (where the Journey status is Active), at one time?

In Journey Builder, If a Contact is included in the Entry Source, they will automatically be added to the Journey.

In Journey Builder, what does a Path Optimiser Activity do?

In Journey Builder, what is meant by a “Channel”?

In Journey Builder, when testing a Journey, wait periods are ignored.

In Journey Builder, why would you select the Exit option when setting up the Journey Goal?

Miho creates a filtered data extension in Email Studio by clicking the filter icon on the Subscribers data extension and defining the filter criteria. She wants to automate the data refresh through Automation Studio. She is looking to build the Filter Activity, but can’t see any Data Filters to select, even though the filtered data extension is setup.

What does Miho need to do to see a Data Filter that she can select to create a Filter Activity?

Miho has been importing subscriber data into her Subscribers data extension. The import has 875 records and 872 have imported successfully. She has three records that won’t import. Miho has checked the records are setup properly, and can’t figure out why they won’t import. She checks with Sebastian and sees that they are old records, around ten years old, and have never opened an email with the previous email service provider. What is the reason that Miho can’t import these three records.

Miho has been running email programs on Marketing Cloud for about six months. They are going quite well, with a steady delivery rate of 98%, opens at 25% and clicks at 15%. She would like to get her open rate increased and has a target of 30%. What would you recommend to Miho? (Select all that appply)

Miho has been sent an SQL query, written by Sebastian, via Slack. He has told her that this query joins the Subscriber and Transaction data extensions, creating an audience for her new campaign. How should Miho get the SQL into Marketing Cloud and run it on a regular basis?

Miho has built out a new email. She wants to test the email to make sure that there are no spam words or phrases included in the copy. What tool should she use to run this test in Marketing Cloud?

Miho has built out an email and would like to look at the Send Preview. She clicks into Send Preview, but the email does not display, and a red error message appears at the top of the screen. Why has this occurred?

Miho has created an email and has successfully run testing across it. She’s confident that everything is working well and would like to send a test out to the stakeholders involved in the email program.

However, there are twenty-one (21) different stakeholders involved and she can only send up to five individual test emails at a time. The stakeholders are also unfamiliar with Marketing Cloud, so may not understand that the personalisation is working on the individual test emails when a subscriber’s details are displayed and not their own.

How would Miho send a test out to all twenty-one (21) stakeholders, that is also personalised for that stakeholder?

Miho has created an email using Dynamic Content, Personalisation and AMPscript. She’d like to check that the business rules are working correctly for different subscribers. Sending a test email for each subscriber would take too long. How would she go about doing this?

Miho has developed a series of email templates that she wants to share with all users of Marketing Cloud, regardless of the Business Unit that they belong to. How would Miho go about sharing these assets?

Miho has developed some Mobile Aware email templates, but has noticed that people are not clicking on the call to action. She takes a look at the email on her mobile and has to scroll a long way down until she reaches the call to action. Where on the email should the call to action go to increase the number of clicks?

Miho has imported a list of attendees from the past ten years to target them for an upcoming event. She has around one-hundred and forty-thousand (140 000) records to target, but decides to test to around 10% of the audience.

The email is sent to thirteen-thousand eight-hundred and seventy-nine (13 879) contacts but only delivers to ten-thousand and fourteen contacts (10 014), with around a twenty-seven percent (27%) hard bounce rate.

Why would the bounce rate be so high?

Miho has just launched her first email through Marketing Cloud. Her manager, Fiona asked Miho if the email was engaging. What metrics in the email tracking could Miho use to determine if the email was engaging or not? (Choose Three)

Miho has over five-thousand (5000) assets inside Content Builder. She would like to locate all of the email templates. What’s the best way of going about this?

Miho has two customer segments, Members and Non-members. Miho has been asked to send out one email to the members and another email to the non-members. The emails are the same, with the exception of the call to action. Members are asked to start shopping while non-members are asked to join the rewards program. The link behind the call to action goes to different parts of the website. How should Miho proceed?

Miho is the Marketing Manager at Inspyr and needs to set up a Sendable Data Extension to hold her Subscriber Data for Email sends. What does Miho need to include when setting up the data extension to ensure that it is sendable? Choose three.

Miho is trying to update a Data Extension that contains transactions. The Data Extension was created during the implementation and is usually updated through an automation. When selecting the Import Type, Miho can only select the Overwrite option. Why would this be?

Miho is working with a design agency to develop a new brand. She wants to ensure that her emails are very easy to read and that the call to action can be quickly identified. What should she brief around using colours on email?

Miho needs to send a one-off email to anyone that has an interest in attending Events has lives in the Australian states of Queensland (QLD) or New South Wales (NSW). The Subscribers Data Extension contains a text attribute for State and a Boolean attribute for Events:

What segmentation tool would Miho use to create the Audience?

Miho needs to send an email to anyone that has made a purchase in the last thirty days. The Subscriber data extension holds the contact information, while the purchase data can be found in the Transactions data extension.

Which segmentation tool would need to be used?

Miho wants to know if her latest email has had a high open rate. Which metric should she use in the Email Tracking?

Select the most appropriate Automation Studio solution for the customer scenario.

A file containing transaction data is uploaded to the Marketing Cloud SFTP whenever it becomes available. This file is compressed as a ZIP file. The file needs to be uncompressed before it can be imported into the Transactions data extension.

Select the most appropriate Automation Studio solution for the customer scenario.

A file containing transaction data is uploaded to the Marketing Cloud SFTP whenever it becomes available. This file is compressed as an XML file. The data from the file needs to be extracted before it can be imported into the Transactions data extension.

Select the most appropriate Automation Studio solution for the customer scenario.

A file containing transaction data is uploaded to the Marketing Cloud SFTP whenever it becomes available. This file is encrypted using PGP encryption. The file needs to be decrypted before it can be imported into the Transactions data extension.

Select the most appropriate Automation Studio solution for the customer scenario.

Assuming that the Subscribers data extension is up to date, daily audience segments are to be run on the Subscribers data extension via SQL Query Activities. The results of the SQL Query Activities are placed into data extensions. These segments need to be extracted out of Marketing Cloud and put onto the Marketing Cloud SFTP.

Select the most appropriate Automation Studio solution for the customer scenario.

In this Automation, we want to run a daily extract all of the data from our Subscribers data extension, then import the subscriber data into All Subscribers so our subscriber always have the most up-to-date email address at send time.

Select the most appropriate Automation Studio solution for the customer scenario.

The subscriber data is extracted from the CRM every night and placed on the marketing cloud SFTP as “subscribers.csv”. At 4:00 AM each day, we would like to import the subscriber data into the Subscribers Data Extension, then verify that there are approximately 10,000 records in the data extension.

Select the most appropriate Automation Studio solution for the customer scenario.

This Automation needs to send an email out at 11:00 o’clock every morning. Before the email is sent, the subscriber data needs to be imported and the subscriber segments need to be created with SQL queries. The data processing should be run before the work day starts.

Select the most appropriate Automation Studio solution for the customer scenario.

Your customer has a one-off email that they need to send to approximately 3 million (3 000 000) people at 10AM. All the data is imported into Marketing Cloud and is up to date, but they will need to run segmentation before the email goes out. They’ve been told not to do this through Journey Builder and unsure how to proceed.

Sendable Data Extensions should only hold subscriber data?

Select the Numeric Operators that can be used in a Data Filter. (Choose three)

Select the Text Operators that can be used in a Data Filter. (Choose three)

Single Send Journeys must be sent to a Data Extension.

SQL Queries are used for complex segmentation needs. Which of these would you use an SQL Query for? (Choose two)

SQL Queries can only be run through Automation Studio.

SQL Query Activities use a drag and drop editor so you don’t need to know Structured Query Language (SQL)

The customer service team at Inspyr have informed the marketing team that lots of customers aren’t sure of what their member number is. It has been suggested that the member number be included in each email that goes out to a customer. The member number is used as the primary key and the subscriber key in all sendable data extensions. What’s the best way to include the member number in all emails?

The customer service team have mentioned to the marketing team that customers aren’t confident with purchasing online. The reason is they don’t get any confirmation emails once the purchase has been made, so they are unsure if the purchase has worked. What should the Marketing Team use to communicate the purchase to the customer immediately? (Choose Two)

The customer service team have received complaints about emails from Inspyr. The main issue is that the customers don’t recognise who the emails are coming from and have missed important updates. The From Name for the emails is “Melinda Walker”, the Marketing Executive. What should Miho update to make the From Name more recognisable?.

The email program at Inspyr has been running for about twelve (12) months. The marketing team would like to start determining baseline metrics for all of their email sends. For example, they would like to know what open rate and click rate they should expect for welcome emails, the number of bounces to expect for re engagement campaigns and which emails are generating the highest unsubscribes.

What type of report should Miho run in Analytics Builder to determine these baseline metrics for the Marketing team?

The Email Sender should be recognisable by the Subscriber.

What does a Wait Activity do in Automation Studio?

What does All Contacts do?

What does an Email Activity do in Journey Builder?

What does an Import Activity do?

What does an SQL Query Activity do?

What does Contact Builder do?

What does Data Retention do when creating a Data Extension?

What does ETL stand for?

What does Mobile Optimised mean?

What does Mobile Responsive mean?

What does the “Add & Update” Import Type do?

What does the “Add” Import Type do?

What does the “Overwrite” Import Type do?

What does the “Update” Import Type do?

What does the “Advanced Run Once Feature” allow you to do in Automation Studio?

What does the “anniversary of” operator do in a data filter?

What does the Contact Entry Setting “No Re-entry” mean?

What does the Contact Entry Setting “Re-entry Anytime” mean?

What does the Contact Entry Setting “Re-entry Only After Exiting” mean?

What does the Dynamic Content Block due?

What is an Email Template?

What is an Entry Source in Journey Builder?

What is Automation Studio?

What is Contact Data in Journey Builder?

What is Content Builder?

What is Journey Data in Journey Builder?

What is Static Content?

What is required to build a Filter Activity in Automation Studio?

What is the difference between a Contact and a Subscriber?

What is the file size limit of files in Content Builder?

What is the maximum number of characters recommended for a subject line?

What is the maximum number of characters recommended for the preheader?

What is the optimal height for a hero image in an email?

What is the optimal width for an email?

What is the Update Contact Activity used for in Journey Builder?

What options are available for creating an email? Choose four (4).

What part of an email can be personalised?

What scheduling options do you have when using a Data Extension as your Entry Source in Journey Builder? (Choose three)

What should you do prior to running a large import into a Data Extension?

What should you do to make sure your emails are accessible to as many subscribers as possible? (Choose five)

When creating Dynamic Content, why do you need Default Content?

When creating Dynamic Content, you need four (4) elements:

When does Journey Builder check that the Journey’s goal has been attained?

When importing data into a Data Extension, the file name can include special characters ( such as \ / * %).

When importing data manually, where can you import data from? (Choose two)

When importing data, and your import file contains a Header Row with columns that do not match your data extension attributes, which Mapping option should you choose?

When importing data, and your import file contains a Header Row with columns that match your data extension attributes, which Mapping option should you choose?

When importing data, and your import file does not contain a Header Row, which Mapping option should you choose? (Choose two)

When importing into a Data Extension, it is OK to leave columns in the source file that are not present in the target Data Extension.

When importing to a data extension, what is required to run an Add, Update or Add and Update import?

When looking for Content in Content Builder, it can be filtered by type or tag.

When sending an email through a Single Send Journey, the email address for the contact is taken from All Subscribers, not the Data Extension.

When testing a Journey in Builder, what does the Send Type option do?

When testing an Automation using the “Run Once” feature in Automation Studio, Email Send Activities are launched.

When testing an import, Sebastian realises that he has set the wrong attribute as the Primary Key for the Subscribers data extension. This data extension is part of an attribute group. There are around one-thousand (1 000) records in the data extension. Sebastian has tried to change the Primary Key attribute but the changes don’t seem to apply on the Data Extension. What does Sebastian need to do to resolve this issue?

When using a Scheduled Starting Source in Automation Studio, which two ways can you start the Automation?

When using a File Drop for the Starting Source in Automation Studio, what two (2) options do you have?

When using Journey Builder, what does Evaluate All Records do when selected for the Contact Evaluation in the Schedule Summary?

When using Journey Builder, what does Evaluate New Records Only do when selected for the Contact Evaluation in the Schedule Summary?

When using Search in Content Builder, it will only search your current Business Unit.

Which Marketing Automation Solution would you use?

Inspyr would like to set up a welcome email. They have an online portal set up with a sign up form, and would like the subscriber to be sent an email as soon as they opt in. (Choose Two)

Which Marketing Automation Solution would you use?

Miho has a simple birthday campaign that sends a birthday message out on the subscriber’s birthday. This is being sent through Automation Studio. She would like to expand this program to include a coupon, giving the subscriber 20% off any purchase. She would like to have 40% of the audience redeeming this coupon.

Which Marketing Automation Solution would you use?

Miho is running a new event. She would like to capture any new attendees via an online form and send them an email confirming their attendance. If they don’t confirm their attendance within seven (7) days, she would like to send a follow up email.

Which Marketing Automation Solution would you use?

Miho would like to set up a simple birthday email. For the solution, she would like to filter the Subscribers Data Extension for everyone that has a birthday that day and send them an email. However, she wants to ensure that all data processes have completed before the email is sent.

Which Marketing Automation Solution would you use?

Sebastian needs to run some Extract Transform and Load (ETL) activities. These will be ongoing and have to run at 4:00 AM every morning. Sebastian would like to import the Subscriber data, Transaction data and Product data. He would then like to run all of subscriber segmentation activities after the data imports have completed.

Which part of the email should prompt the subscriber to click through to the website or landing page?

Which Marketing Automation Solution would you use?

Sebastian would like to do ad hoc imports of his subscriber data when the data is ready.

Which solution would Miho use if she would like to automate the process of selecting the best content or products, based on customer behaviour, for email messages?

Why should a font colour contrast against the background colour?

Why is a good Content Hierarchy important?

Why should ALT Text be applied to all images?

Why should Dynamic Content be used?

Why should you set a goal for a Journey?

Why should you use segmentation?

Why would you use a non-sendable data extension?

With the implementation completed, Miho is launching the first email sent through Marketing Cloud for Inspyr. She is launching a Single Send Journey to a segment of a Data Extension. The Segment produces two-hundred and forty-three (243) contacts, but when the email is sent, it is only delivered to one-hundred and ninety-three (193).

What could cause the difference in numbers?

You can import into a Filtered Data Extension

You can save an email as a template.

You can use System Data Personalisation Strings to populate the date that the email was sent.

You have run an import that contains two records with the email address miho@arachne.com.au. Each record has a different Primary Key, 6548876 and 4587512. How will Marketing Cloud process the Contact?

An Automation can have multiple steps.

An email can be built out using an email that has already been sent.

An email has been sent through Send Flow with an incorrect link. The email has only been out for about five minutes and a resend will take around an hour to complete. Miho remembers that she can change links on live emails. Where can she make this change in Marketing Cloud?

Before building a Filter Activity in Automation Studio, you must have a Data Extension built out to hold the results of the filter.

Before importing into a Data Extension, the data should be de-duped?

Before a Single Send Journey can be sent, what must you do?

Can you add multiple blocks to a Content Area?

Content Blocks cannot be locked to avoid editing.

Content Builder can be integrated with Dropbox.

Content Builder folders can be local to a Business Unit or shared with other Business Units.

Content Builder has a campaign based folder structure that can’t be modified.

Customer service have received complaints that customers are not receiving statements or invoices by email. Miho is investigating and found that these customers have unsubscribed from previous marketing emails. What does Miho need to do to ensure that people that are unsubscribed can still receive statements and invoices.

Data between Salesforce Service Cloud and Marketing Cloud can be synchronised using the Marketing Cloud Connect package.

Data Designer is used to create data relationships.

Data Extensions can only be used to hold subscriber data?

Data Extensions used as Entry Sources should be part of an Attribute Group, linked to the Contact.

Data Filters are built out in:

Data Filters require: (Choose three)

During the implementation phase, Ravi, one of the Marketing Executives at Inspyr, filtered the Subscribers Data Extension by going to Email Studio, clicking the Filter icon next to the data extension and adding the Filter criteria. This has produced a new, Filtered Data Extension containing the results.

It has been a few months and Ravi has not used Marketing Cloud since the implementation was completed. He wants to use the Filtered audience he created, but notices that the data in it is old and has not updated like the Subscribers data extension has.

What is the reason that the filtered data extension has not updated?

During the implementation, Fiona is asked to develop a series of tags for Content Builder. She’s unsure of what a tag is. How would you explain what a tag is used for in Content Builder?

In the context of Data Extensions, what is an attribute?

Inspyr are implementing Marketing Cloud. They have a large number of image assets that they would like imported into Content Builder. These image assets are for different campaigns, such as the welcome campaign, the re-engagement campaign and an abandoned cart campaign. What should they do to organise these assets to make them easy to find for all users of the business unit. (Choose three)

Inspyr has seen a downward trend their delivery rate. From 98% six months ago, down to 84% this month. They feel they are doing everything right, using an opt-in list, easy to find unsubscribe, only sending to engaged subscribers and clearing out bounced addresses. You’ve been asked your advice on reversing the downward trend and look at the email reporting. You notice that all of the emails are steadily decreasing their open and click rates over the same six month period that the delivery rate is declining. You also notice that the emails are all static emails. What would you change on the emails in an attempt increase these metrics? Choose Three (3).

Inspyr have a new event coming up that they would like to promote. They need new creative and would like a new email template, too. Karsten, the lead producer at Inspyr’s design agency, has created a design in a single image and suggested that they just send that to ensure design consistency across all email clients. Miho has suggested that they use a template based email, limiting the number of images and using text and buttons. What are the advantages of Miho’s method? (Choose three)

Inspyr have a new event coming up. It is anticipated that the event will be very popular and there will be a lot of demand placed on the contact centre. Miho has been instructed to send out an email about the event that is going to 150,000 people. The contact centre manager is concerned that they will be overwhelmed if the response is as high as marketing anticipates. What should Miho do to ensure that the contact centre has a manageable volume of calls throughout the day instead of a large volume all at once?

Inspyr have set up their Marketing Cloud account with a Sender Authentication Package (SAP). The domain that they used for the sender authentication package is mail.inspyr.info. They have a new event coming up for retailers that will focus on Christmas called “Ho Ho Ho” and Fiona would like to use a new from address for outgoing emails for the campaign. Which from address could Fiona use?

Inspyr is launching a new Business Unit, Inspyr Travel, and would like to start collecting email addresses. It is important that the collection method asks permission and is SPAM compliant. What methods are OK to use for subscriber acquisition? (Choose three)