{"results":[{"id":"azuresql-99-99-availability-sla","text":"Azure SQL Database offers a 99.99% availability SLA","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-99-99-sla","text":"Azure SQL Database guarantees 99.99% SLA availability (up to 99.995% per the Azure SQL family overview).","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-active-geo-replication-4-secondaries","text":"Azure SQL Database active geo-replication supports up to 4 readable secondary databases in same or different regions","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-always-encrypted-client-side-keys","text":"Always Encrypted keeps encryption keys on the client side; even DBAs cannot see plaintext data.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-always-encrypted-protects-from-dbas","text":"Always Encrypted keeps encryption keys outside the database engine, protecting data even from database administrators — data is encrypted at rest and in use.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-audit-destinations-storage-monitor-eventhubs","text":"SQL Auditing writes audit logs to customer-owned Azure storage, Azure Monitor logs, or Event Hubs.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-automatic-tuning-index-and-plan","text":"Azure SQL Database automatic tuning includes automatic index management and automatic plan correction.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-automatic-tuning-index-plan","text":"Azure SQL Database automatic tuning includes automatic index management and automatic plan correction.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-compression-3-4x-tde-log-exception","text":"Azure SQL Database backups are compressed with typical 3–4x ratio, but TDE-encrypted transaction log backups are NOT compressed.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-dr-planning-constraints","text":"Azure SQL backup has three critical constraints that compound during DR planning: TDE prevents transaction log backup compression (reducing backup storage efficiency), geo-restore is disabled when backup redundancy is set to LRS or ZRS (forcing a GRS/GZRS cost commitment for geo-recovery), and server deletion permanently destroys all databases with only LTR blob backups surviving — making redundancy selection, encryption configuration, and operational procedures interdependent DR concerns.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-free-storage-equals-max-data-size","text":"Azure SQL Database provides free backup storage equal to the provisioned max data size; excess is billed per GB/month.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-frequency","text":"Azure SQL Database automated backups: full weekly, differential every 12h (vCore) or 24h (DTU), transaction log ~10 minutes","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-redundancy-change-48h-future-only","text":"Azure SQL Database backup redundancy changes apply only to future backups, may take up to 48 hours, and existing backups remain on original storage.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-str-max-35-days-basic-7","text":"Azure SQL Database short-term retention (STR) is configurable from 1–35 days (default 7), except Basic tier which is limited to 1–7 days.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-backup-uniform-compression","text":"Azure SQL automated backups achieve uniform 3–4x compression across full, differential, and transaction log backup types at the configured frequency.","truth_value":"OUT","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-basic-tier-max-retention-7-days","text":"Azure SQL Database Basic tier short-term backup retention maximum is 7 days (vs 35 days for other tiers)","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-bc-backups-on-secondary-replicas","text":"Azure SQL Database Business Critical tier runs automated backups on secondary replicas by default, offloading the primary with no extra cost.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-best-practice-custom-roles-least-privilege","text":"Best practice: use custom database roles with least privilege; never assign permissions directly to users; limit db_owner to administrative users only.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-best-practice-roles-least-privilege","text":"Best practice: assign users to database roles with least privilege; avoid direct permission grants to users; limit db_owner role to administrative users only.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"azuresql-business-critical-backups-from-secondary","text":"Azure SQL Database Business Critical tier takes backups from secondary replicas by default to offload the primary","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null}],"count":140,"limit":20,"offset":0}