40510: Microsoft Cloud Workshop: SQL Server Hybrid Cloud — Lesson 2: Azure Backup, Stretch Database, and SQL Server Resilience Design

Topics Covered

• Plan SQL Server backup and recovery with Azure services
• Evaluate Stretch Database scenarios, dependencies, and limitations
• Design an availability group approach for disaster recovery
• Step-by-step implementation workflow and configuration decisions
• Hands-on verification of core features, data, and expected results
• Documentation of assumptions, dependencies, naming, and change controls

Guided Practice Steps

1. Translate the lesson requirement into a clear 40510: Microsoft Cloud Workshop: SQL Server Hybrid Cloud implementation or analysis objective.
2. Document assumptions, selected tools or features, dependencies, risks, and expected results.
3. Perform the guided task, capture evidence, and compare the result with the acceptance criteria.
4. Record issues, corrective actions, and a reusable operational or development note.

Practical Activity

Design backup and data-placement options with recovery and operational evidence.

• Define the scenario, inputs, constraints, and expected outcome.
• Complete the activity and preserve screenshots, outputs, logs, code, or decision evidence.
• Review the result, identify gaps, and document corrective or improvement actions.

Validation Checklist

• The stated requirement and expected outcome are clear.
• Configuration, code, data, or design decisions are documented.
• Normal, boundary, failure, security, and operational considerations are reviewed.
• Evidence supports the conclusion and the next action is prioritized.

Lesson Outcome

Learners can explain and apply Azure Backup, Stretch Database, and SQL Server Resilience Design within a realistic 40510: Microsoft Cloud Workshop: SQL Server Hybrid Cloud scenario and support the result with validation evidence.