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
You have a unified experience to ingest, prepare, manage, and serve data for immediate business intelligence and machine learning needs.
Azure Synapse Analytics
What is Azure HDInsight?
It is a fully managed, open-source analytics service for enterprises.
It’s a cloud service that makes it easier, faster, and more cost-effective to process massive amounts of data.
Azure HDInsight
You can run popular open-source frameworks and create cluster types such as Apache Spark, Apache Hadoop, Apache Kafka, Apache HBase, Apache Storm, and Machine Learning Services.
Azure HDInsight
…supports a broad range of scenarios such as extraction, transformation, and loading (ETL), data warehousing, machine learning, and IoT.
Azure HDInsight
What is Azure Databricks?
A service that helps you unlock insights from all your data and build artificial intelligence solutions.
You can set up your Apache Spark environment in minutes, then autoscale and collaborate on shared projects in an interactive workspace.
Azure Databricks
… supports Python, Scala, R, Java, and SQL, as well as data science frameworks and libraries including TensorFlow, PyTorch, and scikit-learn.
Azure Databricks
What is Azure Data Lake?
It is an on-demand analytics job service that simplifies big data.
Instead of deploying, configuring, and tuning hardware, you can write queries to transform your data and extract valuable insights.
Azure Data Lake Analytics
You only pay for your job when it’s running, making it more cost-effective.
Azure Data Lake
The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need.
Azure Data Lake
