Databases

Question 1

What are the 4 types of Database within Azure ?

Answer 1

CosmosDB, Azure SQL, MySQL, PostgreSQL

Question 2

What are the features of CosmosDB ?

Answer 2

Needs CosmosDB account ?
can have 1 free instance (400 RU’s and 5GB storage)

globally distributed - sync managed by Azure - easily add regions, continued sync promising < 0.9 ms latency
can auto scale
infinite resources
only pay for what used
connect via SDK/API
C#, Java
Integrate with SQL, MongoDB and Cassandra
Data stored within containers

Expensive - costs quickly escalate

Question 3

What are the features of Azure SQL ?

Answer 3

3 options visible in portal ?
- SQL databases, SQL managed instances, SQL virtual machines

managed service (DBaaS)
users only manage data in DB
can migrate directly from on-Prem
frictionless, cost saving, low TCO

No backup,SQL Agent, etc.

Built in Machine Learning

• Optimisation suggestions
• Health monitoring

100TB maximum ?
Scalable / HA

Built in security

Question 4

What are the features of Azure Database for mySQL ? ?

Answer 4

opensource, relational, mature/stable
PaaS - ideal for Development focus (automatic patching, backups, etc.)
Choice of framework (e.g. Wordpress/PHP)
HA possible
Security - Advanced Threat Protection (ATP)
Use cases
- webapps, ecommerce, mobile apps, gaming

Question 5

What are the features of Azure Database for PostgreSQL ?

Answer 5

opensource, relational. free, stable
extensions - JSONB, geospatial
Horizontal scaling - can hyper scale easily

Also gives perf. recommendations, 
fully managed as MySQL
Use Cases
- Financial apps
- Geometric GIS e.g. PostGIS

Question 6

What is the purpose of Database Migration Services ?

Answer 6

Azure DMS - dedicated single tool

Can move on-prem DB to managed SQL cloud instance