Azure storage - Relational database storage

4 important questions on Azure storage - Relational database storage

What SQL db Tiers are there?

  1. General purpose (Default)
  2. Business critical/premium (Oltp with high transaction rate)
  3. Hyperscale (very large oltp with auto-scale of storage compute)

What reasons are there to use an Azure SQL database?

  1. Scale database in cloud vs. On-premises
  2. Machine learning is required
  3. need an oltp system on demand
  4. 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
Discover Study Smart

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
Remember faster, study better. Scientifically proven.
Trustpilot Logo