What are data extension data retention policies?

• A.Settings to prevent users from deleting a Data Extension created by another user.
• B.Settings to define when a data extension or the data within the data extension is deleted.
• C.Settings to control when a data extension creates a back-up of the data it contains.
• D.Settings to "soft" delete all data in a Data Extension so there is no data loss.

Comment: *

Name: *

Email: *

Verification: *

A consulting has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed.
Which import type should be used?

• A.Add Only
• B.Update Only
• C.Add/Update
• D.Overwrite

Comment: *

Name: *

Email: *

Verification: *

When joining a data extension in Contact Builder, in which scenario should a consultant mark the Use as Root checkbox?

• A.Database of record other than All Subscribers.
• B.One-to- Many Relationship to the Contact Record.
• C.Data for both Email and MobileConnect sends.
• D.Supplemental data for an interaction in Journey Builder.

Comment: *

Name: *

Email: *

Verification: *

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 CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
• C.SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
• D.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

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 minimize the impact of Marketing Cloud Connect on daily API limits? Choose Two

• A.Turn off Individual Level Tracking
• B.Filter data
• C.Upgrade the MC account to ConnectedApp
• D.Turn off link details tracking

Comment: *

Name: *

Email: *

Verification: *