rv-2026-0396Submitted by Lukas Hoffmann of Drives Sales Excellence3 Sept 2026Google Cloud, scored under CIS Controls v8.1 and Northwind’s own standardsmatched to Internal GenAI assistant with retrieval at 82%read from sales-proposal-assistant-lld-v1.0.pdf and sales-proposal-assistant-architecture.png
| Maps to | |||||||||
|---|---|---|---|---|---|---|---|---|---|
3.12 | Segment Data Processing and Storage Based on SensitivityCustomer pricing sits in a bucket and a database outside any service perimeter | Data | Security | PR.IR-01 · PR.DS-01 | High | Fail | Missing 4 cited, none proving it is built | Data Platform Engineering | 3 Oct 2026 |
CAT-2 | Conditional services are used on their termsVertex AI is used outside its conditions of use | Estate fit | Estate fit | Service catalogue | High | Fail | Missing 1 cited, none proving it is built | Cyber Security | 3 Oct 2026 |
LLM01 | Prompt InjectionNothing screens the prompt or the retrieved chunks before they reach Gemini | AI | Security | OWASP LLM Top 10 | High | Fail | Missing 3 cited, none proving it is built | Drives Sales Excellence | 3 Oct 2026 |
LLM02 | Sensitive Information DisclosureAny sales user can retrieve any customer's pricing, and drafts are not screened | AI | Security | OWASP LLM Top 10 | High | Fail | Missing 4 cited, none proving it is built | Drives Sales Excellence | 3 Oct 2026 |
LLM07 | System Prompt LeakageThe system prompt carries the CPQ price-book API key | AI | Security | OWASP LLM Top 10 | High | Fail | Missing 3 cited, none proving it is built | Drives Sales Excellence | 3 Oct 2026 |
LLM08 | Vector and Embedding WeaknessesThe vector table carries no entitlements: every sales user can retrieve every chunk | AI | Security | OWASP LLM Top 10 | High | Fail | Missing 4 cited, none proving it is built | Drives Sales Excellence | 3 Oct 2026 |
REL-1 | No single point of failure on the critical pathThe primary data store has no standby | Reliability | Reliability | GCP Architecture Framework | High | Fail | Missing | Drives Sales Excellence | 3 Oct 2026 |
11.4 | Establish and Maintain an Isolated Instance of Recovery DataDatabase backups are described without saying where they are held | Resilience | Security | PR.DS-11 | Medium | Fail | Missing 2 cited, none proving it is built | Cloud Platform Engineering | 2 Nov 2026 |
AP-1 | Shared databaseShared database: chat-api and corpus-sync both reach spa-db (pgvector) directly | Design pattern | Reliability | Design patterns | Medium | Fail | Missing | Drives Sales Excellence | 2 Nov 2026 |
AP-2 | Third party in the data pathThird party in the data path: Salesforce (northwind.my.salesforce.com) | Design pattern | Reliability | Design patterns | Medium | Fail | Missing | Drives Sales Excellence | 2 Nov 2026 |
COST-4 | Spend is visible and attributedNo budget, alert or cost attribution | Cost | Cost | GCP Architecture Framework | Medium | Fail | Missing | Cloud Platform Engineering | 2 Nov 2026 |
MBSS-1 | The design names the baselines it is built to7 baselines apply and none is named in the design | Estate fit | Estate fit | MBSS baselines | Medium | Fail | Missing | Cyber Security | 2 Nov 2026 |
REL-2 | Recovery objectives are statedNo recovery time or recovery point objective is stated | Reliability | Reliability | GCP Architecture Framework | Medium | Fail | Missing 1 cited, none proving it is built | Drives Sales Excellence | 2 Nov 2026 |
REL-3 | Recovery is tested, not assumedThe restore path has never been exercised | Reliability | Reliability | GCP Architecture Framework | Medium | Fail | Missing 1 cited, none proving it is built | Drives Sales Excellence | 2 Nov 2026 |
REL-5 | Dependencies fail without taking the application downA call to Salesforce (northwind.my.salesforce.com) has no stated failure behaviour | Reliability | Reliability | GCP Architecture Framework | Medium | Fail | Missing | Drives Sales Excellence | 2 Nov 2026 |
OPS-4 | Runbooks exist for the likely failuresNo runbooks are referenced | Operations | Operations | GCP Architecture Framework | Low | Fail | Missing | Cloud Platform Engineering | 2 Dec 2026 |
3.10 | Encrypt Sensitive Data in TransitTLS on every hop, including an enforced encrypted connection to Cloud SQL | Data | Security | PR.DS-02 | Low | Pass | Data Platform Engineering | — | |
3.11 | Encrypt Sensitive Data at RestData at rest uses Google default encryption, which the standard accepts for Confidential data | Data | Security | PR.DS-01 | Low | Pass | Data Platform Engineering | — | |
6.3 | Require MFA for Externally-Exposed ApplicationsIdentity-Aware Proxy enforces corporate sign-in and MFA before requests reach the application | Identity | Security | PR.AA-03 | Low | Pass | Identity Engineering | — | |
6.5 | Require MFA for Administrative AccessProject administrators use 2-Step Verification with security keys | Identity | Security | PR.AA-03 · PR.AA-05 | Low | Pass | Identity Engineering | — | |
8.9 | Centralize Audit LogsAudit logs leave the project through the organisation-level sink, and every tool call is logged | Logging | Security | PR.PS-04 | Low | Pass | Cyber Security | — | |
12.2 | Establish and Maintain a Secure Network ArchitecturePrivate IP database, Private Google Access and one allow-listed external destination | Network | Security | PR.IR-01 | Low | Pass | Network Engineering | — | |
13.10 | Perform Application Layer FilteringCloud Armor with the OWASP rule set on the only public entry point | Network | Security | PR.IR-01 · DE.CM-01 | Low | Pass | Network Engineering | — | |
16.10 | Apply Secure Design Principles in Application ArchitecturesOne least-privilege service account per workload, no basic roles | Application | Security | PR.PS-06 | Low | Pass | Drives Sales Excellence | — | |
AP-4 | Snowflake environmentThe environment is reproducible | Design pattern | Operations | Design patterns | Low | Pass | Cloud Platform Engineering | — | |
CAT-1 | Every service is in the catalogue and permittedAll 11 services are in the catalogue and permitted | Estate fit | Estate fit | Service catalogue | Low | Pass | Not assessed | Cyber Security | — |
CAT-3 | Nothing depends on a service that is going awayNothing in the design is retiring or unassessed | Estate fit | Estate fit | Service catalogue | Low | Pass | Not assessed | Cyber Security | — |
CAT-4 | Data is held only where its class is permittedEvery store is assessed for the class it holds | Estate fit | Estate fit | Service catalogue | Low | Pass | Not assessed | Cyber Security | — |
COST-1 | Capacity follows demandNothing runs when nothing is happening | Cost | Cost | GCP Architecture Framework | Low | Pass | Not assessed | Cloud Platform Engineering | — |
COST-2 | Storage has a lifecycleStored data has a stated lifetime | Cost | Cost | GCP Architecture Framework | Low | Pass | Cloud Platform Engineering | — | |
COST-3 | Traffic that leaves is accounted forTraffic leaving the estate is accounted for | Cost | Cost | GCP Architecture Framework | Low | Pass | Cloud Platform Engineering | — | |
LLM05 | Improper Output HandlingDrafts are rendered as sanitised Markdown and exported as plain paragraphs | AI | Security | OWASP LLM Top 10 | Low | Pass | Drives Sales Excellence | — | |
LLM06 | Excessive AgencyThe only tool is a read-only price lookup | AI | Security | OWASP LLM Top 10 | Low | Pass | Drives Sales Excellence | — | |
LLM10 | Unbounded ConsumptionPer-user message and token quotas keyed on the IAP identity, with a project budget alert | AI | Security | OWASP LLM Top 10 | Low | Pass | Drives Sales Excellence | — | |
OPS-1 | Infrastructure is defined as codeThe environment is defined as code | Operations | Operations | GCP Architecture Framework | Low | Pass | Cloud Platform Engineering | — | |
OPS-2 | Releases are staged and reversibleReleases are staged and can be withdrawn | Operations | Operations | GCP Architecture Framework | Low | Pass | Cloud Platform Engineering | — | |
OPS-3 | Monitoring reaches a personAlerts reach a named rota | Operations | Operations | GCP Architecture Framework | Low | Pass | Cloud Platform Engineering | — | |
PERF-1 | Latency and throughput targets are statedThe design states what it is built to serve | Performance | Performance | GCP Architecture Framework | Low | Pass | Drives Sales Excellence | — | |
PERF-4 | Scaling bounds are definedScaling bounds are set | Performance | Performance | GCP Architecture Framework | Low | Pass | Drives Sales Excellence | — |