What is a correct statement about a database of record? Choose 2 answers

• A.A database of record is any database containing subscriber data.
• B.A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber.
• C.A database of record is a system in which a subscriber's status is maintained
• D.A database of record is a centralized storage repository of data about objects or people.

Comment: *

Name: *

Email: *

Verification: *

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

• A.SELECT * FROM Subscribers WHERE CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate JOIN Orders On CustomerID=CustomerID
• B.SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers OUTER JOIN Orders ON Subscribers.CustomerID=Orders.CustomerID
• C.SELECT CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate FROM Subscribers INNER JOIN Orders ON CustomerID=CustomerID
• D.SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN Orders T2 ON T1.CustomerID=T2.CustomerID

Comment: *

Name: *

Email: *

Verification: *

A customer wants to set up a real-time, API-driven way to be alerted when transactional messages fail to send out of Marketing Cloud. They are currently in the process of hiring a full-time developer but want an implementation in place for the developer to maintain.
What should the customer have in place to ensure this solution can be implemented?

• A.An external system to receive and confirm callback and subscriptions
• B.A Datorama instance to ingest their data
• C.An Interaction Studio instance to ingest their data
• D.A Transactional Journey with the Not Sent Notification activity included

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed.
What should the consultant do to diagnose the issue?

• A.Manually clear the OAuth token to refresh the connection.
• B.Ensure the System User is assigned the Standard User Profile.
• C.Change the connection option to Scope by User.
• D.Initiate a log to troubleshoot package-related API calls.

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters wants to encourage customers who made a purchase on their website without leaving a review to come back and review their purchase. They want to use Journey Builder to automatically inject contacts who meet these criteria into a Journey.
What product should be recommended?

• A.Audience Studio
• B.Web Analytics Connector
• C.Data Studio
• D.Google Analytics 360

Comment: *

Name: *

Email: *

Verification: *