ExamGecko
Search Search Login
Home Home / Salesforce / Certified Marketing Cloud Developer
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5
NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given these requirements? Choose 3
A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber. In which way could the developer create the CTA link?
A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including: Which subject line will be used at the time of deployment?
A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?
A developer wants to create a data model in Contact Builder. Which two applications will be able to use this newly-created data model for segmentation? Choose 2 answers
A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?
A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV. Which SQL functions could be used to change each line break to a single space?
NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?
A developer is troubleshooting why an API client Jd and chent_secret are authenticating yet failing to access data from a child business unit. What should be checked to validate the installed package can access the child business unit data?

Question 64 - Certified Marketing Cloud Developer discussion

Report
Export

A developer wants to build an audience by identifying subscribers who opened a specific email.

Which query should the developer use?

A.
SELECT * FROM _Open WHERE ListID = '1234'
Answers
A.
SELECT * FROM _Open WHERE ListID = '1234'
B.
SELECT * FROM _Open WHERE JobID = "1234"
Answers
B.
SELECT * FROM _Open WHERE JobID = "1234"
C.
SELECT SubscriberID FROM _Open WHERE JobID = "1234"
Answers
C.
SELECT SubscriberID FROM _Open WHERE JobID = "1234"
D.
SELECT SubscriberKey FROM _Open WHERE JobID = '1234'
Answers
D.
SELECT SubscriberKey FROM _Open WHERE JobID = '1234'
Suggested answer: D
Show Answer
asked 23/09/2024
FELIPE DE JESUS RODRIGUEZ ANGULO
34 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms