Azure storage - Relational database storage
4 important questions on Azure storage - Relational database storage
What SQL db Tiers are there?
- General purpose (Default)
- Business critical/premium (Oltp with high transaction rate)
- Hyperscale (very large oltp with auto-scale of storage compute)
What reasons are there to use an Azure SQL database?
- Scale database in cloud vs. On-premises
- Machine learning is required
- need an oltp system on demand
- have a large amount of users
When would you use an azure synapse analytics?
- Want to use MPP for big data analytics
- Need to prepare loads of data that is all over the place
- Desire to release business intelligence report in a timely fashion
- Abiltiy to pause and resume compute
- Answer complex business questions
- Have a large amounts of data and a small amount of users.
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What disk types are available in in Azure for VMs?
- Standard HDD (standard, non-critical infrequent access)
- Standard SSD (Lightly used)
- Premium SSD (Production and performance sensitive workloads)
- Ultra disk (IO intense workloads, like databases and transaction heavy workloads)
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding