# SFMC — Complete Study Reference > Salesforce Marketing Cloud: the full consolidated corpus — every chapter from all five courses plus the complete question banks, in one file. **Contents at a glance** | | | |---|---| | Chapters | 101 | | Words (chapters) | 550,330 | | Master Question Bank | 644 questions | | Certification practice | 286 questions | | Flashcards | 82 cards | Generated by `tools/build_sfmc_md.py` from the sources in `SFMC Study Guide/`. Re-run it after editing any source file. The same sources power the readers at [aiakp.com/sfmc](https://aiakp.com/sfmc). --- ## Table of Contents - **[Part I — SFMC Interview Prep](#part-i-sfmc-interview-prep)** - [🎯 SFMC Interview Prep — Master Roadmap (Zero → Hero)](#sfmc-interview-prep-master-roadmap-zero-hero) - [Module 01 — SFMC Architecture & Data Model](#module-01-sfmc-architecture-data-model) - [Module 02 — Email Studio & Content Builder](#module-02-email-studio-content-builder) - [Module 03 — Email Development (HTML / CSS)](#module-03-email-development-html-css) - [Module 04 — AMPscript Deep Dive](#module-04-ampscript-deep-dive) - [Module 05 — SSJS (Server-Side JavaScript) & WSProxy](#module-05-ssjs-server-side-javascript-wsproxy) - [Module 06 — SQL in SFMC](#module-06-sql-in-sfmc) - [Module 07 — Automation Studio](#module-07-automation-studio) - [Module 08 — Journey Builder](#module-08-journey-builder) - [Module 09 — CloudPages, APIs & Integrations](#module-09-cloudpages-apis-integrations) - [Module 10 — Deliverability & Compliance](#module-10-deliverability-compliance) - [Module 11 — Personalization, Einstein & MovableInk](#module-11-personalization-einstein-movableink) - [Module 12 — Admin, Security, Reporting & Best Practices](#module-12-admin-security-reporting-best-practices) - [Module 13 — Code Lab (Hands-On Exercises)](#module-13-code-lab-hands-on-exercises) - [Module 14 — Interview Q&A Bank (Basic → Advanced)](#module-14-interview-qa-bank-basic-advanced) - [Module 15 — Behavioral & Resume STAR Stories](#module-15-behavioral-resume-star-stories) - [Module 16 — Mobile Studio & Cross-Channel](#module-16-mobile-studio-cross-channel) - [Module 17 — Data Cloud, Intelligence & Modern SFMC](#module-17-data-cloud-intelligence-modern-sfmc) - [Module 18 — Platform Limits & Hard Numbers](#module-18-platform-limits-hard-numbers) - [Module 19 — AMPscript & SSJS Function Reference (Appendix)](#module-19-ampscript-ssjs-function-reference-appendix) - [Module 20 — One-Page Rapid-Revision Cheat Sheet](#module-20-one-page-rapid-revision-cheat-sheet) - [Module 21 — SFMC A–Z Glossary](#module-21-sfmc-az-glossary) - [Module 22 — Full Mock Interview Scripts](#module-22-full-mock-interview-scripts) - [Module 23 — Certifications & Continued Learning](#module-23-certifications-continued-learning) - **[Part II — SFMC Practical Playbook](#part-ii-sfmc-practical-playbook)** - [P00 — Start Here: The Practical UI Playbook](#p00-start-here-the-practical-ui-playbook) - [P01 — SFMC Navigation & App Map](#p01-sfmc-navigation-app-map) - [P02 — Create & Load a Data Extension](#p02-create-load-a-data-extension) - [P03 — Writing SQL: the Query Activity](#p03-writing-sql-the-query-activity) - [P04 — Build & Send an Email](#p04-build-send-an-email) - [P05 — Preview, Test & Validate](#p05-preview-test-validate) - [P06 — Journey Builder (build a journey)](#p06-journey-builder-build-a-journey) - [P07 — Automation Studio (build an automation)](#p07-automation-studio-build-an-automation) - [P08 — Contact Deletion (GDPR erasure)](#p08-contact-deletion-gdpr-erasure) - [P09 — Reports & Broader Engagement](#p09-reports-broader-engagement) - [P10 — CloudPage Form → DE → Email](#p10-cloudpage-form-de-email) - [P11 — Deliverability & IP Warming](#p11-deliverability-ip-warming) - [P12 — Troubleshooting & Day-to-Day Ops (the questions you got)](#p12-troubleshooting-day-to-day-ops-the-questions-you-got) - [P13 — Write-It-Live Drills](#p13-write-it-live-drills) - [P14 — Deloitte Round: CRM writes, Suppression, Lists & i18n](#p14-deloitte-round-crm-writes-suppression-lists-i18n) - **[Part III — Coforge Crash Course](#part-iii-coforge-crash-course)** - [C00 — Start Here & How to Win This Interview](#c00-start-here-how-to-win-this-interview) - [C01 — The Big Picture (mental maps you can draw blind)](#c01-the-big-picture-mental-maps-you-can-draw-blind) - [C02 — Data Extensions & the Data Model](#c02-data-extensions-the-data-model) - [C03 — SQL & Automation Studio](#c03-sql-automation-studio) - [C04 — AMPscript & Dynamic Content](#c04-ampscript-dynamic-content) - [C05 — Email Studio & Content Builder](#c05-email-studio-content-builder) - [C06 — Journey Builder](#c06-journey-builder) - [C07 — Campaign Validation, Testing, Preview & Deployment (PRACTICAL CORE)](#c07-campaign-validation-testing-preview-deployment-practical-core) - [C08 — Distributed Marketing & Advisor Communications (NEW — JD-critical)](#c08-distributed-marketing-advisor-communications-new-jd-critical) - [C09 — SFMC APIs & Integrations](#c09-sfmc-apis-integrations) - [C10 — Support Model: INC, RCA, SLA & Troubleshooting (NEW — JD-critical)](#c10-support-model-inc-rca-sla-troubleshooting-new-jd-critical) - [C11 — Deliverability & Compliance](#c11-deliverability-compliance) - [C12 — Financial-Services Domain & Technical-Lead Behaviors](#c12-financial-services-domain-technical-lead-behaviors) - [C13 — Memory Vault (everything to recall, in one place)](#c13-memory-vault-everything-to-recall-in-one-place) - [C14 — Practical Drills & Mock (the LTM-gap fix)](#c14-practical-drills-mock-the-ltm-gap-fix) - **[Part IV — TCS Fast Track](#part-iv-tcs-fast-track)** - [T00 — Tonight's Plan (TCS interview tomorrow)](#t00-tonights-plan-tcs-interview-tomorrow) - [T01 — The Asked-Questions Bank (researched from real interviews)](#t01-the-asked-questions-bank-researched-from-real-interviews) - [T02 — CloudPages Mastery (theory + every asked question)](#t02-cloudpages-mastery-theory-every-asked-question) - [T03 — SPF, DKIM, DMARC & SAP Setup (theory + every asked question)](#t03-spf-dkim-dmarc-sap-setup-theory-every-asked-question) - [T04 — Last-Hours Revision (read this in the morning)](#t04-last-hours-revision-read-this-in-the-morning) - **[Part V — Marketing Cloud Next](#part-v-marketing-cloud-next)** - [N00 — Start Here: Marketing Cloud Next, Zero → Hero](#n00-start-here-marketing-cloud-next-zero-hero) - [N01 — The Marketing Cloud Next Landscape](#n01-the-marketing-cloud-next-landscape) - [N02 — Core Salesforce Platform Foundations (for the MC-Next marketer)](#n02-core-salesforce-platform-foundations-for-the-mc-next-marketer) - [N02 — Data Cloud Foundations](#n02-data-cloud-foundations) - [N03 — Segmentation & Audiences](#n03-segmentation-audiences) - [N04 — Content & Email in Marketing Cloud Next](#n04-content-email-in-marketing-cloud-next) - [N05 — Flows & Journeys](#n05-flows-journeys) - [N07 — Channels: Email, SMS & WhatsApp in MC Next](#n07-channels-email-sms-whatsapp-in-mc-next) - [N08 — Campaigns End-to-End (brief → audience → content → flow → send → results)](#n08-campaigns-end-to-end-brief-audience-content-flow-send-results) - [N06 — Einstein & Agentforce for Marketing](#n06-einstein-agentforce-for-marketing) - [N10 — Analytics, Reporting & Attribution in MC Next](#n10-analytics-reporting-attribution-in-mc-next) - [N11 — Admin & Setup: provisioning, permissions, environments](#n11-admin-setup-provisioning-permissions-environments) - [N07 — Skills Bridge: Classic → MC Next](#n07-skills-bridge-classic-mc-next) - [N13 — Hands-On Lab Path (free orgs, Trailhead, exercises zero→hero)](#n13-hands-on-lab-path-free-orgs-trailhead-exercises-zerohero) - [N08 — Certifications & the 3-Month Plan](#n08-certifications-the-3-month-plan) - [N09 — Interview Q&A for Marketing Cloud Next](#n09-interview-qa-for-marketing-cloud-next) - [N16 — Glossary & One-Page Cheat Sheet](#n16-glossary-one-page-cheat-sheet) - **[Part VI — Accenture Round 1](#part-vi-accenture-round-1)** - [A00 — Start Here: Passing Accenture Round 1](#a00-start-here-passing-accenture-round-1) - [A01 — The Two Questions You Failed (solved cold)](#a01-the-two-questions-you-failed-solved-cold) - [A02 — HTML for Email (tables, Outlook, and the SFMC layer)](#a02-html-for-email-tables-outlook-and-the-sfmc-layer) - [A03 — CSS for Email (inlining, responsive, dark mode, Outlook)](#a03-css-for-email-inlining-responsive-dark-mode-outlook) - [A04 — JavaScript for Email and CloudPages](#a04-javascript-for-email-and-cloudpages) - [A05 — AMPscript Essentials](#a05-ampscript-essentials) - [A06 — SQL and Data Views in SFMC](#a06-sql-and-data-views-in-sfmc) - [A07 — Journey Builder](#a07-journey-builder) - [A08 — Email Studio and Content Builder](#a08-email-studio-and-content-builder) - [A09 — Mobile Studio (MobileConnect, MobilePush, GroupConnect)](#a09-mobile-studio-mobileconnect-mobilepush-groupconnect) - [A10 — Social Studio and Advertising](#a10-social-studio-and-advertising) - [A11 — APIs and Integrations](#a11-apis-and-integrations) - [A12 — Architecture and Data Model](#a12-architecture-and-data-model) - [A13 — Technical Leadership and Delivery](#a13-technical-leadership-and-delivery) - [A14 — Round 1 Rapid Drills](#a14-round-1-rapid-drills) - [A15 — Sales Cloud, Service Cloud, Data Cloud & the File Drop Question](#a15-sales-cloud-service-cloud-data-cloud-the-file-drop-question) - [A17 — The Lead Round: What They Actually Asked (updated prep)](#a17-the-lead-round-what-they-actually-asked-updated-prep) - [A18 — How to Answer Any Scenario (the foundation)](#a18-how-to-answer-any-scenario-the-foundation) - [A19 — Scenario Bank: Data, Identity, Contact Model & Compliance](#a19-scenario-bank-data-identity-contact-model-compliance) - [A20 — Scenario Bank: Deliverability, Sending & Email Studio](#a20-scenario-bank-deliverability-sending-email-studio) - [A21 — Scenario Bank: Journey Builder & Automation Studio](#a21-scenario-bank-journey-builder-automation-studio) - [A22 — Scenario Bank: Integrations, Performance, Migration & Leadership](#a22-scenario-bank-integrations-performance-migration-leadership) - [A23 — Last Hour Revision](#a23-last-hour-revision) - [A24 — The 125-Question SFMC Drill Set (with corrected answers)](#a24-the-125-question-sfmc-drill-set-with-corrected-answers) - [A25 — The Deep-Drill Scenario Ladder (350 × 2)](#a25-the-deep-drill-scenario-ladder-350-2) - **[Part VII — Master Question Bank](#part-vii-master-question-bank)** - [Admin, Setup & Reporting (30 questions)](#qb-admin-setup-reporting) - [AMPscript (55 questions)](#qb-ampscript) - [APIs & Integrations (40 questions)](#qb-apis-integrations) - [Architecture & Data Model (49 questions)](#qb-architecture-data-model) - [Automation Studio (34 questions)](#qb-automation-studio) - [CloudPages & Forms (41 questions)](#qb-cloudpages-forms) - [Data Extensions & Contact Builder (40 questions)](#qb-data-extensions-contact-builder) - [Deliverability, SPF/DKIM/DMARC & Compliance (40 questions)](#qb-deliverability-spfdkimdmarc-compliance) - [Email HTML/CSS & Rendering (35 questions)](#qb-email-htmlcss-rendering) - [Email Studio & Sending (45 questions)](#qb-email-studio-sending) - [Journey Builder (45 questions)](#qb-journey-builder) - [Lead-Level: Architecture Decisions & Leadership (50 questions)](#qb-lead-level-architecture-decisions-leadership) - [SQL & Data Views (45 questions)](#qb-sql-data-views) - [SSJS & WSProxy (35 questions)](#qb-ssjs-wsproxy) - [Troubleshooting & Bug-Fix Scenarios (60 questions)](#qb-troubleshooting-bug-fix-scenarios) - **[Part VIII — Developer Certification Practice](#part-viii-developer-certification-practice)** - [Certification Practice Questions](#certification-practice-questions) - [Flashcards (82 cards)](#flashcards) --- ## Part I — SFMC Interview Prep *The core curriculum — zero to hero across architecture, AMPscript, SSJS, SQL, Journey Builder and deliverability.* ### 🎯 SFMC Interview Prep — Master Roadmap (Zero → Hero) Source: `SFMC Study Guide/SFMC_Interview_Prep/00_START_HERE.md` **For:** Akash Kumar Panda — SFMC Email Developer @ GAP Inc. (4+ yrs), Certified MC Email Specialist **Goal:** Walk into the LTM interview proficient in *every* SFMC topic — fundamentals, dev, architecture, cross-channel, the modern platform, and your own projects. > **One naming note before you start.** The product this course teaches in depth — Email Studio, Journey Builder, Automation Studio, Content Builder, AMPscript/SSJS — is now branded **Marketing Cloud Engagement** (lineage: ExactTarget → "Marketing Cloud" → **Marketing Cloud Engagement**). Salesforce *also* now sells newer **core-platform / Data Cloud-native** editions — **Marketing Cloud Growth, Marketing Cloud Advanced**, and (2025) **Engagement Plus** — which use Flow instead of Journey Builder and segments instead of SQL. If LTM's interviewer says "Engagement" they mean the classic product you know; if they say "Growth/Advanced" they mean the new stack. **Module 17** makes you fluent in the difference so you never sound out of date. > **Currency:** content verified accurate to **current Salesforce Marketing Cloud, 2026**. Salesforce rebrands fast (Datorama → Marketing Cloud Intelligence → Marketing Intelligence; Interaction Studio → Marketing Cloud Personalization; Genie/CDP → Data Cloud / Data 360). Modules 17 and 18 hold the moving numbers and names so they only have to be corrected in one place. --- #### How this course is organized Each numbered file is a **module**. Read them in order the first time. After that, jump around. Every module has the same shape: 1. **Concept** — what it is, why it exists, where it fits. 2. **Deep dive** — the detail an interviewer probes for. 3. **Code / Hands-on** — real snippets you can run in your own BU. 4. **Interview angles** — the exact questions you'll be asked + model answers. 5. **Gotchas** — the "senior developer" knowledge that separates you from a 2-year dev. > 🔑 = a must-know that interviewers use to separate juniors from seniors. > 🧪 = go do this hands-on in your GAP sandbox (or a free SFMC trial) before the interview. --- #### The full module map **Modules 01–15** are the core curriculum (read in order). **Modules 16–17** are the cross-channel + modern-platform stretch. **Modules 18–21** are fast-revision *reference assets* — cheat sheet, limits, function reference, glossary — built for the last 48 hours. **Modules 22–23** are rehearsal and career framing. | # | Module | Why it matters for you | |---|--------|------------------------| | 01 | Architecture & Data Model | The #1 thing senior interviews probe. BUs, the *two* systems of record (Subscriber/All Subscribers vs Contact Builder), the full DE taxonomy, Subscriber Key vs Contact Key. **Canonical home for: unsubscribe scope, data-view retention.** | | 02 | Email Studio & Content Builder | Your daily tool. Sends, tracking, Sender/Delivery Profiles & send classification, triggered sends, A/B. | | 03 | Email Development (HTML/CSS) | Your craft. Outlook/Gmail quirks, responsive, dark mode, a11y, AMP. | | 04 | AMPscript Deep Dive | Your headline skill. Every function class + patterns. | | 05 | SSJS & WSProxy | Your DE Lookup project lives here. Platform vs Core, WSProxy, error handling. | | 06 | SQL in SFMC | Segmentation, data views, dedup, performance. | | 07 | Automation Studio | Batch processing, the "back office" of SFMC. | | 08 | Journey Builder | The orchestration engine. Splits, entry sources, data binding — now with SMS/Push touchpoints. | | 09 | Cloud Pages & APIs | CloudPages, REST/SOAP, MC Connect, OAuth 2.0 Installed Packages. | | 10 | Deliverability & Compliance | SPF/DKIM/DMARC, SAP, **Gmail/Yahoo 2024 bulk-sender rules**, bounces, GDPR/CAN-SPAM (+ TCPA/SMS & WhatsApp consent). Senior differentiator. | | 11 | Personalization, Einstein & MovableInk | Send-time personalization (AMPscript/Dynamic Content) + the *products*: Marketing Cloud Personalization, MovableInk, Einstein, Einstein Personalization. | | 12 | Admin, Reporting & Best Practices | Roles, folder strategy, data governance, audit trail. | | 13 | Code Lab (Hands-On Exercises) | Drills: AMPscript, SSJS, SQL, HTML to practice out loud. | | 14 | Interview Q&A Bank | 130+ Q&A, difficulty-laddered & topic-tagged, basic → advanced, with model answers. | | 15 | Behavioral & Resume STAR Stories | Turn your GAP work into crisp interview stories. Includes a JD→module mapping worksheet. | | 16 | **Mobile Studio & Cross-Channel** | The biggest channel gap closed. MobileConnect (SMS/MMS), MobilePush, GroupConnect (WhatsApp/LINE), the mobile data model, opt-in/STOP/HELP, and orchestrating one customer across Email + SMS + Push without double-messaging. RCS too. 🔑 | | 17 | **Data Cloud, Intelligence & Modern SFMC** | "Where the platform is going." Data Cloud (DLO/DMO, identity resolution, Calculated Insights, activation), Marketing Cloud Intelligence/MI, MC Personalization, Engagement vs **Growth/Advanced** editions, Agentforce/Einstein generative. Maps your classic skills onto the modern stack. 🔑 | | 18 | **Platform Limits & Hard Numbers** | The authoritative limits appendix: 2,500-row SOAP pages, 30-min query cap, token TTL, retention windows, Gmail 102KB clip — each as *limit → consequence → workaround*. Quote the number, then explain the why. 🔑 | | 19 | **AMPscript & SSJS Function Reference (Appendix)** | Scannable signatures + 1-line purpose + gotcha for every function family (incl. exact arg order for `LookupOrderedRows`, `UpsertDE`, date/format functions) plus the SSJS Core/Platform/WSProxy API. The cram spine. 🔑 | | 20 | **One-Page Rapid-Revision Cheat Sheet** | The single sheet for the train ride: contact model, DE types, key AMPscript/SQL snippets, REST vs SOAP, SPF/DKIM/DMARC, metric formulas, limits — all on one page. 🔑 | | 21 | **SFMC A–Z Glossary** | Every acronym an interviewer fires at you — SAP, SDE, TSD, VAWP, MPP, BU/MID, CTOR, RMM, MSISDN, HSM, DLO/DMO — with definition, interview angle, and trap. Skim the morning of. 🔑 | | 22 | **Full Mock Interview Scripts** | Three end-to-end, timed LTM mocks (technical screen, architecture/deep-dive, behavioral) with interviewer lines, ideal answers, escalating follow-ups, "if you stall, say this" recovery lines, and a 1–5 self-scoring rubric. 🔑 | | 23 | **Certifications & Continued Learning** | The credential ladder (Email Specialist → Developer → Consultant → Data Cloud), what each proves, what to be *visibly working toward*, how to talk certs without over-claiming, and a 30/60/90 ramp plan. | --- #### Pick your track first Before you plan, decide which track LTM's JD points at — then prioritize accordingly. (Do the **Module 15** JD→module worksheet once you have the real job description.) - **Email-Developer track (your core strength):** 01–15, with extra reps on 04, 05, 06, 10. This is the bulk of the course and where you already shine. - **Cross-Channel / Architecture stretch track:** add 16 (Mobile/cross-channel) and 17 (Data Cloud, editions, Intelligence, Personalization) early and heavily. This is what separates "maintenance-mode email dev" from "can grow into architecture" — your stated goal. Either way, treat **18–21** as reference (look-up, don't read cover-to-cover) and finish with **22** (mock interviews) + **23** (cert narrative). #### Suggested study plan **If you have ~10 days:** | Day | Focus | |-----|-------| | 1 | Module 01 (Architecture/Data Model) — foundational, re-read twice | | 2 | Modules 02 + 03 (Email Studio, Email Dev) | | 3 | Module 04 (AMPscript) — your strength, sharpen it. Keep **19 (Function Reference)** open as you go | | 4 | Module 05 (SSJS/WSProxy) + rehearse your DE Lookup project | | 5 | Module 06 (SQL) + Module 13 SQL drills | | 6 | Modules 07 + 08 (Automation Studio, Journey Builder) | | 7 | Modules 09 + 10 (Cloud Pages/APIs, Deliverability — incl. Gmail/Yahoo 2024 rules) | | 8 | Modules 11 + 12 (Personalization, Admin) + skim **18 (Limits)** | | 9 | Modules **16 + 17** (Mobile/cross-channel, Data Cloud & modern editions) — the stretch topics that read as senior | | 10 | Self-quiz Module 14 → run a full **Module 22** mock out loud → scan **20 (Cheat Sheet)** + **21 (Glossary)** → Module 15 behavioral + weak-spot review. Skim **23** for your cert narrative. | **If you have ~3 days:** Day 1 = 01, 04, 05 (ref: 19). Day 2 = 06, 08, 10, plus 16/17 skim. Day 3 = 14 self-quiz → one **Module 22** mock → 20 + 21 scan → 15. **Last 48 hours, regardless of track:** live in the reference assets — **20 (Cheat Sheet)**, **21 (Glossary)**, **19 (Function Reference)**, **18 (Limits)** — and run at least one timed **Module 22** mock end-to-end. --- #### The 13 questions you MUST be able to answer cold If you can nail these, you're 80% there. (Full answers live in **Module 14**; rehearse them as spoken answers in **Module 22**; one-liner versions are on the **Module 20** cheat sheet.) 1. Walk me through the SFMC **Contact model** — Contact, Subscriber, Subscriber Key, Contact Key. *Senior "why": there are* **two systems of record** *— the Email Studio Subscriber (keyed by Subscriber Key, lives on the* **All Subscribers** *list, drives email-channel status) and the Contact Builder Contact (Contact Key, cross-channel). Keep them in sync via the same key; a Contact can exist without a Subscriber record and vice versa.* 2. **List vs Data Extension** — when each, and why DEs win? *Relational/multi-key modeling, custom schema + data types, AMPscript/SQL access, no practical list ceiling, far better performance, Journey/Automation integration. Lists are essentially legacy except* **publication lists** *used for unsubscribe scoping — and All Subscribers still underpins subscriber status even when you send from DEs.* 3. **Data Extension taxonomy — keep the axes separate** (an interviewer *will* pull this thread): (1) **structural type** — Standard, Filtered, Random; (2) **sendability** — Sendable vs non-Sendable (a *property*, enabled by the Subscriber/Send Relationship — see #10); (3) **scope/sharing** — **Shared** DEs (require Enterprise 2.0 / multi-BU) and **Synchronized** DEs (`SYNC_EXT`, fed by Marketing Cloud Connect from CRM, and **read-only** — you copy into a Standard sendable DE before sending). These are *independent* properties, not mutually exclusive "types": one DE can be Standard **and** Sendable **and** Shared at once. 4. **AMPscript vs SSJS** — when each? *AMPscript for inline content personalization and most send-time logic (faster, simpler); SSJS for control flow, try/catch error handling, API/WSProxy calls, and complex data manipulation. Gotcha: SSJS runs in a different context — AMPscript vars don't transparently cross over; bridge with* `Variable.SetValue`/`GetValue` *or* `Platform.Function.TreatAsContent`. 5. Explain `Lookup`, `LookupRows`, `LookupOrderedRows` — and **what each returns**: `Lookup()` → a single value (first match); `LookupRows()` → an *unordered* rowset; `LookupOrderedRows()` → an *ordered, row-capped* set (explicit count + sort spec like `'Date DESC'`). All cap at **2,000 rows**. On zero matches you get an **empty rowset / `RowCount`=0 — not an error.** 6. How does **Journey Builder** differ from **Automation Studio**? *JB = customer-state orchestration: real-time/triggered, wait-until, decision splits. Automation = scheduled/file-triggered batch ETL. They're* **complementary and often chained** *— Automation preps the DE, Journey orchestrates the experience.* 7. Walk me through how an **email actually sends** — DE → inbox. *Don't stop at "DE to send"; reach the deliverability layer:* **Sender Profile / Delivery Profile** *resolution, send classification, throttling/IP warmup, the SAP authenticated domain, and bounce processing (hard vs soft vs block; auto-unsubscribe after repeated hard bounces via RMM).* 8. What are **SPF, DKIM, DMARC** and how do they relate to **SAP (Sender Authentication Package)**? *SAP = paid add-on: dedicated IP + private/branded sending domain + Reply Mail Management (RMM) + the DKIM signing domain SFMC sets up. SFMC publishes SPF and signs DKIM on the authenticated domain;* **DMARC alignment is the customer's responsibility** *via their own DNS.* 9. How do you make an email **render correctly in Outlook**? *MSO conditional comments (`
Your preview text here ‌ ‌ ‌ ‌ ‌ ‌ 
``` **🔍 Line by line:** - `` — declares standard HTML5 mode so clients that *do* render in a browser-like engine use predictable, modern parsing rather than legacy "quirks mode." - `` — opens the document. `lang="en"` tells screen readers which language to pronounce (accessibility); the `xmlns:v` and `xmlns:o` namespace declarations register the **VML** (`v:`) and **Office** (`o:`) tag families so classic Outlook's Word engine understands the ``/`` tags you'll use later. Without them, those Outlook-only tags are ignored. - `` — opens the metadata/style region. Note many clients strip or ignore parts of ``, which is exactly why critical styling is *also* inlined. - `` — sets the character encoding to UTF-8 so accented letters, em-dashes, ™ symbols and emoji render instead of turning into garbled "mojibake." - `` — tells mobile clients to use the device's real width at 1:1 zoom, so your responsive layout scales correctly instead of being shown as a zoomed-out desktop page. - `` — stops iOS/Apple Mail from auto-resizing (re-flowing) your font sizes and layout; without it Apple Mail may bump up your text. - `` — declares the email supports both light and dark rendering, opting into native dark-mode handling on supporting clients (Apple/iOS Mail). - `` — the companion declaration; together they signal "I've designed for dark mode, don't aggressively force-invert me" to Class-2 clients. - `` — commented-out legacy Internet Explorer document-mode directive; it has no meaningful effect in modern email clients, so it's left as an optional, non-essential note (cargo-cult — see the load-bearing list below). - `` — the document title; usually left empty in email because clients don't show it, but a valid HTML document expects the tag. - `` is read *only* by classic, Word-engine Outlook and ignored (treated as a comment) by every other client. - `` — closes the Office settings, XML, and noscript wrappers. - `` — closes the MSO conditional comment. - ` ``` **🔍 Line by line:** - `` — closes the Outlook-only conditional. - **Retina:** serve a 2× source and size it down via `width`/`height` + inline `style` (full example in §3). ##### The inline-CSS workflow (a senior pipeline question) 🔑 "Do you hand-inline or use an inliner?" — and the SFMC-specific gotcha: - **SFMC Content Builder does NOT auto-inline your `
Left Right
``` *Checks:* media query stacking, role=presentation, inline fonts. **🔍 Line by line:** - `` — close the style block. - `` — the layout table. `role="presentation"` tells assistive tech this is **layout, not data** (so it isn't read as a grid). `width="600"` is the desktop width; the zeroed `cellpadding`/`cellspacing`/`border` remove default table spacing for pixel control. - `` — one table row holding the two columns. - `` — the left column. `class="col"` is the hook the media query stacks; `width="300"` is half of 600 for the desktop two-up layout; `valign="top"` top-aligns content; the inline `style` sets fonts **inline** because that survives even when ` ...content... ``` **🔍 Line by line:** - `` — the **traditional email doctype**. Three reasons it won: (1) it forces **standards mode** rather than quirks mode, so box sizing and margins behave predictably in the browser-based clients; (2) **Transitional** (not Strict) legally permits the presentational attributes email depends on — `align`, `bgcolor`, `cellpadding`, `cellspacing`, `border`, `valign`, `width` on `
Left ` — which Strict forbids; (3) it is the doctype most webmail clients have been tested against for two decades. `` (HTML5) is also standards-mode and increasingly common; the honest interview answer is *"XHTML 1.0 Transitional is the conservative default and what most SFMC templates carry, HTML5 doctype is fine for modern clients — but note many webmail clients **strip your doctype entirely** and impose their own, which is a further reason not to depend on doctype-specific behaviour."* - `` — `lang` tells screen readers which language to pronounce; it is a genuine accessibility requirement, not boilerplate. - `xmlns="http://www.w3.org/1999/xhtml"` — declares the default XHTML namespace, matching the doctype. - `xmlns:v="urn:schemas-microsoft-com:vml"` — registers the **VML** namespace so classic Outlook understands ``, ``, ``. Without this declaration your VML buttons silently render as nothing. - `xmlns:o="urn:schemas-microsoft-com:office:office"` — registers the **Office** namespace for `` below. - `` — sets UTF-8 so accented characters, curly quotes, ™ and emoji render instead of mojibake. (`` is the HTML5 equivalent; the long form matches the XHTML doctype and the self-closing ` />` syntax XHTML expects.) - `` — tells mobile clients to use the real device width at 1:1 zoom, so your media queries actually fire instead of the client rendering a zoomed-out desktop page. - `` — stops iOS/Apple Mail auto-scaling your font sizes and re-flowing the layout. - `` and `` — declare "I have designed for dark mode," which makes Apple/iOS Mail apply your `prefers-color-scheme` rules instead of guessing. Covered fully in A03. - `Spring Sale` — required for a valid document; most clients never show it, but the "View in browser" page can, and empty titles trip some HTML validators used in spam scoring. - `[if mso]` — opens an **MSO conditional comment**. Because it starts as a real HTML comment, only classic Word-engine Outlook "opens" it; every other client treats the whole thing as a comment and skips it. This is *downlevel-hidden* syntax. - `