Given a scenario, describe API objects, methods, and routes
Describe the OAuth authentication flow and how an access token is used in SOAP and REST headers
Given a scenario, evaluate the significance of response handling
SOAP Vs REST
SOAP
REST
Email Sending
✔
✔
Templates and Content Areas
✔
✔
Data Extensions
✔
✔
Folders
✔
✔
Administration (Users, BUs)
✔
✘
Automation Studio
✔
✘
Email Tracking Data
✔
✘
Subscribers and Lists
✔
✘
SOAP
REST
MobileConnnect (SMS)
✘
✔
MobilePush
✘
✔
Salesforce Sends
✘
✔
Contact Model
✘
✔
Journey Builder
✘
✔
OAuth Tokens
✔
✔
Content Builder
✘
✔
Marketing Cloud REST API routes
REST API
Route
Content Builder
/asset/v1/content
Event Notification Service
/platform/v1
Journey Builder
/interactions/v1
Transactional Messaging
/messaging/v1/email /messaging/v1/sms
Triggered Send
/messaging/v1/messageDefinitionSends
REST API
JSON
Maximum Payload Size is 4MB
Request time out – 120 seconds and 300 seconds for tracking requests
SOAP API
XML
Supports Username and password authentication
Request time out – 3 second for single email send, 30 second for tracking data
Most API objects return results in batches of 2,500
SOAP API – 20 or fewer synchronous API threads per request with references to up to 50 objects per synchronous call or 100 objects per asynchronous call
You can retrieve tracking information on the send using JobID
You can retrieve the status of API call using RequestId property on ResultItem object
Marketing Cloud SOAP API common key methods
Retrieve – Get information on a single object type
Configure – Configure a Marketing Cloud account
Perform – Perform an asynchronous action
Extract – Extract a file to the Marketing Cloud FTP site
DataExtension – Represents a Data Extension (name, attributes, retention policies, etc) where as DataExtensionObject – Represents a row within a Data Extension
Installed package Integration Type
Server-to-Server with Client Credentials Grant Type
Web and Public App Integrations with Authorization Code Grant Type
A web app can securely store a client secret, but a public app cannot
OAuth token is only valid for 18 minutes (actual expiry is 20 minutes but needs to refreshed before 18 minutes)
LogUnsubEvent call allows you to unsubscribe a subscriber and log an UnsubEvent that is tracked against a specific Job
The Subscriber Context is defined by the SubscriberID, SubscriberKey and EmailAddress parameters
The Job Context is defined by the JobID, ListID and BatchID parameters
Unsub Reason is used to specify the reason the subscriber is being unsubscribed from the system
REST Error Codes
Error Code
Cause
401
Unauthorised – token expired
429
API throttling
SOAP Error Codes
Error Code
Cause
Error Code 2
Authentication
Error Code 5
Cannot perform {method} on objects of type {object}
Error Code 8
This operation does not support the APIObject of type [type]
Error Code 11
SOAP Web Service API feature is not enabled
5.4 Data Management: 22% (13 Questions)
Configure import activity using various file formats within Marketing Cloud
Types of Data Extract
Convert XML
Data Extension
ZIP Data
Tracking Data
Given a scenario, apply SQL to produce the desired results
Given a scenario, explain the different ways to extract data from Marketing Cloud
Describe SQL best practices for managing data in Marketing Cloud
Given a scenario, apply best practices for send logs
Send Logging can be enabled at Parent or Child Business Unit
It’s best practice to add 10 or fewer custom fields to the Send Log
Content Builder test sends are not recorded on Send Log Data Extensions
To record the new send log, ensure that you pause, republish, and restart triggered sends and Journey Builder triggered sends
SQL commands are not case sensitive: select is the same as SELECT
SQL Queries time-out after 30 minutes
SQL Query Activity is based on Microsoft SQL Server 2016
Avoid Data Extensions where the sum of the length of all attributes is greater than 4000 characters
SQL Join Statement
-- Inner Join
SELECT customerID as ‘customerID’, amount as ‘Total_Amount’
FROM CustomerDataExtension c
INNER JOIN BillingDataExtension b
ON c.customerID = b.customerID
WHERE b.amount is not NULL
-- Some other joins important for exam LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN
Sample SQL Queries
-- Query Complaint Data view
SELECT SubscriberKey, JobID, SMTPBounceReason
FROM _Complaint
-- Get Parent Account data by adding ent prefix to the Data Extension name
SELECT Name
FROM ent.DataExtension
-- Get All the fields by using *
SELECT *
FROM DataExtension
-- Select random 10 percent records
SELECT TOP 10 PERCENT Id, Name FROM customerNames
ORDER BY NEWID()
Queries that include both a join and a Select * statement are not permitted
Data at Rest Encryption (Transparent Data Encryption) – encrypts data at rest using SQL Server’s built-in data protection technology
Tokenized Sending – take information from your own data systems and transmit it to the Marketing Cloud only at send time via an API call. Instead of storing sensitive information in your Marketing Cloud account database, your account stores a single token per send attribute. This token resembles a standard email address or phone number but does not include any information about the contact
Data at Rest Encryption is not available for
Predictive Intelligence
Audience Builder
Social Studio
Marketing Cloud Shield combines security products to provide trusted encryption solutions with advanced Audit Trail functionality
Marketing Cloud supports PGP or GPG decryption and encryption
