Question 820
An Azure SQL operations team investigates: A security team needs evidence that SQL backup encryption meets confidentiality rules without sacrificing recoverability. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A security team needs evidence that SQL backup encryption meets confidentiality rules without sacrificing recoverability. The specific supported administrative response is: Preserve supported SQL Server native backup encryption certificates or asymmetric keys and their passwords separately from backup artifacts. The technical risk is: A perfectly copied encrypted backup is unusable when its decryption protector is missing at the recovery site. Confirm the correction with: An isolated restore test succeeds with the approved protector and rejects access without authorized key material.
The acceptance evidence for this incident (A security team needs evidence that SQL backup encryption meets confidentiality rules without sacrificing recoverability.) is: An isolated restore test succeeds with the approved protector and rejects access without authorized key material. It directly tests whether the remediation (Preserve supported SQL Server native backup encryption certificates or asymmetric keys and their passwords separately from backup artifacts.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Always on availability groups on azure SQL vms (5.3) would demonstrate or implement: A planned replica failover preserves database accessibility through the listener and reports expected synchronization health. The case states: A security team needs evidence that SQL backup encryption meets confidentiality rules without sacrificing recoverability. The most direct paired action and test is: Preserve supported SQL Server native backup encryption certificates or asymmetric keys and their passwords separately from backup artifacts.
SQL managed instance failover and link design (5.3) addresses another technical failure: Assuming managed instance deployment includes every SQL Server high-availability mechanism without configuration can leave hybrid failback gaps. This case instead tests Encrypted native backup keys and recovery (5.2); the choice measures or changes another part of the system.
SQL server backup and restore to azure blob storage (5.2) addresses another technical failure: Unreachable Blob storage, expired credentials or unverified backup integrity can make a cloud backup unusable in a disaster. The paired-answer requirement concerns Encrypted native backup keys and recovery (5.2); this alternative does not provide the matching intervention and separate acceptance evidence.