Topic lessonTopic: AWS authorization, encryption, audit and response
AWS KMS authorization for reading SQL Server backup copies
Separate access to storage from use of the encryption key. Diagnose a failed read by matching its key, operation and principal.
Diagnose a failed read by matching its key, operation and principal.
This exercise uses fictional evidence and makes no changes in a live environment.
Check restoration dependencies
Each KMS key has a key policy. Object access, KMS authorization and SQL Server TDE belong to separate layers.
- Request → StorageFix the version
- Storage → KMSResolve the key
- KMS → RestoreReconcile restored data
- Request
- Identify the backup version
- Storage
- Read the selected object
- KMS
- Verify the actual key and operation
- Restore
- Validate a synthetic database
Two copies with a similar name
| Observation | Result | Check |
|---|---|---|
| List | Two copies visible | S3 list permission |
| Source copy | Test read succeeds | Source key |
| Destination copy | Decrypt stage denied | Destination key and effective permissions |
| Restore | Pending | Synthetic data and integrity check |
Storage access may be the same while the key or caller changes.
Evidence for the decision
Define each boundary Record storage access, key authorization and SQL Server restore dependencies separately.
Fix the target Match the key ARN and region, object version and actual caller.
Rehearse restoration After the read works, restore the synthetic fixture and reconcile expected row counts.
Check your decision
Choose an option to see the result and explanation.
Check, then explain in your own words
- Fix the exact backup version.
- Verify storage and key permissions.
- Validate restored data.
Check your understanding: Does object access permit SQL Server TDE operations as well?
Confirm the SQL Server key and certificate requirements separately.
The layers protect different parts of the system.
Sources and conditions checked
The official references used in this lesson are collected here with their scope, conditions and corresponding sections. Independent expert review and live AWS comparison have not been performed.
- Key policies in AWS KMSChecked:
Scope and conditionsHow key policies govern IAM authorization.
Used in this lessonCheck restoration dependencies Two copies with a similar name Evidence for the decision