ExpertMedium1 markMultiple Choice
AZ-305 · Question 21 · Domain 2.1: Relational Data Storage
A retail company has an e-commerce application backed by an Azure SQL Database.
During the holiday shopping season, read-heavy reporting queries run by the analytics team are causing performance degradation for customer transactions. You need to design a solution to isolate the reporting workload from the transactional workload without changing the application code for the transactional system.
Which feature should you implement?
A retail company has an e-commerce application backed by an Azure SQL Database.
During the holiday shopping season, read-heavy reporting queries run by the analytics team are causing performance degradation for customer transactions. You need to design a solution to isolate the reporting workload from the transactional workload without changing the application code for the transactional system.
Which feature should you implement?
Answer options:
A.
Active Geo-Replication
B.
Read Scale-Out
C.
Azure Cache for Redis
D.
Elastic Pools
How to approach this question
Look for 'isolate reporting workload' and 'no code changes for transactional system'. Read Scale-Out routes read-intent connections to a replica.
Full Answer
B.Read Scale-Out✓ Correct
For Azure SQL Database Premium and Business Critical tiers, Read Scale-Out is built-in. It leverages the Always On high availability architecture by directing read-only connections (using `ApplicationIntent=ReadOnly` in the connection string of the reporting tool) to one of the secondary replicas. This isolates the heavy reporting queries from the primary replica handling customer transactions.
Common mistakes
Choosing Active Geo-Replication. While it works, Read Scale-Out is free (included in the tier) and designed specifically for this local performance isolation scenario.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4
55 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ02CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ03CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ04CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ05CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...Hard