A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?

• A.SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
• B.SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID
• C.SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
• D.SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.
How should this distributor-specific sender profile be configured in the Marketing Cloud?
Choose 2 answers

• A.Match the external keys of the sender profile and data extension containing account representative details.
• B.Pick "Choose from list," selecting the from name and from email values from the list of account users.
• C.Populate substitution strings in the sender profile for the profile attributes containing from name and from email values.
• D.Utilize data extension AMPScript lookups to dynamically populate the from name and from email values.

Comment: *

Name: *

Email: *

Verification: *

An entertainment customer has added a new business unit for one of its record labels. It has also purchased a Sender Authentication Package (SAP) and owns the branded domain.
What is necessary to complete SAP setup?

• A.Configure custom Reply Mail Management for the business unit's subdomain.
• B.Configure link wrapping to redirect to the business unit's subdomain.
• C.Delegate a specific subdomain to the Marketing Cloud name servers.
• D.Route the domain through an IP address unique to the business unit.

Comment: *

Name: *

Email: *

Verification: *

A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits.
What should the consultant suggest to minimise the impact of Marketing Cloud Connect on daily API limits?
Choose 2

• A.Filter target audiences based on mapped profile attributes to reduce Bulk API calls
• B.Share Sales Cloud user licenses across Marketing Cloud users
• C.Upgrade the Marketing Cloud Account to ConnectedApp Authentification
• D.Use Data Stream to sync object data into a Data Extension in the Marketing Cloud

Comment: *

Name: *

Email: *

Verification: *

An online retail customer needs daily promotional email content to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose.
The customer has communicated the following:
* The email content will highlight new inventory each day.
* A small team will run both their digital marketing operations and their email program.
* A user needs to build, test, and send a daily email in less than an hour.
* Images for the emails will be hosted on their website CMS.
Which three questions are relevant to identify strategies for designing the custom template for the customer's daily promotional email? (Choose three.)

• A.How often will email content be image-only with text overlaying images?
• B.How often will the layout of the content in a content area change?
• C.Will image URLs be available publicly?
• D.What From Name will be used for these emails?
• E.What is the maximum file size of the images being used?

Comment: *

Name: *

Email: *

Verification: *