Which Azure SQL Database service tier provides the fastest recovery time for a database?Select only one answer.Business criticalGeneral PurposeHyperscale

Analysis of Azure SQL Database Service Tiers

1. Business Critical Tier: This service tier provides high availability with a minimum of 99.995% uptime and low latency. It is designed for applications that require high performance and rapid recovery, leveraging local SSD storage for quick data access and restored operations.

2. General Purpose Tier: While it is cost-effective and suitable for many applications, it does not offer the same level of performance and recovery speed as the Business Critical tier. It utilizes remote disk storage which can be slower.

3. Hyperscale Tier: This tier is designed for large databases that exceed the limits of traditional tiers. Although it can scale out efficiently, the recovery times can vary and it is not specifically optimized for the fastest recovery.

Conclusion

The Business Critical tier provides the fastest recovery time for a database due to its architecture and resource allocation.

Final Answer

Business Critical