Question 1

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?

Accepted Answer

Look for 'isolate reporting workload' and 'no code changes for transactional system'. Read Scale-Out routes read-intent connections to a replica.

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

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.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4

More questions from this exam