nerdexam
Microsoft

AZ-204 · Question #139

Your company is designing an application named App1 that will use data from Azure SQL Database. App1 will be accessed over the internet by many users. You need to recommend a solution for improving…

The correct answer is D. Azure Cache for Redis. To improve the performance of an Azure SQL Database-backed web application accessed by many internet users, Azure Cache for Redis should be included in the recommendation.

Submitted by yuki_2020· Mar 30, 2026Monitor, troubleshoot, and optimize Azure solutions

Question

Your company is designing an application named App1 that will use data from Azure SQL Database. App1 will be accessed over the internet by many users. You need to recommend a solution for improving the performance ofApp1. What should you include in the recommendation?

Options

  • AAzure HPC cache
  • BExpressRoute
  • Ca CON profile
  • DAzure Cache for Redis

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    11% (3)
  • D
    81% (22)

Why each option

To improve the performance of an Azure SQL Database-backed web application accessed by many internet users, Azure Cache for Redis should be included in the recommendation.

AAzure HPC cache

Azure HPC Cache is designed for high-performance computing workloads to accelerate file access for large-scale compute jobs, not for general web application database caching.

BExpressRoute

ExpressRoute provides private, dedicated network connectivity between on-premises networks and Azure, improving network latency for hybrid scenarios but not directly enhancing application performance for internet users accessing Azure SQL Database.

Ca CON profile

A 'CON profile' is not a recognized Azure service for improving application performance. If referring to a CDN profile, a CDN primarily caches static content and does not accelerate dynamic database interactions.

DAzure Cache for RedisCorrect

Azure Cache for Redis is an in-memory data store that significantly improves application performance by caching frequently accessed data, reducing the load on the backend Azure SQL Database. This offloads database queries and delivers extremely low-latency data retrieval, enhancing responsiveness for many concurrent users.

Concept tested: Caching for web application database performance

Source: https://learn.microsoft.com/en-us/azure/azure-cache-for-redis/cache-overview

Topics

#Azure Cache for Redis#caching#performance optimization#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full AZ-204 Practice