Database Flashcards
Cosmos DB Characteristics ?
1) Globally Available (closer to the end users)
What is Latency ?
The time it takes for data travel, more latency == more time.
What is latency for Cosmos DB ?
Cosmos DB promises single millisecond latency (0-9 milliseconds)
Cosmos Scalability ?
Cosmos DB can auto scale to meet demands.
* also pay for what you use.
What is Azure SQL ?
It is Azure SQL as a Service.
- IaaS
- Azure manages everything but the data.
- Direct to Azure from On-Prem path.
Azure SQL Benefits ?
1) Scalability
2) Space - Mange up to 100 TB.
3) Availability
4) Security - Patching and Updates.
Azure SQL Flavours ?
Azure SQL Database vs Azure Managed SQL Instance.
What are the difference between Azure SQL and Azure Managed SQL Instance ?
Managed SQL Instance Has:
- Recovery from Full backups (not supported by Azure SQL).
- No Geo-replication (unlike Azure SQL)
- No automatic tuning (unlike Azure SQL)
- No SQL Server Profiler (unlike Azure SQL)
- No SQL Server Agent (unlike Azure SQL)
What is Azure DB for MySQL ?
Built and maintained by the Community.
- Open Source
- Relational Database
- Mature and Stable Architecture.
Advantages for Azure DB for MySQL ?
1) Platform as a Service
2) Development Focused
3) Choice of Language
4) High Availability
5) Azure Security Features
What is Azure DB for PostgreSQL?
Built and maintained by the Community.
- Open Source
- IaaS
- Relational Database
- Mature and Stable Architecture.
- default DB for Mac OS.
Features of Azure DB for PostgreSQL?
1) Extensions
2) Development Focused
3) Choice of Language
4) Horizontal scaling
5) Fully Managed
What is Database Migration Services (DMS) ?
A database Migration tool provided by Microsoft to move from on-prem databases to the cloud - either Azure DB or Azure DB for MySQL.
CosmosDB Naming (uniqueness) ?
Account names are unique across Azure, because you can access them externally, so w when creating an account Name, it shall need to be unique.
