Back to blog
·How to

How to build a security knowledge base for questionnaires

How to build a centralized security knowledge base that cuts DDQ response time by 80%. DIY (Google Docs/Notion) and automated approaches.

How to build a security knowledge base for questionnaires

Every time you complete a DDQ, you're creating valuable intellectual property: vetted, approved answers about your company's security posture. The problem is, most companies let that knowledge die in a random Google Sheet or email thread.

Building a security knowledge base turns every DDQ from a 6-hour chore into a 30-minute review. Here's how.

What goes in a security knowledge base

At minimum, you need:

1. Source documents (the ground truth)

  • SOC 2 Type II report
  • Information Security Policy
  • Data Retention Policy
  • Incident Response Plan
  • Access Control Policy
  • Business Continuity / Disaster Recovery Plan
  • Most recent penetration test summary
  • Cyber insurance certificate
  • Data Processing Agreement (DPA) template
  • Architecture / infrastructure diagram

2. Q&A pairs (the answer library)

For every DDQ question you've ever answered, store:

  • The question (normalized — e.g., "Do you encrypt data at rest?" regardless of how each DDQ phrases it)
  • The approved answer
  • The source document and section
  • Date last reviewed
  • Who approved it

3. Metadata

  • When each source document was last updated
  • Which answers depend on which documents (so when SOC 2 gets updated, you know which answers to review)

The DIY approach: Google Sheets + drive

For companies doing 1–3 DDQs per month, a well-organized spreadsheet works:

Structure:

CategoryQuestionApproved AnswerSourceLast ReviewedOwner
EncryptionDo you encrypt data at rest?Yes. AES-256 via AWS RDS encryption...InfoSec Policy v2.1, §5.22026-03-15CTO
Incident ResponseDescribe your IR processWe maintain a formal IRP reviewed annually...IR Plan v1.3, §22026-02-01CTO
Access ControlDo you enforce MFA?Yes. MFA enforced via Okta for all users...Access Control Policy v2.0, §4.32026-04-01CTO

Pros:

  • Free
  • Simple to start
  • Everyone knows how to use Google Sheets

Cons:

  • Manual maintenance — you update answers by hand
  • No automatic matching — you still Ctrl+F for each new question
  • No format handling — you copy-paste from the sheet into Excel/Word/portals
  • No consistency checking — contradictions slip through
  • Doesn't scale past 3–4 DDQs/month

The notion/Confluence approach

Some teams build their knowledge base in Notion or Confluence:

  • Each security domain gets a page (Encryption, Access Control, Incident Response, etc.)
  • Each page has Q&A blocks with source citations
  • Policies are stored as sub-pages or linked documents
  • Tags for framework mapping (SOC 2, ISO 27001, HIPAA)

Pros:

  • Better organization than a spreadsheet
  • Easier to browse and update
  • Team collaboration built-in

Cons:

  • Still manual matching and copy-paste for each DDQ
  • No format handling
  • No versioning/dependency tracking
  • Notion search isn't great for finding specific security answers

The automated approach

Tools like FillBase automate the entire knowledge base lifecycle:

  1. Ingestion — Upload your SOC 2 and policies. The AI extracts facts, maps them to common question categories, and builds the knowledge base automatically.

  2. Matching — When you submit a new DDQ, the AI matches each question to the best answer in your knowledge base — regardless of how the question is phrased.

  3. Citation — Every auto-generated answer includes the source document and section.

  4. Learning — When you edit an answer, the system learns. After 5–10 DDQs, accuracy exceeds 90%.

  5. Versioning — Update your SOC 2? The system identifies all answers that reference the old report and flags them for review.

  6. Consistency — The same question always gets the same answer, across every DDQ format.

Pros:

  • 30-minute setup, not 30 hours
  • Automatic matching and generation
  • Scales to any volume
  • Gets better over time

Cons:

  • Monthly cost ($149–$599)
  • Requires trust in AI (mitigated by human review + confidence scoring)

Building your knowledge base: The 30-minute quick start

Regardless of which approach you choose, here's how to get started today:

Step 1 (10 min): Gather your SOC 2 report and top 3 security policies into one folder.

Step 2 (5 min): Find your 2–3 most recent completed DDQs.

Step 3 (15 min): Either:

  • DIY: Create a Google Sheet with columns: Category | Question | Answer | Source | Date | Owner. Start populating from your completed DDQs.
  • Automated: Upload your documents to FillBase and let the AI build the knowledge base.

Step 4 (ongoing): After each DDQ, add any new Q&A pairs to the knowledge base. Update source documents when they change.

Maintenance: The part everyone forgets

A knowledge base is only useful if it's current. Schedule these:

  • Monthly: Review 10 random Q&A pairs for accuracy
  • Quarterly: Update answers after SOC 2 audit / policy reviews
  • Immediately: Update when any policy, tool, or process changes
  • After each DDQ: Add new questions and approved answers

The goal is that after 6 months, your knowledge base covers 95%+ of any DDQ question. New questionnaires become a 15-minute review, not a 6-hour project.

Start building your knowledge base for free →

Your next enterprise deal shouldn't wait on a spreadsheet

Get started