Free Marketing-Cloud-Developer: Salesforce Certified Marketing Cloud Developer (SP20) Exam Questions and Answers
175 verified practice questions for Marketing-Cloud-Developer.
The first 10 questions on this page are free to read, answers included — no account and no card. A plan opens the rest of the bank, the full timed practice test and your weak-topic reporting.
Last updated: September 19, 2026
- Provider
- Salesforce
- Questions in our bank
- 1000+
- Free to read
- First 10, with answers
- Our test mode duration & pass mark
- 130 mins · 70%
- Verified answers
- Reviewed weekly
- Practice format
- Multiple choice
Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.
Question #1
A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension. Which SELECT statement is optimal for returning all of the columns in the data extension?
Please select an optionIncorrectCorrect answer: C
SELECT * returns all columns of the data extension without listing them, so the new third field is included automatically. The other statements use invalid syntax or name columns that would omit fields.
Was this answer correct?Question #2
A field value returned from a DE lookup contains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?
Please select an optionIncorrectCorrect answer: B
BuildRowSetFromString splits the tab-delimited value into rows, which can then be looped to find the target string anywhere in the list. IndexOf, Substring and Length operate on plain strings, not delimited lists.
Was this answer correct?Question #3
Which SSJS library can be used in landing pages? Choose 1.
Please select an optionIncorrectCorrect answer: C
CloudPages landing pages support both the Core and Platform SSJS libraries, so either can be used. The answer is therefore "Both", not a single library.
Was this answer correct?Question #4
Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website. Which API should be used for this? Choose 2.
Select 2 answers.
Please select an optionIncorrectCorrect answer: C, D
A purchase event can trigger a send through the SOAP API's triggered send or through the REST transactional messaging endpoint. There is no standalone Subscriber or Email API for triggering sends.
Was this answer correct?Question #5
A developer is configuring a new Marketing Cloud account and has decided to use a unique 10-digit integer as each customer's Contact Key. Which data type should be used when representing the value of Contact Key?
Please select an optionIncorrectCorrect answer: C
The Contact Key is always stored as Text regardless of its content, so numeric identifiers keep leading digits and stay consistent across channels. Number and Decimal types would strip or reformat the value.
Was this answer correct?Question #6
A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?
Please select an optionIncorrectCorrect answer: A
RowCount on the lookup result tells the developer whether a row was found, and an IF statement then renders the unique or the default content. The other functions retrieve the row but do not by themselves branch to default content.
Was this answer correct?Question #7
A developer wants to add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?
Please select an optionIncorrectCorrect answer: D
Creating a Content Builder asset is a POST to /asset/v1/content/assets, and the returned FileProperties parameter contains the published URL of the image. GET requests and category endpoints do not create assets.
Was this answer correct?Question #8
A new 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?
Please select an optionIncorrectCorrect answer: D
GROUP BY SubscriberKey collapses the rows per subscriber and HAVING COUNT(*) > 1 keeps only those with multiple orders. DISTINCT and TOP 1 cannot express a minimum number of purchases.
Was this answer correct?Question #9
A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site. Which action should be configured?
Please select an optionIncorrectCorrect answer: A
A File Drop automation starts when a file matching the naming pattern lands on the FTP site, so the import runs as soon as the file arrives with a unique name each night. A scheduled automation would run at a fixed time regardless of arrival.
Was this answer correct?Question #10
A developer wants to programmatically inject Contacts into a journey via REST API. What is the recommended route using POST data extension fields and values?
Please select an optionIncorrectCorrect answer: B
Contacts are injected into a journey by posting event data to the /interaction/v1/events REST endpoint, which maps data extension fields to the event definition. The other routes create or read journey definitions rather than injecting contacts.
Was this answer correct?
Continue with Marketing-Cloud-Developer: Salesforce Certified Marketing Cloud Developer (SP20)
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in Marketing-Cloud-Developer: Salesforce Certified Marketing Cloud Developer (SP20), the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Other Salesforce certifications
- ADM-201: Administration Essentials for New Admins (opens in a new tab)
- Certified Sales Cloud Consultant (opens in a new tab)
- Certified Platform Developer II (opens in a new tab)
- ADM-211: Administration Essentials for Experienced Admin (opens in a new tab)
- Certified Platform App Builder (opens in a new tab)
- CRT-450: Salesforce Certified Platform Developer I (opens in a new tab)
Reviews
★★★★★
This platform is a lifesaver. The practice questions and explanations are so detailed. It’s the best study tool I’ve ever used.
Hannah Smith
USA
★★★★★
I highly recommend Exam Practice. The feedback after each test helped me improve significantly, and I passed my exams easily.
Oscar Nyström
Sweden
★★★★★
Exam Practice is worth every penny. The mock exams are realistic, and the feedback helped me focus on key areas.
Amit Sharma
India
FAQ
Learn More: https://trailhead.salesforce.com/en/credentials/administratoroverview/
- Q1: What are Salesforce Certification Exams?
- A: Salesforce Certification Exams validate your expertise in using and managing Salesforce’s customer relationship management (CRM) platform. These certifications demonstrate your proficiency in deploying, configuring, and optimizing Salesforce applications to drive business growth and customer engagement.
- Q2: Why should I pursue Salesforce Certification?
- A: Salesforce Certification enhances your professional credibility, showcasing your skills and knowledge in Salesforce solutions. This can lead to better job opportunities, higher salaries, and career advancement in CRM, cloud computing, and IT management roles.
- Q3: What are the benefits of Salesforce Certification?
- A: Benefits include recognition as a certified Salesforce professional, improved job performance, access to exclusive resources, continuing education opportunities, and staying current with the latest Salesforce technologies and best practices.
- Q4: Who should take Salesforce Certification Exams?
- A: CRM administrators, developers, consultants, sales and marketing professionals, and anyone involved in managing and implementing Salesforce solutions should consider these certifications to validate their expertise and advance their careers.
- Q5: What types of Salesforce Certification Exams are available?
- A: Salesforce offers various certification paths, including:
- Q6: How do I prepare for Salesforce Certification Exams?
- A: Preparation can include official Salesforce training courses, study guides, practice exams, online tutorials, and hands-on experience with Salesforce products and solutions.
- Q7: Where can I take Salesforce Certification Exams?
- A: Salesforce Certification Exams can be taken online with remote proctoring or at authorized testing centers worldwide, providing flexibility to fit your schedule and location.
- Q8: How do Salesforce Certifications impact my career?
- A: Salesforce Certifications significantly boost your career by demonstrating your expertise to employers, making you a more competitive candidate for advanced roles and promotions in CRM, cloud computing, and IT management.
- Q9: Are there any prerequisites for Salesforce Certification Exams?
- A: Some exams may have prerequisites, such as foundational knowledge or prior experience with Salesforce products. Check the specific requirements for each certification path on the Salesforce certification website.
- Q10: How often do I need to recertify for Salesforce Certifications?
- A: Salesforce Certifications typically require recertification annually to ensure that certified professionals stay updated with the latest Salesforce technologies and industry practices.