Azure DB's Flashcards

1
Q

Azure SQL DB (7)

A

Cloud hosted managed PaaS SQL Server DB
Relational DB Mnt system
Application backed in online transaction processing paradigm (OLTP)
Reading from and writing to often
Vertically scaled
Geo replication (replicas around the world using Azure is easy)
Threat analytics (Azure scans DB and access patterns)

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

Azure Synapse Analytics (6)

A

Formerly Azure SQL Data Warehouse
Relational
Online Application Processing
Massive horizontal scale (no need to setup cluster)
Data warehousing (already defined =just platform for analysis)
Big data analytics (integration between big ones apache and data bricks)

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

Cosmos DB (3)

A

Globally distributed multimodel non-relational DB

noSQL (non-relational / no schema)

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

Azure DB MIgration Service

A

Azure Migrate
One stop shop for any kind of migration into Azure
Online or offline DB migration at scale (several DB migrations at once from on-prem or cloud)
First class support for sql server, AWS, mySQL, Oracle, MongoDB PostgreSQL

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