Core Services: Databases

Question 1

Azure Cosmos DB

Answer 1

Globally distributed database that supports NoSQL options

Question 2

Azure SQL Database

Answer 2

Fully managed relational database with auto-scale, integral intelligence, and robust security

Question 3

Azure Database for MySQL

Answer 3

Fully managed and scalable MySQL relational database with high availability and security

MySQL is a Database Management System (not a database in iteself)

For relational data

Question 4

Azure Database for PostgreSQL

Answer 4

Fully managed and scalable PostgreSQL relational database with high availability and security

Question 5

SQL Server on VMs

Answer 5

Host enterprise SQL Server apps in the cloud

Question 6

Azure Synapse Analytics

Answer 6

Azure Synapse is an analytics service that brings together enterprise data warehousing and Big Data analytics.

Fully managed data warehouse with integral security at every level of scale at no extra cost

Can query serverless or on provisioned resources

Question 7

Azure Database Migration Service

Answer 7

Migrates your databases to the cloud with no application code changes

Question 8

Azure Cache for Redis

Answer 8

Caches frequently used and static data to reduce data and application latency

Question 9

Data Lake Analytics

Answer 9

Big data solution

Devs can write C# or SQL (called U-SQL)

Question 10

HD Insight

Answer 10

Fast and cost effective tool for analysing big data, including IoT.

Can analyze streaming of historic.