Azure: Databases (SQL,Cosmos, Warehouses, Data Lake)

Cosmos DB

•  Can be used with Serverless Computing
• Globally Distributed
• Elastic
• Various regions
• Can also scale storage
• Can use SQL API
• Enterprise ready

 The High availability helps web, gaming, IoT, and mobile 


Data Lake

•  Enterprise
• Big Data
• Storing all Sorts of Data
• Integrates with data warehouses
• Processing
• Analytics
• Pay per job
• Instant Scale
• Used for things like
• Xbox Live
• Office 365
• Skype
• Big

SQL Database

•  Can import data from there to Classic Machine Studio
• Current Operational
• Normalized Relational
• Max Capacity is 4 TB
• Always on by design
• Create
• Retrive
• Update
• Delete
• Query Limit - 6400
• Machine Learning built in (See: Azure Machine Learning Service, and Azure Machine Learning Studio Classic)

SQL Data Warehouse

• For external data, historical operational
• Denormalized (into larger table [notes unclear])
• Near unlimited storage with 240 TB
• Paused post analysis
• Limited number of uses
• Query Limit - 32