Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company runs an Azure App Service web application deployed to multiple instances behind Azure Application Gateway. Product pages query an Azure SQL Database for pricing and stock levels. During flash-sale events, database latency rises sharply. You must introduce a shared cache that reduces database load yet supports near-real-time invalidation whenever an inventory-update event is published through Azure Event Grid. Which solution should you recommend?
Turn on result-set caching at the Azure SQL Database layer to serve repeated queries from memory.
Deploy Azure Cache for Redis and use Redis Pub/Sub triggered by the Event Grid inventory event to invalidate or update cached keys.
Enable ASP.NET in-memory caching on each App Service instance.
Configure Azure CDN with a rules engine policy to cache generated HTML for 24 hours.
Azure Cache for Redis provides a distributed, in-memory data store that can be shared by all App Service instances, drastically reducing round-trips to Azure SQL Database. Redis supports the built-in Pub/Sub feature and key-space notifications, so an Azure Function triggered by an Event Grid inventory event can publish a message or explicitly remove affected keys, giving near-instantaneous consistency.
Azure CDN is optimized for static assets and long TTLs; it is not appropriate for highly dynamic, personalized catalog data that must update immediately when stock changes.
In-memory caching inside each App Service instance is not shared across the load-balanced fleet, leading to inconsistent data and inefficient memory use.
Result-set caching at the database layer still requires every request to reach Azure SQL Database and does not allow external invalidation on demand, so it will not meet latency or freshness requirements during flash-sale spikes.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Azure Cache for Redis, and why is it suitable for reducing database load in this scenario?
Open an interactive chat with Bash
What are Redis Pub/Sub and key-space notifications, and how do they work with Azure Event Grid?
Open an interactive chat with Bash
Why are other solutions, like Azure CDN or ASP.NET in-memory caching, not recommended?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design infrastructure solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .