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
Q

Instead of deploying, configuring, and tuning hardware, you can write queries to transform your data and extract valuable insights.

A

Azure Data Lake Analytics

26
Q

You only pay for your job when it’s running, making it more cost-effective.

A

Azure Data Lake

27
Q

The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need.

A

Azure Data Lake