Databases
If you are studying for Microsoft Azure Fundamentals Exam, this guide will help you with quick revision before the exam. it can use as study notes for your preparation.
Dashboard Other Certification NotesDatabases
- Multiple database services to store a wide variety of data types and volumes.
- Have global connectivity and instant data availability
Azure Cosmos DB
- 📝 Globally distributed (= multiple regions) database service
- Supports schema-less data, stores JSON
- 💡 Good for Always On applications to support constantly changing data.
- Helps with failover during regional disaster
- Transparent multi-master replication, 99.999% high availability for both reads and writes
- 💡 Good for data used by & maintained by users around the globe.
Azure Cache for Redis
- Caches frequently used and static data to reduce data and application latency
Azure SQL Database Options
- Azure Database for MySQL: Fully managed and scalable MySQL
- Azure Database for PostgreSQL: Fully managed and scalable PostgreSQL
- Azure Database for MariaDB: Fully managed and scalable MariaDB
- SQL server on VMs: Host SQL servers in own VPNs
Azure SQL Database
- Relational database as a service (DaaS)
- Based on the latest stable version of the Microsoft SQL Server database engine.
- High-performance, reliable, fully managed and secure database
Azure Database Migration Service
- Allows to migrate existing SQL Server to Azure
- Performs all of the required steps.
- Minimal downtime
- Uses the Microsoft Data Migration Assistant
- Generate assessment reports that provide recommendations
Azure Synapse Analytics
- Formerly SQL Data Warehouse
- 📝 A cloud data warehouse for the enterprise
- Characterized by high resiliency through automatic scaling.
- Massive parallel processing (MPP) to run complex queries quickly across petabytes of data