Skip to content
Back to skills

1542 07 Compliance Matrix 51e7bcad

ASecurity

![Step](https://img.shields.io/badge/Step-7f-blue?style=for-the-badge) ![Status](https://img.shields.io/badge/Status-Draft-orange?style=for-the-badge) ![Agent](https://img.shields.io/badge/Agent-As--Built-purple?style=for-the-badge) <details open> <summary><strong>๐Ÿ“‘ Compliance Contents</strong></summary> - [๐Ÿ“‹ Executive Summary](#-executive-summary) - [๐Ÿ—บ๏ธ 1. Control Mapping](#๏ธ-1-control-mapping) - [๐Ÿ” 2. Gap Analysis](#-2-gap-analysis) - [๐Ÿ“ 3. Evidence Collection](#-3-evidence-collection)...

  • 9 stars
  • 0 votes
  • 0 copies
  • 0 views
  • Added October 11, 2026
securitygosqlazureterraformsecurity

Security analysis

A100/100

Scanned October 11, 2026

npx -y skills add tools-only/X-Skills --skill 1542-07-compliance-matrix_51e7bcad --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of 1542 07 Compliance Matrix 51e7bcad?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for 1542 07 Compliance Matrix 51e7bcad
[![Security: A โ€” Skills Directory](https://www.skillsdirectory.com/api/skills/tools-only-1542-07-compliance-matrix-51e7bcad/badge)](https://www.skillsdirectory.com/skills/tools-only-1542-07-compliance-matrix-51e7bcad)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

SKILL.md
# โš–๏ธ Compliance Matrix: terraform-e2e

![Step](https://img.shields.io/badge/Step-7f-blue?style=for-the-badge)
![Status](https://img.shields.io/badge/Status-Draft-orange?style=for-the-badge)
![Agent](https://img.shields.io/badge/Agent-As--Built-purple?style=for-the-badge)

<details open>
<summary><strong>๐Ÿ“‘ Compliance Contents</strong></summary>

- [๐Ÿ“‹ Executive Summary](#-executive-summary)
- [๐Ÿ—บ๏ธ 1. Control Mapping](#๏ธ-1-control-mapping)
- [๐Ÿ” 2. Gap Analysis](#-2-gap-analysis)
- [๐Ÿ“ 3. Evidence Collection](#-3-evidence-collection)
- [๐Ÿ“ 4. Audit Trail](#-4-audit-trail)
- [๐Ÿ”ง 5. Remediation Tracker](#-5-remediation-tracker)
- [๐Ÿ“Ž 6. Appendix](#-6-appendix)
- [References](#references)

</details>

> Generated by as-built agent | 2026-02-26

<div align="center">

| โฌ…๏ธ Previous                                  | ๐Ÿ“‘ Index            | Next โžก๏ธ                                          |
| -------------------------------------------- | ------------------- | ------------------------------------------------ |
| [07-backup-dr-plan.md](07-backup-dr-plan.md) | [README](README.md) | [07-ab-cost-estimate.md](07-ab-cost-estimate.md) |

</div>

**Generated**: 2026-02-26
**Version**: 1.0
**Environment**: dev
**Primary Compliance Framework**: GDPR + Azure Policy baseline

---

## ๐Ÿ“‹ Executive Summary

This matrix maps as-built controls to requirements from project artifacts and enforced Azure Policies.

| Compliance Area | Coverage | Status |
| --------------- | -------- | ------ |
| Network Security | 80% | โœ… |
| Data Protection | 85% | โœ… |
| Access Control | 85% | โœ… |
| Monitoring & Audit | 80% | โœ… |
| Incident Response | 70% | โš ๏ธ |
| Overall | 80% | โœ… |

---

## ๐Ÿ—บ๏ธ 1. Control Mapping

### Requirement 1: Governance Policy Compliance

| Control | Requirement | Implementation | Status |
| ------- | ----------- | -------------- | ------ |
| Allowed locations | Deploy only in approved regions | Resources deployed in `swedencentral` (plus global alert rule) | โœ… |
| Required resource tags | `Environment`, `Project` enforced | Applied to deployed resources (`Environment=dev`, `Project=terraform-e2e`) | โœ… |
| Required RG tags | 9 lowercase tags enforced | RG tagging model implemented in Terraform locals | โœ… |

### Requirement 2: Secure Application Platform

| Control | Requirement | Implementation | Status |
| ------- | ----------- | -------------- | ------ |
| Web HTTPS | App Service must be HTTPS-only | Both web apps deployed with `https_only = true` | โœ… |
| SQL AAD-only | SQL server must use AAD-only auth | `azureADOnlyAuthentication = true` in deployed SQL server | โœ… |
| TLS baseline | SQL minimum TLS 1.2 | `minimalTlsVersion = 1.2` on SQL server | โœ… |
| Key Vault hardening | RBAC + purge protection | `enableRbacAuthorization = true`, purge protection enabled | โœ… |

### Requirement 3: Monitoring and Operations

| Control | Requirement | Implementation | Status |
| ------- | ----------- | -------------- | ------ |
| Centralized telemetry | App + platform logs | App Insights linked to Log Analytics workspace | โœ… |
| Alerting | Failure anomaly detection | Smart detector alert rule enabled | โœ… |
| Operational runbooks | Day-2 guidance | Documented in [07-operations-runbook.md](./07-operations-runbook.md) | โœ… |

---

## ๐Ÿ” 2. Gap Analysis

| Gap | Severity | Risk Level | Remediation | Timeline |
| --- | -------- | ---------- | ----------- | -------- |
| Single-region deployment | ๐ŸŸก | Medium | Implement warm standby pattern in secondary EU region | Before production |
| Broad SQL RBAC role (`Contributor`) | ๐ŸŸก | Medium | Narrow to least-privilege SQL roles | Next sprint |
| No private endpoints | ๐ŸŸข | Low (dev), Medium (prod) | Add private endpoints + VNet integration for production | Before production |
| Manual DR orchestration | ๐ŸŸก | Medium | Automate failover runbook and test quarterly | Next quarter |

---

## ๐Ÿ“ 3. Evidence Collection

| Control | Evidence Type | Location | Last Collected |
| ------- | ------------- | -------- | -------------- |
| Deployment outcomes | Deployment summary | [06-deployment-summary.md](./06-deployment-summary.md) | 2026-02-26 |
| Resource configuration | Inventory snapshot | [07-resource-inventory.md](./07-resource-inventory.md) | 2026-02-26 |
| Policy constraints | Governance artifact | [04-governance-constraints.md](./04-governance-constraints.md) | 2026-02-26 |
| Terraform control definitions | IaC source | [../../infra/terraform/terraform-e2e/main.tf](../../infra/terraform/terraform-e2e/main.tf) | 2026-02-26 |

---

## ๐Ÿ“ 4. Audit Trail

| Date | Auditor | Finding | Status | Commit |
| ---- | ------- | ------- | ------ | ------ |
| 2026-02-26 | as-built agent | Step 7 compliance mapping created from deployed state | โœ… Complete | N/A |

---

## ๐Ÿ”ง 5. Remediation Tracker

| Finding | Owner | Due Date | Status |
| ------- | ----- | -------- | ------ |
| Replace broad SQL scope role with least privilege | Platform engineering | 2026-03-31 | ๐Ÿ”„ In Progress |
| Define production private networking baseline | Architecture + Security | 2026-04-30 | โฌœ Todo |
| Run DR simulation and capture evidence | Operations | 2026-05-15 | โฌœ Todo |

---

## ๐Ÿ“Ž 6. Appendix

### A. Compliance Framework Reference

- GDPR applicability identified in requirements and architecture artifacts.
- Azure Policy baseline controls enforced at subscription/management-group scopes.

### B. Azure Security Baseline Mapping

- HTTPS-only web apps: implemented
- AAD-only SQL auth: implemented
- Managed identity usage: implemented
- Centralized monitoring: implemented
- Private networking hardening: deferred to production posture

---

## References

| Topic | Link |
| ----- | ---- |
| Microsoft Cloud Security Benchmark | [Overview](https://learn.microsoft.com/security/benchmark/azure/overview) |
| Azure Policy | [Policy overview](https://learn.microsoft.com/azure/governance/policy/overview) |
| Azure compliance offerings | [Compliance](https://learn.microsoft.com/azure/compliance/) |

---

<div align="center">

| โฌ…๏ธ [07-backup-dr-plan.md](07-backup-dr-plan.md) | ๐Ÿ  [Project Index](README.md) | โžก๏ธ [07-ab-cost-estimate.md](07-ab-cost-estimate.md) |
| ----------------------------------------------- | ----------------------------- | --------------------------------------------------- |

</div>

Attribution

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

Comments

Loading commentsโ€ฆ

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.