INFRASTRUCTURE LEARNINGINFRASTRUCTURE LEARNING
インフラ大全インフラ大全IT INFRASTRUCTURE / LEARNING
Infrastructure learning guide
Find a lesson or lab/

Esc to close · Search terms stay on your device

LEARNING日本語

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.

What you will learn

Diagnose a failed read by matching its key, operation and principal.

Prerequisite

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.

Check a dedicated restore role
Check a dedicated restore role1: Request — Fix the version — Storage. 2: Storage — Resolve the key — KMS. 3: KMS — Reconcile restored data — Restore123RequestStorageKMSRestoreCheck a dedicated restore role1: Request — Fix the version — Storage. 2: Storage — Resolve the key — KMS. 3: KMS — Reconcile restored data — Restore123RequestStorageKMSRestore
  1. Request → StorageFix the version
  2. Storage → KMSResolve the key
  3. 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

A fictional SQL Server backup is stored in S3. The destination copy uses another key.
ObservationResultCheck
ListTwo copies visibleS3 list permission
Source copyTest read succeedsSource key
Destination copyDecrypt stage deniedDestination key and effective permissions
RestorePendingSynthetic 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.

Does a visible object list establish decryption access?
Read the answer and reason

Answer: Inspect the target key and caller · Listing and using the key have separate requirements.

How do you retest a different copy?
Read the answer and reason

Answer: Match the version and key ARN · Use the actual key protecting that copy.

What demonstrates recovery?
Read the answer and reason

Answer: Restore a synthetic database and reconcile it · Show that the content is usable.

Check, then explain in your own words

  1. Fix the exact backup version.
  2. Verify storage and key permissions.
  3. 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.