A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the dataextension. Which SELECT statement is optimal for returning all of the columns in the data extension?
A. SELECT field*
B. SELECT *, field1, field2, field3
C. SELECT*
D. SELECT 22SE, field2, field3
A developer is using the legacy endpoint www.exacttargetapis.com and hasbeen asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?
A. A longer lasting OAuth token
B. API calls will no longer fail
C. Gain access to TSE-specific REST routes
D. Improved API performance
A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code. Which syntax should the developer use?
A. < !- This is a comment
B. // Thisis a comment
C. -- This is a comment
D. /" This is a comment */
A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call. How long are Marketing Cloud v1 access tokens valid?
A. Access tokens expire after 24 hours.
B. REST calls do not require an access token.
C. Each API call requires a new access token.
D. Access tokens expire after one hour.
NTO puts the word TEST at the beginning of the name for each testemai. Which query would return the subs who were sent those emails?
A. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
B. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE'TEST%'
C. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHEREJ.EmailName LIKE 'TEST%'
D. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHEREJ.EmailName = 'TEST%'
A developer is using the REST Authorization Service to obtain an OAuth access token. Which method should be used to include the access token in the API requests
A. Include the header x-access-token: your_access_token
B. Include as a query parameter access_token=Y0UR_ACCESS_TOKEN
C. Include the header Authorization: Basic your_access_token
D. Include the header Authorization: Bearer YOUR ACCESS TOKEN
Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.
A. DataExtensionObject object
B. Subscriber object
C. Attribute object
D. DataExtension object
Contact Builder can be used to create a relational model of an organization's data within
Marketing Cloud. Which three factors should be taken into consideration when preparing data to be used in Contact Builder? Choose 3 answer
A. Assigningdata relationships and primary keys across all channels
B. Verifying data address marketing needs
C. Verifying all data extensions have a sendable value
D. Verifying each data extension has the required Email Address field populated
E. Normalizing data toreduce redundancy
A doctor's office creates Populations for staff, patients and vendors. What is the maximum number of Populations that should be created to ensure performance?
A. Five
B. Three
C. Unlimited
D. One
Anew record is appended to the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?
A. SELECT TOP 1 SubscriberKey FROM Orders
B. SELECT DISTINCT SubscriberKey FROM Orders
C. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
D. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVINGCOUNT(*)>1