Describe Azure Database and Analytics services Flashcards

1
Q

List the Azure Database services

A

Azure Cosmos DB

Azure SQL Database

Azure SQL Managed Instance

Azure Database for MySQL

Azure Database for PostgreSQL

Azure SQL on VM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Name 3 key features of Azure Cosmos DB

A

Globally distributed NoSQL (semi-structured data) Database service

Schema-less

Multiple APIs (SQL, MongoDB, Cassandra, Gremlin, Table Storage)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Designed for:

    Highly responsive (real time) applications with super low latency responses <10ms
    Multi-regional applications
A

Azure Cosmos DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

List 3 key features of Azure SQL Database

A

Relational database service in the cloud (PaaS)

Structured data service

Rich Query Capabilities (SQL)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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.

A

Azure Database for MySQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

what is Azure Database for MySQL?

A

It is a relational database service in the cloud, and it’s based on the MySQL Community Edition database engine

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is Azure Database for PostgreSQL

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Azure Database for PostgreSQL is available in two deployment options:

A

Single server

Hyperscale (Citus)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

This Azure Database for PostgreSQL deployment option delivers horizontal scalability

A

Hyperscale (Citus)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Fully fledged SQL Server managed by cloud provider

A

Azure SQL Managed Instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Fully fledged SQL Server on IaaS

A

Azure SQL on VM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

High-performance, reliable, fully managed and secure database for building - applications

A

Azure SQL Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which are Azure’s analytics services?

A

Azure Synapse Analytics
Azure HDInsight
Azure Databricks
Azure Data Lake Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

…is a limitless analytics service that brings together enterprise-data warehousing and big-data analytics.

A

Azure Synapse Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You can query data on your terms by using either serverless or provisioned resources at scale.

A

Azure Synapse Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You have a unified experience to ingest, prepare, manage, and serve data for immediate business intelligence and machine learning needs.

A

Azure Synapse Analytics

17
Q

What is Azure HDInsight?

A

It is a fully managed, open-source analytics service for enterprises.

18
Q

It’s a cloud service that makes it easier, faster, and more cost-effective to process massive amounts of data.

A

Azure HDInsight

19
Q

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.

A

Azure HDInsight

20
Q

…supports a broad range of scenarios such as extraction, transformation, and loading (ETL), data warehousing, machine learning, and IoT.

A

Azure HDInsight

21
Q

What is Azure Databricks?

A

A service that helps you unlock insights from all your data and build artificial intelligence solutions.

22
Q

You can set up your Apache Spark environment in minutes, then autoscale and collaborate on shared projects in an interactive workspace.

A

Azure Databricks

23
Q

… supports Python, Scala, R, Java, and SQL, as well as data science frameworks and libraries including TensorFlow, PyTorch, and scikit-learn.

A

Azure Databricks

24
Q

What is Azure Data Lake?

A

It is an on-demand analytics job service that simplifies big data.

25
Instead of deploying, configuring, and tuning hardware, you can write queries to transform your data and extract valuable insights.
Azure Data Lake Analytics
26
You only pay for your job when it's running, making it more cost-effective.
Azure Data Lake
27
The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need.
Azure Data Lake