@dev-thakku
Thank you for reaching out.I understand you are using Azure CDN to access the blob storage and are generating the URLs to the file with new SAS tokens every time and cache setting is configured to Cache every unique URL.
As correctly identified by Silvia above, you will not get the caching benefit in this case. Although I do not think you will also get the benefit of using CDN to send the data to nearest entry point because even without using CDN for storage, primary endpoints always use the Microsoft global network. The global BGP Anycast announcement ensures ingress traffic enters Microsoft network closest to the user. When a user from Singapore accesses Azure resources hosted in Chicago, the traffic enters the Microsoft global network at the Singapore edge POP. The traffic then travels on the Microsoft network to the service hosted in Chicago. More details can be found here.
As documented here Azure CDN can also accelerate dynamic content, which can't get cached, by using various network optimizations using CDN POPs. For example, route optimization to bypass Border Gateway Protocol (BGP).
If it helps. I am assuming you are generating the URLs to the file with new SAS tokens every time in order to enhance security so that no one on the internet can access the File without the newly created SAS token. Based on this assumption I think using Azure FrontDoor instead of Azure CDN will be beneficial for your use case.
I think using Azure Front Door Premium to access the Storage via Private link as described here will help in enhancing the security of the Blob Storage. In this configuration Front Door securely connects to the Azure Storage account by using Private Link. The storage account is configured to deny direct access from the internet, and to only allow requests through the private endpoint connection used by Front Door. This configuration ensures that every request gets processed by Front Door, and avoids exposing the contents of your storage account directly to the internet.
WIth AFD you can also use Web Application Firewall to enhance security of your web application
Additional references
https://learn.microsoft.com/en-us/azure/frontdoor/private-link
Hope this helps! Please let me know if you have any additional questions. Thank you!
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.