Which storage solution should you use?

You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting.

Which storage solution should you use?
A . Azure SQ
B . Database elastic pools
C . Azure SQL Data Warehouse
D . Azure Cosmos DB that uses the Gremlin API
E . Azure SQL Database Hyperscale

View Answer

Answer: D

Explanation:

A Hyperscale database is an Azure SQL database in the Hyperscale service tier that is backed by the Hyperscale scale-out storage technology. A Hyperscale database supports up to 100 TB of data and provides high throughput and performance, as well as rapid scaling to adapt to the workload requirements. Scaling is transparent to the application C connectivity, query processing, etc. work like any other Azure SQL database.

Incorrect Answers:

A: SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

B: Rather than SQL Data Warehouse, consider other options for operational (OLTP) workloads that have large numbers of singleton selects.

References:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-hyperscale-faq