Describe Azure Database and Analytics services Flashcards
List the Azure Database services
Azure Cosmos DB
Azure SQL Database
Azure SQL Managed Instance
Azure Database for MySQL
Azure Database for PostgreSQL
Azure SQL on VM
Name 3 key features of Azure Cosmos DB
Globally distributed NoSQL (semi-structured data) Database service
Schema-less
Multiple APIs (SQL, MongoDB, Cassandra, Gremlin, Table Storage)
Designed for:
Highly responsive (real time) applications with super low latency responses <10ms Multi-regional applications
Azure Cosmos DB
List 3 key features of Azure SQL Database
Relational database service in the cloud (PaaS)
Structured data service
Rich Query Capabilities (SQL)
Built-in high availability with no additional cost.
Predictable performance and inclusive, pay-as-you-go pricing.
Scale as needed, within seconds.
Ability to protect sensitive data at rest and in motion.
Automatic backups.
Enterprise-grade security and compliance.
Azure Database for MySQL
what is Azure Database for MySQL?
It is a relational database service in the cloud, and it’s based on the MySQL Community Edition database engine
What is Azure Database for PostgreSQL
It is a relational database service in the cloud. The server software is based on the community version of the open-source PostgreSQL database engine
Azure Database for PostgreSQL is available in two deployment options:
Single server
Hyperscale (Citus)
This Azure Database for PostgreSQL deployment option delivers horizontal scalability
Hyperscale (Citus)
Fully fledged SQL Server managed by cloud provider
Azure SQL Managed Instance
Fully fledged SQL Server on IaaS
Azure SQL on VM
High-performance, reliable, fully managed and secure database for building - applications
Azure SQL Database
Which are Azure’s analytics services?
Azure Synapse Analytics
Azure HDInsight
Azure Databricks
Azure Data Lake Analytics
…is a limitless analytics service that brings together enterprise-data warehousing and big-data analytics.
Azure Synapse Analytics
You can query data on your terms by using either serverless or provisioned resources at scale.
Azure Synapse Analytics