You have a high-traffic SQL database that is reaching its capacity limits. You want to improve performance for read-heavy workloads without upgrading the main database tier. What is a common strategy?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: Create read-only replicas using Active Geo-Replication

Read replicas offload read traffic from the primary database, improving overall performance....

๐Ÿ“‹Part of Microsoft Certified: Azure Fundamentals (AZ-900) ยท Azure Certification Practice
Real Exam ScenarioScenario Based

You have a high-traffic SQL database that is reaching its capacity limits. You want to improve performance for read-heavy workloads without upgrading the main database tier. What is a common strategy?

โœ“ Correct Answer & ExplanationScenario Based

Correct Answer

Create read-only replicas using Active Geo-Replication

Why This Answer Is Correct

Read replicas offload read traffic from the primary database, improving overall performance.

๐Ÿ“š What This Question Tests

This question evaluates your knowledge of Scenario Based โ€” a core concept tested in Microsoft Certified: Azure Fundamentals (AZ-900). Understanding Scenario Based is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.