Please enable JavaScript.
Coggle requires JavaScript to display documents.
DP-201 (Design DR (CosmosDB) (HA - Single region 99.99 SLA, HA - Multi…
DP-201
-
Multi-Model Options
Core (SQL)
Default API
SQL like, uses JSON + document model
-
-
Azure Table
Key Value data model
Use case if you have a table model
Use SQL API unless you are moving to cosmos with a table model
Gremlin (graph)
Graph model
Use case, Amazon + Netflix in getting recomms
Involves relationships
-
-
SQL DW
-
-
Replicate Table
Full copy of table
Use case, small tables (lots of space being used)
Round-Robin Table
Ideal of staging tables, less queries
-
-
-
Polybase
(Ingestion)
ETL vs ELT
-
-
Extract data as text files from source
Landing data into blob of Data Lake Store
Prepare data for loading
Loading the data into SQL staging tables using Polybase (BCP)
Transform the data
Insert the data into prod tables
-
Allows you to bypass ETL and use ELT
Import and Export toolset. Lets you mount data either stored in blob or hadoop, you can run t-sql against this data
-